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_Click(object sender, System.EventArgs e)
{
sqlDataAdapter1.Fill(dsAllAO1);
DataGrid1.DataBind();
}
private void lnkByOrder_Click(object sender, System.EventArgs e)
{
sqlSelectCommand2.Parameters["@o"].Value=txtOrder.Text;
// Different data set
sqlDataAdapter2.Fill(dsByOrder1); DataGrid1.DataSource=
dsByOrder1;
DataGrid1.DataMember="INVOICES";
DataGrid1.DataKeyField= "ORDER_NO";
DataGrid1.AutoGenerateColumns=true;
DataGrid1.DataBind();
}
private void lnkByName_Click(object sender, System.EventArgs e)
{
sqlSelectCommand2.Parameters["@n"].Value=txtName.Text;
// Different data set
sqlDataAdapter2.Fill(dsByName1); DataGrid1.DataSource=
dsByName1;
DataGrid1.DataMember="INVOICES";
DataGrid1.DataKeyField= "ORDER_NO";
DataGrid1.AutoGenerateColumns=true;
DataGrid1.DataBind();
}
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 5 2459
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_Click(object sender, System.EventArgs e) { sqlDataAdapter1.Fill(dsAllAO1); DataGrid1.DataBind(); }
private void lnkByOrder_Click(object sender, System.EventArgs e) { sqlSelectCommand2.Parameters["@o"].Value=txtOrder.Text;
// Different data set sqlDataAdapter2.Fill(dsByOrder1); DataGrid1.DataSource= dsByOrder1; DataGrid1.DataMember="INVOICES"; DataGrid1.DataKeyField= "ORDER_NO"; DataGrid1.AutoGenerateColumns=true; DataGrid1.DataBind(); }
private void lnkByName_Click(object sender, System.EventArgs e) { sqlSelectCommand2.Parameters["@n"].Value=txtName.Text;
// Different data set sqlDataAdapter2.Fill(dsByName1); DataGrid1.DataSource= dsByName1; DataGrid1.DataMember="INVOICES"; DataGrid1.DataKeyField= "ORDER_NO"; DataGrid1.AutoGenerateColumns=true; DataGrid1.DataBind(); }
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.SelectCommand.CommandType = CommandType.StoredProcedure;
if(paramName != null && paramValue != null)
{
sda.SelectCommand.Paramaters.Add(paramName, paramValue);
}
sda.Fill(queryTable);
DataGrid1.DataSource = queryTable;
DataGrid1.DataKeyField = "ORDER_NO";
DataGrid1.AutoGenerateColumns=true;
DataGrid1.DataBind();
}
</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.EventArgs e)
{
// sqlSelectCommand2.Parameters["@n"].Value=txtName.Text;
// // Different data set
// sqlDataAdapter2.Fill(dsByName1);
// DataGrid1.DataSource= dsByName1;
// DataGrid1.DataMember="INVOICES";
// DataGrid1.DataKeyField= "ORDER_NO";
// DataGrid1.AutoGenerateColumns=true;
// DataGrid1.DataBind();
//Replace above with:
BindData("<stored proc name>", "@n", txtName.Text);
} Thanks
hth,
~d
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_Click(object sender, System.EventArgs e) { sqlDataAdapter1.Fill(dsAllAO1); DataGrid1.DataBind(); }
private void lnkByOrder_Click(object sender, System.EventArgs e) { sqlSelectCommand2.Parameters["@o"].Value=txtOrder.Text;
// Different data set sqlDataAdapter2.Fill(dsByOrder1); DataGrid1.DataSource= dsByOrder1; DataGrid1.DataMember="INVOICES"; DataGrid1.DataKeyField= "ORDER_NO"; DataGrid1.AutoGenerateColumns=true; DataGrid1.DataBind(); }
private void lnkByName_Click(object sender, System.EventArgs e) { sqlSelectCommand2.Parameters["@n"].Value=txtName.Text;
// Different data set sqlDataAdapter2.Fill(dsByName1); DataGrid1.DataSource= dsByName1; DataGrid1.DataMember="INVOICES"; DataGrid1.DataKeyField= "ORDER_NO"; DataGrid1.AutoGenerateColumns=true; DataGrid1.DataBind(); }
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.SelectCommand.CommandType = CommandType.StoredProcedure; if(paramName != null && paramValue != null) { sda.SelectCommand.Paramaters.Add(paramName, paramValue); } sda.Fill(queryTable); DataGrid1.DataSource = queryTable; DataGrid1.DataKeyField = "ORDER_NO"; DataGrid1.AutoGenerateColumns=true; DataGrid1.DataBind(); } </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.EventArgs e) { // sqlSelectCommand2.Parameters["@n"].Value=txtName.Text; // // Different data set // sqlDataAdapter2.Fill(dsByName1); // DataGrid1.DataSource= dsByName1; // DataGrid1.DataMember="INVOICES"; // DataGrid1.DataKeyField= "ORDER_NO"; // DataGrid1.AutoGenerateColumns=true; // DataGrid1.DataBind();
//Replace above with: BindData("<stored proc name>", "@n", txtName.Text); }
Thanks
hth, ~d
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.SelectCommand.CommandType = CommandType.StoredProcedure;
if(paramName != null && paramValue != null)
{
//sda.SelectCommand.Paramaters.Add(paramName, paramValue);
sda.SelectCommand.Parameters.Add(paramName, paramValue);
}
sda.Fill(queryTable);
DataGrid1.DataSource = queryTable;
DataGrid1.DataKeyField = "ORDER_NO";
DataGrid1.AutoGenerateColumns=true;
DataGrid1.DataBind();
}
private void lnkByOrder_Click(object sender, System.EventArgs e)
{
BindData("dbo.usp_Order", "@OrderNo",
int.Parse(txtOrder.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_Click(object sender, System.EventArgs e) { sqlDataAdapter1.Fill(dsAllAO1); DataGrid1.DataBind(); }
private void lnkByOrder_Click(object sender, System.EventArgs e) { sqlSelectCommand2.Parameters["@o"].Value=txtOrder.Text;
// Different data set sqlDataAdapter2.Fill(dsByOrder1); DataGrid1.DataSource= dsByOrder1; DataGrid1.DataMember="INVOICES"; DataGrid1.DataKeyField= "ORDER_NO"; DataGrid1.AutoGenerateColumns=true; DataGrid1.DataBind(); }
private void lnkByName_Click(object sender, System.EventArgs e) { sqlSelectCommand2.Parameters["@n"].Value=txtName.Text;
// Different data set sqlDataAdapter2.Fill(dsByName1); DataGrid1.DataSource= dsByName1; DataGrid1.DataMember="INVOICES"; DataGrid1.DataKeyField= "ORDER_NO"; DataGrid1.AutoGenerateColumns=true; DataGrid1.DataBind(); }
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.SelectCommand.CommandType = CommandType.StoredProcedure; if(paramName != null && paramValue != null) { sda.SelectCommand.Paramaters.Add(paramName, paramValue); } sda.Fill(queryTable); DataGrid1.DataSource = queryTable; DataGrid1.DataKeyField = "ORDER_NO"; DataGrid1.AutoGenerateColumns=true; DataGrid1.DataBind(); } </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.EventArgs e) { // sqlSelectCommand2.Parameters["@n"].Value=txtName.Text; // // Different data set // sqlDataAdapter2.Fill(dsByName1); // DataGrid1.DataSource= dsByName1; // DataGrid1.DataMember="INVOICES"; // DataGrid1.DataKeyField= "ORDER_NO"; // DataGrid1.AutoGenerateColumns=true; // DataGrid1.DataBind();
//Replace above with: BindData("<stored proc name>", "@n", txtName.Text); }
Thanks
hth, ~d
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(txtOrder.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.SelectCommand.CommandType = CommandType.StoredProcedure; if(paramName != null && paramValue != null) { //sda.SelectCommand.Paramaters.Add(paramName, paramValue); sda.SelectCommand.Parameters.Add(paramName, paramValue); } sda.Fill(queryTable); DataGrid1.DataSource = queryTable; DataGrid1.DataKeyField = "ORDER_NO"; DataGrid1.AutoGenerateColumns=true; DataGrid1.DataBind(); }
private void lnkByOrder_Click(object sender, System.EventArgs e) { BindData("dbo.usp_Order", "@OrderNo", int.Parse(txtOrder.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_Click(object sender, System.EventArgs e) { sqlDataAdapter1.Fill(dsAllAO1); DataGrid1.DataBind(); }
private void lnkByOrder_Click(object sender, System.EventArgs e) { sqlSelectCommand2.Parameters["@o"].Value=txtOrder.Text;
// Different data set sqlDataAdapter2.Fill(dsByOrder1); DataGrid1.DataSource= dsByOrder1; DataGrid1.DataMember="INVOICES"; DataGrid1.DataKeyField= "ORDER_NO"; DataGrid1.AutoGenerateColumns=true; DataGrid1.DataBind(); }
private void lnkByName_Click(object sender, System.EventArgs e) { sqlSelectCommand2.Parameters["@n"].Value=txtName.Text;
// Different data set sqlDataAdapter2.Fill(dsByName1); DataGrid1.DataSource= dsByName1; DataGrid1.DataMember="INVOICES"; DataGrid1.DataKeyField= "ORDER_NO"; DataGrid1.AutoGenerateColumns=true; DataGrid1.DataBind(); }
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.SelectCommand.CommandType = CommandType.StoredProcedure; if(paramName != null && paramValue != null) { sda.SelectCommand.Paramaters.Add(paramName, paramValue); } sda.Fill(queryTable); DataGrid1.DataSource = queryTable; DataGrid1.DataKeyField = "ORDER_NO"; DataGrid1.AutoGenerateColumns=true; DataGrid1.DataBind(); } </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.EventArgs e) { // sqlSelectCommand2.Parameters["@n"].Value=txtName.Text; // // Different data set // sqlDataAdapter2.Fill(dsByName1); // DataGrid1.DataSource= dsByName1; // DataGrid1.DataMember="INVOICES"; // DataGrid1.DataKeyField= "ORDER_NO"; // DataGrid1.AutoGenerateColumns=true; // DataGrid1.DataBind();
//Replace above with: BindData("<stored proc name>", "@n", txtName.Text); }
Thanks
hth, ~d
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(object sender, System.EventArgs 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.SelectCommand.CommandType = CommandType.StoredProcedure;
if(paramName != null && paramValue != null)
{
sda.SelectCommand.Parameters.Add(paramName, paramValue);
}
sda.Fill(queryTable);
DataGrid1.DataSource = queryTable;
DataGrid1.DataKeyField = "ORDER_NO";
DataGrid1.AutoGenerateColumns=true;
DataGrid1.DataBind();
}
private void BindData(string sqlQuery, string paramName, object
paramValue,string paramName1, object paramValue1)
{
DataTable queryTable = new DataTable();
SqlDataAdapter sda = new SqlDataAdapter(sqlQuery, sqlConnection1);
sda.SelectCommand.CommandType = CommandType.StoredProcedure;
if(paramName != null && paramValue != null && paramName1 != null &&
paramValue1 != null)
{
sda.SelectCommand.Parameters.Add(paramName, paramValue);
sda.SelectCommand.Parameters.Add(paramName1,paramV alue1);
}
sda.Fill(queryTable);
DataGrid1.DataSource = queryTable;
DataGrid1.DataKeyField = "ORDER_NO";
DataGrid1.AutoGenerateColumns=true;
DataGrid1.DataBind();
}
private void LinkButton1_Click(object sender, System.EventArgs e)
{
BindData("dbo.usp_MasterBrowser_ViewAll",null,null );
}
private void DataGrid1_SortCommand(object source,
System.Web.UI.WebControls.DataGridSortCommandEvent Args e)
{
}
private void lnkByOrder_Click(object sender, System.EventArgs e)
{
BindData("dbo.usp_Order", "@OrderNo", int.Parse(txtOrder.Text));
}
private void lnkByDate_Click(object sender, System.EventArgs e)
{
BindData("dbo.usp_MasterBrowser_Date","@StartDate" ,
System.DateTime.Parse(txtStartDate.Text),"@EndDate ",System.DateTime.Parse(txtEndDate.Text));
}
private void lnkByStatus_Click(object sender, System.EventArgs e)
{
BindData("dbo.usp_MasterBrowser_Status","@Status", 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(txtOrder.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.SelectCommand.CommandType = CommandType.StoredProcedure; if(paramName != null && paramValue != null) { //sda.SelectCommand.Paramaters.Add(paramName, paramValue); sda.SelectCommand.Parameters.Add(paramName, paramValue); } sda.Fill(queryTable); DataGrid1.DataSource = queryTable; DataGrid1.DataKeyField = "ORDER_NO"; DataGrid1.AutoGenerateColumns=true; DataGrid1.DataBind(); }
private void lnkByOrder_Click(object sender, System.EventArgs e) { BindData("dbo.usp_Order", "@OrderNo", int.Parse(txtOrder.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_Click(object sender, System.EventArgs e) { sqlDataAdapter1.Fill(dsAllAO1); DataGrid1.DataBind(); }
private void lnkByOrder_Click(object sender, System.EventArgs e) { sqlSelectCommand2.Parameters["@o"].Value=txtOrder.Text;
// Different data set sqlDataAdapter2.Fill(dsByOrder1); DataGrid1.DataSource= dsByOrder1; DataGrid1.DataMember="INVOICES"; DataGrid1.DataKeyField= "ORDER_NO"; DataGrid1.AutoGenerateColumns=true; DataGrid1.DataBind(); }
private void lnkByName_Click(object sender, System.EventArgs e) { sqlSelectCommand2.Parameters["@n"].Value=txtName.Text;
// Different data set sqlDataAdapter2.Fill(dsByName1); DataGrid1.DataSource= dsByName1; DataGrid1.DataMember="INVOICES"; DataGrid1.DataKeyField= "ORDER_NO"; DataGrid1.AutoGenerateColumns=true; DataGrid1.DataBind(); }
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.SelectCommand.CommandType = CommandType.StoredProcedure; if(paramName != null && paramValue != null) { sda.SelectCommand.Paramaters.Add(paramName, paramValue); } sda.Fill(queryTable); DataGrid1.DataSource = queryTable; DataGrid1.DataKeyField = "ORDER_NO"; DataGrid1.AutoGenerateColumns=true; DataGrid1.DataBind(); } </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.EventArgs e) { // sqlSelectCommand2.Parameters["@n"].Value=txtName.Text; // // Different data set // sqlDataAdapter2.Fill(dsByName1); // DataGrid1.DataSource= dsByName1; // DataGrid1.DataMember="INVOICES"; // DataGrid1.DataKeyField= "ORDER_NO"; // DataGrid1.AutoGenerateColumns=true; // DataGrid1.DataBind();
//Replace above with: BindData("<stored proc name>", "@n", txtName.Text); }
Thanks
hth, ~d This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Jordan O'Hare |
last post by:
Hello Everyone,
I am after some help with the following:
I have a windows application that contains a list box and
two data grids. All three controls are binded to a dataset
that contains...
|
by: Eagle |
last post by:
I have a form that has one record with 22 fields. A grid is not the answer,
either several small tables or combinations of textboxes and labels, so the
user can edit all the editable fields then...
|
by: Jim |
last post by:
I have a datagrid on a windows form that is filled using a data adapter and
dataset created in code. I have mapped columns to the various fields. The
user enters new infromation into the grid and...
|
by: pmud |
last post by:
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...
|
by: Mike Wilson |
last post by:
Dear Group,
I have a heirarchical set of database tables, say - "order" and "order_type"
and want to display a series of orders in a grid control, and in place of
the order_type foreign key...
|
by: Scottie_do |
last post by:
I have a 20meg in-memory stack-based array and I'd like to normalise in the
client's memory... then add foriegn keys, and display results on a datagrid.
I discovered that converting the stack to a...
|
by: Kent Boogaart |
last post by:
Hi,
I have some hierarchical data (FAQs) that I would like to bind to. The basic
structure is:
FAQ Category
+ Categories
+ FAQs
So an FAQ category has any number of sub-categories and any...
|
by: Brian P. Hammer |
last post by:
I have data from multiple SQL tables, some of the tables will only have one
row, while others multiple rows. I load a bunch of data from the various
tables and add them to a third party grid. With...
|
by: =?Utf-8?B?bXIgcGVhbnV0?= |
last post by:
How do I turn on the visual grid in the web (asp) design environment. I know
this is stupid but it's counterintuitive to me.
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM).
In this month's session, the creator of the excellent VBE...
|
by: DolphinDB |
last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation.
Take...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: Aftab Ahmad |
last post by:
Hello Experts!
I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
|
by: Aftab Ahmad |
last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below.
Dim IE As Object
Set IE =...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
| |