sqlDataAdapter1.SelectCommand .CommandText ="SELECT * FROM TABLE1 WHERE 姓名='text'";
sqlDataAdapter1.Fill (dataSet11.TABLE1 );if( dataSet11.Tables[TABEL1].Rows.Count == 0 )
{
MessageBox.Show( "Null" );
}
sqlDataAdapter1.Fill (dataSet11.TABLE1 );if( dataSet11.Tables[TABEL1].Rows.Count == 0 )
{
MessageBox.Show( "Null" );
}
sqlConnection1.Open ();
SqlCommand sqlSelectCommand1=new SqlCommand (sele,sqlConnection1);
SqlDataReader reader=sqlSelectCommand1.ExecuteNonQuery ();sqlSelectCommand1.ExecuteNonQuery ();返回的是int类型,
SqlDataReader 返回的是String类型,不匹配,
当语句执行成功后sqlSelectCommand1.ExecuteNonQuery ();返回0
不成功返回-1;
string sele="SELECT * FROM TABLE1";
sqlConnection1.Open ();
SqlCommand sqlSelectCommand1=new SqlCommand (sele,sqlConnection1);
SqlDataReader reader=sqlSelectCommand1.ExecuteNonQuery ();
取出什么东西?
改为
SqlDataReader reader=sqlSelectCommand1.ExecuteReader();
可是照着maotin(liu)程序时,编译结果说“TABLE1在Form1中不存在,”
这是什么意思?dataSet11.Tables[string name].Rows.Count
照着这个命令格式为什么会出现问题啊?谢谢大家
TABLE1 是dataSet11里的tableName,
DataSet dataSet11 = new DataSet( "TABLE1" );
sqlDataAdapter.Fill( dataSet11, TABLE1 );
{
MessageBox.Show( "Null" );
}