.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Post New Web Links

About SDF

Posted By:      Posted Date: September 21, 2010    Points: 0   Category :Sql Server
 

Dear Sir.

i wrote this code to insert data in SDF database file

 using (SqlCeCommand com = new SqlCeCommand("INSERT INTO Banks (Bank_code, Bank_name, Phone) VALUES(@p1,@p2,@p3)", def.con))
            {
                com.Parameters.AddWithValue("@p1", Bank_code.Text);
                com.Parameters.AddWithValue("@p2", Bank_name.Text);
                com.Parameters.AddWithValue("@p3", Hotline.Text);
                com.ExecuteNonQuery();
            }
                fillgrid("select * from banks");
                MessageBox.Show("saved");

all command were approved but no data was added in database file.

same for update and delete. While select command retrieved data.

could you help me


View Complete Post


More Related Resource Links

Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend