Guide for Asp gridview bind function

Question

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

Sanjeeb Lenka · Answer

check this: in aspx page: ' runat=server> '> 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 StudentIDStudentName from student; SqlDataAdapter da = new SqlDataAdapter(strsql conn); da.Fill(ds student); grid.DataSource = ds.Tables[student]; grid.DataBind();

Parthiban B · Answer

no not this databind in gridview like template option in ASP script

Sanjeeb Lenka · Answer

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.