usingSystem;
usingSystem.Collections.Generic;
usingSystem.ComponentModel;
usingSystem.Data;
usingSystem.Drawing;
usingSystem.Linq;
usingSystem.Text;
usingSystem.Windows.Forms;
usingSystem.Data.SqlClient;
usingSystem.Configuration;
namespaceReadByDataSet
{
publicpartialclassForm1:Form
{
publicForm1()
{
InitializeComponent();
}
privatevoidbtnRead_Click(objectsender,EventArgse)
{
using(SqlConnectionconn=newSqlConnection(ConfigurationManager.ConnectionStrings["SqlConn"].ConnectionString))
{
SqlCommandcomm=newSqlCommand();
comm.Connection=conn;
comm.CommandText="SelectID,Name,Sex,ClassIDFromStudent";
SqlDataAdapterda=newSqlDataAdapter();
da.SelectCommand=comm;
DataSetds=newDataSet();
da.Fill(ds,"student");
dataGridView1.DataSource=ds.Tables[0];
}
}
}
}
|
|