命令对象里加参数对象例如SqlDataAdapter adpa=new SqlDataAdapter("b_GetMovieList",conn);
adpa.SelectCommand.CommandType=CommandType.StoredProcedure;
//下面注释掉后就不能显示数据,当然储存过程也要改
adpa.SelectCommand.Parameters.Add( new SqlParameter("@BigType",SqlDbType.VarChar,50));
adpa.SelectCommand.Parameters["@BigType"].Value = BigType;
adpa.SelectCommand.CommandType=CommandType.StoredProcedure;
//下面注释掉后就不能显示数据,当然储存过程也要改
adpa.SelectCommand.Parameters.Add( new SqlParameter("@BigType",SqlDbType.VarChar,50));
adpa.SelectCommand.Parameters["@BigType"].Value = BigType;
adpa.SelectCommand.CommandType=CommandType.StoredProcedure;
//下面注释掉后就不能显示数据,当然储存过程也要改
adpa.SelectCommand.Parameters.Add( new SqlParameter("@BigType",SqlDbType.VarChar,50));
adpa.SelectCommand.Parameters["@BigType"].Value = BigType;
DataTable table = new DataTable();
SqlParameter par=new SqlParameter("=@UserName",this.txtUserName.Text.Trim());
adapter.SelectCommand.Parameters.Add(par);
adapter.SelectCommand.CommandType=CommandType.StoredProcedure;
adapter.Fill(table);
this.Hide();
fis = new FormInfoShow(this.txtUserName.Text);
fis.Show();
fis.datViewFriInfo.DataSource = table;