2 DATA GRID Questions

[pmud]

Hi,

I need to display columns in a data grid based on 7 different queries. Now I
have 32 questions:

1. Is it possble to have 1 single data adapter with 7 queries & 1 data set
or do I need to have a separate data adapter & a separate data set for each
select query?
If thats possible then how?

2. I have the following code which allows the user to enter an order number
& click the view button which should show all information for that
order...But the data gris is not showing the infomation, it is showing the
only the column headings... I am using only 1 data grid for all the
queries... Everytime a different view link (related to a different criteria)
is clicked , I change the DataSource , DataKeyField & DataMember for the grid
which points to a separate data set.

Code ::

private void LinkButton1_Cli ck(object sender, System.EventArg s e)
{
sqlDataAdapter1 .Fill(dsAllAO1) ;
DataGrid1.DataB ind();
}
private void lnkByOrder_Clic k(object sender, System.EventArg s e)
{
sqlSelectComman d2.Parameters["@o"].Value=txtOrder .Text;

// Different data set
sqlDataAdapter2 .Fill(dsByOrder 1); DataGrid1.DataS ource=
dsByOrder1;
DataGrid1.DataM ember="INVOICES ";
DataGrid1.DataK eyField= "ORDER_NO";
DataGrid1.AutoG enerateColumns= true;
DataGrid1.DataB ind();
}

private void lnkByName_Click (object sender, System.EventArg s e)
{
sqlSelectComman d2.Parameters["@n"].Value=txtName. Text;

// Different data set
sqlDataAdapter2 .Fill(dsByName1 ); DataGrid1.DataS ource=
dsByName1;
DataGrid1.DataM ember="INVOICES ";
DataGrid1.DataK eyField= "ORDER_NO";
DataGrid1.AutoG enerateColumns= true;
DataGrid1.DataB ind();
}

Is smthg wrong with this code? Will the data grid not work if I bound it to
a different data set on different link button clicks?

Thanks

--
pmud

[D.W. Warlock]

pmud wrote:

Hi,

I need to display columns in a data grid based on 7 different queries. Now I
have 32 questions:

1. Is it possble to have 1 single data adapter with 7 queries & 1 data set
or do I need to have a separate data adapter & a separate data set for each
select query?
If thats possible then how?
Yes, you can have 1 single adapter with 7 different queries and 1 data
set. It all depends on how your stored procedure is written. If there
are 7 select statements or unions or whatever, you will get back 7
tables in one stored procedure call that you can then populate into a
data set using the data adapter.

2. I have the following code which allows the user to enter an order number
& click the view button which should show all information for that
order...But the data gris is not showing the infomation, it is showing the
only the column headings... I am using only 1 data grid for all the
queries... Everytime a different view link (related to a different criteria)
is clicked , I change the DataSource , DataKeyField & DataMember for the grid
which points to a separate data set.

Code ::

private void LinkButton1_Cli ck(object sender, System.EventArg s e)
{
sqlDataAdapter1 .Fill(dsAllAO1) ;
DataGrid1.DataB ind();
}
private void lnkByOrder_Clic k(object sender, System.EventArg s e)
{
sqlSelectComman d2.Parameters["@o"].Value=txtOrder .Text;

// Different data set
sqlDataAdapter2 .Fill(dsByOrder 1); DataGrid1.DataS ource=
dsByOrder1;
DataGrid1.DataM ember="INVOICES ";
DataGrid1.DataK eyField= "ORDER_NO";
DataGrid1.AutoG enerateColumns= true;
DataGrid1.DataB ind();
}

private void lnkByName_Click (object sender, System.EventArg s e)
{
sqlSelectComman d2.Parameters["@n"].Value=txtName. Text;

// Different data set
sqlDataAdapter2 .Fill(dsByName1 ); DataGrid1.DataS ource=
dsByName1;
DataGrid1.DataM ember="INVOICES ";
DataGrid1.DataK eyField= "ORDER_NO";
DataGrid1.AutoG enerateColumns= true;
DataGrid1.DataB ind();
}

Is smthg wrong with this code? Will the data grid not work if I bound it to
a different data set on different link button clicks?
Your code above should run fine, but here is something a little leaner
and easier to debug:

<code>
private void BindData(string sqlQuery, string paramName, object paramValue)
{
DataTable queryTable = new DataTable();
SqlDataAdapter sda = new SqlDataAdapter( sqlQuery, connection);
sda.SelectComma nd.CommandType = CommandType.Sto redProcedure;
if(paramName != null && paramValue != null)
{
sda.SelectComma nd.Paramaters.A dd(paramName, paramValue);
}
sda.Fill(queryT able);
DataGrid1.DataS ource = queryTable;
DataGrid1.DataK eyField = "ORDER_NO";
DataGrid1.AutoG enerateColumns= true;
DataGrid1.DataB ind();
}
</code>

Then, elsewhere in your code, all you would have to do to populate your
datagrid is to just call

private void lnkByName_Click (object sender, System.EventArg s e)
{
// sqlSelectComman d2.Parameters["@n"].Value=txtName. Text;
// // Different data set
// sqlDataAdapter2 .Fill(dsByName1 );
// DataGrid1.DataS ource= dsByName1;
// DataGrid1.DataM ember="INVOICES ";
// DataGrid1.DataK eyField= "ORDER_NO";
// DataGrid1.AutoG enerateColumns= true;
// DataGrid1.DataB ind();

//Replace above with:
BindData("<stor ed proc name>", "@n", txtName.Text);
}

Thanks

hth,
~d

[pmud]

Hi D.W. Warlock

I have never written stored procedures. but just now I did a tutorial on
them. So I should write a stored procedure with 7 select statements . Then I
use this stored procedure with only one data adapter & 1 data set. & when
the user clicks the view button , the data grid will show the result? Is that
right?

"D.W. Warlock" wrote:

pmud wrote:

Hi,

I need to display columns in a data grid based on 7 different queries. Now I
have 32 questions:

1. Is it possble to have 1 single data adapter with 7 queries & 1 data set
or do I need to have a separate data adapter & a separate data set for each
select query?
If thats possible then how?

Yes, you can have 1 single adapter with 7 different queries and 1 data
set. It all depends on how your stored procedure is written. If there
are 7 select statements or unions or whatever, you will get back 7
tables in one stored procedure call that you can then populate into a
data set using the data adapter.

2. I have the following code which allows the user to enter an order number
& click the view button which should show all information for that
order...But the data gris is not showing the infomation, it is showing the
only the column headings... I am using only 1 data grid for all the
queries... Everytime a different view link (related to a different criteria)
is clicked , I change the DataSource , DataKeyField & DataMember for the grid
which points to a separate data set.

Code ::

private void LinkButton1_Cli ck(object sender, System.EventArg s e)
{
sqlDataAdapter1 .Fill(dsAllAO1) ;
DataGrid1.DataB ind();
}
private void lnkByOrder_Clic k(object sender, System.EventArg s e)
{
sqlSelectComman d2.Parameters["@o"].Value=txtOrder .Text;

// Different data set
sqlDataAdapter2 .Fill(dsByOrder 1); DataGrid1.DataS ource=
dsByOrder1;
DataGrid1.DataM ember="INVOICES ";
DataGrid1.DataK eyField= "ORDER_NO";
DataGrid1.AutoG enerateColumns= true;
DataGrid1.DataB ind();
}

private void lnkByName_Click (object sender, System.EventArg s e)
{
sqlSelectComman d2.Parameters["@n"].Value=txtName. Text;

// Different data set
sqlDataAdapter2 .Fill(dsByName1 ); DataGrid1.DataS ource=
dsByName1;
DataGrid1.DataM ember="INVOICES ";
DataGrid1.DataK eyField= "ORDER_NO";
DataGrid1.AutoG enerateColumns= true;
DataGrid1.DataB ind();
}

Is smthg wrong with this code? Will the data grid not work if I bound it to
a different data set on different link button clicks?

Your code above should run fine, but here is something a little leaner
and easier to debug:

<code>
private void BindData(string sqlQuery, string paramName, object paramValue)
{
DataTable queryTable = new DataTable();
SqlDataAdapter sda = new SqlDataAdapter( sqlQuery, connection);
sda.SelectComma nd.CommandType = CommandType.Sto redProcedure;
if(paramName != null && paramValue != null)
{
sda.SelectComma nd.Paramaters.A dd(paramName, paramValue);
}
sda.Fill(queryT able);
DataGrid1.DataS ource = queryTable;
DataGrid1.DataK eyField = "ORDER_NO";
DataGrid1.AutoG enerateColumns= true;
DataGrid1.DataB ind();
}
</code>

Then, elsewhere in your code, all you would have to do to populate your
datagrid is to just call

private void lnkByName_Click (object sender, System.EventArg s e)
{
// sqlSelectComman d2.Parameters["@n"].Value=txtName. Text;
// // Different data set
// sqlDataAdapter2 .Fill(dsByName1 );
// DataGrid1.DataS ource= dsByName1;
// DataGrid1.DataM ember="INVOICES ";
// DataGrid1.DataK eyField= "ORDER_NO";
// DataGrid1.AutoG enerateColumns= true;
// DataGrid1.DataB ind();

//Replace above with:
BindData("<stor ed proc name>", "@n", txtName.Text);
}

Thanks

hth,
~d

[pmud]

Hi D.W. Warlock,

I created a stored procedure which works fine when i run it from the server
explorer.

Stored Procedure Code::
CREATE PROCEDURE dbo.usp_Order (@OrderNo int) AS
select * from IRUS_INVOICES where ORDER_NO = @OrderNo
GO

& then I used the followng code...
private void BindData(string sqlQuery, string paramName, object paramValue)
{
DataTable queryTable = new DataTable();
SqlDataAdapter sda = new SqlDataAdapter( sqlQuery, sqlConnection1) ;
sda.SelectComma nd.CommandType = CommandType.Sto redProcedure;
if(paramName != null && paramValue != null)
{
//sda.SelectComma nd.Paramaters.A dd(paramName, paramValue);
sda.SelectComma nd.Parameters.A dd(paramName, paramValue);
}
sda.Fill(queryT able);
DataGrid1.DataS ource = queryTable;
DataGrid1.DataK eyField = "ORDER_NO";
DataGrid1.AutoG enerateColumns= true;
DataGrid1.DataB ind();
}

private void lnkByOrder_Clic k(object sender, System.EventArg s e)
{
BindData("dbo.u sp_Order", "@OrderNo",
int.Parse(txtOr der.Text));

}

But when I click the view link , the data grid doesnt show up the records
.... What is wrong with the code?

"D.W. Warlock" wrote:

pmud wrote:

Hi,

I need to display columns in a data grid based on 7 different queries. Now I
have 32 questions:

1. Is it possble to have 1 single data adapter with 7 queries & 1 data set
or do I need to have a separate data adapter & a separate data set for each
select query?
If thats possible then how?

Yes, you can have 1 single adapter with 7 different queries and 1 data
set. It all depends on how your stored procedure is written. If there
are 7 select statements or unions or whatever, you will get back 7
tables in one stored procedure call that you can then populate into a
data set using the data adapter.

2. I have the following code which allows the user to enter an order number
& click the view button which should show all information for that
order...But the data gris is not showing the infomation, it is showing the
only the column headings... I am using only 1 data grid for all the
queries... Everytime a different view link (related to a different criteria)
is clicked , I change the DataSource , DataKeyField & DataMember for the grid
which points to a separate data set.

Code ::

private void LinkButton1_Cli ck(object sender, System.EventArg s e)
{
sqlDataAdapter1 .Fill(dsAllAO1) ;
DataGrid1.DataB ind();
}
private void lnkByOrder_Clic k(object sender, System.EventArg s e)
{
sqlSelectComman d2.Parameters["@o"].Value=txtOrder .Text;

// Different data set
sqlDataAdapter2 .Fill(dsByOrder 1); DataGrid1.DataS ource=
dsByOrder1;
DataGrid1.DataM ember="INVOICES ";
DataGrid1.DataK eyField= "ORDER_NO";
DataGrid1.AutoG enerateColumns= true;
DataGrid1.DataB ind();
}

private void lnkByName_Click (object sender, System.EventArg s e)
{
sqlSelectComman d2.Parameters["@n"].Value=txtName. Text;

// Different data set
sqlDataAdapter2 .Fill(dsByName1 ); DataGrid1.DataS ource=
dsByName1;
DataGrid1.DataM ember="INVOICES ";
DataGrid1.DataK eyField= "ORDER_NO";
DataGrid1.AutoG enerateColumns= true;
DataGrid1.DataB ind();
}

Is smthg wrong with this code? Will the data grid not work if I bound it to
a different data set on different link button clicks?

Your code above should run fine, but here is something a little leaner
and easier to debug:

<code>
private void BindData(string sqlQuery, string paramName, object paramValue)
{
DataTable queryTable = new DataTable();
SqlDataAdapter sda = new SqlDataAdapter( sqlQuery, connection);
sda.SelectComma nd.CommandType = CommandType.Sto redProcedure;
if(paramName != null && paramValue != null)
{
sda.SelectComma nd.Paramaters.A dd(paramName, paramValue);
}
sda.Fill(queryT able);
DataGrid1.DataS ource = queryTable;
DataGrid1.DataK eyField = "ORDER_NO";
DataGrid1.AutoG enerateColumns= true;
DataGrid1.DataB ind();
}
</code>

Then, elsewhere in your code, all you would have to do to populate your
datagrid is to just call

private void lnkByName_Click (object sender, System.EventArg s e)
{
// sqlSelectComman d2.Parameters["@n"].Value=txtName. Text;
// // Different data set
// sqlDataAdapter2 .Fill(dsByName1 );
// DataGrid1.DataS ource= dsByName1;
// DataGrid1.DataM ember="INVOICES ";
// DataGrid1.DataK eyField= "ORDER_NO";
// DataGrid1.AutoG enerateColumns= true;
// DataGrid1.DataB ind();

//Replace above with:
BindData("<stor ed proc name>", "@n", txtName.Text);
}

Thanks

hth,
~d

[D0tN3t C0d3r]

Hi pmud,

Sorry about the delay in getting back to you, I was out sick.

Anyhow, when you call "BindData("dob. usp_Order", "@OrderNo",
int.Parse(txtOr der.Text));" drop the dbo. in the stored procedure name.
For some reason that I have yet to find out, SqlServer/MSDE has issues
when using owner.spname conventions.

HTH,
~d

pmud wrote:

Hi D.W. Warlock,

I created a stored procedure which works fine when i run it from the server
explorer.

Stored Procedure Code::
CREATE PROCEDURE dbo.usp_Order (@OrderNo int) AS
select * from IRUS_INVOICES where ORDER_NO = @OrderNo
GO

& then I used the followng code...
private void BindData(string sqlQuery, string paramName, object paramValue)
{
DataTable queryTable = new DataTable();
SqlDataAdapter sda = new SqlDataAdapter( sqlQuery, sqlConnection1) ;
sda.SelectComma nd.CommandType = CommandType.Sto redProcedure;
if(paramName != null && paramValue != null)
{
//sda.SelectComma nd.Paramaters.A dd(paramName, paramValue);
sda.SelectComma nd.Parameters.A dd(paramName, paramValue);
}
sda.Fill(queryT able);
DataGrid1.DataS ource = queryTable;
DataGrid1.DataK eyField = "ORDER_NO";
DataGrid1.AutoG enerateColumns= true;
DataGrid1.DataB ind();
}

private void lnkByOrder_Clic k(object sender, System.EventArg s e)
{
BindData("dbo.u sp_Order", "@OrderNo",
int.Parse(txtOr der.Text));

}

But when I click the view link , the data grid doesnt show up the records
... What is wrong with the code?

"D.W. Warlock" wrote:

pmud wrote:

Hi,

I need to display columns in a data grid based on 7 different queries. Now I
have 32 questions:

1. Is it possble to have 1 single data adapter with 7 queries & 1 data set
or do I need to have a separate data adapter & a separate data set for each
select query?
If thats possible then how?

Yes, you can have 1 single adapter with 7 different queries and 1 data
set. It all depends on how your stored procedure is written. If there
are 7 select statements or unions or whatever, you will get back 7
tables in one stored procedure call that you can then populate into a
data set using the data adapter.

2. I have the following code which allows the user to enter an order number
& click the view button which should show all information for that
order...Bu t the data gris is not showing the infomation, it is showing the
only the column headings... I am using only 1 data grid for all the
queries... Everytime a different view link (related to a different criteria)
is clicked , I change the DataSource , DataKeyField & DataMember for the grid
which points to a separate data set.

Code ::

private void LinkButton1_Cli ck(object sender, System.EventArg s e)
{
sqlDataAdapter1 .Fill(dsAllAO1) ;
DataGrid1.DataB ind();
}
private void lnkByOrder_Clic k(object sender, System.EventArg s e)
{
sqlSelectComman d2.Parameters["@o"].Value=txtOrder .Text;

// Different data set
sqlDataAdapter2 .Fill(dsByOrder 1); DataGrid1.DataS ource=
dsByOrder1 ;
DataGrid1.DataM ember="INVOICES ";
DataGrid1.DataK eyField= "ORDER_NO";
DataGrid1.AutoG enerateColumns= true;
DataGrid1.DataB ind();
}

private void lnkByName_Click (object sender, System.EventArg s e)
{
sqlSelectComman d2.Parameters["@n"].Value=txtName. Text;

// Different data set
sqlDataAdapter2 .Fill(dsByName1 ); DataGrid1.DataS ource=
dsByName1;
DataGrid1.DataM ember="INVOICES ";
DataGrid1.DataK eyField= "ORDER_NO";
DataGrid1.AutoG enerateColumns= true;
DataGrid1.DataB ind();
}

Is smthg wrong with this code? Will the data grid not work if I bound it to
a different data set on different link button clicks?

Your code above should run fine, but here is something a little leaner
and easier to debug:

<code>
private void BindData(string sqlQuery, string paramName, object paramValue)
{
DataTable queryTable = new DataTable();
SqlDataAdapter sda = new SqlDataAdapter( sqlQuery, connection);
sda.SelectComma nd.CommandType = CommandType.Sto redProcedure;
if(paramName != null && paramValue != null)
{
sda.SelectComma nd.Paramaters.A dd(paramName, paramValue);
}
sda.Fill(queryT able);
DataGrid1.DataS ource = queryTable;
DataGrid1.DataK eyField = "ORDER_NO";
DataGrid1.AutoG enerateColumns= true;
DataGrid1.DataB ind();
}
</code>

Then, elsewhere in your code, all you would have to do to populate your
datagrid is to just call

private void lnkByName_Click (object sender, System.EventArg s e)
{
// sqlSelectComman d2.Parameters["@n"].Value=txtName. Text;
// // Different data set
// sqlDataAdapter2 .Fill(dsByName1 );
// DataGrid1.DataS ource= dsByName1;
// DataGrid1.DataM ember="INVOICES ";
// DataGrid1.DataK eyField= "ORDER_NO";
// DataGrid1.AutoG enerateColumns= true;
// DataGrid1.DataB ind();

//Replace above with:
BindData("<stor ed proc name>", "@n", txtName.Text);
}

Thanks

hth,
~d

[pmud]

Hi ,

I hope you are well now.Thanks for the answer ... Is there a way to sort the
data grid using the following code...coz here i have not used a data set but
a data table for binding to the data grid...I searched many articles but all
were for binding to the dat set using a data vierw only & more over I am
BINDING THE GRID on DIFFERENT LINK BUTTON CLICKS to ONE DATA TABLE WHICH
CONTAINS DIFFERENT VALUES BASED ON DIFFERENT STORED PROCEDURES....

MY code :

private void Page_Load(objec t sender, System.EventArg s e)
{
// Put user code to initialize the page here
}

private void BindData(string sqlQuery, string paramName, object paramValue)
{
DataTable queryTable = new DataTable();
SqlDataAdapter sda = new SqlDataAdapter( sqlQuery, sqlConnection1) ;
sda.SelectComma nd.CommandType = CommandType.Sto redProcedure;
if(paramName != null && paramValue != null)
{

sda.SelectComma nd.Parameters.A dd(paramName, paramValue);
}
sda.Fill(queryT able);
DataGrid1.DataS ource = queryTable;
DataGrid1.DataK eyField = "ORDER_NO";
DataGrid1.AutoG enerateColumns= true;
DataGrid1.DataB ind();
}
private void BindData(string sqlQuery, string paramName, object
paramValue,stri ng paramName1, object paramValue1)
{
DataTable queryTable = new DataTable();
SqlDataAdapter sda = new SqlDataAdapter( sqlQuery, sqlConnection1) ;
sda.SelectComma nd.CommandType = CommandType.Sto redProcedure;
if(paramName != null && paramValue != null && paramName1 != null &&
paramValue1 != null)
{

sda.SelectComma nd.Parameters.A dd(paramName, paramValue);
sda.SelectComma nd.Parameters.A dd(paramName1,p aramValue1);
}
sda.Fill(queryT able);
DataGrid1.DataS ource = queryTable;
DataGrid1.DataK eyField = "ORDER_NO";
DataGrid1.AutoG enerateColumns= true;
DataGrid1.DataB ind();
}

private void LinkButton1_Cli ck(object sender, System.EventArg s e)
{
BindData("dbo.u sp_MasterBrowse r_ViewAll",null ,null);
}

private void DataGrid1_SortC ommand(object source,
System.Web.UI.W ebControls.Data GridSortCommand EventArgs e)
{

}

private void lnkByOrder_Clic k(object sender, System.EventArg s e)
{
BindData("dbo.u sp_Order", "@OrderNo", int.Parse(txtOr der.Text));

}

private void lnkByDate_Click (object sender, System.EventArg s e)
{
BindData("dbo.u sp_MasterBrowse r_Date","@Start Date",
System.DateTime .Parse(txtStart Date.Text),"@En dDate",System.D ateTime.Parse(t xtEndDate.Text) );
}

private void lnkByStatus_Cli ck(object sender, System.EventArg s e)
{
BindData("dbo.u sp_MasterBrowse r_Status","@Sta tus",ddlStatus. SelectedValue);
}
How can sorting be done in this grid? Is it even possible?

"D0tN3t C0d3r" wrote:

Hi pmud,

Sorry about the delay in getting back to you, I was out sick.

Anyhow, when you call "BindData("dob. usp_Order", "@OrderNo",
int.Parse(txtOr der.Text));" drop the dbo. in the stored procedure name.
For some reason that I have yet to find out, SqlServer/MSDE has issues
when using owner.spname conventions.

HTH,
~d

pmud wrote:

Hi D.W. Warlock,

I created a stored procedure which works fine when i run it from the server
explorer.

Stored Procedure Code::
CREATE PROCEDURE dbo.usp_Order (@OrderNo int) AS
select * from IRUS_INVOICES where ORDER_NO = @OrderNo
GO

& then I used the followng code...
private void BindData(string sqlQuery, string paramName, object paramValue)
{
DataTable queryTable = new DataTable();
SqlDataAdapter sda = new SqlDataAdapter( sqlQuery, sqlConnection1) ;
sda.SelectComma nd.CommandType = CommandType.Sto redProcedure;
if(paramName != null && paramValue != null)
{
//sda.SelectComma nd.Paramaters.A dd(paramName, paramValue);
sda.SelectComma nd.Parameters.A dd(paramName, paramValue);
}
sda.Fill(queryT able);
DataGrid1.DataS ource = queryTable;
DataGrid1.DataK eyField = "ORDER_NO";
DataGrid1.AutoG enerateColumns= true;
DataGrid1.DataB ind();
}

private void lnkByOrder_Clic k(object sender, System.EventArg s e)
{
BindData("dbo.u sp_Order", "@OrderNo",
int.Parse(txtOr der.Text));

}

But when I click the view link , the data grid doesnt show up the records
... What is wrong with the code?

"D.W. Warlock" wrote:

pmud wrote:

Hi,

I need to display columns in a data grid based on 7 different queries. Now I
have 32 questions:

1. Is it possble to have 1 single data adapter with 7 queries & 1 data set
or do I need to have a separate data adapter & a separate data set for each
select query?
If thats possible then how?

Yes, you can have 1 single adapter with 7 different queries and 1 data
set. It all depends on how your stored procedure is written. If there
are 7 select statements or unions or whatever, you will get back 7
tables in one stored procedure call that you can then populate into a
data set using the data adapter.
2. I have the following code which allows the user to enter an order number
& click the view button which should show all information for that
order...Bu t the data gris is not showing the infomation, it is showing the
only the column headings... I am using only 1 data grid for all the
queries... Everytime a different view link (related to a different criteria)
is clicked , I change the DataSource , DataKeyField & DataMember for the grid
which points to a separate data set.

Code ::

private void LinkButton1_Cli ck(object sender, System.EventArg s e)
{
sqlDataAdapter1 .Fill(dsAllAO1) ;
DataGrid1.DataB ind();
}
private void lnkByOrder_Clic k(object sender, System.EventArg s e)
{
sqlSelectComman d2.Parameters["@o"].Value=txtOrder .Text;

// Different data set
sqlDataAdapter2 .Fill(dsByOrder 1); DataGrid1.DataS ource=
dsByOrder1 ;
DataGrid1.DataM ember="INVOICES ";
DataGrid1.DataK eyField= "ORDER_NO";
DataGrid1.AutoG enerateColumns= true;
DataGrid1.DataB ind();
}

private void lnkByName_Click (object sender, System.EventArg s e)
{
sqlSelectComman d2.Parameters["@n"].Value=txtName. Text;

// Different data set
sqlDataAdapter2 .Fill(dsByName1 ); DataGrid1.DataS ource=
dsByName1;
DataGrid1.DataM ember="INVOICES ";
DataGrid1.DataK eyField= "ORDER_NO";
DataGrid1.AutoG enerateColumns= true;
DataGrid1.DataB ind();
}

Is smthg wrong with this code? Will the data grid not work if I bound it to
a different data set on different link button clicks?

Your code above should run fine, but here is something a little leaner
and easier to debug:

<code>
private void BindData(string sqlQuery, string paramName, object paramValue)
{
DataTable queryTable = new DataTable();
SqlDataAdapter sda = new SqlDataAdapter( sqlQuery, connection);
sda.SelectComma nd.CommandType = CommandType.Sto redProcedure;
if(paramName != null && paramValue != null)
{
sda.SelectComma nd.Paramaters.A dd(paramName, paramValue);
}
sda.Fill(queryT able);
DataGrid1.DataS ource = queryTable;
DataGrid1.DataK eyField = "ORDER_NO";
DataGrid1.AutoG enerateColumns= true;
DataGrid1.DataB ind();
}
</code>

Then, elsewhere in your code, all you would have to do to populate your
datagrid is to just call

private void lnkByName_Click (object sender, System.EventArg s e)
{
// sqlSelectComman d2.Parameters["@n"].Value=txtName. Text;
// // Different data set
// sqlDataAdapter2 .Fill(dsByName1 );
// DataGrid1.DataS ource= dsByName1;
// DataGrid1.DataM ember="INVOICES ";
// DataGrid1.DataK eyField= "ORDER_NO";
// DataGrid1.AutoG enerateColumns= true;
// DataGrid1.DataB ind();

//Replace above with:
BindData("<stor ed proc name>", "@n", txtName.Text);
}
Thanks
hth,
~d