请教高人:
public static string cs = "server = HMCHE; database = cg; integrated security = sspi";
string sql_str ="select * from SY_T_USER";
SqlConnection sqlcon = new SqlConnection(cs);
SqlCommand sqlCommand1 = new SqlCommand();
SqlDataAdapter sqlDataAdapter1 = new SqlDataAdapter(sql_str,sqlcon);//这行出错 出错提示:字段初始值设定项无法引用非静态字段、方法或属性
public static string cs = "server = HMCHE; database = cg; integrated security = sspi";
string sql_str ="select * from SY_T_USER";
SqlConnection sqlcon = new SqlConnection(cs);
SqlCommand sqlCommand1 = new SqlCommand();
SqlDataAdapter sqlDataAdapter1 = new SqlDataAdapter(sql_str,sqlcon);//这行出错 出错提示:字段初始值设定项无法引用非静态字段、方法或属性
这段代码写在哪的?sqlconnection也没open把SqlConnection先声明个在外面去看看
public partial class cg : Form
{
public cg()
{
InitializeComponent();
}
public static string cs = "server = HMCHE; database = cg; integrated security = sspi";
public static string sql_str = "select * from SY_T_USER";
SqlConnection sqlcon = new SqlConnection(cs);
SqlCommand sqlCommand1 = new SqlCommand();
SqlDataAdapter sqlDataAdapter1 = new SqlDataAdapter(sql_str,sqlcon);
DataSet dataSet1 = new DataSet(); private void cg_Load(object sender, EventArgs e)
{
try
{
this.sqlDataAdapter1.Fill(this.dataSet1, "SY_T_USER");
this.textBox1.DataBindings.Add("Text", this.dataSet1, "SY_T_USER.ID");
this.textBox2.DataBindings.Add("Text", this.dataSet1, "SY_T_USER.RYXM");
this.textBox3.DataBindings.Add("Text", this.dataSet1, "SY_T_USER.ZFJE");
}
catch (Exception Err)
{
MessageBox.Show("打开数据库表错误:" + Err.Message, "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
}
SqlConnection sqlcon = new SqlConnection(cs);
SqlDataAdapter sqlDataAdapter1 = new SqlDataAdapter(sql_str,sqlcon);
改一下
static SqlConnection sqlcon = new SqlConnection(cg.cs);
无法使用实例引用访问静态成员“cg.cg.sqlcon”;改用类型名来限定它