private void COMBOBOXNAME_SelectedIndexChanged(object sender, EventArgs e)
{
string Selecteditem = COMBOBOXNAME.Items[COMBOBOXNAME.SelectedIndex].ToString();
string ConnectionString = @"Server=localhost;Database=dbname;Trusted_Connection=True";
SqlConnection con = new SqlConnection(ConnectionString);
try
{
con.Open();
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message);
}
catch (Exception ex )
{
MessageBox.Show(ex.Message);
}
SqlCommand command = con.CreateCommand()
command.CommandText = "SELECT * from Test";
int iCount =0;
SqlDataReader reader = command.ExecuteReader();
DGName.Rows.Clear();
while (reader.Read())
{
DGName.Rows.Add();
DGName.Rows[iCount].Cells[0].Value = iCount + 1; // row number will be added
DGName.Rows[iCount].Cells[1].Value = reader["DBColumnName"].ToString();
DGName.[iCount].Cells[2].Value = reader["DBColumnName"].ToString();
DGName.Rows[iCount].Cells[3].Value = reader["DBColumnName"].ToString();
DGName.Rows[iCount].Cells[4].Value = reader["DBColumnName"].ToString();
DGName.Rows[iCount].Cells[5].Value = reader["DBColumnName"].ToString();
DGName.Rows[iCount].Cells[6].Value = reader["DBColumnName"].ToString();
DGName.Rows[iCount].Cells[7].Value = reader["DBColumnName"].ToString();
DGName.Rows[iCount].Cells[8].Value = reader["DBColumnName"].ToString();
iCount++;
}
reader.Close();
con.Close();
}
//DGName : Wnter Your Data Grid Name
//iCount : Counts The Rows
//COMBOBOXNAME : Enter Your ComboBoxName
Subscribe to:
Post Comments (Atom)
JWT Token Decode Using Jquery
When it come to authentication we use many mechanism. Ones the user authenticated we must keep these details somewhere safe. So we can share...
-
In this blog post Ill explain you the logic behind the Sri Lankan National Identity Card (NIC). Sri Lanka now has Old NIC No Format as well ...
-
In This Article I Will Demonstrate You To Create A Simple Chat Program Using Java Remote Method Invocation(RMI). Following Program Supports ...
-
In a windows form application sometimes you may want to import a excel file to a data grid view. In this blog post Ill demonstrate to you gu...
No comments:
Post a Comment