Unable to update records in a table

Question

Am unable to update records in a table here is the code am using. am able to read the table data but when i update it is not updating. Here is the code.

 

string Conx = @"Data Source=" +

(System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase)) +

"\\ReaderDB.sdf;Persist Security info=False";

conn =new SqlCeConnection(Conx);

conn.Open();

SqlCeTransaction Trans = conn.BeginTransaction();

try

{

istr = "Update TblLogger set CRead=" + CRead + ",Consumption=" + Consumption + ",Status='" + cboStatus.Text + "' where WSNO='" + cellValue + "'";

comm.Connection = conn;

comm = new SqlCeCommand(istr, conn, Trans);

comm.ExecuteNonQuery();

Trans.Commit();

txtReads.Text = "";

}

catch (Exception)

{

MessageBox.Show("Data not posted").ToString();

}

 

Answer 1

Hi Shiny,


Can you tell me which broser are you using?


Cheers !
Manpreet

Answer 2

Thanks Vithal for the response.
Have tried this but no luck.
Appreciate your help further.

Regards,
Shiny Joseph

Answer 3

I think its due to windows authentication ,try by opening studio as Run as administrator