what i did wrong ??

zartin zaid

13y1.5k.NET

private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
dataGridView1.Rows.Clear();

SqlConnection con = new SqlConnection("Data Source=" + Settings.Default.db_ip + ";Initial Catalog=" + Settings.Default.db_name + ";User Id=" + Settings.Default.db_user + ";Password=" + Settings.Default.db_pass + ";");
SqlDataAdapter tbCount = new SqlDataAdapter("USE " + Settings.Default.db_name + " SELECT * from'" + comboBox1.Text + "'", con);
DataSet dt = new DataSet();
tbCount.Fill(dt);
this.dataGridView1.DataSource = dt.Tables[0];
}

please help

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Kunal Vaishya13y ago
Hi ,
Do like this may be you will resolve the bug ,

private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
//dataGridView1.Rows.Clear();
dataGridView1 = null;

String sConnectionString ="";
sConnectionString = "Data Source=" + Settings.Default.db_ip + ";Initial Catalog="
+ Settings.Default.db_name + ";User Id=" + Settings.Default.db_user + ";Password=" + Settings.Default.db_pass + ";"

SqlConnection con = new SqlConnection(sConnectionString);
SqlDataAdapter tbCount = new SqlDataAdapter("USE " + Settings.Default.db_name + " SELECT * from " + comboBox1.Text + "", con);
DataSet dt = new DataSet();
tbCount.Fill(dt);
this.dataGridView1.DataSource = dt.Tables[0];
}
catch(Exception ex)
{
}
}
Iftikar Hussain13y ago
Hi,
Try like this

try
{
dataGridView1.Rows.Clear();
string constring = string.Format("Data Source={0};Initial Catalog={1};Persist Security Info=True;User ID={2};Password={3}",
Settings.Default.db_ip, Settings.Default.db_name, Settings.Default.db_user, Settings.Default.db_pass);
using (SqlConnection con = new SqlConnection(constring))
{
if (con.State != ConnectionState.Open)
{
con.Open();
}
SqlDataAdapter tbCount=new SqlDataAdapter("SELECT * from'" + comboBox1.Text + "'",con);
DataSet dt = new DataSet();
tbCount.Fill(dt);
con.Close();
this.dataGridView1.DataSource = dt.Tables[0];
}
}

Regards,
Iftikar
Jignesh Trivedi13y ago
hi,
Why you write sql Query like Use DatabaseName?
you are already connected to that database only which is mention in Connection string.
so I think "Use DatabaseName" is not required here.
Also if you fire more than one SQL statement with one command or Adapter than all SQL statement must be seperated by semicolumn (;)
hope this will help you.