{
this.cmbDbName.Items.Clear();
// Loop through the databases list
foreach (Database db in this.m_Server.Databases)
{
//We don't want to be adding the System databases to our list
//Check if database is system database
if (!db.IsSystemObject)
{
this.cmbDbName.Items.Add(db.Name); // Add database to combobox
}
}
this.cmbDbName.SelectedIndex = 0;
//We have the list now
}
as per above bold line, i get database names but tables are not to bind datagridview any one give me solution..
Priyaranjan K SPosted Oct 7, 2015, 9:18 AM
{
SqlCommand cmd = new SqlCommand("Insert into dog(Id, Breed, Name, Age, Gender, Weight, Date) Values (@Id, @Breed, @Name, @Age, @Gender, @Weight, @Date)", con);
cmd.Parameters.AddWithValue("@Id", tb7.Text);
cmd.Parameters.AddWithValue("@Breed", tb1.Text);
cmd.Parameters.AddWithValue("@Name", tb2.Text);
cmd.Parameters.AddWithValue("@Age", tb3.Text);
cmd.Parameters.AddWithValue("@Gender", tb4.Text);
cmd.Parameters.AddWithValue("@Weight", tb5.Text);
cmd.Parameters.AddWithValue("@Date", tb6.Text);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
else if (DropDownList1.Text == "Cat") //Choose Cat
{
SqlCommand cmd = new SqlCommand("Insert into cat(Id, Breed, Name, Age, Gender, Weight, Date) Values (@Id, @Breed, @Name, @Age, @Gender, @Weight, @Date)", con);
cmd.Parameters.AddWithValue("@Id", tb7.Text);
cmd.Parameters.AddWithValue("@Breed", tb1.Text);
cmd.Parameters.AddWithValue("@Name", tb2.Text);
cmd.Parameters.AddWithValue("@Age", tb3.Text);
cmd.Parameters.AddWithValue("@Gender", tb4.Text);
cmd.Parameters.AddWithValue("@Weight", tb5.Text);
cmd.Parameters.AddWithValue("@Date", tb6.Text);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
sagar patilPosted Oct 7, 2015, 7:28 AM
Priyaranjan K SPosted Oct 7, 2015, 7:18 AM
sagar patilPosted Oct 7, 2015, 7:12 AM
Priyaranjan K SPosted Oct 7, 2015, 7:05 AM