hi,
i want to insert data nickname when user select name in listbox item.currently i manage to insert emplid and nickname into database.but i dont know how to insert user's nickname whenever user click name from the list.
pls help me.this is urgent.i dont had any idea
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection myConnection = new SqlConnection(connectionString);
myConnection.Open();
string query = "INSERT INTO task_status ([title_task], [pic], [start_date], [due_date], [status_remarks], [Empl_id]) values (@title_task, @pic, @start_date, @due_date, @status_remarks, @Empl_id)";
SqlCommand cmd = new SqlCommand(query, myConnection);
cmd.Parameters.Add("@title_task", SqlDbType.VarChar).Value = TextBox1.Text.Trim();
cmd.Parameters.Add("@pic", SqlDbType.VarChar, 50);
Boolean IsFirst = true;
foreach (ListItem item in ListBox1.Items)
{
if (item.Selected)
{
if (IsFirst)
{
cmd.Parameters["@pic"].Value = item.Text;
IsFirst = false;
}
else
{
cmd.Parameters["@pic"].Value += "," + item.Text;
}
Label36.Text = item.Text;
}
}
cmd.Parameters.Add("@start_date", SqlDbType.DateTime).Value = DateTime.Parse(TextBox2.Text);
cmd.Parameters.Add("@due_date", SqlDbType.DateTime).Value = DateTime.Parse(TextBox3.Text);
cmd.Parameters.Add("@status_remarks", SqlDbType.VarChar).Value = TextBox5.Text.Trim();
cmd.Parameters.Add("@Empl_id", SqlDbType.VarChar).Value = Label28.Text.Trim();
}
protected void ComboBoxBind()
{
SqlConnection con = new SqlConnection(connectionString);
con.Open();
SqlDataAdapter da = new SqlDataAdapter("select id, Nama from login_staff order by Nama asc", con);
DataSet ds = new DataSet();
da.Fill(ds, "login_staff");
ListBox1.DataSource = ds.Tables["login_staff"].DefaultView;
ListBox1.SelectedIndex = 0;
ListBox1.DataTextField = "Nama";
ListBox1.DataValueField = "id";
ListBox1.DataBind();
ListBox1.Items.Insert(0, "--Select--");
con.Close();
}