Guide for Asp gridview bind function

Parthiban B

13y1.4k.NET

guide me for asp.net gridview bind() from SQL table

3 Replies

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

Sanjeeb Lenka13y ago
Accepted answer
check this:

in aspx page:















in cs:

add the namespaces:

using System.Data.SqlClient;
using System.Data;

write this code in page load:

string connstr = "Data Source=WIN2K8; Initial Catalog=ABC;User ID=sa; Password=123";
DataSet ds = new DataSet();
    SqlConnection conn = new SqlConnection(connstr);
    string strsql = "Select StudentID,StudentName from student";
SqlDataAdapter da = new SqlDataAdapter(strsql, conn);
da.Fill(ds, "student");
grid.DataSource = ds.Tables["student"];
grid.DataBind();
0
Parthiban B13y ago
no not this databind in gridview like template option in ASP script
0
Sanjeeb Lenka13y ago
Step 1: Create new Project
Launch Visual Studio 2010, click on File->New->Website to create a new ASP.NET website Project.

Step 2: Create a new Page
Right click on the Project on the Solution Explorer Panel. Select Add->New Item. Then, choose Web Form. I'd like to name it Products.aspx

Step3: Add the following code to the Products.aspx file

id="form1" runat="server">

ID="grid" runat="server">

then go to .cs and
add the namespaces:

using System.Data.SqlClient;
using System.Data;

write this code in page load:

string connstr = "Data Source=WIN2K8; Initial Catalog=ABC;User ID=sa; Password=123";
DataSet ds = new DataSet();
SqlConnection conn = new SqlConnection(connstr);
string strsql = "Select * from Products";
SqlDataAdapter da = new SqlDataAdapter(strsql, conn);
da.Fill(ds, "ProductsTable");
grid.DataSource = ds.Tables["ProductsTable"];
grid.DataBind();

change the connection string as your and change the query and check.
0