I am using sql server in my vb.net application. I just want that my sql files should not be allowed to be edited once i install my app on some other computer through say "sql server management studio express". Also is it possible that the user is able to run my app without needing to install "sql server" can i convert my files into some other format so that nobody is able to open them and edit them
View 3 RepliesThis is the only line for saving a NEW record.
[code]...
is it possible by 1 program to save settings to another program without running the program that is being edited?
View 6 RepliesI am using VS 2008, Windows XP R3, and Visual Basic.When I open some forms in the form designer, (In Solution Explorer, right click on the form, then select View Designer) the form always opens as Edited. An Asterisk "*" appears after the form name in the open window tabs. If I open the form to just view the code (In Solution Explorer, right click on the form, then select View Code), the form opens normally. This happens for just some forms.
It always happens for the same forms, and never happens for the other forms. What I am missing in those forms where the designer always thinks the form has been edited?
Here is where i load my datagridview Private Sub OE_Prices_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code]...
I'm using ASP.NET 2.0 and VB.NET. I have a login page. If I am an existing user, when I log in, my user details are popped in the respective textBoxes. Now I wish to change one of these fields. I edited one and then clicked on the Edit button to update the record. It's not updated but instead it brings the existing value from the text box.
[code]...
I reloaded ny page with previous data that was available for my login.Now i try to edit the textbox and update .It either updated or doesnt retain the edited value in Textbox.[codd]e...
View 2 RepliesBelow is my revert subroutine:
Private Sub BindingNavigatorRevertItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BindingNavigatorRevertItem.Click
Me.GpheaderBindingSource.CancelEdit()
[Cdoe]....
My problem is Me.gpdetailbindingsource.canceledit() cancels only the current row being edited. I want all rows of my detail be reverted.
I'm trying to show a custom contextmenustrip on my datagridview and it works fine except when the cell is being being edited. Then it shows the default windows contextmenustrip with copy/cut/..Is there a way to overwrite the DataGridViewTextBoxCell contextmenustrip or disable it? The solution from Disable DataGridView System ContextMenu does'nt work for me.
Private Sub DataGridView1_MouseDown(ByVal sender As System.Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles DocCostGroupDetsDataGridView.MouseDown
If e.Button = Windows.Forms.MouseButtons.Right Then
_CustomContextMenuStrip.fGetContextMenu()
[Code]...
actually when I edit float value in datagridcell , I want only two numbers to be displayed after point(.)....i.e 2.35 instead 2.34567 more over am getting it but the actual thing is that value is not getting update in the dataset , but when I reload the form it shows like 2.34567 only instead i want 2.35...
[Code]...
I made a custom button by inheriting the Button class. When I double click the custom button in Designer, it makes the event handling function for MyButton.Click:
Private Sub MyButton1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyButton1.Click
End Sub
[code]....
I'm writing a custom control and I want to add a "MessageText" property of type String:
<Browsable(True),
DefaultValue(""),
Category("CustomControls"),
[code]....
The MessageText property is a multiline text, and the user must be able to set the text using the designer. The problem is that the designer doesn't allow to enter a newline directly for a string property.I want the same behaviour as the system TextBox's Text property, where you can click on the down arrow and write lines in the small text-editor that appears:How do I do that?
can anyone teach me how to save data in microsoft access database and retrieving it back from database?[code]so, how do i save it in that and how do i load their data by typing their ic no only..
View 5 RepliesIve created one database Sql Server Compact Edition 2005, with one table ("Cliente") I know that I can created my database good, but i have a problem saving information since three textbox, in my table(With columns "Nombre" "Apellido" "Cliente". In my form there is a button save ("Guardar"). When I do click in my button appear the next message : "The column cannot contain null values. [ Column name = Nombre,Table name = Cliente ] " and happen the same with apellido and Id_Cliente. And this happen becouse my code cant save the information....
This is the code
Option Explicit On
Option Strict On
Imports System
Imports System.IO
Imports System.Data
[CODE]...
And the code for my button is:
Private Sub cmdguardar_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdguardar.Click
Dim myconnection As SqlCeConnection
Dim mycommand As SqlCeCommand
[CODE]...
1. First off, how do I make my path to my database relative? The path is currently absolute and is: Data Source=J:/College/AS_DSFinalDatabase1.accdb
2. Second of all, where do I save my database in the project? I want it to be included in like project folders...kind of like the App_Data folder in ASP.Net.
3. I'm recieving an error whenever I try to populate more than 1 DataGridView upon form load for some reason...I've tried 5 different ways of writing the code, and I get the same error...there's no error description, so does anyone know what the issue is? Here's the error:
i want save image in directory path and also save path in database...sqlserver 2005 and retrieve in in same folder and path?
View 1 RepliesI can save my data to access database and in the access database field I set it to date/time.But problem is when I get the value out from the database.. the format is always month/day/year hour:minutes:seconds example today: 5/2/2011 12:00:00..How to get the value into listview becoming May/2/2011 without the hour..Here's my code to get it from database ListView1.Items(i).SubItems.Add(dt.Rows(i)(14).ToString).The second problem is.When I would like to edit, how can the datetimepicker get the listview value ? [code] info: using access 2003 (.mdb) the Date of Birth field has been set into Date/Time.
View 2 Repliesstoring data with Foreign keys to sql database. basically i have 2 tables (user and game)game has user_ID as a foreign key.
View 1 RepliesI am using following code to save my data to database Where does the statement to save a picture in the database fit?
[Code]...
create a adding form and it will save to sql database .
View 4 RepliesDatabase edit then save problem Im trying to make a database and for the most part it works. The form1 has add new button (which goes into my form2 window that adds all of the information there, then I hit save, when I exit it and comes back to the form1, with everything saved. There is a listbox that shows all the names, then I click on anyone of the names and try to edit it and it works, then I hit the save button, it comes up with the error under
[Code]...
Visual Studio 2010, Visual Basic I am able to import a .csv file into a datagridview on my windows form using the code below:
Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles btnChooseList.Click
Dim fName As String = ""
OpenFileDialog1.InitialDirectory = "c:desktop"
[code]....
My issue is that I can get the .csv data into the datagridview, but I need the user to be able to indicate which column is the "First Name", "Last Name", "Address", etc so that I can add the data to the correct column in the database. The imported lists won't always be in the same column order.The end result needs to be that the data in my datagridview will be altered by the user and then saved to the correct columns in my database.
I use Visual Basic 2008 I use bound Datagridview I use mysql database If i run this code, everything on the screen ( in the datagridview) neatly Updated.But when I look at records in the table "stock" always the first row (0) of the DataGridView not updated in the table "stock"All the other record are updated with where in the datagridview! This always happens!!!How can fix it?
myAdapter2.SelectCommand = myCommand2
MyBuilder2 = New MySql.Data.MySqlClient.MySqlCommandBuilder(myAdapter2)
MyAdapter2.Fill(MyDataset2, "stock")
MyDataTable2 = MyDataset2.Tables("stock")
[code]....
Recently I've created a window database program(Tools Inventory); everything works fine except for the following two :
1. It doesn't accept modifications to the existing datas in the column & rows. (Error : Updates require a ValidCommand......)
2. Remove button does not delete the data in the database. It only works in the runtime.
I am working on a school project but I am getting an error when I attempt to save an altered dataset.
[code]...
Just curious on how i can save information, like settings, and usernames etc. in my app, but i dont have a database? Or say i wanted to create a licenc key for my app, how can i make sure a window comes up before it with a lic. key check or somethingl ike that.
View 20 RepliesI need save some informations, in a table (date, hour, number of points...) I use Vb .NET 2008.
View 5 RepliesI want to save a zip file at a sql database. I tried to to the same like saving txt files, but if I want to open the saved file (it was created from a stream) the zip file is corrupted!
Saving zip file as stream
Dim fs As New FileStream(tmpPfad, FileMode.Open, FileAccess.Read)
Dim bytData(fs.Length() - 1) As Byte
fs.Read(bytData, 0, bytData.Length)
fs.Close()
Dim i As Integer
[Code] .....
if i had a cancel button which showed a message box, how would i get the message box to show OK and Cancel and for each of them to do something?
and how would i get an OK (paired with the first cancel from above) to save an entry/ changes to a database?
how can i save and retieve pic from database using VB.net?
View 2 Replies