如何使用标签值来触发sql查询？ [英] how to use label value to fire sql query?

问题描述

  private   void  ministatement_Load（对象发​​件人，EventArgs e）
 {
 connect.Open（）; 
 SqlDataAdapter da =  new  SqlDataAdapter（  select *来自user_name =' + label2.Text +  '的交易，连接）; 
 DataSet ds =  new  DataSet（）; 
 da.Fill（ds，  transactions）; 
 BindingSource bs =  new  BindingSource（）; 
 dataGridView1.AutoGenerateColumns =  true ; 
 dataGridView1.DataSource = ds; 
 dataGridView1.DataMember =   transactions .ToString（）; 
} 
} 
} 

，标签价值来自另一种形式

 private void button1_Click（object sender，EventArgs e）
 {
 ministatement mns = new ministatement（）; 
 mns.Show（）; 
 mns.label2.Text = label5.Text; 
} 

解决方案

你好abhinav是你的问题尚未解决，我从同一形式或差异形式获取label4值

private void ministatement_Load(object sender, EventArgs e)
        {
             connect.Open();
SqlDataAdapter da = new SqlDataAdapter("select * from transactions where user_name='" + label2.Text + "'", connect);
            DataSet ds = new DataSet();
            da.Fill(ds, "transactions");
            BindingSource bs = new BindingSource();
            dataGridView1.AutoGenerateColumns = true;
            dataGridView1.DataSource = ds;
            dataGridView1.DataMember = "transactions".ToString();
}
}
}

and the label value comes from another form

private void button1_Click(object sender, EventArgs e)
        {
            ministatement mns = new ministatement();
            mns.Show();
            mns.label2.Text = label5.Text;
}

解决方案

hello abhinav is yur problem not yet solved and r u getting label4 value from same form or diff form

这篇关于如何使用标签值来触发sql查询？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！