storing data from textbox to sql table

Question

hi guys
i dont know if it's the right place
i just want to take value from two textbox & store it into sql database
i am using sql server 2005 & visual studio 2005
i have used a label for checking the data is stoed or not ...but not working
this is the code for the buton event

 SqlConnection con = new SqlConnection();
            con.ConnectionString = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\db.mdf;Integrated Security=True;User Instance=True";

            SqlCommand cmd = new SqlCommand();
            cmd.CommandText = "insert into t1 (name,age) values (@name,@age)";
            cmd.CommandType = CommandType.Text;
            cmd.Connection = con;
            SqlParameter name_param = new SqlParameter("@name", SqlDbType.VarChar, 50);
            name_param.Value = textBox1.Text;
            cmd.Parameters.Add(name_param);

            SqlParameter age_param = new SqlParameter("@age", SqlDbType.VarChar, 10);
            age_param.Value = textBox2.Text;
            cmd.Parameters.Add(age_param);
            con.Open();
            int result = cmd.ExecuteNonQuery();
            if (result != 0)
            {
                lb1.Visible = true;
                lb1.Text = "added";
            }
            else
            {
                lb1.Visible = true;
                lb1.Text = "error";
            }


            con.Close();

can someone pls give some simple explanation of how to solve my problem
thnks

Kirtan Patel · Answer

Hi, One thing you can do my friend to test the thing Just Insert a dataGridView After Inserting Show the record in dataGrid So that you can be sure that records are inserting correctly :) and friend if you having Still Difficulties then send me your project at kirtan007@gmail.com Will try to solve your problem Happy Coding :)

Dipa Ahuja · Answer

thanx so much mr kirtan..!!

gora bhattacharya · Answer

thnks kirtan ...it works... but its a kind of weird thing because i can't see the value while i am editing the project ..... neways thnks again

Kirtan Patel · Answer

Dear Friend , After Compiling your Project Just Copy those Database and exe(s) in /Bin/Debug to any of your desktop folder and run that exe in your desktop folder insert some records then open that Database on desktop there in Visual Studio you will see changes in it :) Happy Coding :)

gora bhattacharya · Answer

ok..i got your point but i cant see any value in the table...... if it is updated in the temp database then after retarting sql server services it should be updated in the main databse but i cant see any values ....... what with this problem ?

Kirtan Patel · Answer

Hi , Friend I Figured out its not problem with SQL Server but When you Run the application in Visual Studio and if you try to Insert Record it Create the another temporary copy of Database in /Bin/Debug and that inserted record is Written into that Temporary database so when you Run the Application in Visual Studio again its again Create new Temporary from your Blank database . This is perfectly correct visual studio is doing that because it don't want to spoil your original database when you developing application it . its no problem with code or anything go ahead develop the application your code will run perfect with your complied exe when you run that exe alone at deployment time :) While in case of ASP.net Visual Studio make changes Directly to Original Database it does not Create Temporary copy it directly writes to original database :)

gora bhattacharya · Answer

thanks Kirtan.... i have used ur code... but the problem is the value is not stored in the databse but the label is working according to the code ....after the button click label is changed to "Aded" i have faced the same problem with my code...is there any problm with my sql server ? because when i work with asp.net , sql server works fine .....

Kirtan Patel · Answer

@above friend For UPDATE, INSERT, and DELETE statements, the return value is the number of rows affected by the command. For all other types of statements, the return value is -1. if the query is not insert update delete then the condition will always produce wrong result because ExecuteNonQuery Will return -1 .

Roei Bar · Answer

well the code specified is better but answer the question asked, which is how to check if the data has been stored in DB, you need the return "rowsAffected" to be bigger then 0 if so it means that the command was successfull upon the Insert.

Kirtan Patel · Answer

Hi, Here is you Corrected code . in most of the Code i have Commented code so that you can understand it easily . .csharpcode, .csharpcode pre { font-size: small; color: black; font-family: Consolas, "Courier New", Courier, Monospace; background-color: #ffffff; /*white-space: pre;*/ } .csharpcode pre { margin: 0em; } .csharpcode .rem { color: #008000; } .csharpcode .kwrd { color: #0000ff; } .csharpcode .str { color: #006080; } .csharpcode .op { color: #0000c0; } .csharpcode .preproc { color: #cc6633; } .csharpcode .asp { background-color: #ffff00; } .csharpcode .html { color: #800000; } .csharpcode .attr { color: #ff0000; } .csharpcode .alt { background-color: #f4f4f4; width: 100%; margin: 0em; } .csharpcode .lnum { color: #606060; } private void btnAdd_Click( object sender, EventArgs e) { // Opening Connection try { SqlConnection con = new SqlConnection( @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True" ); con.Open(); // Define Command Object SqlCommand comm = new SqlCommand( "Insert into t1(Name,Age) values(@Name,@Age)" , con); // Here Use AddWithValue rather than that long procedure for adding parameter comm.Parameters.AddWithValue( "@Name" , txtName.Text); comm.Parameters.AddWithValue( "@Age" , txtAge.Text); // Execute the Query comm.ExecuteNonQuery(); //Finally Close the Connection con.Close(); label1.Visible = true; label1.Text = "Added !!"; } catch { label1.Visible = true; label1.Text = "Error ..!!"; } }

storing data from textbox to sql table

Answers (10)