string strFeederNameSelect =
"select [Column1],[Column2],[Column3],[Column4],[Column5] from TaipowerAccount order by [Column1]";
using (System.Data.SqlClient.SqlConnection con =
new System.Data.SqlClient.SqlConnection(
System.Web.Configuration.WebConfigurationManager.ConnectionStrings[
"MySqlServer"].ConnectionString))
{
using (System.Data.SqlClient.SqlDataAdapter da =
new System.Data.SqlClient.SqlDataAdapter(strFeederNameSelect, con))
{
con.Open();
using (System.Data.SqlClient.SqlCommandBuilder scb =
new System.Data.SqlClient.SqlCommandBuilder(da))
{
scb.ConflictOption = System.Data.ConflictOption.OverwriteChanges;
using (System.Data.DataTable table =
new System.Data.DataTable())
{
da.Fill(table);
gvKeyFeederName.DataSource = table;
gvKeyFeederName.DataBind();
}
}
con.Close();
}
}
＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝＝
gvKeyFeederName是GridView的id
目前是我先替table增加一行資料列
table.Columns.Add(new DataColumn("item", typeof(string)));
然後用個for迴圈 抓取原資料表tableset某一行的資料 處理變更成為新的資料行的資料
以下是我修改的
string strFeederNameSelect =
"select [Column1],[Column2],[Column3],[Column4],[Column5] from TaipowerAccount order by [Column1]";
using (System.Data.SqlClient.SqlConnection con =
new System.Data.SqlClient.SqlConnection(
System.Web.Configuration.WebConfigurationManager.ConnectionStrings[
"MySqlServer"].ConnectionString))
{
using (System.Data.SqlClient.SqlDataAdapter da =
new System.Data.SqlClient.SqlDataAdapter(strFeederNameSelect, con))
{
con.Open();
using (System.Data.SqlClient.SqlCommandBuilder scb =
new System.Data.SqlClient.SqlCommandBuilder(da))
{
scb.ConflictOption = System.Data.ConflictOption.OverwriteChanges;
using (System.Data.DataTable tableset =
new System.Data.DataTable())
{
DataRow dr;
tableset.Columns.Add(new DataColumn("item", typeof(string)));
for (int i = 0; i == tableset.Rows.Count; i++)
{
dr = tableset.NewRow();
dr[0] = tableset.Columns["Column2"].Table.Rows[i].ToString()+"TEST";
tableset.Rows.Add(dr);
}
da.Fill(tableset);
gvKeyFeederName.DataSource = tableset;
gvKeyFeederName.DataBind();
}
}
con.Close();
}
}
===============================================================================================
不過執行出來 錯誤訊息
並未將物件參考設定為物件的執行個體。
錯在
dr[0] = table.Columns["TAId"].Table.Rows[i].ToString()+"TEST";
這個部分我不知道錯在哪
我修改的部份 還有哪個地方是有誤的 貴請指教一下
謝謝 |
