第一步,命名空间:
using System.Data.SqlClient;
第二步,申明变量
public bool bConnect=false;//数据库连接标识
SqlConnection con = new SqlConnection();
第三步,连接数据库
public void ConnectSql()
{
con.ConnectionString = "server=192.168.0.110,1433;Database=db;uid=sa;pwd=sa123;";
try
{
con.Open();
}
catch (System.Exception ex)
{
string strErr = ex.ToString();
MessageBox.Show(strErr);
return;
}
MessageBox.Show("sql连接成功");
bConnect = true;
}
第四步,查询数据
if (!bConnect)
{
MessageBox.Show("数据库未连接");
return;
}
string strOrder="ORDER001";
if (textBox1.Text!="")
{
strOrder = textBox1.Text;
}
string str3 = "";
string str26 = "";
string str27 = "";
string str28 = "";
//创建数据库命令
SqlCommand cmd = con.CreateCommand();
//创建查询语句
cmd.CommandText = "SELECT *FROM MOCTA where T002='" + strOrder + "'";
//从数据库中读取数据流存入reader中
SqlDataReader reader = cmd.ExecuteReader();
//从reader中读取下一行数据,如果没有数据,reader.Read()返回fasle
while (reader.Read())
{
if (reader["T026"]!=System.DBNull.Value)//判断读取数据是否为空
{
str26 = reader.GetString(reader.GetOrdinal("T026"));
}
else
{
MessageBox.Show("T026为空");
}
if (reader["T027"] != System.DBNull.Value)
{
str27 = reader.GetString(reader.GetOrdinal("T027"));
}
else
{
MessageBox.Show("T027为空");
}
if (reader["T028"] != System.DBNull.Value)
{
str28 = reader.GetString(reader.GetOrdinal("T028"));
}
else
{
MessageBox.Show("T028为空");
}
if (reader["T003"]!=System.DBNull.Value)
{
str3 = reader.GetString(reader.GetOrdinal("T003"));
}
else
{
MessageBox.Show("为空");
}
Console.WriteLine(str3 + " " + str26 + " " + str27 + " " + str28);
}
reader.Dispose();