inserting data

[sandy_r]

hello, I am trying to insert data into a database.My code gives no error. But the values are not inserted into database. Please help...can anyone send a sample code

[M K BASHER]

Could u show ur code? Is there any error in database connection?

[N a v a n e e t h]

Your question is not explaining anything about what you did. Have you put breakpoints and stepped into the code ?

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia How to use google | Ask smart questions

[varun_mca_ju 0]

are you trying to insert data from textBox or other controls? are you using Oracle or SQl ?...plz. give some details....

[sandy_r]

I am trying to insert from textbox.I am using SQL

[sandy_r]

No..Please tell how to go about

[Ahsan225]

use a breakpoint to see if the text box value is parsed properly in the query. also, check the single and double quotes. they need to be in a proper sequence for the value to be fetched.

[varun_mca_ju 0]

using System.Data.SqlClient; using System.Data.OleDb; code for connecting to SQL database:- try { SqlConnection mc = new SqlConnection(Persist Security Info=False;User ID=sa;Initial Catalog=DataBase_Name;Data Source= SQL_Server_Name"); SqlDataAdapter da =new SqlDataAdapter("Select * from Table_name", mc); DataSet ds =new DataSet(); da.Fill(ds,"Table_name"); MessageBox.Show("Connection Successfull"); } catch(Exception ex) {MessageBox.Show(ex.Message); } code for inserting data from textBox:- try{ SqlCommand insertCmd=new SqlCommand("insert into Table_Name(Column_Name)values(@Variable_name)",Connection_Name); insertCmd.Parameters.Add("@Variable_Name",SqlDbType.Nchar,10); insertCmd.Parameters["@Variable_Name"].Value=textBox1.Text; insertCmd.ExecuteNonQuery(); MessageBox.Show("Records inserted successfully"); } catch(Exception ex) {MessageBox.Show(ex.Message);}