GridViewMove.DataBind();
string connectionString = ConfigurationManager.ConnectionStrings["MyDB"].ConnectionString;
SqlConnection myConnection = new SqlConnection(connectionString);
myConnection.Open();
String SQLconn = "select * from teacher";
SqlCommand myCommand = new SqlCommand(SQLconn, myConnection);
SqlDataReader myReader = myCommand.ExecuteReader();
myReader.Read();
TextBox myTextBox = DetailsViewMove.FindControl("DetailsViewMoveTextBox") as TextBox;
myTextBox.Text = myReader["TeacherId"].ToString();
myConnection.Close();
string connectionString = ConfigurationManager.ConnectionStrings["MyDB"].ConnectionString;
SqlConnection myConnection = new SqlConnection(connectionString);
myConnection.Open();
String SQLconn = "select * from teacher";
SqlCommand myCommand = new SqlCommand(SQLconn, myConnection);
SqlDataReader myReader = myCommand.ExecuteReader();
myReader.Read();
TextBox myTextBox = DetailsViewMove.FindControl("DetailsViewMoveTextBox") as TextBox;
myTextBox.Text = myReader["TeacherId"].ToString();
myConnection.Close();
TextBox myTextBox = DetailsViewMove.FindControl("DetailsViewMoveTextBox") as TextBox;
myTextBox.Text = myReader["TeacherId"].ToString();with
TextBox myTextBox = DetailsViewMove.FindControl("DetailsViewMoveTextBox") as TextBox;
if( myTextBox != null )
myTextBox.Text = myReader["TeacherId"].ToString();
"select * from(teacher inner join department on teacher.departmentid=department.departmentid) inner join unit on unitid=unit.unitid"
我这句话写的哪有错啊?~
为什么提示列名UNIID不明确啊?
"select * from (teacher inner join department on teacher.departmentid=department.departmentid) as temptable inner join unit on temptable.unitid=unit.unitid"
TextBox myTextBox = DetailsViewMove.FindControl("DetailsViewMoveTextBox") as TextBox;
if(myTextBox != null)
myTextBox.Text = myReader["TeacherId"].ToString();建议楼主进行单步调试,很快能够发现问题出在哪一行代码。