HI Joey,
Please refer the below sample.
Database
CREATE TABLE [Vegitables](
[Id] [int] IDENTITY(1,1) NOT NULL,
[Name] [varchar](50) NULL,
[PricePerkg] [int] NULL,
[QtyInKg] [int] NULL,
CONSTRAINT [PK_Vegitables] PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
HTML
<div>
<asp:GridView ID="gvVegitables" runat="server" AutoGenerateColumns="false"
OnSelectedIndexChanged="OnSelectedIndexChanged">
<Columns>
<asp:BoundField DataField="Id" HeaderText="Id" />
<asp:BoundField DataField="Name" HeaderText="Name" />
<asp:BoundField DataField="PricePerKg" HeaderText="PricePerKg" />
<asp:BoundField DataField="QtyInKg" HeaderText="QtyInKg" />
<asp:ButtonField Text="Select" CommandName="Select" />
</Columns>
<EmptyDataTemplate>
<div align="center">
Record not found
</div>
</EmptyDataTemplate>
</asp:GridView>
<br />
<br />
<table>
<tr>
<td>Id:</td>
<td>
<asp:Label ID="lblId" runat="server"></asp:Label></td>
<td></td>
</tr>
<tr>
<td>Name:</td>
<td>
<asp:TextBox ID="txtName" runat="server"></asp:TextBox></td>
<td>
<asp:RequiredFieldValidator ID="rfvtName" runat="server" ControlToValidate="txtName" Display="Dynamic"
ErrorMessage="Name is required" ForeColor="Red"></asp:RequiredFieldValidator>
<asp:RegularExpressionValidator ID="revName" runat="server" ControlToValidate="txtName" Display="Dynamic" ForeColor="Red"
ErrorMessage="Accepted only alphates" ValidationExpression="[a-zA-Z ]*$"></asp:RegularExpressionValidator>
</td>
</tr>
<tr>
<td>Price Per Kg:</td>
<td>
<asp:TextBox ID="txtPricePerKg" runat="server"></asp:TextBox></td>
<td>
<asp:RequiredFieldValidator ID="rfvPricePerKg" runat="server" ControlToValidate="txtPricePerKg" Display="Dynamic"
ErrorMessage="PricePerKg is required" ForeColor="Red"></asp:RequiredFieldValidator>
<asp:RegularExpressionValidator ID="revPricePerKg" runat="server" ControlToValidate="txtPricePerKg" Display="Dynamic" ForeColor="Red"
ErrorMessage="Accepted only 0-9 " ValidationExpression="[0-9]*$"></asp:RegularExpressionValidator>
</td>
</tr>
<tr>
<td>Qty In Kg:</td>
<td>
<asp:TextBox ID="txtQtyInKg" runat="server"></asp:TextBox></td>
<td>
<asp:RequiredFieldValidator ID="rfvQtyInKg" runat="server" ControlToValidate="txtQtyInKg" Display="Dynamic"
ErrorMessage="QtyInKg is required" ForeColor="Red"></asp:RequiredFieldValidator>
<asp:RegularExpressionValidator ID="revQtyInKg" runat="server" ControlToValidate="txtQtyInKg" Display="Dynamic" ForeColor="Red"
ErrorMessage="Accepted only 0-9" ValidationExpression="[0-9]*$"></asp:RegularExpressionValidator>
</td>
</tr>
<tr>
<td></td>
<td colspan="2">
<asp:Button runat="server" Text="Update" OnClick="OnUpdate" /></td>
</tr>
</table>
</div>
Namespace
using System;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
Code
#region Events
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
this.BindGrid();
}
}
protected void OnUpdate(object sender, EventArgs e)
{
//Reading the values .
int id = int.Parse(lblId.Text);
string name = txtName.Text.Trim();
int pricePerKg = int.Parse(txtPricePerKg.Text);
int qtyInKg = int.Parse(txtQtyInKg.Text);
//Sql query store in variable.
string query = "UPDATE Vegitables SET Name = @Name, PricePerKg = @PricePerKg , QtyInKg = @QtyInKg WHERE Id = @Id";
string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (SqlConnection sqlConnection = new SqlConnection(constr))
{
using (SqlCommand sqlCommand = new SqlCommand(query, sqlConnection))
{
sqlCommand.Parameters.AddWithValue("@Id", id);
sqlCommand.Parameters.AddWithValue("@Name", name);
sqlCommand.Parameters.AddWithValue("@PricePerKg", pricePerKg);
sqlCommand.Parameters.AddWithValue("@QtyInKg", qtyInKg);
//Opening the connection.
sqlConnection.Open();
//Executing the sql query.
sqlCommand.ExecuteNonQuery();
//Colosing the connection.
sqlConnection.Close();
}
}
this.BindGrid();
}
protected void OnSelectedIndexChanged(object sender, EventArgs e)
{
int id = int.Parse(gvVegitables.SelectedRow.Cells[0].Text);
string name = gvVegitables.SelectedRow.Cells[1].Text;
int pricePerKg = int.Parse(gvVegitables.SelectedRow.Cells[2].Text);
int qtyInKg = int.Parse(gvVegitables.SelectedRow.Cells[3].Text);
lblId.Text = id.ToString();
txtName.Text = name;
txtPricePerKg.Text = pricePerKg.ToString();
txtQtyInKg.Text = qtyInKg.ToString();
}
#endregion
#region Private Methods
/// <summary>
/// Populate GridView.
/// </summary>
private void BindGrid()
{
string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (SqlConnection sqlConnection = new SqlConnection(constr))
{
using (SqlCommand sqlCommand = new SqlCommand("SELECT Id, Name, PricePerKg, QtyInKg FROM Vegitables", sqlConnection))
{
using (SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand))
{
using (DataTable dtVegitables = new DataTable())
{
sqlDataAdapter.Fill(dtVegitables);
gvVegitables.DataSource = dtVegitables;
gvVegitables.DataBind();
}
}
}
}
}
#endregion
Screenshot
