gridview in asp dot net

EDN Admin · Sep 12, 2012

i write the code as such as in below can run my program bur cant get data in gridview while updating..can anybody help me?

my cs code

using System; 
using System.Collections.Generic; 
using System.Linq; 
using System.Web; 
using System.Web.UI; 
using System.Web.UI.WebControls; 
using System.Data; 
using System.Data.SqlClient; 
using System.Xml; 
using System.Xml.Linq; 
using System.Configuration; 
 
public partial class Gridview_using_database : System.Web.UI.Page 
{ 
SqlConnection con = new SqlConnection(); 
 
DataTable dt; 
SqlDataAdapter adp; 
protected void Page_Load(object sender, EventArgs e) 
{ 
 
 
} 
protected void SqlDataSource1_Selecting(object sender, SqlDataSourceSelectingEventArgs e) 
{ 
 
} 
 
protected void SubmitOnclick_data(object sender, EventArgs e) 
{ 
con.ConnectionString = ConfigurationManager.ConnectionStrings["Con"].ConnectionString; 
con.Open(); 
if (con.State != ConnectionState.Open) 
{ 
con.Open(); 
SqlCommand cmd = new SqlCommand("INSERTDATA", con); 
cmd.CommandType = CommandType.StoredProcedure; 
cmd.Parameters.Add("@SERIALNUMBER", SqlDbType.Int).Value = TextBox2.Text; 
cmd.Parameters.Add("@NAME", SqlDbType.VarChar, 20).Value = TextBox1.Text; 
cmd.Parameters.Add("@QUALIFICATION", SqlDbType.VarChar, 20).Value = TextBox3.Text; 
cmd.Parameters.Add("@NATIONALITY", SqlDbType.VarChar, 20).Value = TextBox4.Text; 
cmd.Parameters.Add("@CITY ",SqlDbType.VarChar, 20).Value = TextBox5.Text; 
cmd.Parameters.Add("@ADDRESS", SqlDbType.VarChar, 20).Value = TextBox6.Text; 
cmd.ExecuteNonQuery(); 
 
SqlCommand test = new SqlCommand("select * from anjana", con); 
adp=new SqlDataAdapter(); 
adp.Fill(dt); 
GridView1.DataSource = dt; 
GridView1.DataBind(); 
con.Close(); 
} 
} 
}

my aspx code.

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Gridview using database.aspx.cs" Inherits="Gridview_using_database" %> 
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd 
 
<html xmlns="http://www.w3.org/1999/xhtml 
<head runat="server 
<title></title> 
</head> 
<body> 
<form id="form1" runat="server 
 
Serial Number :   
<asp:TextBox ID="TextBox2" runat="server </asp:TextBox> 
 
 
Student Name :   
<asp:TextBox ID="TextBox1" runat="server </asp:TextBox> 
 
 
Qualification :     
<asp:TextBox ID="TextBox3" runat="server </asp:TextBox> 
 
 
Nationality : &nbsp &nbsp   
<asp:TextBox ID="TextBox4" runat="server </asp:TextBox> 
 
 
City : &nbsp &nbsp &nbsp           
<asp:TextBox ID="TextBox5" runat="server </asp:TextBox> 
 
 
Address :          
<asp:TextBox ID="TextBox6" runat="server" TextMode="MultiLine" ></asp:TextBox> 
 
 
                         
<asp:Button ID="Button1" runat="server" Text="submit" 
onclick="SubmitOnclick_data" /> 
 
 
 
 
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
DataSourceID="SqlDataSource1 
<Columns> 
<asp:TemplateField HeaderText="Serialno" SortExpression="serialnumber 
<EditItemTemplate> 
<asp:TextBox ID="testbox2" runat="server" Text=<%# Eval("serialnumber") %> Width="2px </asp:TextBox> 
</EditItemTemplate> 
</asp:TemplateField> 
<asp:TemplateField HeaderText="student name" SortExpression="name 
<EditItemTemplate> 
<asp:TextBox ID="testbox1" runat="server" Text=<%# Eval("name") %> Width="2px </asp:TextBox> 
</EditItemTemplate> 
</asp:TemplateField> 
<asp:TemplateField HeaderText="Qualification" SortExpression="quali 
<EditItemTemplate> 
<asp:TextBox ID="testbox3" runat="server" Text=<%# Eval("quali") %> Width="2px </asp:TextBox> 
</EditItemTemplate> 
</asp:TemplateField> 
<asp:TemplateField HeaderText="Nationality" SortExpression="national 
<EditItemTemplate> 
<asp:TextBox ID="testbox4" runat="server" Text=<%# Eval("national") %> Width="2px </asp:TextBox> 
</EditItemTemplate> 
</asp:TemplateField> 
<asp:TemplateField HeaderText="city" SortExpression="cit 
<EditItemTemplate> 
<asp:TextBox ID="testbox5" runat="server" Text=<%# Eval("cit") %> Width="2px </asp:TextBox> 
</EditItemTemplate> 
</asp:TemplateField> 
<asp:TemplateField HeaderText="address" SortExpression="addre 
<EditItemTemplate> 
<asp:TextBox ID="testbox6" runat="server" Text=<%# Eval("addre") %> Width="2px </asp:TextBox> 
</EditItemTemplate> 
</asp:TemplateField> 
</Columns> 
</asp:GridView> 
 
 
 
 
 
 
 
 
</form> 
</body> 
</html> 

<hr class="sig Sumathi

View the full article

gridview in asp dot net

EDN Admin

Well-known member

Similar threads