DataReader Problem

[sweatha]

Dear Friends

This is Sweatha. Right now I am working in the ASP.NET 2005 with VB coding & the back end is SQL SERVER 2000.

My dilemma is

I have to design a form with 2 DropDownListboxes. I have to load the ‘names of the theater’ on the 1st DropDownListbox & the names of the movie on the second DropDownListbox. That’s why I have created 2 tables named ‘theater’ and ‘movie’ on sql server 2000. The ‘theater’ table consists of 2 fields

Table Name: Theater
-------------------
tid tname
--------------------
t1 udhayam
t2 devi
t3 cinipriya
t4 dhanam
t5 pallavi
--------------------
The 'movie' table has 2 fields

Table Name
-------------------------------
mid tid mname
-------------------------------
m1 t1 billa
m2 t1 kalluri
m3 t2 pidichirukku
m4 t2 jodha akbar
---------------------------------

The coding I have given is as follows

Protected Sub DropDownList2_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles DropDownList2.SelectedIndexChanged
Dim con As SqlConnection
Dim cmd As SqlCommand
Dim str, str1 As String
Str = "user id=sa;password=;data source=AURO-RA4;initial catalog=suganya;server=AURO-RA4"
con = New SqlConnection(str)
Try
con.Open()
Catch
End Try
str1 = "SELECT mname FROM movie WHERE tid = (SELECT tid FROM theater WHERE tname = '" & DropDownList2.SelectedValue & "'"
cmd = New SqlCommand(str1, con)
Dim dr1 As SqlDataReader
dr1 = cmd.ExecuteReader()
DropDownList3.Items.Clear()
While dr1.Read()
DropDownList3.Items.Add(dr1.GetValue(0).ToString() )
End While
con.Close()
End Sub
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If IsPostBack = False Then
Dim con As SqlConnection
Dim cmd As SqlCommand
Dim str, str1 As String
str = "user id=sa;password=;data source=AURO-RA4;initial catalog=suganya;server=AURO-RA4"
con = New SqlConnection(str)
Try
con.Open()
Catch
End Try
str1 = "select tname,tid from theater"
cmd = New SqlCommand(str1, con)
Dim dr2 As SqlDataReader
dr2 = cmd.ExecuteReader()

While dr2.Read()
DropDownList2.Items.Add(dr2.GetValue(0).ToString() )

End While
End If
End Sub

ERROR:
Line 1: Incorrect syntax near 'cinipriya'.
Line 1: Incorrect syntax near 'devi'.

The error is on the line:-------Line 23: dr1 = cmd.ExecuteReader()

-sweatha

[malav123]

Dear Friends

This is Sweatha. Right now I am working in the ASP.NET 2005 with VB coding & the back end is SQL SERVER 2000.

My dilemma is

I have to design a form with 2 DropDownListboxes. I have to load the ‘names of the theater’ on the 1st DropDownListbox & the names of the movie on the second DropDownListbox. That’s why I have created 2 tables named ‘theater’ and ‘movie’ on sql server 2000. The ‘theater’ table consists of 2 fields

Table Name: Theater
-------------------
tid tname
--------------------
t1 udhayam
t2 devi
t3 cinipriya
t4 dhanam
t5 pallavi
--------------------
The 'movie' table has 2 fields

Table Name
-------------------------------
mid tid mname
-------------------------------
m1 t1 billa
m2 t1 kalluri
m3 t2 pidichirukku
m4 t2 jodha akbar
---------------------------------

The coding I have given is as follows

Protected Sub DropDownList2_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles DropDownList2.SelectedIndexChanged
Dim con As SqlConnection
Dim cmd As SqlCommand
Dim str, str1 As String
Str = "user id=sa;password=;data source=AURO-RA4;initial catalog=suganya;server=AURO-RA4"
con = New SqlConnection(str)
Try
con.Open()
Catch
End Try
str1 = "SELECT mname FROM movie WHERE tid = (SELECT tid FROM theater WHERE tname = '" & DropDownList2.SelectedValue & "'"
cmd = New SqlCommand(str1, con)
Dim dr1 As SqlDataReader
dr1 = cmd.ExecuteReader()
DropDownList3.Items.Clear()
While dr1.Read()
DropDownList3.Items.Add(dr1.GetValue(0).ToString() )
End While
con.Close()
End Sub
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If IsPostBack = False Then
Dim con As SqlConnection
Dim cmd As SqlCommand
Dim str, str1 As String
str = "user id=sa;password=;data source=AURO-RA4;initial catalog=suganya;server=AURO-RA4"
con = New SqlConnection(str)
Try
con.Open()
Catch
End Try
str1 = "select tname,tid from theater"
cmd = New SqlCommand(str1, con)
Dim dr2 As SqlDataReader
dr2 = cmd.ExecuteReader()

While dr2.Read()
DropDownList2.Items.Add(dr2.GetValue(0).ToString() )

End While
End If
End Sub

ERROR:
Line 1: Incorrect syntax near 'cinipriya'.
Line 1: Incorrect syntax near 'devi'.

The error is on the line:-------Line 23: dr1 = cmd.ExecuteReader()

-sweatha

Please send me proper Error.... I think Error should be in your sqldatareader...

[sweatha]

ERROR IS

Server Error in '/WebSite2' Application.
Line 1: Incorrect syntax near 'devi'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Line 1: Incorrect syntax near 'devi'.

Source Error:

Line 22: Dim dr1 As SqlDataReader
Line 23:
Line 24: dr1 = cmd.ExecuteReader()
Line 25:
Line 26: While dr1.Read()


Source File: C:\Documents and Settings\SMART\My Documents\Visual Studio 2005\WebSites\WebSite2\Default3.aspx.vb Line: 24

[malav123]

ERROR IS

Server Error in '/WebSite2' Application.
Line 1: Incorrect syntax near 'devi'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Line 1: Incorrect syntax near 'devi'.

Source Error:

Line 22: Dim dr1 As SqlDataReader
Line 23:
Line 24: dr1 = cmd.ExecuteReader()
Line 25:
Line 26: While dr1.Read()


Source File: C:\Documents and Settings\SMART\My Documents\Visual Studio 2005\WebSites\WebSite2\Default3.aspx.vb Line: 24

Hi Swetha,
First of all Check your syntax in "str1" there is syntax error that there is no closing bracket is available... and if then also if u will get error then check your database that you have given proper datatype or not ???
I think there is syntax error only....
so first of all check out syntax of whole code...
your problem will be solved....