以下是我的asp.net程序和c#windows form程序
protected void Button1_Click(object sender, EventArgs e)
{
//通过逗号来区分要查询多少个库,得到填入库名的数据格式如下: student,class,person
string[] databasekeys = textBoxDatabaseSeach.Text.Split(',');
SqlConnection[] sqlConnection = new SqlConnection[databasekeys.Length];
SqlCommand[] sqlCommand = new SqlCommand[databasekeys.Length];
SqlDataReader[] sqlDataReader = new SqlDataReader[databasekeys.Length];
string server = textBoxServer.Text;
string uid = textBoxUid.Text;
string pwd = textBoxPwd.Text;
// string columnName = "username";
//string columnValue = "xie";
string sql = "";
// Response.Write(columnName);
//select 查询语句,格式基本都是写死了 select * from users where username=''
sql = textBoxSelect.Text;
// System.IO.StreamWriter srW1 = new System.IO.StreamWriter(@"d:\LOG2.txt", false);
bool flag;
try
{
//遍历库名,动态初始化连接SqlConnection,SqlCommand对象
for (int i = 0; i < databasekeys.Length; i++)
{
sqlConnection[i] = new SqlConnection("server=" + server + ";database=" + databasekeys[i] + ";uid=" + uid + ";pwd=" + pwd + "");
sqlConnection[i].Open();
sqlCommand[i] = new SqlCommand(sql, sqlConnection[i]);
sqlCommand[i].ExecuteNonQuery();
sqlDataReader[i] = sqlCommand[i].ExecuteReader();
int count = sqlDataReader[i].FieldCount;
// textBoxSelect.Text ="123 \t 456 ";
Response.Write("数据库:" + databasekeys[i]);
Response.Write("<table border='1' CellSpacing=1 CellPadding=3 width=100% style='font-size:10pt; border-collapse:collapse'><tr bgcolor=#E0E0E0><td align=center>#</td> ");
//现实每个库的所有字段名字 for (int j = 0; j < count; j++)
{ Response.Write("<td align=center>");
Response.Write("<b>"); Response.Write(sqlDataReader[i].GetName(j));
Response.Write("</td></b>");
// srW1.Write(sqlDataReader[i].GetName(j) + "\t"); }
Response.Write("</tr>");
Response.Write("<tr bgcolor=#EEEEEE>");
// srW1.WriteLine("");
flag = sqlDataReader[i].HasRows;
if (flag == false)
{ // srW1.WriteLine("没有相关数据" + databasekeys[i]);
}
else
{
int list = 0; //遍历表的数据
while (sqlDataReader[i].Read() == true)
{
Response.Write("<td align=center>" + list + "</td>");
// 遍历表的所有字段值
for (int l = 0; l < count; l++)
{
// srW1.Write(sqlDataReader.GetSqlValue(i));
// srW1.Write(sqlDataReader[i].GetValue(l));
Response.Write("<td align=center>" + sqlDataReader[i].GetValue(l) + "</td>"); }
list++;
// srW1.WriteLine("");
Response.Write("</tr>");
}
}
sqlCommand[i].Clone();
sqlConnection[i].Close();
Response.Write("</table>"); } }
catch (Exception mm)
{ Response.Write(mm.ToString());
}
}
---------------以下是c# windows form的程序-要怎么才能实现用表格的形式在win form现实出来,现在我是以文件输出的格式的
protected void Button1_Click(object sender, EventArgs e)
{
//通过逗号来区分要查询多少个库,得到填入库名的数据格式如下: student,class,person
string[] databasekeys = textBoxDatabaseSeach.Text.Split(',');
SqlConnection[] sqlConnection = new SqlConnection[databasekeys.Length];
SqlCommand[] sqlCommand = new SqlCommand[databasekeys.Length];
SqlDataReader[] sqlDataReader = new SqlDataReader[databasekeys.Length];
string server = textBoxServer.Text;
string uid = textBoxUid.Text;
string pwd = textBoxPwd.Text;
// string columnName = "username";
//string columnValue = "xie";
string sql = "";
// Response.Write(columnName);
//select 查询语句,格式基本都是写死了 select * from users where username=''
sql = textBoxSelect.Text;
// System.IO.StreamWriter srW1 = new System.IO.StreamWriter(@"d:\LOG2.txt", false);
bool flag;
try
{
//遍历库名,动态初始化连接SqlConnection,SqlCommand对象
for (int i = 0; i < databasekeys.Length; i++)
{
sqlConnection[i] = new SqlConnection("server=" + server + ";database=" + databasekeys[i] + ";uid=" + uid + ";pwd=" + pwd + "");
sqlConnection[i].Open();
sqlCommand[i] = new SqlCommand(sql, sqlConnection[i]);
sqlCommand[i].ExecuteNonQuery();
sqlDataReader[i] = sqlCommand[i].ExecuteReader();
int count = sqlDataReader[i].FieldCount;
// textBoxSelect.Text ="123 \t 456 ";
Response.Write("数据库:" + databasekeys[i]);
Response.Write("<table border='1' CellSpacing=1 CellPadding=3 width=100% style='font-size:10pt; border-collapse:collapse'><tr bgcolor=#E0E0E0><td align=center>#</td> ");
//现实每个库的所有字段名字 for (int j = 0; j < count; j++)
{ Response.Write("<td align=center>");
Response.Write("<b>"); Response.Write(sqlDataReader[i].GetName(j));
Response.Write("</td></b>");
// srW1.Write(sqlDataReader[i].GetName(j) + "\t"); }
Response.Write("</tr>");
Response.Write("<tr bgcolor=#EEEEEE>");
// srW1.WriteLine("");
flag = sqlDataReader[i].HasRows;
if (flag == false)
{ // srW1.WriteLine("没有相关数据" + databasekeys[i]);
}
else
{
int list = 0; //遍历表的数据
while (sqlDataReader[i].Read() == true)
{
Response.Write("<td align=center>" + list + "</td>");
// 遍历表的所有字段值
for (int l = 0; l < count; l++)
{
// srW1.Write(sqlDataReader.GetSqlValue(i));
// srW1.Write(sqlDataReader[i].GetValue(l));
Response.Write("<td align=center>" + sqlDataReader[i].GetValue(l) + "</td>"); }
list++;
// srW1.WriteLine("");
Response.Write("</tr>");
}
}
sqlCommand[i].Clone();
sqlConnection[i].Close();
Response.Write("</table>"); } }
catch (Exception mm)
{ Response.Write(mm.ToString());
}
}
protected void Button1_Click(object sender, EventArgs e)
{
//通过逗号来区分要查询多少个库,得到填入库名的数据格式如下: student,class,person
string[] databasekeys = textBoxDatabaseSeach.Text.Split(',');
SqlConnection[] sqlConnection = new SqlConnection[databasekeys.Length];
SqlCommand[] sqlCommand = new SqlCommand[databasekeys.Length];
SqlDataReader[] sqlDataReader = new SqlDataReader[databasekeys.Length];
string server = textBoxServer.Text;
string uid = textBoxUid.Text;
string pwd = textBoxPwd.Text;
// string columnName = "username";
//string columnValue = "xie";
string sql = "";
// Response.Write(columnName);
//select 查询语句,格式基本都是写死了 select * from users where username=''
sql = textBoxSelect.Text;
// System.IO.StreamWriter srW1 = new System.IO.StreamWriter(@"d:\LOG2.txt", false);
bool flag;
try
{
//遍历库名,动态初始化连接SqlConnection,SqlCommand对象
for (int i = 0; i < databasekeys.Length; i++)
{
sqlConnection[i] = new SqlConnection("server=" + server + ";database=" + databasekeys[i] + ";uid=" + uid + ";pwd=" + pwd + "");
sqlConnection[i].Open();
sqlCommand[i] = new SqlCommand(sql, sqlConnection[i]);
sqlCommand[i].ExecuteNonQuery();
sqlDataReader[i] = sqlCommand[i].ExecuteReader();
int count = sqlDataReader[i].FieldCount;
// textBoxSelect.Text ="123 \t 456 ";
Response.Write("数据库:" + databasekeys[i]);
Response.Write("<table border='1' CellSpacing=1 CellPadding=3 width=100% style='font-size:10pt; border-collapse:collapse'><tr bgcolor=#E0E0E0><td align=center>#</td> ");
//现实每个库的所有字段名字 for (int j = 0; j < count; j++)
{ Response.Write("<td align=center>");
Response.Write("<b>"); Response.Write(sqlDataReader[i].GetName(j));
Response.Write("</td></b>");
// srW1.Write(sqlDataReader[i].GetName(j) + "\t"); }
Response.Write("</tr>");
Response.Write("<tr bgcolor=#EEEEEE>");
// srW1.WriteLine("");
flag = sqlDataReader[i].HasRows;
if (flag == false)
{ // srW1.WriteLine("没有相关数据" + databasekeys[i]);
}
else
{
int list = 0; //遍历表的数据
while (sqlDataReader[i].Read() == true)
{
Response.Write("<td align=center>" + list + "</td>");
// 遍历表的所有字段值
for (int l = 0; l < count; l++)
{
// srW1.Write(sqlDataReader.GetSqlValue(i));
// srW1.Write(sqlDataReader[i].GetValue(l));
Response.Write("<td align=center>" + sqlDataReader[i].GetValue(l) + "</td>"); }
list++;
// srW1.WriteLine("");
Response.Write("</tr>");
}
}
sqlCommand[i].Clone();
sqlConnection[i].Close();
Response.Write("</table>"); } }
catch (Exception mm)
{ Response.Write(mm.ToString());
}
}
---------------以下是c# windows form的程序-要怎么才能实现用表格的形式在win form现实出来,现在我是以文件输出的格式的
protected void Button1_Click(object sender, EventArgs e)
{
//通过逗号来区分要查询多少个库,得到填入库名的数据格式如下: student,class,person
string[] databasekeys = textBoxDatabaseSeach.Text.Split(',');
SqlConnection[] sqlConnection = new SqlConnection[databasekeys.Length];
SqlCommand[] sqlCommand = new SqlCommand[databasekeys.Length];
SqlDataReader[] sqlDataReader = new SqlDataReader[databasekeys.Length];
string server = textBoxServer.Text;
string uid = textBoxUid.Text;
string pwd = textBoxPwd.Text;
// string columnName = "username";
//string columnValue = "xie";
string sql = "";
// Response.Write(columnName);
//select 查询语句,格式基本都是写死了 select * from users where username=''
sql = textBoxSelect.Text;
// System.IO.StreamWriter srW1 = new System.IO.StreamWriter(@"d:\LOG2.txt", false);
bool flag;
try
{
//遍历库名,动态初始化连接SqlConnection,SqlCommand对象
for (int i = 0; i < databasekeys.Length; i++)
{
sqlConnection[i] = new SqlConnection("server=" + server + ";database=" + databasekeys[i] + ";uid=" + uid + ";pwd=" + pwd + "");
sqlConnection[i].Open();
sqlCommand[i] = new SqlCommand(sql, sqlConnection[i]);
sqlCommand[i].ExecuteNonQuery();
sqlDataReader[i] = sqlCommand[i].ExecuteReader();
int count = sqlDataReader[i].FieldCount;
// textBoxSelect.Text ="123 \t 456 ";
Response.Write("数据库:" + databasekeys[i]);
Response.Write("<table border='1' CellSpacing=1 CellPadding=3 width=100% style='font-size:10pt; border-collapse:collapse'><tr bgcolor=#E0E0E0><td align=center>#</td> ");
//现实每个库的所有字段名字 for (int j = 0; j < count; j++)
{ Response.Write("<td align=center>");
Response.Write("<b>"); Response.Write(sqlDataReader[i].GetName(j));
Response.Write("</td></b>");
// srW1.Write(sqlDataReader[i].GetName(j) + "\t"); }
Response.Write("</tr>");
Response.Write("<tr bgcolor=#EEEEEE>");
// srW1.WriteLine("");
flag = sqlDataReader[i].HasRows;
if (flag == false)
{ // srW1.WriteLine("没有相关数据" + databasekeys[i]);
}
else
{
int list = 0; //遍历表的数据
while (sqlDataReader[i].Read() == true)
{
Response.Write("<td align=center>" + list + "</td>");
// 遍历表的所有字段值
for (int l = 0; l < count; l++)
{
// srW1.Write(sqlDataReader.GetSqlValue(i));
// srW1.Write(sqlDataReader[i].GetValue(l));
Response.Write("<td align=center>" + sqlDataReader[i].GetValue(l) + "</td>"); }
list++;
// srW1.WriteLine("");
Response.Write("</tr>");
}
}
sqlCommand[i].Clone();
sqlConnection[i].Close();
Response.Write("</table>"); } }
catch (Exception mm)
{ Response.Write(mm.ToString());
}
}
解决方案 »
- 麻烦大神看看这段代码那里错了????
- 求助:System.Numeric.BigInteger 不可访问,因为他受保护级别限制
- C# 游戏取色
- databinding.remove问题
- 关于IssueVision命令模式中对象生命周期的困惑
- 在C#中怎样才能把子窗体拖出父窗体的界面
- c#在服务器生成EXCEL文件,分批写入数据,如何应对“是否替换文件”对话框?
- 请教如何过滤网页里的主体?
- 怎么用C#给.gif动画加水印(急........)
- 有个问题困扰我很久,一直弄不出来,恳请GIS大神,帮忙解决下。
- 有用c#写的论坛登陸發帖程序源代码吗?
- [C#]:为什么改变Form的大小到一定程序就不能缩小了
这个要根据客户填写的库,如果有四个库就自动生成4个datagrid显示
这个方式我不会。所以请求你们帮忙