Hello,
I needed help in codes for update and delete
options in grid view.
Below is the code for the registration form
and grid view.
I want help with the codes in the
adding update and delete options in the gridview.
Default.aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="Default2" %>
<!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>Simple Application Form in ASP.Net</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<div>
<strong><span style="font-size: 14pt; color: #0000ff">Simple Application Form In ASP.Net</span></strong><br />
<br />
<br />
<br />
<table>
<tr>
<td style="width: 123px">
First Name</td>
<td style="width: 63px">
:</td>
<td style="width: 193px">
<asp:TextBox ID="fname" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 123px">
Last Name</td>
<td style="width: 63px">
:</td>
<td style="width: 193px">
<asp:TextBox ID="lname" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 123px">
Date of Birth</td>
<td style="width: 63px">
:</td>
<td style="width: 193px">
<asp:TextBox ID="dob" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 123px">
Gender</td>
<td style="width: 63px">
:</td>
<td style="width: 193px">
<asp:TextBox ID="gender" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 123px">
Father's Name</td>
<td style="width: 63px">
:</td>
<td style="width: 193px">
<asp:TextBox ID="fathername" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 123px">
Contact Number</td>
<td style="width: 63px">
:</td>
<td style="width: 193px">
<asp:TextBox ID="contact" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 123px">
Address</td>
<td style="width: 63px">
:</td>
<td style="width: 193px">
<asp:TextBox ID="address" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td style="width: 123px; height: 21px">
</td>
<td style="width: 63px; height: 21px">
</td>
<td style="width: 193px; height: 21px">
<asp:Label ID="conform" runat="server" Text="Submitted, thank you !" Visible="False"
Width="152px"></asp:Label></td>
</tr>
<tr>
<td style="width: 123px">
</td>
<td style="width: 63px; text-align: center">
</td>
<td style="width: 193px">
<asp:Button ID="submit" runat="server" Text="Submit" OnClick="submit_Click" /></td>
</tr>
</table>
</div>
<br />
<br />
<strong><span style="text-decoration: underline">Database Details</span></strong><br />
<br />
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1"
EmptyDataText="There are no data records to display.">
<Columns>
<asp:BoundField DataField="id" HeaderText="id" SortExpression="id" />
<asp:BoundField DataField="fname" HeaderText="fname" SortExpression="fname" />
<asp:BoundField DataField="lname" HeaderText="lname" SortExpression="lname" />
<asp:BoundField DataField="dob" HeaderText="dob" SortExpression="dob" />
<asp:BoundField DataField="gender" HeaderText="gender" SortExpression="gender" />
<asp:BoundField DataField="fathername" HeaderText="fathername" SortExpression="fathername" />
<asp:BoundField DataField="contact" HeaderText="contact" SortExpression="contact" />
<asp:BoundField DataField="address" HeaderText="address" SortExpression="address" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:onlineapplicationformConnectionString1 %>"
ProviderName="<%$ ConnectionStrings:onlineapplicationformConnectionString1.ProviderName %>"
SelectCommand="SELECT [id], [fname], [lname], [dob], [gender], [fathername], [contact], [address] FROM [onlineapplication]">
</asp:SqlDataSource>
</div>
</form>
</body>
</html>
Default.aspx.cs
using System;
using System.Data;
using System.Configuration;
using System.Data.SqlClient;
using System.ComponentModel;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class Default2 : System.Web.UI.Page
{
public string GetConnectionString()
{
//we will set up the configuration which will call our
//web.config file to provide the database details because
//in configuration file we have created the <connectionStrings>
//in the process we draged and droped. It creates automatically.
//We normally put the database details in web.config file or
//machine.config file because it is very sensitive information
//usually there IP address of remote database, passwords and
//user names are stored.
return System.Configuration.ConfigurationManager.ConnectionStrings
["onlineapplicationformConnectionString1"].ConnectionString;
//in above line "onlineapplicationformConnectionString1" is
//our configuration name which is inside the web.config file.
}
private void execution(string fname, string lname, string dob, string gender, string fathername, string contact, string address)
{
//In above line we declaring different variables same as backend
SqlConnection conn = new SqlConnection(GetConnectionString());
//In above line we are calling connection
//string function which is defined already on top
string sql = "INSERT INTO onlineapplication (fname, lname, dob, gender, fathername, contact, address) VALUES "
+ " (@fname, @lname, @dob, @gender, @fathername, @contact, @address)";
//In above lines we are just storing the sql commands which
//will insert value in onlineapplication named table,
//using variable named sql.
try
{
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
//In above lines we are opening the connection to work and
//also storing connection name and sql command in cmd variable
//which has 'SqlCommand' type.
SqlParameter[] pram = new SqlParameter[7];
//In above lines we are defining 7 sql parameters will be use
//In below lines we will not disscuss about id column
pram[0] = new SqlParameter("@fname", SqlDbType.VarChar, 50);
pram[1] = new SqlParameter("@lname", SqlDbType.VarChar, 50);
pram[2] = new SqlParameter("@dob", SqlDbType.VarChar, 50);
pram[3] = new SqlParameter("@gender", SqlDbType.Char, 10);
pram[4] = new SqlParameter("@fathername", SqlDbType.VarChar, 50);
pram[5] = new SqlParameter("@contact", SqlDbType.Int, 20);
pram[6] = new SqlParameter("@address", SqlDbType.VarChar, 100);
//Now we set-uped all fiels in database in above lines
//Now we will set-up form fields
pram[0].Value = fname;
pram[1].Value = lname;
pram[2].Value = dob;
pram[3].Value = gender;
pram[4].Value = fathername;
pram[5].Value = contact;
pram[6].Value = address;
//Now create loop to insert
for (int i = 0; i < pram.Length; i++)
{
cmd.Parameters.Add(pram[i]);
}
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
}
catch(System.Data.SqlClient.SqlException ex_msg)
{
//Here will be catch elements
string msg = "Error occured while inserting";
msg += ex_msg.Message;
throw new Exception(msg);
}
finally
{
//Here will be fially elements
conn.Close();
}
}
protected void Page_Load(object sender, EventArgs e)
{
}
protected void submit_Click(object sender, EventArgs e)
{
//Here is the command inside the click event of button
if(fname.Text=="")
{
Response.Write("Please complete the form.");
}
else
{
execution(fname.Text,lname.Text,dob.Text,gender.Text,fathername.Text,contact.Text,address.Text);
conform.Visible = true;
fname.Text="";
lname.Text="";
dob.Text="";
gender.Text="";
gender.Text="";
fathername.Text="";
contact.Text="";
address.Text="";
}
}
}
|