请问每句代码的意思是什么?public SqlDataReader GetmySend(string username)
请问每句代码的意思是什么?
public SqlDataReader GetmySend(string username)
{
SqlConnection myConnection = new SqlConnection(ConfigurationManager.AppSettings["MySQLConn"]);
string cmdText = "SELECT * FROM send where name='"+username+"' ORDER BY id DESC";
SqlCommand myCommand = new SqlCommand(cmdText,myConnection);
SqlDataReader dr = null;
try
{
myConnection.Open();
dr = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
}
catch (SqlException ex)
{
throw new Exception(ex.Message,ex);
}
return dr;
}
public SqlDataReader GetmySend(string username)
{
SqlConnection myConnection = new SqlConnection(ConfigurationManager.AppSettings["MySQLConn"]);
string cmdText = "SELECT * FROM send where name='"+username+"' ORDER BY id DESC";
SqlCommand myCommand = new SqlCommand(cmdText,myConnection);
SqlDataReader dr = null;
try
{
myConnection.Open();
dr = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
}
catch (SqlException ex)
{
throw new Exception(ex.Message,ex);
}
return dr;
}
赞 luojizheng 幼苗
共回答了16个问题采纳率：93.8% 举报
SqlConnection myConnection = new SqlConnection(ConfigurationManager.AppSettings["MySQLConn"]);
这句话是声明一个实例加载驱动链接数据库
string cmdText = "SELECT * FROM send where name='"+username+"' ORDER BY id DESC"
声明一个变量SQL 根据用户名按照ID的降序排列.
SqlCommand myCommand = new SqlCommand(cmdText,myConnection);
创建一个Sqlcommand对象传入数据库名和SQL 语句
try
{
myConnection.Open();
dr = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
}
catch (SqlException ex)
{
throw new Exception(ex.Message,ex);
}
return dr;
}
打开数据库链接传入参数 并监控,成功返回dr 失败抛出异常
亲!
这句话是声明一个实例加载驱动链接数据库
string cmdText = "SELECT * FROM send where name='"+username+"' ORDER BY id DESC"
声明一个变量SQL 根据用户名按照ID的降序排列.
SqlCommand myCommand = new SqlCommand(cmdText,myConnection);
创建一个Sqlcommand对象传入数据库名和SQL 语句
try
{
myConnection.Open();
dr = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
}
catch (SqlException ex)
{
throw new Exception(ex.Message,ex);
}
return dr;
}
打开数据库链接传入参数 并监控,成功返回dr 失败抛出异常
亲!
1年前
6
可能相似的问题
-
1年前1个回答
-
1年前5个回答
-
1年前2个回答
你能帮帮他们吗