How my button text stored into my sql server database?

Question

Hi!, How can i store my button text stored into my database using sql server 2005 ?

Vulpes · Answer

Jay's code is on the right lines though it's better to get into the habit of using parameters. Something like this: SqlConnection conn = new SqlConnection(connectionString); try { conn.Open(); string insert = "INSERT INTO Test (test) VALUES (@Param)"; SqlCommand cmd = new SqlCommand(insert, conn); cmd.Parameters.Add("@Param", SqlDbType.VarChar, 20); // or whatever it is cmd.Parameters["@Param"].Value = button1.Text; cmd.ExecuteNonQuery(); } catch(SqlException ex) { MessageBox.Show(ex.Message); } finally { conn.Close(); }

Poppa Wallace · Answer

string strSQL = "INSERT INTO Test (Test)" + " VALUES ('" + tn.Text.Replace(" ", "") + "')"; SqlCommand cmd = new SqlCommand(strSQL,this.sqlConnection1);

Vulpes · Answer

If the text of the button increments every time a voter presses it, then - after the first vote has been cast - you will need to do an update query rather than an insert query. The rest of the code would be exactly the same. Unless you're worried about losing votes if there's a system failure, there's no need to update the database every time a vote is cast but you can do so if you wish.

Black Diamond · Answer

hi! vulpes, finally i can store my button text to my sql database but i have a problem, i want to make a increment value in every user pressed that button....actually im building a system the automatic voting machine thats our project designproject...so expectedly there many voters pressed that button..how can i do it?

Black Diamond · Answer

sir, the error is gone but it can't store into my database...do you have other option aside from this code?

Poppa Wallace · Answer

Yes this would be your sql connection.

Black Diamond · Answer

hi! Jay, string strSQL = "INSERT INTO Test (Test)" + " VALUES ('" + tn.Text.Replace(" ", "") + "')"; SqlCommand cmd = new SqlCommand(strSQL,this.sqlConnection1); What is this.sqlConnection1?, is that my sql connection? I got an error in this.sqlConnection1.

Poppa Wallace · Answer

Not sure if this will work but maybe worth a try Button btn = (Button) sender; //your sql data = btn.Text.Replace(" ", "");

How my button text stored into my sql server database?

Answers (8)