Hello all
Is there any one can help me to have 4 datagrids that gets records from same table but with different sql statements?
I have 4 datagrids in a webform right now with the conditions that i wrote above.but it seems that datagrids fill with the first dataset and i have same datagrid at least. would you please tell me why i get the same datagrids?
thank you

what is your code? it seems as if you are binding each grid to the same datasource.

i've written 2 sample of my datagrids as below:
1)
da = New SqlDataAdapter("select * from tbHGInf where Row is not null and Row<>' ' and DateDiff(d,ModifyDate,GetDate())<=7 order by HGNo Asc", con)
        ds = New DataSet
        da.Fill(ds, "tbHGInf")
        DataGrid1.DataSource = ds.Tables("tbHGInf").DefaultView
        DataGrid1.DataBind()

2)
da5 = New SqlDataAdapter("select * from tbHGInf where CustomRow is not null and CustomRow<>' ' and DateDiff(d,ModifyDate,GetDate())<=7 ", con)
        ds5 = New DataSet
        da5.Fill(ds5, "tbHGInf1")
        DataGrid6.DataSource = ds5.Tables("tbHGInf1").DefaultView
        DataGrid6.DataBind()
 *tbHgInf is my table name and Row and CustomRow are two different fileds of my table
i would be very thankfull if you help me
thank you again

it seems like it should work. Is this code in your Page_Load? Do you have it in an If NOT IsPostBack statement?

thank you for your reply
this code is in my page_Load and i didn't use if not ispostback.should i use it?i will try it.but where should i put this if clause??for binding the datagrid???
thank you for your help again.

If NOT IsPostBack Then
   ..your code above goes here...
End If

I did it as you wrote but it is like before:(where is the problem?:(

I think that u shold use
if(!IsPostBack)
{

// Your code comes in this section..
}

It depends on wether the person is using VB or C#. It looks like the code posted above is in VB.

yes the code is in vb.but i think we put if not ispostback for avoiding the same datagrids.but it does'nt shows the same datagrids.my datagrid for the same tables but with different strsqls are looking different.and i have different looking datagrids when the page loads but these different looking datagrids have same records in it and it ignored the strsqls it used the first strsql.
ofcourse i used if not ispostback as you said but it is as same as before.
where is the problem?:(