Prizes & Awards
My Profile
Active Members
TodayLast 7 Days
more...
|
 New Feature: Community Sites:
Create your own .NET community website and start earning from Google AdSense !
It's Free !
|
Query Problem
Posted Date:
29 Aug 2008
Total Responses:
2
|
Posted By: Chandra Sheker.G Member Level: Gold Points: 1
|
Iam passing the parametrs is like this but i am not geeting any values in gridview pls correct me
Dim cmd As SqlCommand = New SqlCommand("Summary", con)
cmd.CommandType = CommandType.StoredProcedure
cmd.Parameters.Add("@empid", SqlDbType.VarChar, 10)
cmd.Parameters("@empid").Value = IIf(empid = "", DBNull.Value, empid)
cmd.Parameters.Add("@audit_by", SqlDbType.VarChar, 30)
cmd.Parameters("@audit_by").Value = IIf(Auitid = "", DBNull.Value, Auitid)
cmd.Parameters.Add("@depid", SqlDbType.VarChar, 10)
cmd.Parameters("@depid").Value = IIf(depid = "", DBNull.Value, depid)
cmd.Parameters.Add("@type", SqlDbType.Char, 1)
cmd.Parameters("@distribution_type").Value = "p"
cmd.Parameters.Add("@accountid", SqlDbType.VarChar, 25)
cmd.Parameters("@account").Value = IIf(accid = "", DBNull.Value, accid)
cmd.Parameters.Add("@FromDate", SqlDbType.DateTime)
cmd.Parameters("@FromDate").Value = txtFdate.Text
cmd.Parameters.Add("@ToDate", SqlDbType.DateTime)
cmd.Parameters("@ToDate").Value = txtTdate.Text
Dim dr As SqlDataReader = cmd.ExecuteReader
GridView1.DataSource = dr
GridView1.DataBind()
con.Close()
|
Responses
|
| Author: ANIL PANDEY 29 Aug 2008 | Member Level: Diamond | Rating:  Points: 6 | hi,
u can use the DATAREADER like this to bind the values in the Grid view...
protected void filllGrid()
{
int lintCounter = 0;
//Adding the Column
dt.Columns.Add("LT");
dt.Columns.Add("TQ");
dt.Columns.Add("LA");
dt.Columns.Add("LB");
for (lintCounter = 0; lintCounter < 7; lintCounter++)
{
if (lintCounter == 0)
{
addRow("CL");
}
else if (lintCounter == 1)
{
addRow("SL");
}
else if (lintCounter == 2)
{
addRow("PL");
}
else if (lintCounter == 3)
{
addRow("CO");
}
else if (lintCounter == 4)
{
addRow("PT");
}
else if (lintCounter == 5)
{
addRow("MT");
}
else
{
addRow("LWP");
}
}
grdLeaves.DataSource = dt;
grdLeaves.DataBind();
}
Thanks
Anil
| | Author: D.Jeya kumar(JK) 29 Aug 2008 | Member Level: Diamond | Rating: Points: 6 | Hi,
Is it throwing any exception.?
check the Datatype of the parameters it is varchar for some values which might be integer.
cmd.Parameters.Add("@empid", SqlDbType.VarChar, 10)
cmd.Parameters("@empid").Value = IIf(empid = "", DBNull.Value, empid)
cmd.Parameters.Add("@audit_by", SqlDbType.VarChar, 30)
cmd.Parameters("@audit_by").Value = IIf(Auitid = "", DBNull.Value, Auitid)
cmd.Parameters.Add("@depid", SqlDbType.VarChar, 10)
cmd.Parameters("@depid").Value = IIf(depid = "", DBNull.Value, depid)
cmd.Parameters.Add("@accountid", SqlDbType.VarChar, 25)
cmd.Parameters("@account").Value = IIf(accid = "", DBNull.Value, accid)
Check this values Datatype how is it defined in Database?
Regards
JK
|
| Post Reply |
|
|
|
You must Sign In to post a response.
|
|
|
|