62,265
社区成员
发帖
与我相关
我的任务
分享
#region 这个函数的功能就是绑定数据。这里我帮定了十行空数据。
private void DataEmptyBanding()
{
string strQuery = "select * from employees";
DataSet ds = db.GetDataSet(strQuery);
/*追加十行空数据行*/
for(int i=0;i<=9;i++)
{
/*下面的就是绑定一个空行,把它放在上面的ds的末尾*/
DataRow row = ds.Tables[0].NewRow();
row["EmployeeID"] = "";
row["EmployeeName"] = "";
ds.Tables[0].Rows.Add(row);
}
/*帮定datagrid*/
int num= ds.Tables[0].Rows.Count;
DataGrid1.DataSource = ds;
DataGrid1.DataBind();
}
#endregion
int num=((DataSet)DataGrid1.DataSource).Tables[0].Rows.Count;
int dd=DataGrid1.Items.Count;
for(int i=0;i<num;i++)
{ TextBox tbx=new TextBox();
tbx=(TextBox)DataGrid1.Items[i].FindControl("TextBox1"); tbx.Attributes.Add("onkeydown","if(event.keyCode==13) event.keyCode=9"); tbx.Attributes.Add("onblur","showValueFromEmployeeID(this)"); }
for(int i=1;i<num;i++)
{
TextBox tbx=new TextBox();
tbx=(TextBox )DataGrid1.Items[i].FindControl("TextBox2");
tbx.Attributes.Add("onkeydown","if(event.keyCode==13) event.keyCode=9");
//tbx.Attributes.Add("onblur","showNewDataGrid()");
}
protected void DataGrid1_ItemDataBound(object sender, DataGridItemEventArgs e)
{
//int num = ((DataTable)DataGrid1.DataSource).Rows.Count;
//int dd = DataGrid1.Items.Count;
//for (int i = 0; i < num; i++)
//{
// TextBox tbx = new TextBox();
// tbx = (TextBox)DataGrid1.Items[i].FindControl("TextBox1"); tbx.Attributes.Add("onkeydown", "if(event.keyCode==13) event.keyCode=9"); tbx.Attributes.Add("onblur", "showValueFromEmployeeID(this)");
//}
//for (int i = 1; i < num; i++)
//{
// TextBox tbx = new TextBox();
// tbx = (TextBox)DataGrid1.Items[i].FindControl("TextBox2");
// tbx.Attributes.Add("onkeydown", "if(event.keyCode==13) event.keyCode=9");
// //tbx.Attributes.Add("onblur","showNewDataGrid()");
//}
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
((TextBox)e.Item.FindControl("TextBox1")).Text = 这样才对嘛。。。";
}
}protected void bindcolumns()
{
//这里还是应该用dd来做循环直接
int num=((DataSet)DataGrid1.DataSource).Tables[0].Rows.Count;
int dd = DataGrid1.Items.Count;
for (int i = 0; i < num; i++)
{
TextBox tbx = new TextBox();
tbx = (TextBox)DataGrid1.Items[i].FindControl("TextBox1"); tbx.Attributes.Add("onkeydown", "if(event.keyCode==13) event.keyCode=9"); tbx.Attributes.Add("onblur", "showValueFromEmployeeID(this)");
}
for (int i = 1; i < num; i++)
{
TextBox tbx = new TextBox();
tbx = (TextBox)DataGrid1.Items[i].FindControl("TextBox2");
tbx.Attributes.Add("onkeydown", "if(event.keyCode==13) event.keyCode=9");
//tbx.Attributes.Add("onblur","showNewDataGrid()");
}
}