How my button text stored into my sql server database?

Black Diamond

15y1.6kVisual Basic .NET

Hi!,

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

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes15y ago
Accepted 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();
}
Vulpes15y ago
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 Diamond15y ago
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 Diamond15y ago
sir, the error is gone but it can't store into my database...do you have other option aside from this code?
Poppa Wallace15y ago
Yes this would be your sql connection.
Black Diamond15y ago
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 Wallace15y ago
string strSQL = "INSERT INTO Test (Test)" + " VALUES ('" + tn.Text.Replace(" ", "") + "')";
SqlCommand cmd = new SqlCommand(strSQL,this.sqlConnection1);
Poppa Wallace15y ago
Not sure if this will work but maybe worth a try

Button btn = (Button) sender;
//your sql data = btn.Text.Replace(" ", "");