Thursday, May 20, 2010

Bind Data in DataGridView

            string strSQLconnection = "Data Source=(local);Initial Catalog=Info;Integrated Security=True";
            SqlConnection sqlConnection = new SqlConnection(strSQLconnection);
            SqlCommand sqlCommand = new SqlCommand("select * from product", sqlConnection);
            sqlConnection.Open();
            SqlDataAdapter sda = new SqlDataAdapter(sqlCommand.CommandText, sqlConnection);
            DataSet ds = new DataSet();
            sda.Fill(ds);
            DataGrid1.DataSource = ds.Tables[0];

No comments:

Post a Comment

Mat Table Angular

Mat Table in Angular Mat table is used to display data . its a material designed styled data-table . For using Material Table MatTableMo...