string yougetname="";
SqlConnection myConn=MyConn();//这里我用了自写的function
myConn.Open();
System.Data.SqlClient.SqlCommand MyComm = new System.Data.SqlClient.SqlCommand(Sql,myConn);
System.Data.SqlClient.SqlDataReader dr= MyComm.ExecuteReader();
if(dr.Read())
{
i=i+1;
if(i==RowNum)
yougetname=dr["FieldName"].ToString();
}
dr.Close();
myConn.Close();
return yougetname;
}
SqlConnection myConn=MyConn();//这里我用了自写的function
myConn.Open();
System.Data.SqlClient.SqlCommand MyComm = new System.Data.SqlClient.SqlCommand(Sql,myConn);
System.Data.SqlClient.SqlDataReader dr= MyComm.ExecuteReader();
if(dr.Read())
{
i=i+1;
if(i==RowNum)
yougetname=dr["FieldName"].ToString();
}
dr.Close();
myConn.Close();
return yougetname;
}
int i=0;
SqlConnection myConn=MyConn();//这里我用了自写的function
myConn.Open();
System.Data.SqlClient.SqlCommand MyComm = new System.Data.SqlClient.SqlCommand(Sql,myConn);
System.Data.SqlClient.SqlDataReader dr= MyComm.ExecuteReader();
if(dr.Read())
{
i=i+1;
if(i==RowNum)
yougetname=dr["FieldName"].ToString();
}
dr.Close();
myConn.Close();
if (yougetname=="" ||yougetname==null)
yougetname=="False";
return yougetname;
}
函数部分:
public string GetTableFieldValueX(string Sql,string FieldName,int RowNum)
{
int TempI=0;
string TempValue="false";
SqlConnection myConnection=new SqlConnection(ConnectionString);
myConnection.Open();
System.Data.SqlClient.SqlCommand MyCommand=new System.Data.SqlClient.SqlCommand(Sql,myConnection);
System.Data.SqlClient.SqlDataReader MyDataReader=MyCommand.ExecuteReader();
if(MyDataReader.Read())
{
TempI=TempI+1;
if(TempI==RowNum)
{
TempValue=MyDataReader[FieldName].ToString();
}
}
MyDataReader.Close();
myConnection.Close();
return TempValue;
}
调用部分:
fun fun=new fun();
string Sql="select * from music";
Label1.Text=fun.GetTableFieldValueX(Sql,"歌名",0);
得到的结果总是false,为什么呀???大哥,帮帮忙呀?