I need help with datagrid

[student]

Hi all, I'm having trouble with my datagrid, it is suppose to display a row
from a table called "Calls" based on what is selected in the dropdownlist
which displays the first and last name from another table called "Contacts".
The problem is only the dropdownlist is showing in the browser and nothing
from the datagrid shows.
Could someone please point out my error, I am new at this, and would
appreciate some help.
thanks,
student
Here's the code:
Imports System.Data.Sql Client
Imports System.Data
Public Class WebForm1
Inherits System.Web.UI.P age
Protected WithEvents SqlSelectComman d1 As
System.Data.Sql Client.SqlComma nd
Protected WithEvents SqlInsertComman d1 As
System.Data.Sql Client.SqlComma nd
Protected WithEvents SqlUpdateComman d1 As
System.Data.Sql Client.SqlComma nd
Protected WithEvents SqlDeleteComman d1 As
System.Data.Sql Client.SqlComma nd
Protected WithEvents SqlSelectComman d2 As
System.Data.Sql Client.SqlComma nd
Protected WithEvents SqlInsertComman d2 As
System.Data.Sql Client.SqlComma nd
Protected WithEvents SqlUpdateComman d2 As
System.Data.Sql Client.SqlComma nd
Protected WithEvents SqlDeleteComman d2 As
System.Data.Sql Client.SqlComma nd
Protected WithEvents ContactMgmt As System.Data.Sql Client.SqlConne ction
Protected WithEvents adptCalls As System.Data.Sql Client.SqlDataA dapter
Protected WithEvents adptContacts As
System.Data.Sql Client.SqlDataA dapter
Protected WithEvents dsCalls As figure5_22.Data Set1
Protected WithEvents dsContacts As figure5_22.Data Set2
Protected WithEvents grdCalls As System.Web.UI.W ebControls.Data Grid
Protected WithEvents drpContacts As
System.Web.UI.W ebControls.Drop DownList

#Region " Web Form Designer Generated Code "

'This call is required by the Web Form Designer.
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
System.EventArg s) Handles MyBase.Load
'Put user code to initialize the page here
'Run the first time the page is displayed.
If Not IsPostBack Then
'fill the contacts data set.
adptContacts.Fi ll(dsContacts)
'for each row in the table...
Dim drowItem As DataSet2.Contac tsRow
For Each drowItem In dsContacts.Cont acts
'create a new list item
Dim lstnew As New ListItem()
lstnew.Text = drowItem.FirstN ame & " " & drowItem.LastNa me
lstnew.Value = drowItem.Contac tID
'add the list item to the drop-down list.
drpContacts.Ite ms.Add(lstnew)
Next
End If
End Sub

Private Sub drpContacts_Sel ectedIndexChang ed(ByVal sender As
System.Object, ByVal e As System.EventArg s) Handles
drpContacts.Sel ectedIndexChang ed

'When a contact is selected, display the contact's calls
adptCalls.Selec tCommand.Comman dText = "SELECT * FROM Calls" & _
"WHERE ContactID =" & drpContacts.Sel ectedItem.Value
'Clear the data set.
dsCalls.Clear()
adptCalls.Fill( dsCalls)
'Display the results in a data grid.
grdCalls.DataBi nd()
End Sub
End Class

[John Saunders]

"student" <mr********@yah oo.com> wrote in message
news:ht******** *********@newss vr17.news.prodi gy.com...

Hi all, I'm having trouble with my datagrid, it is suppose to display a
row
from a table called "Calls" based on what is selected in the dropdownlist
which displays the first and last name from another table called
"Contacts".
The problem is only the dropdownlist is showing in the browser and nothing
from the datagrid shows.
Could someone please point out my error, I am new at this, and would
appreciate some help.

Are you sure that the DataSource and DataMember are set in the datagrid? Are
you sure that the Fill is returning rows?

John Saunders

[Saravana]

In the page_load you are not binding datagrid itself. so it wont come in the
browser. If you want to bring the datagrid in the browser when page loads,
bind it with datasource filtered using default value of dropdownlist
selection.

--
Saravana
http://dotnetjunkies.com/WebLog/saravana/
www.ExtremeExperts.com
"student" <mr********@yah oo.com> wrote in message
news:ht******** *********@newss vr17.news.prodi gy.com...

Hi all, I'm having trouble with my datagrid, it is suppose to display a row from a table called "Calls" based on what is selected in the dropdownlist
which displays the first and last name from another table called "Contacts". The problem is only the dropdownlist is showing in the browser and nothing
from the datagrid shows.
Could someone please point out my error, I am new at this, and would
appreciate some help.
thanks,
student
Here's the code:
Imports System.Data.Sql Client
Imports System.Data
Public Class WebForm1
Inherits System.Web.UI.P age
Protected WithEvents SqlSelectComman d1 As
System.Data.Sql Client.SqlComma nd
Protected WithEvents SqlInsertComman d1 As
System.Data.Sql Client.SqlComma nd
Protected WithEvents SqlUpdateComman d1 As
System.Data.Sql Client.SqlComma nd
Protected WithEvents SqlDeleteComman d1 As
System.Data.Sql Client.SqlComma nd
Protected WithEvents SqlSelectComman d2 As
System.Data.Sql Client.SqlComma nd
Protected WithEvents SqlInsertComman d2 As
System.Data.Sql Client.SqlComma nd
Protected WithEvents SqlUpdateComman d2 As
System.Data.Sql Client.SqlComma nd
Protected WithEvents SqlDeleteComman d2 As
System.Data.Sql Client.SqlComma nd
Protected WithEvents ContactMgmt As System.Data.Sql Client.SqlConne ction Protected WithEvents adptCalls As System.Data.Sql Client.SqlDataA dapter
Protected WithEvents adptContacts As
System.Data.Sql Client.SqlDataA dapter
Protected WithEvents dsCalls As figure5_22.Data Set1
Protected WithEvents dsContacts As figure5_22.Data Set2
Protected WithEvents grdCalls As System.Web.UI.W ebControls.Data Grid
Protected WithEvents drpContacts As
System.Web.UI.W ebControls.Drop DownList

#Region " Web Form Designer Generated Code "

'This call is required by the Web Form Designer.
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
System.EventArg s) Handles MyBase.Load
'Put user code to initialize the page here
'Run the first time the page is displayed.
If Not IsPostBack Then
'fill the contacts data set.
adptContacts.Fi ll(dsContacts)
'for each row in the table...
Dim drowItem As DataSet2.Contac tsRow
For Each drowItem In dsContacts.Cont acts
'create a new list item
Dim lstnew As New ListItem()
lstnew.Text = drowItem.FirstN ame & " " & drowItem.LastNa me
lstnew.Value = drowItem.Contac tID
'add the list item to the drop-down list.
drpContacts.Ite ms.Add(lstnew)
Next
End If
End Sub

Private Sub drpContacts_Sel ectedIndexChang ed(ByVal sender As
System.Object, ByVal e As System.EventArg s) Handles
drpContacts.Sel ectedIndexChang ed

'When a contact is selected, display the contact's calls
adptCalls.Selec tCommand.Comman dText = "SELECT * FROM Calls" & _
"WHERE ContactID =" & drpContacts.Sel ectedItem.Value
'Clear the data set.
dsCalls.Clear()
adptCalls.Fill( dsCalls)
'Display the results in a data grid.
grdCalls.DataBi nd()
End Sub
End Class