protected void Page_Load(object sender, System.EventArgs e)
{
if(!Page.IsPostBack)
{
DataBind();
this.btnDelete.Attributes.Add("onclick","return Delete();");
}
}
#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
InitializeComponent();
base.OnInit(e);
}
/
private void InitializeComponent()
{
}
#endregion
#region DataBind
private void DataBind()
{
string sql = "select * from ContactInfo";
DataSet ds=GetDataSet(sql);
string[] cols = new string[ds.Tables[0].Columns.Count];
for(int i=0;i<ds.Tables[0].Columns.Count;i++)
{
cols[i]=ds.Tables[0].Columns[i].ColumnName;
}
string[] width = new string[]{"0","40","15","15","15","15"};
this.WebDataGrid1.ColumnsField = cols;
this.WebDataGrid1.ColumnsWidth = width;
this.WebDataGrid1.GridID = "WebDataGrid1";
this.WebDataGrid1.GridDataSource = ds.Tables[0];
this.WebDataGrid1.GridBind();
}
#endregion
#region GetDataSet
private DataSet GetDataSet(string sql)
{
string constring=System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"];
SqlDataAdapter sda =new SqlDataAdapter(sql,constring);
DataSet ds=new DataSet();
sda.Fill(ds);
return ds;
}
#endregion
#region delete
private void delete(string id)
{
SqlConnection conn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]);
string sql= @"declare @sql nvarchar(400)
set @sql = 'delete from ContactInfo where ID in('+@ID+')'
exec( @sql)";
SqlCommand comm=new SqlCommand(sql,conn);
SqlParameter parm1=new SqlParameter("@ID",SqlDbType.VarChar,20);
parm1.Value=id;
comm.Parameters.Add(parm1);
conn.Open();
comm.ExecuteNonQuery();
conn.Close();
DataBind();
}
#endregion
protected void btnDelete_Click(object sender, System.EventArgs e)
{
string id=this.WebDataGrid1.GridSelectItems;//.Split(',');
if(id.EndsWith(","))
{
id=id.Substring(0,id.Length-1);
}
delete(id);
this.Response.Redirect( Request.Url.ToString(),true );
}