|
can anyone show me how to update a access database using vb .net?
to be more clear, i have an access database call "databasename.mdb",and the table is named "prduct" when the user select from the combobox matching column1, column2's value will show in the textbox ready to be modify, when seavebutton click the text in textbox will update to column2.
i know how to do connect and read from the database only updating need help! thanks for your time!
|
|
|
|
|
You can use
Me.yourTableAdapter.Update(Me.yourDataBaseDataSet.yourTable)
Just as you load data
Me.yourTableAdapter.Fill(Me.yourDataBaseDataSet.yourTable)
and check whether you have created the primary key
Regards,
Chatura Dilan
|
|
|
|
|
do you mean this?
Dim connectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Password="""";User ID=Admin;Data Source=""c:\databasename.mdb"";"
Dim objConn As New OleDb.OleDbConnection(connectionString)
objConn.Open()
Dim ds As New DataSet
Dim da2 As OleDb.OleDbDataAdapter
Dim sql As String
sql = "SELECT [Name] FROM Developer"
da2 = New OleDb.OleDbDataAdapter(sql, objConn)
da2.Fill(ds, "Developer")
Dim cb As New OleDb.OleDbCommandBuilder(da2)
ds.Tables("Developer").Rows(0).Item(0) = "yes"
da2.Update(ds, "Developer")
but it give me an "Invalid Operation Exception" ---"Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information."
can anyone tell me why?
p.s. do i have to created the primary key? why do i have to check?
|
|
|
|
|
|
Can you have 1.1 and visual studio 2003 and 2.0 and visual studio 2005 on one machine without everything going wonky?
|
|
|
|
|
Yes. Visual Studio 2003 and 2005 can coexist on the same machine.
|
|
|
|
|
Please do not corss-post!
--------------------------------------------------------
My development blog
Q:What does the derived class in C# tell to it's parent?
A:All your base are belong to us!
|
|
|
|
|
i have a problem with vb.net 2005.
when set localization = true on a form and add databinding to textbox.text and write on load_form event
fill(dataset) i can see my data )( my database has data)
and when change the property localization = false
i can see my data
some body help me
.....
123
|
|
|
|
|
What don't you know?
Chatura Dilan
-- modified at 23:45 Monday 10th April, 2006
|
|
|
|
|
What do you expect to happen?
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog
|
|
|
|
|
this massege show after day or two day on more for customers
this massege is :-
(null) not a valid win32 application
then program not open
please send me solution it
Ahmed
|
|
|
|
|
It's virtually impossible for anyone to provide an answer based on this, unless that's the message you get when .NET 2.0 is not installed on the target machine.
Does your app do any sort of error logging ? Perhaps you should add some.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
|
pls i need the help immediately pls help me to generate the source code for direct exchange of data between xml and relational database by using mapping rules in xml.very urgent pls
aiyshu
|
|
|
|
|
I want to increment the size of array at run time and also want to preserve the data already existing in the array.
Please help me
Thank You
Pankaj
|
|
|
|
|
|
|
Hi,
In my new project(VS2005) i want to create a datagridview and in that view
a new datagridview!
But i don't know where to start
I know i have to use some sort of relationship with the dataset, but i don't know the rest!
I want to display a row With in front of the row a + (Like in Explorer)
which you can expand (-) and see for this new a new datagridview inside the other with the child
rows.
Example :
Row 1 --> Customer, name, ...
Row a --> orderid, item,...
Row b --> orderid, item,...
Row 2 --> customer, name, ...
Does anybody have an example or an article about this
Thanks
A.
|
|
|
|
|
is there any easy way to paint a column header?
if not i will set UseItemStyleForSubItems of listviewitems for specific subitems that located at the columnheader which i want to paint;then set backcolor of that subitem to any color.
|
|
|
|
|
Protected Overrides Sub OnEnter(ByVal e As System.EventArgs)<br />
MyBase.OnEnter(e)<br />
If Not Me.ReadOnly Then Me.BorderStyle = Windows.Forms.BorderStyle.FixedSingle<br />
End Sub<br />
Protected Overrides Sub OnLeave(ByVal e As System.EventArgs)<br />
MyBase.OnLeave(e)<br />
If Not Me.ReadOnly Then Me.BorderStyle = Windows.Forms.BorderStyle.Fixed3D<br />
End Sub
After adding this code, when i try to shift next control by pressing tab key ; why cant i focus to the next control ?
|
|
|
|
|
How can i override readonly property of Text Box
Public Overrides Property [ReadOnly]() As Boolean -- this doesnt work it says it is not overridable.
Is there any other method except controlling keypress,keyup,keydown events?
|
|
|
|
|
Override it to do what exactly? Change the visual look of readonly fields maybe?
|
|
|
|
|
IF value is TRUE, i'll set TabStop to FALSE.
|
|
|
|
|
protected override void OnReadOnlyChanged(EventArgs e)
{
this.TabStop = !this.ReadOnly;
base.OnReadOnlyChanged (e);
}
|
|
|
|
|
hi there
whil i open an input file which is huge in size , if some popup occurs in between the loading fails , if i break and try to find the error it is not giving any source code what might be the reason???
thanks in advance..
Bharath.S
bharath.s
|
|
|
|