Tom's Guide | Tom's Hardware | Tom's Games
 |
 |
 |
I am making a new customer data base In c# and am having problems with the update of the data base from my form.
the code is:
private void btnSubmit_Click(object sender, EventArgs e)
{ //Database Update subroutine
string login = "Provider=SQLOLEDB; Data Source=kellylaptop\\Portable;Database=newCustomer;Integrated Security=SSPI";
OleDbConnection cust = new OleDbConnection(login);
cust.Open();
//Database Update
string mySelectQuery = "SELECT * FROM dbo.CustNew";
string feild1 = "SELECT RepID, CPhone FROM dbo.CustNew";
OleDbCommand myCommand = new OleDbCommand(mySelectQuery, cust);
OleDbDataReader myReader = myCommand.ExecuteReader();
// try
// {
while (myReader.Read())
{
string tblUpdate = "INSERT INTO dbo.CustNew (" + RepID.Text + "," + Date.Text + "," + Price.Text + "," + FName.Text + "," + LName.Text + "," + Address1.Text + "," + Address2.Text + "," + City.Text + "," + State.Text + "," + ZipCode.Text + "," + HPhone.Text + "," + APhone.Text + "," + PPhone.Text + "," + Social.Text + "," + DLNum.Text + "," + ESN.Text + "," + MandM.Text + "," + CNum.Text + "," + PinNum.Text + "," + Other.Text + "," + ETime.Text + "," + Ten.Text + "," + Twenty.Text + "," + TFive.Text + "," + Fifty.Text + "," + Hund.Text + "," + EMail.Text + "," + CPhone.Text + ")";
OleDbCommand cmd = new OleDbCommand(tblUpdate, cust);
cmd.Parameters.Add(RepID.Text);
cmd.Parameters.Add(Date.Text);
cmd.Parameters.Add(Price.Text);
cmd.Parameters.Add(FName.Text);
cmd.Parameters.Add(LName.Text);
cmd.Parameters.Add(Address1.Text);
cmd.Parameters.Add(Address2.Text);
cmd.Parameters.Add(City.Text);
cmd.Parameters.Add(State.Text);
cmd.Parameters.Add(ZipCode.Text);
cmd.Parameters.Add(HPhone.Text);
cmd.Parameters.Add(APhone.Text);
cmd.Parameters.Add(PPhone.Text);
cmd.Parameters.Add(Social.Text);
cmd.Parameters.Add(DLNum.Text);
cmd.Parameters.Add(ESN.Text);
cmd.Parameters.Add(MandM.Text);
cmd.Parameters.Add(CNum.Text);
cmd.Parameters.Add(PinNum.Text);
cmd.Parameters.Add(Other.Text);
cmd.Parameters.Add(ETime.Text);
cmd.Parameters.Add(Ten.Text);
cmd.Parameters.Add(Twenty.Text);
cmd.Parameters.Add(TFive.Text);
cmd.Parameters.Add(Fifty.Text);
cmd.Parameters.Add(Hund.Text);
cmd.Parameters.Add(EMail.Text);
cmd.Parameters.Add(CPhone.Text);
}
try
{
}
//}
finally
{
// always call Close when done reading.
myReader.Close();
// always call Close when done reading.}
cust.Close();
Application.OpenForms["Form1"].Show();
Application.OpenForms["AddCust"].Close();}
HELP!!!!What do I need to do? I am using VS.Net 2005.
If you use a DataAdapter instead of a DataReader you can call the DataAdapter.Update method to post all of your modifications to your DataSet.
0 
 |
 |
 |
This post is quite old and has been locked from receiving new replies. Please create a new posting instead.
| Ads by Google |
