private void FindData()
{
SqlConnection conn=new SqlConnection(publicDB.strConn); SqlCommand cmd=new SqlCommand();
cmd.CommandType=CommandType.StoredProcedure;
cmd.CommandText="show_enterprise";
SqlParameter sqlp=new SqlParameter();
sqlp=cmd.Parameters.Add("@epid",SqlDbType.Int,4);
cmd.Parameters["@epid"].Value=Request["epid"].ToString(); try
{
conn.Open();
cmd.Connection=conn;
SqlDataReader reader;
reader=cmd.ExecuteReader();
while(reader.Read())
{
bid.Text=reader["bid"].ToString();
dwmc.Text=reader["dwmc"].ToString();
zczj.Text=reader["zczj"].ToString();
zzh.Text=reader["zzh"].ToString();
rs.Text=reader["rs"].ToString();
lxtel.Text=reader["lxtel"].ToString();
addr.Text=reader["addr"].ToString();
dwjs.Text=reader["dwjs"].ToString();
zpzw.Text=reader["zpzw"].ToString();
yq.Text=reader["yq"].ToString();
gztime.Text=reader["gztime"].ToString();
gzdy.Text=reader["gzdy"].ToString();
fjsm.Text=reader["fjsm"].ToString();
}
}
catch(Exception ex)
{
throw(ex);
} }
{
SqlConnection conn=new SqlConnection(publicDB.strConn); SqlCommand cmd=new SqlCommand();
cmd.CommandType=CommandType.StoredProcedure;
cmd.CommandText="show_enterprise";
SqlParameter sqlp=new SqlParameter();
sqlp=cmd.Parameters.Add("@epid",SqlDbType.Int,4);
cmd.Parameters["@epid"].Value=Request["epid"].ToString(); try
{
conn.Open();
cmd.Connection=conn;
SqlDataReader reader;
reader=cmd.ExecuteReader();
while(reader.Read())
{
bid.Text=reader["bid"].ToString();
dwmc.Text=reader["dwmc"].ToString();
zczj.Text=reader["zczj"].ToString();
zzh.Text=reader["zzh"].ToString();
rs.Text=reader["rs"].ToString();
lxtel.Text=reader["lxtel"].ToString();
addr.Text=reader["addr"].ToString();
dwjs.Text=reader["dwjs"].ToString();
zpzw.Text=reader["zpzw"].ToString();
yq.Text=reader["yq"].ToString();
gztime.Text=reader["gztime"].ToString();
gzdy.Text=reader["gzdy"].ToString();
fjsm.Text=reader["fjsm"].ToString();
}
}
catch(Exception ex)
{
throw(ex);
} }
SqlDataReader reader;
reader=cmd.ExecuteReader();//关键是这个.看得懂不咯
Dim myCommand As SqlCommand = new SqlCommand("Select pub_id, pub_name From publishers", myConnection)
Dim myDataReader As SqlDataReader
Try
myConnection.Open()
myDataReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection)
......(这里不知道该怎么写)
this.textBox1.Text = this.myDataSet1.Tables["allplanlist"].Rows[0][0].ToString();
this.textBox2.Text = this.myDataSet1.Tables["allplanlist"].Rows[0][2].ToString();
(.Rows[0][0]中,第一个0表行号,第二个0表列号)
this.oda1.Fill(this.myDataSet1,"allplanlist");
DataTable myTable = this.myDataSet1.Tables["allplanlist"];
this.textBox1.Text = myTable.Rows[0][0].ToString();
this.textBox2.Text = myTable.Rows[0][2].ToString();
.......
其他的GG也很感谢~~~