Question

如何从SQL中读取数据然后放到C#的form中呢？我遇到了些问题

有两个project,一个是win form 还有一个是SQL。如图所示
我创建了如下的一个class，
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;
using System.IO;
using System.Text.RegularExpressions;
using System.Windows;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using Microsoft.SqlServer.Server;

namespace
FYPTEST01{

classcustomer{

publicstring password;
publicstring strConn = "Intergrated Security = true;" + "Initial Catalog = master;" + "Data Source = Steve-VAIO\\sqlexpress";
publicvoid executeDataCommand(string strSql){

SqlConnection conn = newSqlConnection();conn.ConnectionString = strConn;
conn.Open();

SqlCommand cmd = newSqlCommand();cmd.Connection = conn;
cmd.CommandText = strSql;
cmd.ExecuteNonQuery();
conn.Close();
}

publicSqlDataReader executeDataRead(string strSql){

SqlConnection conn = newSqlConnection();conn.ConnectionString = strConn;
conn.Open();

SqlCommand cmd = newSqlCommand();cmd.Connection = conn;
cmd.CommandText = strSql;

SqlDataReader dr = cmd.ExecuteReader();conn.Close();

return dr;}

publicvoid getCustomerDetail(string custID){

SqlDataReader dr;
string strSql = "BusID from Customer where BusNo = 'SBS1234H'";dr = executeDataRead(strSql);

if (dr.Read()){
password = dr[
"BusID"].ToString();}
dr.Close();
}
}

}
然后我不懂如何将SQL project中得到的数据放到win form 中去

Answer 1

可以用WinForms中的控件DataGridView，这个控件用于向用户显示查询得到的数据。操作先简单，看了上面你写的代码，你应该懂DataSet对象吧。调用SqlDataAdapter对象填充DataSet对象，然后将得到的DataSet对象绑定为DataGridView的数据源，写个大概的样式给你参考一下：
private void BindData()
{
using(SqlConnection connection=new SqlConnection("数据库连接字符串"))
{
DataSet ds=new DataSet();
SqlDataAdapter da=new SqlDataAdapter("sql语句",connection);
da.Fill(ds);
GridView1.DataSource=ds.Tables[0].DefaultView;
}

}
将上面的代码的调用写在Form1_Load事件中即可。