ado.net里面,executescalar()能不能返回datarow和datacolumn??
我下面这样写,对不对??
C# code
public class DBOperator
{
private static string connectionText=......;
public static Object SqlExecuteScalar(string sqlText)
{
Object o;
SqlConnection conn = new SqlConnection(connectionText);
SqlCommand cmd = new SqlCommand(sqlText, conn);
conn.Open();
o = cmd.ExecuteScalar();
conn.Close();
return o;
}
string sqlText1="select * from student where ID='10'";
DataRow dr=DBOperator.SqlExecuteScalar(sqlText1);
string sqlText2=“select ID from student where sex='男'";
DataColumn dc=DBOperator.SqlExecuteScalar(sqlText2);
}