Need help Updating SQL Server Express DB from c# :(
Posted on
16th Feb 2014 07:03 pm by
admin
Please can anyone help with:-
1 How to sructure the strSelect statement.
2 How to instruct the cn, da, cb, tb etc to go and get on with it.
Extra info: gl_Dataset.ds is a dataset that is in an object that is created in the forms designer.cs
and is then global to all code on this form. This setup works because I can read and display the data.
colErrByUserID is not PK but all columns in table were selected when gl_Dataset.ds was created.
private void btnSaveAllChangesMadeToAllLogsSoFar_Click(object sender, EventArgs e)
{
string strSelect = "UPDATE INTO dbo.tblQLs WHERE colErrByUserID = '" +
LoginForm.gb_strUserID + "' ";
SqlConnection cn = new SqlConnection(LoginForm.gb_strConnection);
SqlDataAdapter daTblQLs = new SqlDataAdapter(strSelect, LoginForm.gb_strConnection);
SqlCommandBuilder cb = new SqlCommandBuilder(daTblQLs);
cb.GetUpdateCommand();
daTblQLs.Update(gl_Dataset.ds, "tblQLs");
cn.Close();
}
Thank you for your help.
No comments posted yet
Your Answer:
Login to answer
87
34
Other forums
Javascript using window.location seems to lose state
Not sure what forum so let me know if I'm in the wrong place.
I have a main window with a ajax grid
quotes changing
hi all
in my content
opening quotes " changes to “
close qu
Help with echo()
I'm having some problems with this code:
Code: echo '
<A HREF="jav
Map.php
I am a complete beginner to PHP and am looking for some help with a program I am messing around with
How to assign JS screen.width to ASP.Net variable
I've got this ASP.net routine that gets the cookie value of the screen width, but now I need to chan