what i did wrong ??

Question

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

Kunal Vaishya · Answer

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 Hussain · Answer

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 Trivedi · Answer

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.