i have asp.net project which has dropdownlist. i need to insert data into my database according to dropdownlist condition.
For example; in my project, i will choose the employee and i will insert the some values from my textboxes and after clicking button on the bottom, i need to insert the changes into database that selected employee from my dropdownlist.
Here is the button click codes;
protected void Button2_Click(object sender, EventArgs e)
SqlCommand cmd = new SqlCommand();
string strSQL = "Insert INTO info (day,event) Values (@day,@event)";
string bag_str = WebConfigurationManager.ConnectionStrings["asgdb01ConnectionString"].ConnectionString;
conn = new SqlConnection(bag_str);
cmd.Connection = conn;
cmd.CommandText = strSQL;
cmd.Parameters.Add(new SqlParameter("@day", TextBox1.Text));
cmd.Parameters.Add(new SqlParameter("@event", TextBox2.Text));
int i = cmd.ExecuteNonQuery();
if (i > 0)
Waiting your helps. I looked around too much but couldnt see the example or idea like that.
Please i need your helps.
The answer is nearly found.Thanks for your answer. But here is the problem. This commands adds new rows into my table, i need to insert an existing row.
Here something to make your mind clear;
i have penalties table which includes that columuns ;
ID NAME TYPE MON TUE....SUN TOTAL DAY P1 P2 OVER DATE
1 mike out 250 350..... 0 900 - - - - 22-06-2012
2 john in 350 150 ....100 1100 - - - - 28-06-2012
As you see from here my friend, i will choose the dates from my datetimepickers, i will choose the employee from my dropdownlist and i will enter the values into textboxes and after that i will click finish button.
the day,p1,p2 and over values must be inserted into that chosen employee.
waiting your answer please, i need it too badly..