Question

C#中TEXTBOX显示SQL查询结果的代码

弱弱的问一个新手问题，我的数据库是DATA SOURCE=IBMSER;DATABASE_DB_01;UID=SA;PWD=;
窗体上就一个TEXTBOX控件，我想在运行程序时在TEXTBOX中自动显示"SELECT BAT_NO FROM MF_MO WHERE MO_NO='MO12345678'"中BAT_NO的值。谁能帮我写个完整代码啊？谢谢了啊。

Answer 1

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
//new 添加命名空间
using System.Data;
using System.Data.SqlClient;

namespace text
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

private void Form1_Load(object sender, EventArgs e)
{
DataBind();//数据绑定
}

private void DataBind()
{
string connstr = "DATA SOURCE=IBMSER;database=DATABASE_DB_01;UID=SA;PWD=;";//连接语句
string cmdstr = "SELECT BAT_NO FROM MF_MO WHERE MO_NO='MO12345678'";//查询语句
SqlConnection conn = new SqlConnection(connstr);//新建数据库连接
conn.Open();//打开连接
SqlDataAdapter da = new SqlDataAdapter(cmdstr, conn);//获取查询语句所得数据
DataTable dt = new DataTable();//把所得数据放入dt表中
da.Fill(dt);
conn.Close();//关闭连接
textBox1.Text = dt.Rows[0][0].ToString();//这里取表中第1行第1列，楼主你根据自己情况修改

}

}
}

Answer 2

public static DataSet ExecDataSet(string SQLString, params SqlParameter[] cmdParms)
{
using (SqlCommand cmd = new SqlCommand())
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
PrepareCommand(cmd, connection, null, SQLString, cmdParms);
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
DataSet ds = new DataSet();
try
{
da.Fill(ds, "ds");
cmd.Parameters.Clear();
}
catch (SqlException e)
{
throw e;
}
return ds;
}
}
}
}

private static void PrepareCommand(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, string cmdText, SqlParameter[] cmdParms)
{
if (conn.State != ConnectionState.Open)
conn.Open();
cmd.Connection = conn;
cmd.CommandText = cmdText;
if (trans != null)
cmd.Transaction = trans;
cmd.CommandType = CommandType.Text;//cmdType;
if (cmdParms != null)
{

foreach (SqlParameter parameter in cmdParms)
{
if ((parameter.Direction == ParameterDirection.InputOutput || parameter.Direction == ParameterDirection.Input) &&
(parameter.Value == null))
{
parameter.Value = DBNull.Value;
}
cmd.Parameters.Add(parameter);
}
}
}
两个方法自己研究下，不行再留言！