use dataReader
string strconn="server=kk;uid=kk;pwd=kk;database=kk";
string strsql="select po_no,sea_no from PO_Master_T where po_no='3055'";
SqlConnection conn=new SqlCommand(strconn);
conn.open();
SqlCommand comm=new sqlcomm(strsql,conn);
SqlDataReader dr=comm.Executereader();
while(dr.read())
{
TextBox1.Text+=Convert.Tostring(dr["po_no"]);
TextBox1.Text+=Convert.Tostring(dr["sea_no"]);
}
string strconn="server=kk;uid=kk;pwd=kk;database=kk";
string strsql="select po_no,sea_no from PO_Master_T where po_no='3055'";
SqlConnection conn=new SqlCommand(strconn);
conn.open();
SqlCommand comm=new sqlcomm(strsql,conn);
SqlDataReader dr=comm.Executereader();
while(dr.read())
{
TextBox1.Text+=Convert.Tostring(dr["po_no"]);
TextBox1.Text+=Convert.Tostring(dr["sea_no"]);
}
SqlConnection cn=new SqlConnection(cnstring);
SqlDataAdapter command=new SqlDataAdapter("select * from PO_Master_T where po_no='3055'",cn);
DataSet ds = new DataSet();
command.Fill(ds,"weeklyjob");
DataTable mytable =new DataTable();
mytable=ds.Tables["weeklyjob"];
TextBox1.Text=mytable.rows[0]["po_no"]
cn.Close();
cn.Dispose();
ds=fetchData ( stringquery, stringdb ) ;
int i;
for(i=0;i>ds.Tables[0].Rows().Count-1;i++)
{
YourTextBox.Text=ds.Tables[0].Rows[i][0].ToString();
}DataSet fetchData ( string query, string db ) {
// connect to data source
SqlConnection myConn = new SqlConnection (
"server=(local)\\NetSDK; trusted_connection=yes; database=" + db ); // initialize dataadapter with query
SqlDataAdapter myAdapter = new SqlDataAdapter ( query, myConn ); // initalize and fill dataset with query results
DataSet myData = new DataSet ( );
myAdapter.Fill ( myData ); // return dataset
return myData;
}
Dim conn As OleDb.OleDbConnection
conn = New OleDb.OleDbConnection("连接数据库")
Dim myadapter As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter
myadapter = New OleDb.OleDbDataAdapter("select * from PO_Master_T where po_no='3055'", conn)
conn.Open()
myadapter.Fill(ds)
TextBox1.Text = ds.Tables(0).Rows(0).Item(0)
TextBox2.Text = ds.Tables(0).Rows(0).Item(1)
TextBox3.Text = ds.Tables(0).Rows(0).Item(2)
TextBox4.Text = ds.Tables(0).Rows(0).Item(3)
SqlCommand comm=new sqlcomm(strsql,conn)
SqlDataReader dr=comm.Executereader()
这是笨笨的方法,谁能告诉我其中主要对象,方法的含义吗,我不知道,以及怎么定义的
我谢了,回了就有分