Binding GridView with code-behind

[sck10]

Hello,

I have a GridView that is using the following to connect to a SQL Server
2000 stored procedure:

<asp:SqlDataSou rce
ID="dsWebDocLis t" SelectCommand=" sp_web_WebDocum ent"
ConnectionStrin g="<%$ ConnectionStrin gs:cnnSQL_Conne ct %>" Runat="server">
<SelectParamete rs>
<asp:Paramete r Type="String" DefaultValue="F indWebDocAll"
Name="strParm01 "></asp:Parameter>
<asp:Paramete r Type="String" DefaultValue="I nterlock"
Name="strParm02 "></asp:Parameter>
<asp:Paramete r Type="String" DefaultValue="1-1-2000"
Name="strParm03 "></asp:Parameter>
<asp:Paramete r Type="String" DefaultValue="N oParameter"
Name="strParm04 "></asp:Parameter>
<asp:Paramete r Type="String" DefaultValue="N oParameter"
Name="strParm05 "></asp:Parameter>
</SelectParameter s>
</asp:SqlDataSour ce>

But for all my other controls, I am using code-behind and using something
like the following:
'Populate the GridView combo box
'------------------------------
Dim spGridView As OleDb.OleDbData Reader
Dim prmGridView As OleDbParameter
Dim cmdGridView As New OleDb.OleDbComm and("sp_web_Web Document",
cnnSearch)
cmdGridView.Com mandType = CommandType.Sto redProcedure

'Declare Parameters
prmGridView = cmdGridView.Par ameters.Add("@s trParm01",
OleDbType.VarCh ar) : prmGridView.Val ue = "FindWebDoc All"
prmGridView = cmdGridView.Par ameters.Add("@s trParm02",
OleDbType.VarCh ar) : prmGridView.Val ue = "Interlock"
prmGridView = cmdGridView.Par ameters.Add("@s trParm03",
OleDbType.VarCh ar) : prmGridView.Val ue = "1-1-2000"
prmGridView = cmdGridView.Par ameters.Add("@s trParm04",
OleDbType.VarCh ar) : prmGridView.Val ue = "NoParamete r"
prmGridView = cmdGridView.Par ameters.Add("@s trParm05",
OleDbType.VarCh ar) : prmGridView.Val ue = "NoParamete r"

'Data Bind: DropdownList
spGridView = cmdGridView.Exe cuteReader()

The problem I am having is that I can't bind the data to the GridView. I am
using the following:

'Data Bind: DropdownList
spGridView = cmdGridView.Exe cuteReader()
gvWebDocList.Da taSourceID = spGridView
gvWebDocList.Da taBind()

Any help with this would be appreciated.

Thanks in advance, sck10

[Kevin Yu [MSFT]]

Hi sck10,

We have reviewed this issue and are currently researching on it. We will
update you ASAP. Thanks for your patience!

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

[Steven Cheng[MSFT]]

Hi Sck10,

From your description and the code snippet you provided, it seems that
you're assigning the retrieved DataReader object to the DropDownList's
datasource, yes? If so, I think we should try binding the DataReader to the
GridView directly rather than the dropdownlist, the dropdownlist is just a
helper control for selecting tables. The actual datasource should be the
GRidView's DataSource, we should bind the data we retrieved to the
GridView. You may have a try to see whether this is the cause. Also, if
you meet any further problem, you can also have a look in the .net's
Whidbey newsgroup for some more specific guides:

http://communities.microsoft.com/new...idbey&slcid=us

Thanks.

Regards,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

[sck10]

Hi Steve,

The problem I am having is trying to find the syntac for binding a GridView
using CodeBehind. I am unable to set the DataSourceID to the
OleDbDataReader . Am I setting the wrong method(?)?

Thanks, Steven
'Populate the GridView combo box
'------------------------------
Dim spGridView As OleDb.OleDbData Reader
Dim prmGridView As OleDbParameter
Dim cmdGridView As New
OleDb.OleDbComm and("sp_web_Web Document",cnnSe arch)
cmdGridView.Com mandType = CommandType.Sto redProcedure

'Declare Parameters
prmGridView = cmdGridView.Par ameters.Add("@s trParm01",OleDb Type.VarChar)
: prmGridView.Val ue = "FindWebDoc All"
prmGridView = cmdGridView.Par ameters.Add("@s trParm02",OleDb Type.VarChar)
: prmGridView.Val ue = "Interlock"
prmGridView = cmdGridView.Par ameters.Add("@s trParm03",OleDb Type.VarChar)
: prmGridView.Val ue = "1-1-2000"
prmGridView = cmdGridView.Par ameters.Add("@s trParm04",OleDb Type.VarChar)
: prmGridView.Val ue = "NoParamete r"
prmGridView = cmdGridView.Par ameters.Add("@s trParm05",OleDb Type.VarChar)
: prmGridView.Val ue = "NoParamete r"

'Data Bind: GridView
spGridView = cmdGridView.Exe cuteReader()
gvWebDocList.Da taSourceID = spGridView
gvWebDocList.Da taBind()

"Steven Cheng[MSFT]" <v-******@online.m icrosoft.com> wrote in message
news:WN******** ******@cpmsftng xa10.phx.gbl...

Hi Sck10,

From your description and the code snippet you provided, it seems that
you're assigning the retrieved DataReader object to the DropDownList's
datasource, yes? If so, I think we should try binding the DataReader to the GridView directly rather than the dropdownlist, the dropdownlist is just a
helper control for selecting tables. The actual datasource should be the
GRidView's DataSource, we should bind the data we retrieved to the
GridView. You may have a try to see whether this is the cause. Also, if
you meet any further problem, you can also have a look in the .net's
Whidbey newsgroup for some more specific guides:

http://communities.microsoft.com/new...idbey&slcid=us
Thanks.

Regards,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

[Steven Cheng[MSFT]]

Hi Sck10,

Thank for your response. From my research, the ASP.NET 2.0's GridView
Control is different from the DataGrid/DataList Controls in asp.net 1.1.
The GridView must stand upon a DataSourceContr ol , so I think if we want to
programmly bind data to GridView Control, we need to programly create a new
DAtaSourceContr ol( add into the page) first and assign the
DataSourceContr ol's ID to that GridView Control.
Thanks.

Regards,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

[lewisv]

I am having an issue that is similar.

I have a page that needs to build a complex where clause and return the
results into a gridview. After i bind the data no results are returned,
even when the sql statement (a select statement) returns data. I have
tried something similar with an objectdatasourc e also but it shows the
same thind.

Here is my code

// m_sds is a sqldatasource object, with the connection, and mode
(dataset) set declaritively
// m_gv is my gridview control
m_sds.SelectCom mand = sql;
m_sds.DataSourc eMode = SqlDataSourceMo de.DataSet;
m_gv.DataSource ID = m_sds.ID;
m_gv.DataBind() ;
refresh_page();
Steven Cheng[MSFT] wrote:

*Hi Sck10,

Thank for your response. From my research, the ASP.NET 2.0's
GridView
Control is different from the DataGrid/DataList Controls in asp.net
1.1.
The GridView must stand upon a DataSourceContr ol , so I think if we
want to
programmly bind data to GridView Control, we need to programly create
a new
DAtaSourceContr ol( add into the page) first and assign the
DataSourceContr ol's ID to that GridView Control.
Thanks.

Regards,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers
no
rights.) *

--
lewisv
------------------------------------------------------------------------
Posted via http://www.codecomments.com
------------------------------------------------------------------------