Help Me Modify This code...

[Trips]

Please tell me if there is any Mistake in The code Coz its not working..

public int UpdateData(int tab_id,string tab_name)
{
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\rahulv\My Documents\db5.mdb;Persist Security Info=False");
conn.Open();
OleDbCommand cmd = conn.CreateCommand();
cmd.CommandText = "UPDATE [tab] SET [tab_name]=[@tab_name] WHERE [tab_id]=[@tab_id]";
try
{
cmd.Parameters.AddWithValue("[@tab_id]", tab_id);
cmd.Parameters.AddWithValue("[@tab_name]", tab_name);
return cmd.ExecuteNonQuery();
}
catch
{
throw;
}
finally
{
cmd.Dispose();
conn.Close();
conn.Dispose();
}
Thanks in Advance..


View the full article