inserting textbox in gridview in asp using c#

HI Chiranjeevi,

Run the attachments.


One alternate solution for your problem.You have to select all the checkbox and enter the values in the gridview and when you click insert button all the records are inserted into the database.

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





   


   

   

                                 AllowPaging="True"
                             DataSourceID="SqlDataSource1"
                             AutoGenerateColumns="false">

 
    
 
   
   
                      AutoPostBack="true"
             OnCheckedChanged="chkSelect_CheckedChanged"/>
   
   
   
                                       SortExpression="ID"/>
                                  
                           SortExpression="name">
   
                     Text='<%# Bind("name") %>' ReadOnly="true"
                 ForeColor="Blue" BorderStyle="none"
                 BorderWidth="0px" >
   
   
   
   
                           SortExpression="address">
   
                     Text='<%# Bind("address") %>'
                 ReadOnly="true" ForeColor="Blue"
                 BorderStyle="none" BorderWidth="0px">
   
   
   
   
   
                            SortExpression="marks">
   
                     Text='<%# Bind("marks") %>'
                 ReadOnly="true" ForeColor="Blue"
                 BorderStyle="none" BorderWidth="0px">
   
   
   



ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT [ID], [name], [address],[marks]FROM [Details]"
UpdateCommand="UPDATE [Details] SET [name] = @name,
              [address] = @address, [marks] = @marks WHERE [ID] = @ID">
       
       
               
               
               
                  
       
       

       
            OnClick="btnUpdate_Click" Text="Insert" />

           

   

   

using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
using System.Collections;
using System.Text;
public partial class _Default : System.Web.UI.Page
{
    string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
   
   
    protected void btnUpdate_Click(object sender, EventArgs e)
    {
       
       
        StringBuilder strSql = new StringBuilder(string.Empty);

        SqlConnection con = new SqlConnection(connStr);
        SqlCommand cmd = new SqlCommand();

        for (int i = 0; i < GridView1.Rows.Count; i++)
        {
            CheckBox chkUpdate = (CheckBox)
               GridView1.Rows[i].Cells[0].FindControl("chkSelect");
            if (chkUpdate != null)
            {
                if (chkUpdate.Checked)
                {
                  
                    string strID = GridView1.Rows[i].Cells[1].Text;
                    string strName = ((TextBox)
                        GridView1.Rows[i].FindControl("txtname")).Text;

                    string straddress = ((TextBox)
                        GridView1.Rows[i].FindControl("txtaddress")).Text;

                    string strmarks = ((TextBox)
                        GridView1.Rows[i].FindControl("txtmarks")).Text;

                    string strUpdate =
                        "Update Details set name = '" + strName + "',address = '" + straddress + "',marks = '" + strmarks + "' WHERE ID ='" + strID + "'";
                   
                    strSql.Append(strUpdate);
                }
            }
        }
        try
        {
            cmd.CommandType = CommandType.Text;
            cmd.CommandText = strSql.ToString();
            cmd.Connection = con;
            con.Open();
            cmd.ExecuteNonQuery();
        }
        catch (SqlException ex)
        {
            string errorMsg = "Error in Updation";
            errorMsg += ex.Message;
            throw new Exception(errorMsg);
        }
        finally
        {
            con.Close();
        }
        UncheckAll();
    }
    private void UncheckAll()
    {
        foreach (GridViewRow row in GridView1.Rows)
        {
            CheckBox chkUncheck = (CheckBox)
                         row.FindControl("chkSelect");
            TextBox txtname = (TextBox)
                           row.FindControl("txtname");
            TextBox txtaddress = (TextBox)
                       row.FindControl("txtaddress");

            TextBox txtmarks = (TextBox)
                       row.FindControl("txtmarks");

            chkUncheck.Checked = false;


            txtname.ReadOnly = true;
            txtaddress.ReadOnly = true;
            txtname.ForeColor = System.Drawing.Color.Blue;
            txtaddress.ForeColor = System.Drawing.Color.Blue;
            txtmarks.ForeColor = System.Drawing.Color.Blue;
        }
    }
    protected void chkSelect_CheckedChanged
                            (object sender, EventArgs e)
    {
        CheckBox chkTest = (CheckBox)sender;
        GridViewRow grdRow = (GridViewRow)chkTest.NamingContainer;
        TextBox txtname = (TextBox)grdRow.FindControl
                                            ("txtname");
        TextBox txtladdress = (TextBox)grdRow.FindControl
                                          ("txtaddress");

        TextBox txtlmarks = (TextBox)grdRow.FindControl
                                          ("txtmarks");
        if (chkTest.Checked)
        {
            txtname.ReadOnly = false;
            txtladdress.ReadOnly = false;
            txtlmarks.ReadOnly = false;
            txtname.ForeColor = System.Drawing.Color.Black;
            txtladdress.ForeColor = System.Drawing.Color.Black;
            txtlmarks.ForeColor = System.Drawing.Color.Black;
        }
        else
        {
            txtname.ReadOnly = true;
            txtladdress.ReadOnly = true;
            txtlmarks.ReadOnly = true;
            txtname.ForeColor = System.Drawing.Color.Blue;
            txtladdress.ForeColor = System.Drawing.Color.Blue;
            txtlmarks.ForeColor = System.Drawing.Color.Blue;
        }
    }
  
  

}


Thanks
If this post helps you mark it as answer

Hi
     You can try this code..

DataTable dtData;
private void Form1_Load(object sender, EventArgs e)
{
dtData = new DataTable();
dtData.Columns.Add("Name");
dtData.Columns.Add("Address");
dtData.Columns.Add("Mark");
}

private void button9_Click(object sender, EventArgs e)
{

if (dtData.Rows.Count > 0)
{
dtData.Rows.Clear();
dataGridView2.DataSource = null;
}
DataRow dr = dtData.NewRow();
dr[0] = "Datta";
dr[1] = "Mumbai";
dr[2] = textBox4.Text;
dtData.Rows.Add(dr);
dr = dtData.NewRow();
dr[0] = "DK";
dr[1] = "Pune";
dr[2] = textBox5.Text;
dtData.Rows.Add(dr);
dr = dtData.NewRow();
dr[0] = "Kharad";
dr[1] = "Hyderbad";
dr[2] = textBox6.Text;
dtData.Rows.Add(dr);
dataGridView2.DataSource = dtData;

}

try this