protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { lista = iusu.ListarUsuarios(); GV1.DataSource = lista; GV1.DataBind(); GV1.HeaderRow.Cells[6].Visible = false; GV1.HeaderRow.Cells[0].Text = "ID Usuario"; GV1.HeaderRow.Cells[1].Text = "Nombre"; GV1.HeaderRow.Cells[2].Text = "Primer apellido"; GV1.HeaderRow.Cells[3].Text = "Segundo apellido"; GV1.HeaderRow.Cells[5].Text = "ID Rol"; GV1.HeaderRow.Cells[7].Text = "Correo"; for (int w = 0; w < GV1.Rows.Count; w++) { GV1.Rows[w].Cells[6].Visible = false; } divMantenimiento.Visible = false; ListItem i; i = new ListItem("Dentista", "1"); DDLRol.Items.Add(i); i = new ListItem("Asistente", "2"); DDLRol.Items.Add(i); } }
public void QueryFunc(string qr) { try { MySqlConnection con = new MySqlConnection(connectionString); con.Open(); String query2 = @"SELECT NID,QRID,UID, (SELECT FULLNAME FROM USERS WHERE UID = N.UID) AS FULLNAME, UPDATEDATE,TYPEN, (SELECT TYPEV FROM TYPES WHERE TYPEN = N.TYPEN) AS TYPEV, TXTNOTE,LOC FROM NOTES AS N WHERE QRID = @QRID ORDER BY UPDATEDATE DESC"; MySqlCommand com2 = new MySqlCommand(query2, con); com2.Parameters.AddWithValue("@QRID", QRIDV); MySqlDataAdapter adapter = new MySqlDataAdapter(com2); DataSet ds = new DataSet(); adapter.Fill(ds); con.Close(); GV1.DataSource = ds; GV1.DataBind(); } catch (Exception ex) { Response.Write(ex.Message); } }
protected void GridBind() { Snlg_DBConnect vt = new Snlg_DBConnect(true); GV1.DataSource = vt.DBReaderOlustur("SELECT ContainerId, PHName, Title FROM snlg_V1.TblPlaceHolders ORDER BY PHName", CommandType.Text); GV1.DataBind(); vt.Kapat(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DataModel ob = new DataModel(); GV1.DataSource = ob.listadoEncuesta(); GV1.DataBind(); } }
private void Sb_Export_Click(object sender, EventArgs e) { SaveFileDialog SFD = new SaveFileDialog(); if (SFD.ShowDialog() == DialogResult.OK) { GV1.ExportToXlsx(SFD.FileName); } }
protected void btn3_Click(object sender, EventArgs e) { MultiView1.ActiveViewIndex = 2; if (!IsPostBack) { DataModel ob = new DataModel(); GV1.DataSource = ob.listadoEncuesta(); GV1.DataBind(); } }
protected void ddlCuatri_SelectedIndexChanged(object sender, EventArgs e) { if (ddlCarrera.SelectedIndex != 0 && ddlCuatri.SelectedIndex != 0) { if (GV1.Rows.Count > 1) { for (int i = 2; i < GV1.Columns.Count; i++) { GV1.Columns[i].Visible = false; } } strSQL = "select id, Nombre from catMateria where CveCarrera='" + ddlCarrera.SelectedValue.ToString() + "' and CveCuatri='" + ddlCuatri.SelectedValue.ToString() + "'"; dt2 = conex.ObtenerDatos(strSQL); claves = new int[dt2.Rows.Count]; for (int i = 0; i < dt2.Rows.Count; i++) { claves[i] = int.Parse(dt2.Rows[i]["id"].ToString()); } Session["columnas"] = dt2.Rows.Count; Session["claves"] = claves; DataTable dt = new DataTable(); DataRow row; for (int i = 0; i < 21; i++) { row = dt.NewRow(); dt.Rows.Add(row); } GV1.DataSource = dt; GV1.DataBind(); for (int j = 1; j < 21; j++) { GV1.Rows[j].Cells[0].Text = j.ToString(); GV1.Rows[j].Cells[1].Text = Pregs[j]; } GV1.Columns[0].Visible = true; GV1.Columns[1].Visible = true; for (int k = 2; cont < dt2.Rows.Count; k++) { GV1.HeaderRow.Cells[k].Text = dt2.Rows[cont]["nombre"].ToString(); cont++; if (!GV1.HeaderRow.Cells[k].Text.Contains("Materia")) { GV1.Columns[k].Visible = true; } else { GV1.Columns[k].Visible = false; } } } GV1.Rows[0].Visible = false; FilaObserva.Visible = true; TextoObserva.Visible = true; }
void filldata() { con.Open(); SqlDataAdapter da = new SqlDataAdapter("select SlNO,ContractNO,Event,Frequency,ExecutionDate,Basis,InvoiceNo,InvoiceRaised,AmountInRs,Status from Royality where ContractNo='" + txtContractNo.Text.Trim() + "'", con); DataTable dt = new DataTable(); da.Fill(dt); GV1.DataSource = dt; GV1.DataBind(); con.Close(); }
private void QueryFunc(string Qr = "") { try { string connectionString = ConfigurationManager.ConnectionStrings["ConnDB"].ConnectionString; MySqlConnection conn = new MySqlConnection(connectionString); conn.Open(); if (Session["OID"] != null) { Qr = Session["OID"].ToString(); } MySqlCommand cmd = new MySqlCommand(@"SELECT QRID,NID,UID,OID ,(SELECT NAME FROM OFFICES WHERE OID = N.OID) AS NAME ,(SELECT FULLNAME FROM USERS WHERE UID = N.UID) AS FULLNAME ,UPDATEDATE,TYPEN, (SELECT TYPEV FROM TYPES WHERE TYPEN = N.TYPEN) AS TYPEV ,(SELECT COUNT(QRID) FROM NOTES WHERE QRID = N.QRID) as COUNTQRID ,TXTNOTE,LOC FROM NOTES AS N WHERE NID = (SELECT MAX(NID) FROM notes WHERE QRID = N.QRID GROUP BY QRID) AND OID = @OID GROUP BY QRID ORDER BY UPDATEDATE DESC", conn); cmd.Parameters.AddWithValue("@OID", Qr); MySqlDataAdapter adapter = new MySqlDataAdapter(cmd); DataSet ds = new DataSet(); adapter.Fill(ds); conn.Close(); if (ds.Tables[0].Rows.Count == 0) { //Response.Write("<script>alert('حدث خطأ : لاتوجد ملاحظات')</script>"); //P1.Visible = false; //Response.Redirect("Home.aspx"); ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('حدث خطأ : لاتوجد ملاحظات');window.location ='Home.aspx';", true); } else { GV1.DataSource = ds; GV1.DataBind(); P1.Visible = true; } } catch (Exception ex) { Response.Write("<script>alert('" + "حدث خطأ : " + ex.Message + "')</script>"); } }
protected void OnPaging(object sender, GridViewPageEventArgs e) { try { GV1.PageIndex = e.NewPageIndex; GV1.DataBind(); QueryFunc(TbQRID.Text); } catch (Exception ex) { Response.Write("<script>alert('" + "حدث خطأ : " + ex.Message + "')</script>"); } }
protected void SearchBT_Click(object sender, EventArgs e) { decimal d1 = 0, d2 = 0; if (!string.IsNullOrEmpty(StyleTB.Text.Trim())) { 入庫應付LB.BackColor = System.Drawing.Color.White; 入庫應付LB.ForeColor = System.Drawing.Color.Black; 入庫暫估LB.BackColor = System.Drawing.Color.White; 入庫暫估LB.ForeColor = System.Drawing.Color.Black; DataTable dt = new DataTable(); using (SqlConnection Conn = new SqlConnection(strConnectString)) { SqlDataAdapter myAdapter = new SqlDataAdapter(DB1(), Conn); myAdapter.Fill(dt); //---- 這時候執行SQL指令。取出資料,放進 DataSet。 } if (dt.Rows.Count > 0) { d1 = Convert.ToDecimal(dt.Compute("Sum(數量)", "true")); GV1.DataSource = dt; GV1.DataBind(); } DataTable dt2 = new DataTable(); using (SqlConnection Conn = new SqlConnection(strConnectString)) { SqlDataAdapter myAdapter = new SqlDataAdapter(DB2(), Conn); myAdapter.Fill(dt2); //---- 這時候執行SQL指令。取出資料,放進 DataSet。 } if (dt2.Rows.Count > 0) { d2 = Convert.ToDecimal(dt2.Compute("Sum(數量)", "true")); GV2.DataSource = dt2; GV2.DataBind(); } 入庫應付LB.Text = d1.ToString(); 入庫暫估LB.Text = d2.ToString(); if (d1 > d2) { 入庫應付LB.BackColor = System.Drawing.Color.Red; 入庫應付LB.ForeColor = System.Drawing.Color.Yellow; } else if (d1 < d2) { 入庫暫估LB.BackColor = System.Drawing.Color.Red; 入庫暫估LB.ForeColor = System.Drawing.Color.Yellow; } } }
protected void btnGridDisplay_Click(object sender, EventArgs e) { string qry = "select * from emp"; //dbc.executeIUD("insert into emp values (4, 'Ruhita', 20000, 2)"); //DataTable dt = dbc.executeSelectQueryWithDT(qry); //SqlDataReader dr = dbc.executeSelectQueryWithDR(qry); DataSet ds = new DataSet(); ds = dbc.executeSelectQueryWithDS(qry); //DG1.AutoGenerateColumns = true; GV1.DataSource = ds.Tables[0]; GV1.DataBind(); DG1.DataSource = ds.Tables[0]; DG1.DataBind(); //Persist.print = "<br />Success!"; }
protected void RecieveNewRequest(object sender, EventArgs e) { String connectionString; SqlConnection cnn; connectionString = WebConfigurationManager.ConnectionStrings["constr"].ConnectionString; cnn = new SqlConnection(connectionString); cnn.Open(); SqlCommand cmd = new SqlCommand("Receive_New_Request", cnn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@contributor_id", 1)); cmd.Parameters.Add("@can_receive", System.Data.SqlDbType.Int).Direction = System.Data.ParameterDirection.Output; SqlDataReader rdr = cmd.ExecuteReader(); int can_receive = Convert.ToInt32(cmd.Parameters["@can_receive"].Value); rdr.Close(); if (can_receive == 1) { SqlCommand dbo = new SqlCommand("Receive_New_Requests", cnn); //CommandType = System.Data dbo.CommandType = System.Data.CommandType.StoredProcedure; dbo.Parameters.Add(new SqlParameter("@contributor_id", 1)); if (L.Text.Equals("")) { dbo.Parameters.Add(new SqlParameter("@request_id", DBNull.Value)); } else { dbo.Parameters.Add(new SqlParameter("@request_id", L.Text)); } GV1.DataSource = dbo.ExecuteReader(); GV1.DataBind(); } else { label.Text = "No New Requests"; } cnn.Close(); }
protected void BtnExcel_Click(object sender, EventArgs e) { if (GV1.Rows.Count < 1) { Misc.Message(Response, "无数据要导出!"); return; } Response.ClearContent(); Response.AddHeader("content-disposition", "attachment; filename=wuzixuqiu.xls"); Response.ContentType = "application/excel"; StringWriter sw = new StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); GV1.RenderControl(htw); Response.Write(sw.ToString()); Response.End(); }
protected void Page_Load(object sender, EventArgs e) { //creating a table manually DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("BlogID", Type.GetType("System.String"))); dt.Columns.Add(new DataColumn("BlogText", Type.GetType("System.String"))); dt.Columns.Add(new DataColumn("Mood", Type.GetType("System.String"))); dt.Rows.Add(dt.NewRow()); dt.Rows.Add(dt.NewRow()); dt.Rows.Add(dt.NewRow()); dt.Rows[0]["BlogID"] = "FirstID"; dt.Rows[0]["BlogText"] = "Awesome!"; dt.Rows[0]["Mood"] = "This is for awesome people"; dt.Rows[1]["BlogID"] = "SecondID"; dt.Rows[1]["BlogText"] = "Take it easy..."; dt.Rows[1]["Mood"] = "Stop messing"; dt.Rows[2]["BlogID"] = "ThirdID"; dt.Rows[2]["BlogText"] = "Great!"; dt.Rows[2]["Mood"] = "Well done"; dt.PrimaryKey = new DataColumn[] { dt.Columns["BlogID"] }; GV3.DataSource = dt; GV3.DataBind(); DataSet ds = new DataSet(); ds.Tables.Add(dt); GV4.DataSource = ds.Tables[0]; GV4.DataBind(); DALBlog blogDAL = new DALBlog("cheeseConnectionString"); GV1.DataSource = blogDAL.GetDataTable("SELECT * FROM Blogs", "Blog"); GV1.DataBind(); Database db = DatabaseFactory.CreateDatabase("cheeseConnectionString"); GV2.DataSource = db.ExecuteDataSet(db.GetSqlStringCommand("SELECT * FROM Blogs")); GV2.DataBind(); }
protected void showall(object sender, EventArgs e) { //Response.Write(L1.Text); cnn = new SqlConnection(connectionString); cnn.Open(); SqlCommand cmd = new SqlCommand("Show_Event", cnn); cmd.CommandType = System.Data.CommandType.StoredProcedure; if (L1.Text.Equals("")) { cmd.Parameters.Add(new SqlParameter("@event_id", DBNull.Value)); } else { cmd.Parameters.Add(new SqlParameter("@event_id", L1.Text)); } GV1.DataSource = cmd.ExecuteReader(); GV1.DataBind(); cnn.Close(); }
protected void ShowMessages(object sender, EventArgs e) { String connectionString; SqlConnection cnn; connectionString = WebConfigurationManager.ConnectionStrings["constr"].ConnectionString; cnn = new SqlConnection(connectionString); cnn.Open(); String ID = Session["ids"].ToString(); SqlCommand dbo = new SqlCommand("Show_Message", cnn); dbo.CommandType = System.Data.CommandType.StoredProcedure; dbo.Parameters.Add(new SqlParameter("@contributor_id", Convert.ToInt32(ID))); GV1.DataSource = dbo.ExecuteReader(); GV1.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (HttpContext.Current.Application["AccessToken"] != null) { List <UserType> userList = new List <UserType>(); List <AttributeType> attributeList = new List <AttributeType>(); string accessKey = RDSContext.Create().awsCredentials.FirstOrDefault().AccessKey; string secretKey = RDSContext.Create().awsCredentials.FirstOrDefault().SecretKey; BasicAWSCredentials basicAWSCredentials = new BasicAWSCredentials(accessKey, secretKey); AmazonCognitoIdentityProviderClient provider = new AmazonCognitoIdentityProviderClient(basicAWSCredentials); if (HttpContext.Current.Application["AccessToken"] != null) { ListUsersRequest listUserRequest = new ListUsersRequest { UserPoolId = ConfigurationManager.AppSettings["USERPOOL_ID"], AttributesToGet = new List <string> { "email" }, }; ListUsersResponse response = provider.ListUsers(listUserRequest); userList.AddRange(response.Users); foreach (UserType u in userList) { attributeList.AddRange(u.Attributes); } GV1.DataSource = attributeList.Select(t => t.Value); GV1.DataBind(); GV1.HeaderRow.Cells[0].Text = "Email List"; } } }
protected void btnAceptar_Click(object sender, EventArgs e) { r = Valida(); if (r) { int cl = 0; int total = 0; int colum = (int)Session["columnas"]; int[] claves1 = (int[])Session["claves"]; col = 1; for (int j = 1; j <= colum; j++) { strSQL = "insert into evaluacion values("; for (int i = 1; i < 21; i++) { TextBox t1 = (GV1.Rows[i].Cells[j].FindControl("txt" + col) as TextBox); strSQL += int.Parse(t1.Text) + ","; total += int.Parse(t1.Text); } col++; strSQL += total + ",'" + ddlGpo.SelectedItem.ToString() + "','" + Convert.ToDateTime(txtFecha.Text) + "','" + txtObserva.Text + "'," + claves1[cl] + ")"; cl++; try { conex.GuardarDatos(strSQL); } catch (Exception ex) { Response.Write("<script type=text/javascript>alert('" + ex.Message + "')</script>"); return; } strSQL = ""; total = 0; } } Response.Write("<script type=text/javascript>alert('¡Gracias por responder la encuesta!')</script>"); GV1.Dispose(); Response.Redirect("~/Inicio.aspx"); }
protected void btnExportWord_Click(object sender, EventArgs e) { try { ////////////////////////////////////// GV1.AllowPaging = false; QueryFunc(TbQRID.Text); GV1.Columns[8].Visible = false; GV1.Columns[9].Visible = false; ///////////////////////////////////// Response.Clear(); Response.Buffer = true; Response.AddHeader("content-disposition", "attachment;filename=GridViewExport.doc"); Response.Charset = ""; Response.ContentType = "application/vnd.ms-word "; StringWriter sw = new StringWriter(); HtmlTextWriter hw = new HtmlTextWriter(sw); GV1.AllowPaging = false; GV1.DataBind(); QueryFunc(TbQRID.Text); //GV1.Columns[8].Visible = false; //GV1.Columns[9].Visible = false; GV1.RenderControl(hw); Response.Output.Write(sw.ToString()); Response.Flush(); Response.End(); ////////////////////////////////////// GV1.Columns[8].Visible = true; GV1.Columns[9].Visible = true; ///////////////////////////////////// } catch (Exception ex) { Response.Write("<script>alert('" + "حدث خطأ : " + ex.Message + "')</script>"); } }
protected void Page_Load(object sender, EventArgs e) { _logger.Info("Start program."); try { string s = "abc"; int i = int.Parse(s); } catch (Exception ex) { _logger.Debug(ex); } _logger.Info("Stop program."); DataAccess a = new DataAccess(); string da = "select * from HR_tblEmp"; string da1 = "select LSDeptID from LS_tblDepartment"; string da2 = "select LSJobTitleID from LS_tblJobTitle"; string da3 = "select LSNationalityID from LS_tblNationality"; GV1.DataSource = a.ExcuteReader(da); GV1.DataBind(); ddldept.DataSource = a.ExcuteReader(da1); ddldept.DataTextField = "LSDeptID"; ddldept.DataValueField = "LSDeptID"; ddldept.DataBind(); ddlJob.DataSource = a.ExcuteReader(da2); ddlJob.DataTextField = "LSJobTitleID"; ddlJob.DataValueField = "LSJobTitleID"; ddlJob.DataBind(); ddlNation.DataSource = a.ExcuteReader(da3); ddlNation.DataTextField = "LSNationalityID"; ddlNation.DataValueField = "LSNationalityID"; ddlNation.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { try { if (!IsPostBack) { divMantenimiento.Visible = false; ListItem i; i = new ListItem("Niño", "1"); DDLTipoOntograma.Items.Add(i); i = new ListItem("Adulto", "2"); DDLTipoOntograma.Items.Add(i); //int admin = Convert.ToInt32(Session["id"]); lista = usu.ListarPacientes(); GV1.DataSource = lista; GV1.DataBind(); GV1.HeaderRow.Cells[7].Visible = false; GV1.HeaderRow.Cells[0].Text = "ID Paciente"; GV1.HeaderRow.Cells[1].Text = "Nombre"; GV1.HeaderRow.Cells[2].Text = "Primer apellido"; GV1.HeaderRow.Cells[3].Text = "Segundo apellido"; GV1.HeaderRow.Cells[4].Text = "Telefono"; GV1.HeaderRow.Cells[5].Text = "Correo"; GV1.HeaderRow.Cells[6].Text = "Fecha de Naciemiento"; for (int w = 0; w < GV1.Rows.Count; w++) { GV1.Rows[w].Cells[7].Visible = false; } } } catch (Exception) { MostrarMensajeError("Ha ocurrido un error al cargar los datos, intente mas tarde"); } }
//////////////////////////////////////////////////////////////// protected void PrintCurrentPage(object sender, EventArgs e) { try { GV1.Columns[8].Visible = false; GV1.Columns[9].Visible = false; GV1.PagerSettings.Visible = false; GV1.DataBind(); QueryFunc(TbQRID.Text); StringWriter sw = new StringWriter(); HtmlTextWriter hw = new HtmlTextWriter(sw); GV1.RenderControl(hw); string gridHTML = sw.ToString().Replace("\"", "'") .Replace(System.Environment.NewLine, ""); StringBuilder sb = new StringBuilder(); sb.Append("<script type = 'text/javascript'>"); sb.Append("window.onload = new function(){"); sb.Append("var printWin = window.open('', '', 'left=0"); sb.Append(",top=0,width=1000,height=600,status=0');"); sb.Append("printWin.document.write(\""); sb.Append(gridHTML); sb.Append("\");"); sb.Append("printWin.document.close();"); sb.Append("printWin.focus();"); sb.Append("printWin.print();"); sb.Append("printWin.close();};"); sb.Append("</script>"); ClientScript.RegisterStartupScript(this.GetType(), "GridPrint", sb.ToString()); GV1.PagerSettings.Visible = true; GV1.DataBind(); QueryFunc(TbQRID.Text); } catch (Exception ex) { Response.Write("<script>alert('" + "حدث خطأ : " + ex.Message + "')</script>"); } }
private void QueryFunc(string Qr = "") { try { HyperLink1.Text = ""; MySqlConnection conn = new MySqlConnection(connectionString); conn.Open(); Qr = '%' + Qr.Trim() + '%'; MySqlCommand cmd = new MySqlCommand(@"SELECT * FROM pilgrims WHERE (QRID LIKE @P1 OR PASSPORTID LIKE @P1 OR FULLNAME LIKE @P1 OR NATIONALITY LIKE @P1 OR BLOOD LIKE @P1 OR ADDRESS LIKE @P1) AND OID = @OID", conn); cmd.Parameters.AddWithValue("@OID", Session["OID"].ToString()); cmd.Parameters.AddWithValue("@P1", Qr); MySqlDataAdapter adapter = new MySqlDataAdapter(cmd); DataSet ds = new DataSet(); adapter.Fill(ds); conn.Close(); GV1.DataSource = ds; GV1.DataBind(); } catch (Exception ex) { Response.Write("<script>alert('" + "حدث خطأ : " + ex.Message + "')</script>"); } }
protected void LoadGrid() { GV1.DataSource = GetAll(ddlType.SelectedValue); GV1.DataBind(); }
protected void GVDataBind() { GV1.DataSource = GVData(); GV1.DataBind(); }
protected void Button1_Click(object sender, EventArgs e) { string sql = "select * from HR_tblEmp"; DataAccess db = new DataAccess(); string Gender = ""; if (rdoSex.Checked == true) { Gender = "1"; } else { Gender = "0"; } int Active; if (rdoTrue.Checked == true) { Active = 1; } else { Active = 0; } if (EmpCode.Text.Length < 0 || txtAddress.Text.Length < 0 || txtDOB.Text.Length < 0 || txtFirst.Text.Length < 0 || txtJoinDate.Text.Length < 0 || txtLast.Text.Length < 0) { Response.Write("Vui lòng nhập đầy đủ các thông tin trên"); } else if (EmpCode.Text.Length > 5) { Response.Write("Mã không được quá 5 số"); } else if (txtFirst.Text.Length > 30 || txtLast.Text.Length > 30) { Response.Write("Tên không quá 30 ký tự"); } else if (kiemtrangay() < 6570) { Response.Write("Bạn chưa đủ 18 tuổi"); } else if (IsNumber(EmpCode.Text) == false) { Response.Write("Mã không nhập ký tự"); } else { List <SqlParameter> lst = new List <SqlParameter>(); lst.Add(new SqlParameter("@EmpCode", EmpCode.Text)); lst.Add(new SqlParameter("@JoinDate", txtJoinDate.Text)); lst.Add(new SqlParameter("@LSDeptID", ddldept.SelectedValue.ToString())); lst.Add(new SqlParameter("@LSJobTitleID", ddlJob.SelectedValue.ToString())); lst.Add(new SqlParameter("@Active", Active)); lst.Add(new SqlParameter("@FirstName", txtFirst.Text)); lst.Add(new SqlParameter("@LastName", txtLast.Text)); lst.Add(new SqlParameter("@DOB", txtDOB.Text)); lst.Add(new SqlParameter("@Address", txtAddress.Text)); lst.Add(new SqlParameter("@Gender", Gender)); lst.Add(new SqlParameter("@LSNationalityID", ddlNation.SelectedValue.ToString())); db.ExcuteNonQueryPro("sp_F02", lst); GV1.DataSource = db.ExcuteReader(sql); GV1.DataBind(); Response.Write("Success!"); } }