protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection FConnection;
SqlCommand FCommand;
SqlDataReader FDataReader;
String FConnString;
String FQueryString; FConnString = "Server=(Local);Database=XinDB;Uid=sa;Pwd=sa";
FConnection = new SqlConnection(FConnString);
FConnection.Open(); FQueryString = "Select Item_ID From tbDefTable_Item";
FCommand = new SqlCommand(FQueryString, FConnection);
FDataReader = FCommand.ExecuteReader();
FDataReader.Read();
try
{
//System.Data.SqlClient.SqlDataReader dr = command.ExecuteReader();
if (FDataReader.Read())
{
for (int i = 0; i < FDataReader.FieldCount; i++)
{
Response.Write("字段名"+ FDataReader.GetString(i)+"<br>");
}
}
} //while (FDataReader.Read())
//{
// Response.Write(FDataReader[0] + "<br>");
//}
catch (System.Exception Err)
{
throw new ArgumentException(Err.Message.ToString());
}
}
{
SqlConnection FConnection;
SqlCommand FCommand;
SqlDataReader FDataReader;
String FConnString;
String FQueryString; FConnString = "Server=(Local);Database=XinDB;Uid=sa;Pwd=sa";
FConnection = new SqlConnection(FConnString);
FConnection.Open(); FQueryString = "Select Item_ID From tbDefTable_Item";
FCommand = new SqlCommand(FQueryString, FConnection);
FDataReader = FCommand.ExecuteReader();
FDataReader.Read();
try
{
//System.Data.SqlClient.SqlDataReader dr = command.ExecuteReader();
if (FDataReader.Read())
{
for (int i = 0; i < FDataReader.FieldCount; i++)
{
Response.Write("字段名"+ FDataReader.GetString(i)+"<br>");
}
}
} //while (FDataReader.Read())
//{
// Response.Write(FDataReader[0] + "<br>");
//}
catch (System.Exception Err)
{
throw new ArgumentException(Err.Message.ToString());
}
}
那你有没有例子呢?
发个过来! 谢谢
在我的原码上怎样加以改善!
我需要代码 , 理论我知道,但是时间的编码对我有些困难,我是新手
{
response.Write(......)
}
这个应该可以的吧,其他的代码都和你上面的差不多!
如果用while 点击按钮时把数据库的全部给输出来了
用for就只能输出一条
这个我也搞不懂! 所以来求助