protected void Button1_Click(object sender, EventArgs e) { string connStr = ConfigurationManager.ConnectionStrings["mydms"].ConnectionString; SqlConnection mySQLconnection = new SqlConnection(connStr); try{ mySQLconnection.Open(); for (int i = 0; i < Repeater2.Items.Count; i++) { DropDownList DropDownListcontrol = ((DropDownList)Repeater2.Items[i].FindControl("DropDownList4")); Label DocId = ((Label)Repeater2.Items[i].FindControl("DocId")); SqlCommand cmd = new SqlCommand("approveddd", mySQLconnection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@DocID", SqlDbType.Int).Value = Convert.ToInt32((DocId.Text)); cmd.Parameters.Add("@ApproveID", SqlDbType.Int).Value = Convert.ToInt32(DropDownListcontrol.SelectedValue); cmd.Parameters.Add("@ApproveBy", SqlDbType.VarChar, 50).Value = (Session["Login2"]); cmd.ExecuteNonQuery(); DMSLIB.Doc myDoc = new DMSLIB.Doc(); myDoc.MarkDocAs(Convert.ToInt16(DocId.Text), Convert.ToInt32(DropDownListcontrol.SelectedValue)); } } catch (Exception ex) { apfi.Text = "Error"; } finally { mySQLconnection.Close(); } }
Convert.ToInt32
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)