private void loadinfo(string sql)
{
inits gg = new inits();
string s = "";
sqlConnection1.ConnectionString = gg.m_strConnstr;
//SqlDataAdapter da = new SqlDataAdapter();
sqlDataAdapter1.SelectCommand = new SqlCommand(sql, sqlConnection1);
sqlDataAdapter1.Fill(baseinfo1.Ocean_SceneInfoInput);
this.gridEX1.Refresh();
}
为什么我用这个函数输入不同的sql语句视图不刷新,一点反映也没有,有没有人知道。谢谢。
{
inits gg = new inits();
string s = "";
sqlConnection1.ConnectionString = gg.m_strConnstr;
//SqlDataAdapter da = new SqlDataAdapter();
sqlDataAdapter1.SelectCommand = new SqlCommand(sql, sqlConnection1);
sqlDataAdapter1.Fill(baseinfo1.Ocean_SceneInfoInput);
this.gridEX1.Refresh();
}
为什么我用这个函数输入不同的sql语句视图不刷新,一点反映也没有,有没有人知道。谢谢。
不知道是俺太笨,还是破绽太多无处下手,还是什么的.
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Data Source=.\\SQLEXPRESS;AttachDbFilename=C:\\Documents and Settings\\louzhudeshushu \\My Documents\\Visual Studio 2005\\Projects\\数据库操作示例\\数据库操作示例\\MyLove.mdf;Integrated Security=True;User Instance=True";
SqlCommand comm = new SqlCommand("Student_PL_addage",conn );
conn.Open();
comm.CommandType = CommandType.StoredProcedure;
/* SqlParameter parameter1 = new SqlParameter();
parameter1.ParameterName = "@parameter1";
parameter1.DbType = DbType.Int16;
parameter1.Value = 10;
SqlParameter @adage = new SqlParameter();
adage.ParameterName = "@adage";
adage.DbType = DbType.Int16;
adage.Value = 5;
adage.Direction = ParameterDirection.Output;
comm.Parameters.Add(parameter1);
comm.Parameters.Add(adage);*/
SqlParameter sq = new SqlParameter("@parameter1", SqlDbType.Int);
sq.Value = 10;
comm.Parameters.Add(sq);
SqlParameter sqs = new SqlParameter("@adage", SqlDbType.Int);
sqs.Direction = ParameterDirection.Output;
comm.Parameters.Add(sqs);
/* SqlParameter @adage = new SqlParameter();
adage.Direction = ParameterDirection.Output;
comm.Parameters.Add("@parameter1", DbType.Int16).Value = 10;
comm.Parameters.Add("@adage", DbType.Int16).Value = 2;*/
comm.ExecuteNonQuery();
DialogResult result = MessageBox.Show(comm.Parameters["@adage"].Value.ToString ());
bool bai = (result == DialogResult.OK);
// String SQLString = " SELECT name FROM sysobjects WHERE type='U'";
// String SQLString = "SELECT * FROM Student_PL";
// String SQLString = "update Student_PL set StudentAge=StudentAge+10 where StudentAge>0";
// String SQLString = "UPDATE Student_PL SET StudentName='囤泡泡' WHERE Student_PL.StudentName='囤金强'";
// String SQLString = "SELECT Student_PL.*,家庭成员.* FROM Student_PL,家庭成员 WHERE Student_PL.StudentName=家庭成员.姓名";
// SqlCommand comm = new SqlCommand (SQLString ,conn );
// comm.ExecuteNonQuery();
String SQLString1 = "SELECT * FROM Student_PL";
SqlCommand comm1 = new SqlCommand(SQLString1, conn);
//comm.ExecuteNonQuery();
/* String SQLString1 = "SELECT * FROM Student_PL";
SqlCommand comm1 = new SqlCommand(SQLString1, conn);*/
dap = new SqlDataAdapter(comm1);
ds = new DataSet();
dap.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
if (conn.State == ConnectionState.Open)
conn.Close();
给你个更乱的.