Can anybody help with some example to programatically access the GridView.  Also we should be able to manipulate the gridview data  for different search criteria, with a drop down fields, text box search box, checkbox etc.  All this should be done through stored procedures and no HTML code, no inline code, Only code behined model.  Could anyone provide a sample code in VB or C#.

Thanks

Hi!

You can use the objectDataSource or the sqldatasource as dataprovider.

Using ObjectDataSource (Bussines object as data provider)

http://www.codeproject.com/KB/aspnet/GridviewObjectDataSrc.aspx

Using SqlDataSource (Stored Procedure as data provider)

http://msdn2.microsoft.com/en-us/library/k10148y1(VS.80).aspx

 For both approach is important to pay attention to select paramenters, you will need to use Control Parameters in order to implement the search funcionality.

Hi Siby2000,

Here is a sample for filtering data from DropDownList control:

string query = "select * from table";

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            GridView1.DataSource = GetData(query);
            GridView1.DataBind();
        }
    }

    public DataSet GetData(string query)
    {
        SqlConnection conn = new SqlConnection("Connection String");
        SqlCommand cmd = new SqlCommand(query, conn);
        conn.Open();
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        da.Fill(ds);
        conn.Close();
        return ds;
    }

    protected void Filter_Click(object sender, EventArgs e)
    {
        string id = SearchTextBox.Text;
        if (id != "")
            query = "select * from table where ID=" + id;
        GridView1.DataSource = GetData(query);
        GridView1.DataBind();
    }

Other controls are similar to this, so you can try them by yourself. Remember to pass search text into query and then retrieve data to bind GridView.

Thanks,