Asp.net programming we consider all important topic for knowledge about controls,web Services, JSON, Ajax, database, and interview related Question. In this Asp.net and sql server tutorial blog we give many examples of jquery as like How Play YouTube Video in Your Asp.net Website by URL, How to Play YouTube Videos in Asp.net by using Jquery , Jquery Change div background on mouseover in asp.net , JQuery UI Datepicker (Calendar) etc.

Tuesday, August 19, 2014

How to bind data to textbox inside Gridview in asp.net using C#

Textbox inside Gridview in ASP.NET:



In this post we describe that how to get textbox control into gridview control and then bind this textbox. As we know that for solving this we use templatefield in gridview. In this asp.net tutorial we also give Example that refers how to get (make) templatefiled in asp.net gridview. And also consider many examples related to gridview contro. Some important gridview and textbox related post listed here:

Gridview related posts :


How to bind data to Textbox:

For binding textbox in gridview we take a sql table with data. On the C# code page create connection to the sql for get table data.  The name of table is list of state which contain name of state and one Id.

Then get the data and bind textbox.

Textbox binding:

<asp:TextBox ID="label1" runat="server" Text='<%# Eval("ID") %>'></asp:TextBox>

Here ID is the sql table column name.

Textbox with gridview Example:

Code of Exampleoftextboxbind.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile=" Exampleoftextboxbind.aspx.cs" Inherits="Exampleoftemplate" %>

<!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>Bind data to Textbox inside Gridview in ASP.NET</title>
</head>
<body>
    <form id="form1" runat="server">
    <div style="" align="center">
        <br />       
            <h3>How to bind data to textbox inside Gridview in ASP.NET: </h3>
        <asp:GridView ID="grd" runat="server" AutoGenerateColumns="false"
            Height="258px" Width="559px" >
        <Columns>
         <asp:TemplateField HeaderText="SNo" ItemStyle-HorizontalAlign="Center">
                            <ItemTemplate>
                                <%#Container.DataItemIndex+1 %>
                            </ItemTemplate>
                            <ItemStyle HorizontalAlign="Center"></ItemStyle>
                        </asp:TemplateField>
         <asp:TemplateField HeaderText="State ID" ItemStyle-HorizontalAlign="Center">
                            <ItemTemplate>
                                <asp:TextBox ID="label1" runat="server" Text='<%# Eval("ID") %>'></asp:TextBox>
                               
                            </ItemTemplate>
                            <ItemStyle HorizontalAlign="Center"></ItemStyle>
                        </asp:TemplateField>
         <asp:TemplateField HeaderText="Name of State" ItemStyle-HorizontalAlign="Center">
                            <ItemTemplate>
                               
                                <asp:TextBox ID="label2" runat="server" Text='<%# Eval("Name") %>'></asp:TextBox>
                            </ItemTemplate>
                            <ItemStyle HorizontalAlign="Center"></ItemStyle>
                        </asp:TemplateField>
                      

        </Columns>
            <HeaderStyle BackColor="#990000" BorderColor="#CC33FF" BorderStyle="Dotted"
                BorderWidth="2px" ForeColor="#009933" />
        </asp:GridView>
    </div>
    </form>
</body>
</html>


Exampleoftextboxbind.aspx.cs page 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.SqlClient;
using System.Data;

public partial class Exampleoftextboxbind : System.Web.UI.Page
{
    string connection;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            connection = @"Data Source=PARIJAT-PC\PARIJAT;Initial Catalog=Database1;Integrated Security=True;Pooling=False";// create connection....
            BindData();//  call function here........
        }
    }

    private void BindData() //make function .....
    {
        try
        {

            string sql = "select StateID as ID,StateName as Name from States";//sql Query for fetching data from table
            SqlConnection conn = new SqlConnection(connection);
            SqlCommand command = new SqlCommand(sql, conn);
            SqlDataAdapter adapter = new SqlDataAdapter(command);
            DataTable datatable = new DataTable();
            adapter.Fill(datatable);

            grd.DataSource = datatable;  //bind grid view control here
            grd.DataBind();

        }
        catch(Exception ex)
        {
           
        }
    }
   
}

Simple copy code and past on page and run

Other Asp.net related Post:


No comments:

Post a Comment