Search the grid row data....

GridView Insert update delete search


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





   


   

   

            DataKeyNames="VendorId"
        AllowPaging="True"
        CellPadding="3"
        OnPageIndexChanging="ResultGridView_PageIndexChanging"
        OnRowDeleting="ResultGridView_RowDeleting"
        OnRowEditing="ResultGridView_RowEditing"
            OnRowUpdating="ResultGridView_RowUpdating"
            OnRowCancelingEdit="ResultGridView_RowCancelingEdit" PageSize="5"
            BackColor="#DEBA84" BorderColor="#DEBA84" BorderStyle="None" BorderWidth="1px"
            CellSpacing="2" OnRowCommand="ResultGridView_RowCommand" AllowSorting="true"
            onsorting="ResultGridView_Sorting">
           
                                    ReadOnly="True" SortExpression="VendorId" />
               
                   
                       
                   
                   
                   
                   
                   
                       
                   
               
               
                   
                       
                   
                   
                   
                   
                   
                       
                   
               
               
                   
                       
                   
                   
                   
                   
                   
                       
                   
               
               
                   
                       
                   
                   
                   
                   
                   
                       
                   
               
               
                   
                       
                   
                   
                   
                   
                   
                       
                   
               
               
                   
                       
                   
                   
                   
                   
                   
                       
                   
               
               
               
               
               
               
               
                 
                 
               
               
                 
               
               
                 
               
               
               
               

           
           
           
           
           
           
       



       
   
   
   
            onclick="btn_search_Click" />
   

   
   

   






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;
public partial class _Default : System.Web.UI.Page
{
    string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
    //SqlConnection conn = new SqlConnection(connStr);
    SqlDataAdapter ad = new SqlDataAdapter();
    SqlCommand cmd = new SqlCommand();
    DataTable dataTable;
    SqlDataAdapter sqlda;
    DataSet ds;
    string str;
    protected void Page_Load(object sender, EventArgs e)
    {
        Session["sortBy"] = null;
        if (!IsPostBack)
        {
            FillVendorGrid();
        }
    }
    private void FillVendorGrid()
    {
        SqlConnection conn = new SqlConnection(connStr);
        dataTable = new DataTable();
        cmd.Connection = conn;
        cmd.CommandText = "SELECT * FROM Vendor";
        ad = new SqlDataAdapter(cmd);
        ad.Fill(dataTable);
        ResultGridView.DataSource = dataTable;
        ResultGridView.DataBind();
       
    }

    protected void ResultGridView_RowEditing(object sender, GridViewEditEventArgs e)
    {
        ResultGridView.EditIndex = e.NewEditIndex;
        FillVendorGrid();
    }


    protected void ResultGridView_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        ResultGridView.PageIndex = e.NewPageIndex;
        FillVendorGrid();
    }

    protected void ResultGridView_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        SqlConnection conn = new SqlConnection(connStr);
        cmd.Connection = conn;
        cmd.CommandText = "DELETE FROM Vendor WHERE VendorId='" + ResultGridView.DataKeys[e.RowIndex].Values[0].ToString() + "'";
        conn.Open();
        cmd.ExecuteNonQuery();
        conn.Close();
        FillVendorGrid();

    }

    protected void ResultGridView_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        TextBox txtFName = (TextBox)ResultGridView.Rows[e.RowIndex].FindControl("txtFName");
        TextBox txtLName = (TextBox)ResultGridView.Rows[e.RowIndex].FindControl("txtLName");
        TextBox txtCity = (TextBox)ResultGridView.Rows[e.RowIndex].FindControl("txtCity");
        TextBox txtState = (TextBox)ResultGridView.Rows[e.RowIndex].FindControl("txtState");
        TextBox txtCountry = (TextBox)ResultGridView.Rows[e.RowIndex].FindControl("txtCountry");
        TextBox txtDescription = (TextBox)ResultGridView.Rows[e.RowIndex].FindControl("txtDescription");

        SqlConnection conn = new SqlConnection(connStr);
        cmd.Connection = conn;
        cmd.CommandText = "UPDATE Vendor SET VendorFName ='" + txtFName.Text + "',VendorLName ='" + txtLName.Text + "',VendorCity ='" + txtCity.Text + "',VendorState ='" + txtState.Text + "',VendorCountry ='" + txtCountry.Text + "',VendorDescription ='" + txtDescription.Text + "'   WHERE VendorId='" + ResultGridView.DataKeys[e.RowIndex].Values[0].ToString() + "'";
        conn.Open();
        cmd.ExecuteNonQuery();
        ResultGridView.EditIndex = -1;
        FillVendorGrid();
        conn.Close();

    }

    protected void ResultGridView_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        ResultGridView.EditIndex = -1;
        FillVendorGrid();

    }

    protected void ResultGridView_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        if (e.CommandName.Equals("AddNew"))
        {

            TextBox txtFName = (TextBox)ResultGridView.FooterRow.FindControl("txtFName1");
            TextBox txtLName = (TextBox)ResultGridView.FooterRow.FindControl("txtLName1");
            TextBox txtCity = (TextBox)ResultGridView.FooterRow.FindControl("txtCity1");
            TextBox txtState = (TextBox)ResultGridView.FooterRow.FindControl("txtState1");
            TextBox txtCountry = (TextBox)ResultGridView.FooterRow.FindControl("txtCountry1");
            TextBox txtDescription = (TextBox)ResultGridView.FooterRow.FindControl("txtDescription1");
            SqlConnection conn = new SqlConnection(connStr);
            cmd.Connection = conn;
            cmd.CommandText = "INSERT INTO Vendor(VendorFName, VendorLName,VendorCity,VendorState,VendorCountry,VendorDescription) Values('" + txtFName.Text + "', '" + txtLName.Text + "', '" + txtCity.Text + "', '" + txtState.Text + "', '" + txtCountry.Text + "' , '" + txtDescription.Text + "')";
            conn.Open();
            cmd.ExecuteNonQuery();
            FillVendorGrid();
            conn.Close();
        }
    }
    protected void btn_search_Click(object sender, EventArgs e)
    {
        SqlConnection conn = new SqlConnection(connStr);
        conn.Open();
        str = "select * from Vendor where VendorFName like '" + TextBox1.Text + "%'";
        cmd = new SqlCommand(str, conn);
        sqlda = new SqlDataAdapter(cmd);
        ds = new DataSet();
        sqlda.Fill(ds, "Vendor");
        conn.Close();
      
        ResultGridView.DataSource = ds;
        ResultGridView.DataMember = "Vendor";
        ResultGridView.DataBind();

    }
    protected void ResultGridView_Sorting(object sender, GridViewSortEventArgs e)
    {
        Session["sortBy"] = e.SortExpression;
        FillVendorGrid();
    }
}

Sorry I Cant Remove datasourceID from Designing/aspx Page because i already have explained in asked query (can see above) thati have used the database property/sqldatasource1 to display the edit delete & select property in grid and this is running well also.

But only the problem is in i want some search button here with text boxes (see design page/attachment). while i coded on image button event initially it was throwing sqldatasource defination duplicacy, i tried every thing whis are instructed by you but its not working every time throwing some new error.

Please help me (any body here)

Sarch code on image button event:(According to you)

as error describe remove datasourceID from page. and make sure that your query is running successfully.

Hover on dataset after

da.Fill(ds);

and check dataset filled or not..

Sir,
I did every possible thing as instructed by you and as per last code i again reached on initial stage where from i started still m getting the datasource binding duplicacy.

According to you the final code are:

protected void ImageButton1_Click(object sender, ImageClickEventArgs e)

    {

        con.Open();

        SqlDataAdapter da = new SqlDataAdapter("Select h_id as 'Hoarding ID', Address,Size as 'Hoarding Size', State, District, Cost as 'Hoarding Cost', Pincode,From_date as 'Available From', To_date as 'Available To', hoarding_type as 'Hoarding Type', Lightboxes_type as 'Light Boxes', hoarding_image as 'Image Path' from providers_post where h_id = '"+ TextBox1.Text+"'  ",con);

        DataSet ds = new DataSet();

        da.Fill(ds);

        GridView1.DataSource = ds.Tables[0];

        GridView1.DataBind();

    

        con.Close();

 

    }

I also removed the table as well as deleted the loop for table row data count

still its throwing the previous error:

Both DataSource and DataSourceID are defined on 'GridView1'.  Remove one definition.

remove id

GridView1.DataSource =ds.tables[0];
           GridView1.DataBind();

nd when i m putting this code without table 

Hello Mr. Gujrathi,
Good Morning!!

Sir, I already tried that code instructed by you, but it's throwing the following error

 Cannot implicitly convert type 'System.Data.DataTable' to 'string'

and m new in this field so i m unable to identify whats the problem actually.
Can you help me deeply i attached the file here

.cs Code:

Also for this task you no need to take any sqldatasource in aspx page

why you need data table

just do

           GridView1.DataSourceID = ds.Tables[0];
           GridView1.DataBind();

actually i was facing the grid binding duplicacy earlier after that i putted the following code one by one you can see in above code but the commented codes are not running and that uncommented code is not throwing any errors but it did not give aspected result also

Please read once again in above what i want exactly: means i want when we put any searching keywords in text boxes then it should display in grid. I all ready coded on image button event please check

//GridView1.DataSource = null;
            //GridView1.DataSource = dt;
            ////GridView1.DataBind();


            GridView1.DataSourceID = "SqlDataSource1";
           GridView1.DataBind();




            //GridView1.DataSourceID = "SqlDataSource1";
            ////GridView1.DataBind();

What problem you are facing>


Give us exact error.