asp.net C# - populate a gridview using an existing stored procedure...
using a StoreProce with three input parameter: spPercentageForm (@Metric_ID INT = NULL,@YYYY NVARCHAR(4) = NULL,@RegionID INT = NULL). How to populate gridview ID="gvLefttForm" ?
FYI: I have:
SqlDataSource: LeftGV but the parameters are entered as constant Metric_ID = 101, YYYY = "2014", RegionID = 1 during SqlDataSource: LeftGV construction.
From Page_Load event I want to call: PopulateGV(102, "2013", 2, "LeftGV");
Question: How can I modify the sample code below to populate ID="gvLefttForm"?
Thank you.
FYI: I have:
SqlDataSource: LeftGV but the parameters are entered as constant Metric_ID = 101, YYYY = "2014", RegionID = 1 during SqlDataSource: LeftGV construction.
From Page_Load event I want to call: PopulateGV(102, "2013", 2, "LeftGV");
Question: How can I modify the sample code below to populate ID="gvLefttForm"?
Thank you.
static void PopulateGV(int Metric_ID, string yyyy, int RegionID, string gvName)
{
using (SqlConnection connection = new SqlConnection("myConnection"))
{
// Create the command and set its properties.
SqlCommand command = new SqlCommand();
command.Connection = connection;
command.CommandText = "updateGridview";
command.CommandType = CommandType.StoredProcedure;
// Add the input parameter and set its properties.
SqlParameter parameter = new SqlParameter();
parameter.ParameterName = "@Metric_ID"; // <--------- ????????????????????
parameter.ParameterName = "@YYYY"; // <--------- ????????????????????
parameter.ParameterName = "@RegionID"; // <--------- ????????????????????
parameter.SqlDbType = SqlDbType.NVarChar;
parameter.Direction = ParameterDirection.Input;
parameter.Value = Metric_ID; // <--------- ????????????????????
command.Parameters.Add(parameter);
parameter.Value = yyyy; // <--------- ????????????????????
command.Parameters.Add(parameter);
parameter.Value = RegionID; // <--------- ????????????????????
command.Parameters.Add(parameter);
// Open the connection and execute the reader.
connection.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
//How to bind it to gridview called gvName ="gvLefttForm?"
}
}
else
{
// igonor this option for now
}
reader.Close();
}
}ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Okay, the message is clear:
"Both DataSource and DataSourceID are defined on 'gwLeftForm'. Remove one definition."
Since we are programmatically assigning a data source to the gridview, we should not provide DataSourceId in the design. From below code, remove DataSourceID="LeftGW":
"Both DataSource and DataSourceID are defined on 'gwLeftForm'. Remove one definition."
Since we are programmatically assigning a data source to the gridview, we should not provide DataSourceId in the design. From below code, remove DataSourceID="LeftGW":
<asp:GridView ID="gwLeftFormID" runat="server" AutoGenerateColumns="False" BackColor="White"
BorderColor="#DEDFDE" BorderStyle="None" BorderWidth="1px" CellPadding="4" DataKeyNames="MedCtrID"
DataSourceID="LeftGW" Font-Names="Arial" Font-Size="Small" ForeColor="Black"
GridLines="Vertical" Width="412px">
Also note that you are using AutoGenerateColumns="False
Here is a good article with source code that demonstrates N-Tier architecture:
http://www.codeproject.com/Articles/439688/Creating-ASP-NET-application-with-n-tier-architect
There are many more to know about separating out the layers, but this is a good start.
http://www.codeproject.com/Articles/439688/Creating-ASP-NET-application-with-n-tier-architect
There are many more to know about separating out the layers, but this is a good start.
ASKER
Thank you very much.
ASKER
Thank you very much for the solution and good suggestions.
re:> You should separate your data access layer from web layer
I am sort of beginner, I definately will take your advise on this and learn more about this. If you can think of good link on this subject please share it with me.
re:> you can directly access gvLefttForm directly.
Yes, this gridview is on the same page where I am putting this code. FYI, in the aspx page I have:
<asp:GridView ID="gWLeftForm" runat="server" AutoGenerateColumns="False
As you can see, I actualy have gWLeftForm not gvLefttForm. I wanted to improve the syntax before I post the question. The reason for mentioning this may be related to my followup question below.
I am getting an error on the second line at DataBind().
gWLeftForm.DataSource = PopulateGV(102, "2013", 2);
gWLeftForm.DataBind();
Question: How can I correct this.
Error details:
Open in new window
In an attempt to correct this error, I changed ID="gWLeftForm" to ID="gWLeftFormID" to avoid naming conflict. But the error didn't go away.Here is my latest aspx code for the gridview:
(FYI, it is possible that I may have used this name to create a data source not in use now but its trace is somewhere in the application)
Open in new window