string sql = "SELECT rightcopy FROM webTest.dbo.basicInfo";
SqlConnection sqlcon = new SqlConnection("Data Source=VIC;Initial Catalog=webTest;Integrated Security=True");
sqlcon.Open();
SqlCommand aa = new SqlCommand();
aa.CommandText = sql;
aa.Connection = sqlcon;
sqlcon.Close();
1 . 我新建一个 Lable 请问 Lable.test 显示 SQL表中的值 怎么写 还有 我的SqlConnection 是否错误
SqlConnection sqlcon = new SqlConnection("Data Source=VIC;Initial Catalog=webTest;Integrated Security=True");
sqlcon.Open();
SqlCommand aa = new SqlCommand();
aa.CommandText = sql;
aa.Connection = sqlcon;
sqlcon.Close();
1 . 我新建一个 Lable 请问 Lable.test 显示 SQL表中的值 怎么写 还有 我的SqlConnection 是否错误
//连接数据库
public class ConnectionSQL
{
public static SqlConnection conn = new SqlConnection("Data Source=.;Initial Catalog=Blogger;Integrated Security=True");
public static SqlCommand command = new SqlCommand("",conn);
//打开连接
private static void OpenConn() {
if (conn.State != System.Data.ConnectionState.Open) {
conn.Open();
}
}
//查询
public static SqlDataReader ExecuteSelect(string sql) {
OpenConn();
command.CommandText = sql;
return command.ExecuteReader();
}
//非查询
public static int ExecuteNonSelect(string sql)
{
OpenConn();
command.CommandText = sql;
return command.ExecuteNonQuery();
} //关闭连接
public static void CloseConn()
{
if (conn.State == System.Data.ConnectionState.Open)
{
conn.Close();
}
}
}
在 ADO.NET 中检索和修改数据
以下我简写写重要的代码,若需详细内容,请找我就好了
try
{
...数据库连接代码略...
SqlDataReader dataReader=command.ExecuteReader();
String rightcopy="";
while(dataReader.Read())
{
rightcopy= dataReader[0].ToString();
this.label1.text=rightcopy;
}
dataReader,close();
}
catch(){省略}
finally
{
...关闭数据库操作...
}