using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class test_display_all_table : System.Web.UI.Page
{
string strConn;
protected void Page_Load(object sender, EventArgs e)
{
strConn = System.Configuration.ConfigurationManager.ConnectionStrings["schoolConnectionString"].ConnectionString;
}
private void display_all()
{
DataTable t = new DataTable();
string strSQL = "select a.name as zdname,b.name as tbname from syscolumns as a inner join sysobjects as b on a.id=b.id where a.xtype in(175,167,231,239)";
using (SqlConnection conn = new SqlConnection(strConn))
{
using (SqlCommand cmd = new SqlCommand(strSQL, conn))
{
cmd.CommandType = CommandType.Text;
conn.Open();
SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
t.Load(dr);
dr.Close();
}
}
string SQL = "";
for (int i = 0; i < t.Rows.Count; i++)
{
SQL = "select " + t.Rows[i]["zdname"].ToString() + " from " + t.Rows[i]["tbname"].ToString() + " where " + t.Rows[i]["zdname"].ToString() + " ='admin' ";
try
{
if (ExecuteSqlEx(SQL))
{
Response.Write("表名为：" + t.Rows[i]["tbname"].ToString() + " <br>字段名为：" + t.Rows[i]["zdname"].ToString() + "<br><br>");
//break;
//Response.End();
}
}
catch (Exception er)
{
//Response.Write("总行数为："+t.Rows.Count+"执行到了" + i + " <br>出错信息：" + er.Message+"<br><br>下一个表为：<br>");
//Response.Write("表名为：" + t.Rows[i]["tbname"].ToString() + " <br>字段名为：" + t.Rows[i]["zdname"].ToString() + "<br><br>");
//break;
//Response.End();
}
}
}
/// <summary>
///执行一条sql语句，返回bool值，判断该记录是否存在
/// </summary>
/// <param name="strSQL">要执行的SQL语句,为字符串类型string</param>
/// <returns>返回执行情况,整形int</returns>
public bool ExecuteSqlEx(string strSQL)
{
SqlConnection myCn = new SqlConnection(strConn);
SqlCommand myCmd = new SqlCommand(strSQL, myCn);
try
{
myCn.Open();
SqlDataReader myReader = myCmd.ExecuteReader();
if (myReader.Read())
{
return true;
}
else
{
return false;
}
}
catch (Exception er)
{
throw er;
}
finally
{
myCmd.Dispose();
myCn.Close();
}
}
protected void Button1_Click(object sender, EventArgs e)
{
display_all();
Label1.Text = "没找到！";
}
}