---
title: "How can fill textbox on click on select button"
description: "CRUD Operation/Insert, Update, Delete Operation in asp.net by using the stored procedure."
author: "Anonymous User"
published: 2018-08-09
updated: 2019-09-07
canonical: https://www.mindstick.com/articles/13063/how-can-fill-textbox-on-click-on-select-button
category: "c#"
tags: ["c#", "ado.net", "asp.net"]
reading_time: 8 minutes
---
# How can fill textbox on click on select button
Fill textbox on click on the select button.
\
| \ | \ |
| --- | --- |
Today we are going to create a project for Insert, Update, Delete operation in DotNet Technology.
Here I want to tell you which techniques I have used in my project like as-
1). SQL server 2008.
For Database, Table, and Stored Procedure.
2). Visual Studio 2012(integrated development environment (IDE))
I. C#.
II. ASP.Net(for controls like Button, HiddenField, Gridview etc.)
III. ADO.net(for ConnectionString, DataAdapter, SqlCommand etc.)
First Create A database “**APCRUD**” and table “**Contact**”
And Second step is – Create Stored Procedure for different action as Insert data, delete data, Edit data or select data and update data etc.
```
//----For DataBase----//
CREATE database APCRUD
GO
USE APCRUD
```
```
//-----For Table-----//
CREATE TABLE Contact
(
ContactID int primary Key Identity(1,1),
Name varchar(50),
Mobile varchar(50),
Address varchar(250)
)
```
Create Stored Procedure – for Insert and Update records...
\
```
CREATE Proc ContactCreateOrUpdate
@ContactID int,
@Name varchar(50),
@Mobile varchar(50),
@Address varchar(50)
AS
BEGIN
IF(@ContactID=0)
Begin
insert into Contact(Name,Mobile,Address) values(@Name, @Mobile, @Address)
END
Else
Begin
update Contact Set Name=@Name, Mobile=@Mobile, Address=@Address
where ContactID=@ContactID
END
END
```
Create Stored Procedure - for Delete records by ID
```
CREATE Proc ContactDeleteByID
@ContactID int
AS
Begin
Select * from Contact where ContactID=@ContactID
END
```
Create Stored Procedure - for Display all records
```
CREATE Proc ContactViewAll
AS
Begin
Select * from Contact
END
```
Create Stored Procedure - for Display record by ID
```
CREATE Proc ContactViewByID
@ContactID int
AS
Begin
Select * from Contact where ContactID=@ContactID
END
```
Here I define **.aspx** page for design pattern.
--- Using HiddenField to get ContactID for any operation.
```
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
```
And
Here Define the **.cs** code for all actions
```
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.Configuration;
public partial class _Default : System.Web.UI.Page
{
SqlConnection con = new SqlConnection("Data Source=s-pc;Initial Catalog=ASPCRUD;Integrated Security=True");
protected void Page_Load(object sender, EventArgs e)
{
if(!IsPostBack)
{
btnDelete.Enabled = false;
FillGridView();
}
}
public void Clear()
{
hfContactID.Value= "";
txtName.Text = "";
txtMobile.Text = "";
txtAddress.Text = "";
lblErrorMessage.Text = "";
lblSuccessMessage.Text = "";
btnDelete.Enabled = false;
}
public void FillGridView()
{
if (con.State == ConnectionState.Closed)
con.Open();
SqlDataAdapter da = new SqlDataAdapter("ContactViewAll", con);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
DataTable dtbl = new DataTable();
da.Fill(dtbl);
gvContact.DataSource = dtbl;
gvContact.DataBind();
}
protected void btnClear_Click(object sender, EventArgs e)
{
Clear();
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (con.State == ConnectionState.Closed)
con.Open();
SqlCommand cmd = new SqlCommand("ContactCreateOrUpdate",con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ContactID", (hfContactID.Value == "" ? 0 : Convert.ToInt32(hfContactID.Value)));
cmd.Parameters.AddWithValue("@Name", txtName.Text.Trim());
cmd.Parameters.AddWithValue("@Mobile", txtMobile.Text.Trim());
cmd.Parameters.AddWithValue("@Address", txtAddress.Text.Trim());
cmd.ExecuteNonQuery();
con.Close();
string ContactID = hfContactID.Value;
Clear();
if (ContactID == "")
lblSuccessMessage.Text = "Record Save Successfully";
else
lblErrorMessage.Text = "Update Successfull";
FillGridView();
}
protected void lnk_OnClick(object sender, EventArgs e)
{
int contactID = Convert.ToInt32((sender as LinkButton).CommandArgument);
if (con.State == ConnectionState.Closed)
con.Open();
SqlDataAdapter SqlDa = new SqlDataAdapter("ContactViewByID",con);
SqlDa.SelectCommand.CommandType = CommandType.StoredProcedure;
SqlDa.SelectCommand.Parameters.AddWithValue("ContactID", contactID);
DataTable dtbl = new DataTable();
SqlDa.Fill(dtbl);
con.Close();
hfContactID.Value = contactID.ToString();
txtName.Text = dtbl.Rows[0]["Name"].ToString();
txtMobile.Text = dtbl.Rows[0]["Mobile"].ToString();
txtAddress.Text = dtbl.Rows[0]["Address"].ToString();
btnSave.Text = "Update";
btnDelete.Enabled = true;
FillGridView();
lblErrorMessage.Text = "";
lblSuccessMessage.Text = "";
}
protected void btnDelete_Click(object sender, EventArgs e)
{
if (con.State == ConnectionState.Closed)
con.Open();
SqlCommand SqlCmd = new SqlCommand("ContactDeleteByID",con);
SqlCmd.CommandType = CommandType.StoredProcedure;
SqlCmd.Parameters.AddWithValue("@ContactID", Convert.ToInt32(hfContactID.Value));
SqlCmd.ExecuteNonQuery();
con.Close();
Clear();
FillGridView();
lblSuccessMessage.Text = "Record Delete Successfully";
}
}
```
Thank You...
\
---
Original Source: https://www.mindstick.com/articles/13063/how-can-fill-textbox-on-click-on-select-button
Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.