EDN Admin
Well-known member
Good morning all
would someone be kind enough to give me a little help?? I am completely new to C# and trying to teach myself, most of the time I can get through with looking at forums when I get a problem but
this one Im really stuck on. it to do with SQL data base.
I have created the database and table and assigned values to variables to just try and add a record
to the database, but for some reason the var dRow on the last line is set to Null, showing this when debugging and no matter what I try I cant assign it.
Please can anyone shed some light as to why
<span style="font-size:small <span style="font-size:small
System.Data.SqlServerCe.<span style="color:#2b91af; font-size:small <span style="color:#2b91af; font-size:small <span style="color:#2b91af; font-size:small SqlCeConnection<span style="font-size:small <span style="font-size:small con;
<span style="font-size:small <span style="font-size:small
System.Data.SqlServerCe.<span style="color:#2b91af; font-size:small <span style="color:#2b91af; font-size:small <span style="color:#2b91af; font-size:small SqlCeDataAdapter<span style="font-size:small <span style="font-size:small da;
<span style="color:#2b91af; font-size:small <span style="color:#2b91af; font-size:small <span style="color:#2b91af; font-size:small DataSet<span style="font-size:small <span style="font-size:small ds1;
//******************************************<span style="font-size:small <span style="font-size:small
// this is on a form button_click from here
//*******************************************
<span style="font-size:small <span style="font-size:small
con = <span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small new<span style="font-size:small <span style="font-size:small System.Data.SqlServerCe.<span style="color:#2b91af; font-size:small <span style="color:#2b91af; font-size:small <span style="color:#2b91af; font-size:small SqlCeConnection<span style="font-size:small <span style="font-size:small ();
<span style="font-size:small <span style="font-size:small
con.ConnectionString = <span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small "Data Source=C:\Users\Eddie\Numbers.sdf";
<span style="font-size:small <span style="font-size:small
con.Open();
// understand the line below may be wrong at the moment
<span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small
string sql = <span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small "SELECT * from tbl_AllNumbers"<span style="font-size:small <span style="font-size:small ;
<span style="font-size:small <span style="font-size:small
da = <span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small new<span style="font-size:small <span style="font-size:small System.Data.SqlServerCe.<span style="color:#2b91af; font-size:small <span style="color:#2b91af; font-size:small <span style="color:#2b91af; font-size:small SqlCeDataAdapter<span style="font-size:small <span style="font-size:small (sql,
con);
<span style="font-size:small <span style="font-size:small
ds1 = <span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small new<span style="font-size:small <span style="font-size:small <span style="color:#2b91af; font-size:small <span style="color:#2b91af; font-size:small <span style="color:#2b91af; font-size:small DataSet<span style="font-size:small <span style="font-size:small ();
<span style="color:#2b91af; font-size:small <span style="color:#2b91af; font-size:small <span style="color:#2b91af; font-size:small
DataRow dRow = ds1.Tables[<span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small "Numbers"<span style="font-size:small <span style="font-size:small ].NewRow();
thank you in advance
Eddie<span style="font-size:small <span style="font-size:small <span style="font-size:small <span style="font-size:small <span style="font-size:small <span style="font-size:small <span style="font-size:small <span style="font-size:small <span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small <span style="font-size:small <span style="font-size:small <span style="font-size:small <span style="font-size:small <span style="color:#2b91af; font-size:small <span style="color:#2b91af; font-size:small
<span style="font-size:small <span style="font-size:small
<span style="font-size:small <span style="font-size:small
<span style="font-size:small <span style="font-size:small
<span style="font-size:small <span style="font-size:small
<span style="font-size:small <span style="font-size:small
<span style="font-size:small <span style="font-size:small
<span style="font-size:small <span style="font-size:small
<span style="font-size:small <span style="font-size:small
<span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small
<span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small
<span style="font-size:small <span style="font-size:small
<span style="font-size:small
<span style="font-size:small
<span style="font-size:small <span style="font-size:small
<span style="font-size:small <span style="font-size:small
View the full article
would someone be kind enough to give me a little help?? I am completely new to C# and trying to teach myself, most of the time I can get through with looking at forums when I get a problem but
this one Im really stuck on. it to do with SQL data base.
I have created the database and table and assigned values to variables to just try and add a record
to the database, but for some reason the var dRow on the last line is set to Null, showing this when debugging and no matter what I try I cant assign it.
Please can anyone shed some light as to why
<span style="font-size:small <span style="font-size:small
System.Data.SqlServerCe.<span style="color:#2b91af; font-size:small <span style="color:#2b91af; font-size:small <span style="color:#2b91af; font-size:small SqlCeConnection<span style="font-size:small <span style="font-size:small con;
<span style="font-size:small <span style="font-size:small
System.Data.SqlServerCe.<span style="color:#2b91af; font-size:small <span style="color:#2b91af; font-size:small <span style="color:#2b91af; font-size:small SqlCeDataAdapter<span style="font-size:small <span style="font-size:small da;
<span style="color:#2b91af; font-size:small <span style="color:#2b91af; font-size:small <span style="color:#2b91af; font-size:small DataSet<span style="font-size:small <span style="font-size:small ds1;
//******************************************<span style="font-size:small <span style="font-size:small
// this is on a form button_click from here
//*******************************************
<span style="font-size:small <span style="font-size:small
con = <span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small new<span style="font-size:small <span style="font-size:small System.Data.SqlServerCe.<span style="color:#2b91af; font-size:small <span style="color:#2b91af; font-size:small <span style="color:#2b91af; font-size:small SqlCeConnection<span style="font-size:small <span style="font-size:small ();
<span style="font-size:small <span style="font-size:small
con.ConnectionString = <span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small "Data Source=C:\Users\Eddie\Numbers.sdf";
<span style="font-size:small <span style="font-size:small
con.Open();
// understand the line below may be wrong at the moment
<span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small
string sql = <span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small "SELECT * from tbl_AllNumbers"<span style="font-size:small <span style="font-size:small ;
<span style="font-size:small <span style="font-size:small
da = <span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small new<span style="font-size:small <span style="font-size:small System.Data.SqlServerCe.<span style="color:#2b91af; font-size:small <span style="color:#2b91af; font-size:small <span style="color:#2b91af; font-size:small SqlCeDataAdapter<span style="font-size:small <span style="font-size:small (sql,
con);
<span style="font-size:small <span style="font-size:small
ds1 = <span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small new<span style="font-size:small <span style="font-size:small <span style="color:#2b91af; font-size:small <span style="color:#2b91af; font-size:small <span style="color:#2b91af; font-size:small DataSet<span style="font-size:small <span style="font-size:small ();
<span style="color:#2b91af; font-size:small <span style="color:#2b91af; font-size:small <span style="color:#2b91af; font-size:small
DataRow dRow = ds1.Tables[<span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small "Numbers"<span style="font-size:small <span style="font-size:small ].NewRow();
thank you in advance
Eddie<span style="font-size:small <span style="font-size:small <span style="font-size:small <span style="font-size:small <span style="font-size:small <span style="font-size:small <span style="font-size:small <span style="font-size:small <span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small <span style="color:#0000ff; font-size:small <span style="font-size:small <span style="font-size:small <span style="font-size:small <span style="font-size:small <span style="color:#2b91af; font-size:small <span style="color:#2b91af; font-size:small
<span style="font-size:small <span style="font-size:small
<span style="font-size:small <span style="font-size:small
<span style="font-size:small <span style="font-size:small
<span style="font-size:small <span style="font-size:small
<span style="font-size:small <span style="font-size:small
<span style="font-size:small <span style="font-size:small
<span style="font-size:small <span style="font-size:small
<span style="font-size:small <span style="font-size:small
<span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small
<span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small <span style="color:#a31515; font-size:small
<span style="font-size:small <span style="font-size:small
<span style="font-size:small
<span style="font-size:small
<span style="font-size:small <span style="font-size:small
<span style="font-size:small <span style="font-size:small
View the full article