如何在gridview ASP.NET C＃中添加文本框打击每一列？ [英] How can I add textbox blow every column in gridview ASP.NET C#?
问题描述
嗨..
我有一个gridview，其列名具有自定义名称，来自sql命令。
我想要添加文本框，每列都在吹，最后有一个插入按钮，当我按下插入按钮然后值插入gridview然后生成新行然后输入值并按插入按钮然后插入gridview中的值等等..
我尝试过：
这是我的aspx.cs代码
受保护 void Page_Load（ object sender，EventArgs e）
{
load（）;
}
public void load（）
{
SqlConnection cnn = new SqlConnection（ 数据源= HAMEED_KHAN \\SQLEXPRESS;初始目录= db_compiler;集成安全性=真）;
string query = SELECT Column_Name FROM tbl_field WHERE Table_Name ='std';
SqlCommand cmd = new SqlCommand（query，cnn）;
cnn.Open（）;
string somevalue = cmd.ExecuteScalar（）。ToString（）;
DataTable dt1 = new DataTable（）;
SqlDataAdapter da = new SqlDataAdapter（cmd）;
da.Fill（dt1）;
cmd.ExecuteNonQuery（）;
int rows = dt1.Rows.Count;
DataRow dr = null ;
foreach （DataRow row in dt1.Rows）
{
DataTable dt2 = new DataTable（）;
dt2 = new DataTable（）;
for （ int i = 0 ; i < 行; i ++）
{
dt2.Columns.Add（dt1.Rows [i] [ 0 ]。ToString（），System.Type.GetType（ System.String））;
dr = dt2.NewRow（）;
}
会话[ MyDataTable ] = dt2;
DataTable dt3 =（DataTable）会话[ MyDataTable];
DataRow row1 = dt3.NewRow（）;
dt3.Rows.Add（row1）;
会话[ MyDataTable] = dt3;
GridView1.DataSource = dt3;
GridView1.DataBind（）;
cnn.Close（）;
}
}
}
这是我的aspx代码：
< pre lang =HTML> < body >
< 表格 id = form1 runat = 服务器 >
< div >
< asp：GridView ID = GridView1 runat = server >
< 列 >
< asp：CommandField ShowEditButton = True / >
< asp：CommandField ShowDeleteButton = True / >
< asp：ButtonField CommandName = 取消 HeaderText = 操作 ShowHeader = True
< span class =code-attribute> 文字 = 插入 / >
< /列 >
< / asp：GridView >
< / div >
< /表格 >
< / body >
请看这篇文章..很好地解释..动态地使用TemplateField..create列..我希望这有帮助..如果你仍然需要帮助，请告诉我..
如何创建模板网格视图中的动态列 [ ^ ]
干杯
Praveen
Hi..
I have a gridview which column name have custom names and coming from sql command.
I want that add textboxes blow every column and at the end have a insert button when i press insert button then value insert in gridview then new row generated and then enter values and press insert button then values inserted in gridview and so on..
What I have tried:
Here is my aspx.cs code
protected void Page_Load(object sender, EventArgs e)
{
load();
}
public void load()
{
SqlConnection cnn = new SqlConnection("Data Source=HAMEED_KHAN\\SQLEXPRESS;Initial Catalog=db_compiler;Integrated Security=True");
string query = "SELECT Column_Name FROM tbl_field WHERE Table_Name='std'";
SqlCommand cmd = new SqlCommand(query, cnn);
cnn.Open();
string somevalue = cmd.ExecuteScalar().ToString();
DataTable dt1 = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt1);
cmd.ExecuteNonQuery();
int rows = dt1.Rows.Count;
DataRow dr = null;
foreach (DataRow row in dt1.Rows)
{
DataTable dt2 = new DataTable();
dt2 = new DataTable();
for (int i = 0; i < rows; i++)
{
dt2.Columns.Add(dt1.Rows[i][0].ToString(), System.Type.GetType("System.String"));
dr = dt2.NewRow();
}
Session["MyDataTable"] = dt2;
DataTable dt3 = (DataTable)Session["MyDataTable"];
DataRow row1 = dt3.NewRow();
dt3.Rows.Add(row1);
Session["MyDataTable"] = dt3;
GridView1.DataSource = dt3;
GridView1.DataBind();
cnn.Close();
}
}
}
and here is my aspx code :
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server" >
<Columns>
<asp:CommandField ShowEditButton="True" />
<asp:CommandField ShowDeleteButton="True" />
<asp:ButtonField CommandName="Cancel" HeaderText="Operation" ShowHeader="True"
Text="Insert" />
</Columns>
</asp:GridView>
</div>
</form>
</body>please see this article .. nicely explained .. to make use of TemplateField..create columns dynamically .. i hope this helps .. let me know if you still need help ..
How to create template columns dynamically in a grid view[^]
Cheers
Praveen
这篇关于如何在gridview ASP.NET C＃中添加文本框打击每一列？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
