i am using this code but at da.fill(dt) i got error "invalid colum name a" this a is user name and exist in database. this is a desktop application
private void comboBox1_SelectedValueChanged(object sender, EventArgs e)
{
if ( comboBox1.SelectedItem.ToString() == "Name")
{
SqlConnection my = new SqlConnection(@"Data Source=heaven_prince20;Initial Catalog=final_pr;Integrated Security=True");
my.Open();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter("Select * from addcustomer where name= " +
textBox1.Text + "", my);
da.Fill(dt); ......................................error
}
else
{
MessageBox.Show("error");
}
Loading
Sanjeeb LenkaPosted Jul 24, 2013, 6:16 AM
Sanjeeb LenkaPosted Jul 24, 2013, 6:31 AM
ta muPosted Jul 24, 2013, 6:28 AM
dataGridView1.DataSource = dt.DefaultView;
was mising
ta muPosted Jul 24, 2013, 6:12 AM
Riyaz AkhtarPosted Jul 24, 2013, 6:02 AM
use like this
SqlDataAdapter da = new SqlDataAdapter("Select * from addcustomer where name= '" + textBox1.Text + "'", my);
Riyaz AkhtarPosted Jul 24, 2013, 5:58 AM
Sanjeeb LenkaPosted Jul 24, 2013, 5:56 AM
SqlDataAdapter da = new SqlDataAdapter("Select * from addcustomer where name='" +textBox1.Text + "'", my);