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)
{
SqlConnection conn;
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);
conn.Open();
cmd.Connection = conn;
cmd.CommandText = strSQL;
cmd.Parameters.Add
cmd.Parameters.Add(new SqlParameter("@day", TextBox1.Text));
cmd.Parameters.Add(new SqlParameter("@event", TextBox2.Text));
int i = cmd.ExecuteNonQuery();
conn.Close();
if (i > 0)
Response.Write("Data Inserted");
else
Response.Write("Try Again");
}
Here is something to make clear on your mind;
|Dropdownlist1| (i will click here and names will appear you know.)
-Mike
-John
-Susan
-Kevin
(label1) DAY : ______________ (TEXTBOX1)
(label2) EVENT : ______________ (TEXTBOX2)
|FINISH| (button1)
You see from here, i will click dropdownlist and i will choose the employee. After i will enter the values and i will click on FINISH button and data will be inserted into that selected employee.
Here is the key question; how can i tell the button_click event; you will insert these data's into selected employees table which i have chosen the employee from dropdownlist. okay ?
Waiting your helps with four eye.
Thanks.
Did you understand what i mean my friends ? Thanks.
Edit 1 :
Thank you for your answers my friends, but here is the problem ;
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],[WED],[THU],[FRI],[SAT],[SUN],[TOTAL],[DAY],[P1],[P2],[OVER].
Includes ;
ID NAME TYPE MON TUE....SUN TOTAL DAY EVENT 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..
thanks.