本文整理汇总了C#中System.Data.SqlHelper.ExecuteDataTable方法的典型用法代码示例。如果您正苦于以下问题:C# SqlHelper.ExecuteDataTable方法的具体用法?C# SqlHelper.ExecuteDataTable怎么用?C# SqlHelper.ExecuteDataTable使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.SqlHelper
的用法示例。
在下文中一共展示了SqlHelper.ExecuteDataTable方法的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: Page_Load
protected void Page_Load(object sender, EventArgs e)
{
Response.Clear();
string str_sql = "";
IDbHelper sql = GetHelper();
DbDataReader rd = sql.ExecuteReader(CommandType.Text, "select [name] from sysobjects where xtype='U'");
while (rd.Read())
{
string tableName = rd["name"].ToString();
if (tableName.ToLower() == "sysuser")
{
continue;
}
IDbHelper Helper = new SqlHelper(Voodoo.Setting.DataBase.ConnStr);
DataTable dt = Helper.ExecuteDataTable(CommandType.Text, string.Format("select * from [{0}]",tableName));
string str_insert = string.Format("SET IDENTITY_INSERT [{0}] ON ;\n insert into [{0}](", tableName);
for (int i = 0; i < dt.Columns.Count; i++)
{
str_insert += "[" + dt.Columns[i].ColumnName + "]";
if (i != dt.Columns.Count - 1)
{
str_insert += ",";
}
}
str_insert += ") values(";
for (int i = 0; i < dt.Rows.Count; i++)
{
str_sql += str_insert;
for (int j = 0; j < dt.Columns.Count; j++)
{
str_sql += "N'" + dt.Rows[i][j].ToString().Replace("'", "''") + "'";
if (j != dt.Columns.Count - 1)
{
str_sql += ",";
}
}
str_sql += string.Format(")\n SET IDENTITY_INSERT [{0}] OFF ;\n\n\n",tableName);
}
}
rd.Close();
rd.Dispose();
//Response.Write(str_sql);
Voodoo.IO.File.Write(Server.MapPath("~/e/installer/tabledata.txt"), str_sql, System.IO.FileMode.Create);
Response.Write("已经生成到:" + Server.MapPath("~/e/installer/tabledata.txt"));
Response.End();
}