[painthu]

hi,

i am creating a custom control- a grid view..
i have been asked to create search options such that under each column's header in the grid view there will be a textbox and then when the user types int something in any of the textboxes and hits search button ,he can actually see the grid getting populated with the relevant rows.

i was successfull in doing this in a normal program..ie aspx in code behind, but u see the problem is that in the case of a custom control, the grid view can be populated using any table from sql server, i don't know what common logic can be put under search section in a custom grid view....


i mean i was successful in creating textboxes under each column in the custom control-grid view...but it's the search function that i am uanble to incorporate....any ideas....?


the custom control code:-

the code is as follows:-
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Text;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
namespace customcon
{
 
 
public class WebCustomControl6 : System.Web.UI.WebControls.GridView
{
SqlConnection con = new SqlConnection();
string s;
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
SqlCommandBuilder scb = new SqlCommandBuilder();
public GridView grid;
public DropDownList txtSearch;
public TextBox txtSearch1;
public TextBox txtSearch2;
public TextBox txtSearch3;
public TextBox txtSearch4;
public TextBox txtSearch5;
public TextBox txtSearch6;
public string f; 
 
protected override void OnRowCreated(GridViewRowEventArgs e)
{
base.OnRowCreated(e);
if (e.Row.RowType == DataControlRowType.Header)
{
Literal litHeader;
TextBox txtSearch;
 
 
//GridViewRow se=new GridViewRow(0,1,DataControlRowType.Header,
 
for(int i = 0; i <= (e.Row.Cells.Count - 1); i++)
{
for (int z = 0; z <= (e.Row.Cells.Count - 1); z++)
{
if (i == z)
{
litHeader = new Literal();
txtSearch = new TextBox();
txtSearch.ID = "txtname" + z;
txtSearch.Width = 35;
litHeader.Text = e.Row.Cells&#91;z].Text + "<br />";
e.Row.Cells&#91;z].Controls.Add(litHeader);
e.Row.Cells&#91;z].Controls.Add(txtSearch);
 
}
}
}
 
} 
}
protected override void OnDataBound(EventArgs e)
{
base.OnDataBound(e);
 
this.CreateSecondHeader();
 
}
private SqlConnection connection
{
get
{
return (SqlConnection)this.ViewState&#91;"connection"];
 
}
set
{
this.ViewState&#91;"connection"] = value;
}
 
}
private void btnclick(DataTable dt,SqlConnection connection)
{
string s = "select * from " + dt + "where" + this.Columns&#91;0].HeaderText + "like" + "'" + txtSearch.Text + "'";
da = new SqlDataAdapter(s, connection);
scb = new SqlCommandBuilder(da);
ds = new DataSet();
da.Fill(ds);
ds.Tables.Add(dt);
this.DataSource = dt;
this.DataBind();
 
}
 
 
 
private void CreateSecondHeader()
{
GridViewRow row = new GridViewRow(0,1, DataControlRowType.DataRow, DataControlRowState.Normal);
 
Button btn = new Button();
btn.Width = Unit.Pixel(60);
btn.Text = "search";
Button btn1 = new Button();
btn1.Width = Unit.Pixel(60);
btn1.Text = "cancel";
 
TableCell th = new TableCell();
th.Controls.Add(btn);
 
th.HorizontalAlign = HorizontalAlign.Center;
th.ColumnSpan = this.Columns.Count;
TableCell th1 = new TableCell();
th1.Controls.Add(btn1);
th.HorizontalAlign = HorizontalAlign.Center;
th.ColumnSpan = this.Columns.Count;
//th.Width =this.Width;
 
row.Cells.Add(th);
row.Cells.Add(th1);
 
this.InnerTable1.Rows.AddAt(0, row);
}
protected Table InnerTable1
{
get
{
if (this.HasControls())
{
return (Table)this.Controls&#91;0];
}
 
return null;
}
}
 
 
 
}
} 

the code for a normal aspx code behind:-:-

Imports System
Imports System.Data
Imports System.Data.SqlClient
Partial Class Default2
    Inherits System.Web.UI.Page
    Dim con As New SqlConnection
    Dim s As String
    Dim ds As New DataSet
    Dim da As New SqlDataAdapter
    Dim scb As New SqlCommandBuilder
    Dim dt As New DataTable
    Public WithEvents txtSearch As DropDownList
    Public WithEvents txtSearch1 As TextBox
    Public WithEvents txtSearch2 As TextBox
    Public WithEvents txtSearch3 As TextBox
    Public WithEvents txtSearch4 As TextBox
    Public WithEvents txtSearch5 As TextBox
    Public WithEvents txtSearch6 As TextBox
    Public f As String
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        con = New SqlConnection("server=DCPLDC;user id=sa;password=crorepathy;database=Testing")
        con.Open()
        s = "SELECT Id,Label,Textbox FROM textboxtable"
        da = New SqlDataAdapter(s, con)
        ds = New DataSet
        scb = New SqlCommandBuilder(da)
        da.Fill(ds)
        ds.Tables.Add(dt)
        dt = New DataTable("textboxtable")
        BulkEditGridView1_2.DataSource = ds.Tables(0)
        BulkEditGridView1_2.DataBind()
        con.Close()
    End Sub
    Sub binddata()
        s = "SELECT Id,Label,Textbox FROM textboxtable"
        da = New SqlDataAdapter(s, con)
        ds = New DataSet
        scb = New SqlCommandBuilder(da)
        da.Fill(ds)
        ds.Tables.Add(dt)
        dt = New DataTable("textboxtable")
        BulkEditGridView1_1.DataSource = ds.Tables(0)
        BulkEditGridView1_1.DataBind()
    End Sub
    Protected Sub BulkEditGridView1_1_RowCreated(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles BulkEditGridView1_1.RowCreated
        If e.Row.RowType = DataControlRowType.Header Then
            Dim litHeader As Literal
            Dim litHeader1 As Literal
            Dim txtSearch As TextBox
            ' loop through each cell
            For i As Integer = 0 To (e.Row.Cells.Count - 1)
                If i = 1 Then
                    litHeader = New Literal
                    txtSearch = New TextBox
                    'GridView1.FindControl(txtSearch), = New TextBox
                    ' Dim txt1 As TextBox = CType(GridView1.FindControl("textsearch"), TextBox)
                    With txtSearch
                        '.Text = "fdfdsfd"
                        '.MaxLength = 10
                        .Width = 35
                        '.Text = "rere"
                        .ID = "txtname1"
                    End With
                    ' get the current header text
                    litHeader.Text = e.Row.Cells(1).Text & "<br />"
                    ' add the header text plus a new textbox
                    e.Row.Cells(1).Controls.Add(litHeader)
                    e.Row.Cells(1).Controls.Add(txtSearch)
                End If
                If i = 2 Then
                    litHeader1 = New Literal
                    txtSearch1 = New TextBox
                    With txtSearch1
                        '.Text = "fdfdsfd"
                        .Width = 75
                        .ID = "txtname2"
                    End With
                    ' get the current header text
                    litHeader1.Text = e.Row.Cells(2).Text & "<br />"
                    ' add the header text plus a new textbox
                    e.Row.Cells(2).Controls.Add(litHeader1)
                    e.Row.Cells(2).Controls.Add(txtSearch1)
                End If
                If i = 3 Then
                    litHeader = New Literal
                    txtSearch2 = New TextBox
                    With txtSearch2
                        '.Text = "fdfdsfd"
                        .Width = 75
                        .ID = "txtname3"
                    End With
                    litHeader.Text = e.Row.Cells(3).Text & "<br />"
                    e.Row.Cells(3).Controls.Add(litHeader)
                    e.Row.Cells(3).Controls.Add(txtSearch2)
                End If
                If i = 4 Then
                    litHeader = New Literal
                    txtSearch3 = New TextBox
                    With txtSearch3
                        '.Text = "fdfdsfd"
                        .Width = 75
                        .ID = "txtname4"
                    End With
                    ' get the current header text
                    litHeader.Text = e.Row.Cells(4).Text & "<br />"
                    ' add the header text plus a new textbox
                    e.Row.Cells(4).Controls.Add(litHeader)
                    e.Row.Cells(4).Controls.Add(txtSearch3)
                End If
                If i = 5 Then
                    litHeader = New Literal
                    txtSearch4 = New TextBox
                    With txtSearch4
                        '.Text = "fdfdsfd"
                        .Width = 75
                        .ID = "txtname5"
                    End With
                    ' get the current header text
                    litHeader.Text = e.Row.Cells(5).Text & "<br />"
                    ' add the header text plus a new textbox
                    e.Row.Cells(5).Controls.Add(litHeader)
                    e.Row.Cells(5).Controls.Add(txtSearch4)
                End If
                If i = 6 Then
                    litHeader = New Literal
                    txtSearch5 = New TextBox
                    With txtSearch5
                        '.Text = "fdfdsfd"
                        .Width = 75
                        .ID = "txtname6"
                    End With
                    ' get the current header text
                    litHeader.Text = e.Row.Cells(6).Text & "<br />"
                    ' add the header text plus a new textbox
                    e.Row.Cells(6).Controls.Add(litHeader)
                    e.Row.Cells(6).Controls.Add(txtSearch5)
                End If
                If i = 7 Then
                    litHeader = New Literal
                    txtSearch6 = New TextBox
                    With txtSearch6
                        '.Text = "fdfdsfd"
                        .Width = 75
                        .ID = "txtname7"
                    End With
                    ' get the current header text
                    litHeader.Text = e.Row.Cells(7).Text & "<br />"
                    ' add the header text plus a new textbox
                    e.Row.Cells(7).Controls.Add(litHeader)
                    e.Row.Cells(7).Controls.Add(txtSearch6)
                End If
            Next
        End If
        'End If
    End Sub
    Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim txt1 As System.Web.UI.WebControls.TextBox = CType(BulkEditGridView1_1.HeaderRow.FindControl("txtname1"), System.Web.UI.WebControls.TextBox)
        Dim z As String = txt1.Text
        Dim txt2 As System.Web.UI.WebControls.TextBox = CType(BulkEditGridView1_1.HeaderRow.FindControl("txtname2"), System.Web.UI.WebControls.TextBox)
        Dim v As String = txt2.Text
        Dim txt3 As System.Web.UI.WebControls.TextBox = CType(BulkEditGridView1_1.HeaderRow.FindControl("txtname3"), System.Web.UI.WebControls.TextBox)
        Dim vw As String = txt3.Text
        s = "SELECT Id,Label,Textbox FROM textboxtable where Id like '" & txt1.Text.Trim() & "%' and label like '" & txt2.Text.Trim() & "%' and Textbox like '" & txt3.Text.Trim() & "%'"
        'and TaxName like '" & wt2.Text & "%' and MS01User like '" & wt3.Text & "%' and LUDatetime like '" & wt5.text & "%' and SystemGenerated like '" & wt6.Text & "%' and MS04Status like '" & wt7.Text & "%'"
        con.Open()
        da = New SqlDataAdapter(s, con)
        scb = New SqlCommandBuilder(da)
        ds = New DataSet
        da.Fill(ds)
        BulkEditGridView1_1.DataSource = ds.Tables(0).DefaultView
        BulkEditGridView1_1.DataBind()
        con.Close()
    End Sub
    Protected Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button2.Click
        con.Open()
        s = "SELECT Id,Label,Textbox FROM textboxtable"
        da = New SqlDataAdapter(s, con)
        scb = New SqlCommandBuilder(da)
        ds = New DataSet
        da.Fill(ds)
        BulkEditGridView1_1.DataSource = ds.Tables(0).DefaultView
        BulkEditGridView1_1.DataBind()
    End Sub
End Class 

i would really appreciate any help on this from ur side....
painthu