Can not figure out why I am getting this error, can someone please help!!! Incorrect syntax near '.'. Public Sub GenerateText() Dim connString1 As String = ConfigurationSettings.AppSettings("connString1") 'bkf-sql1/jHelp Dim cnnConnection As New System.Data.SqlClient.SqlConnection(connString1)
Dim cmdCommand As New System.Data.SqlClient.SqlDataAdapter Dim cmdCommandSel As New System.Data.SqlClient.SqlDataAdapter cmdCommand = New System.Data.SqlClient.SqlDataAdapter("Select Cust_Access, CIC_Description, Item_Comment, AssocNbr_Name, CIC_Status, Ord_Pending,
CIC_Solution, CCSC_Unit From CIC_ItemStatus WHERE CIC_ID=@ID ", cnnConnection) cmdCommand.SelectCommand.Parameters.Add("@ID", SqlDbType.Int, 4).Value = ("225") 'Request.QueryString("ID") Ds = New DataSet cmdCommand.Fill(Ds, "GenerateText") lblCustomerAccess1.Text
= Ds.Tables("GenerateText").Rows(0)("Cust_Access").ToString() lblItemDescription1.Text = Ds.Tables("GenerateText").Rows(0)("CIC_Description").ToString() lblProblemComment1.Text = Ds.Tables("GenerateText").Rows(0)("Item_Comment").ToString() lblAssocNbrName1.Text
= Ds.Tables("GenerateText").Rows(0)("AssocNbr_Name").ToString() lblStatus1.Text = Ds.Tables("GenerateText").Rows(0)("CIC_Status").ToString() lblOrderPending.Text = Ds.Tables("GenerateText").Rows(0)("Ord_Pending").ToString() lblSolution1.Text = Ds.Tables("GenerateText").Rows(0)("CIC_Solution").ToString()
cmdCommandSel = New System.Data.SqlClient.SqlDataAdapter("Select CCSC_Unit,CICC.CCSC_Name FROM CIC_ItemStatus CICI, CIC_Center CICC WHERE CICI.CCSC_Unit = @CICC.CCSC_Name", cnnConnection) cmdCommandSel.SelectCommand.Parameters.Add("@CICC.CCSC_Name", SqlDbType.Char,
30).Value = lblCCSCUnit1.Text Ds = New DataSet cmdCommandSel.Fill(Ds, "CCSCName") lblCCSCUnit1.Text = Ds.Tables("CCSCName").Rows(0)("CCSC_Unit").ToString() End Sub
Oh, I am really sorry! Line: 79 Line 77: Line 78: Ds = New DataSet Line 79: cmdCommandSel.Fill(Ds, "CCSCName") Line 80: Line 81: lblCCSCUnit1.Text = Ds.Tables("CCSCName").Rows(0)("CCSC_Unit").ToString()
vedwards
Member
600 Points
120 Posts
Syntax Error
Nov 24, 2003 04:53 PM|LINK
augustwind
All-Star
35860 Points
4900 Posts
ASPInsiders
Moderator
Re: Syntax Error
Nov 24, 2003 05:58 PM|LINK
All Things Dot Net
Stored Procs and Code in a Flash!
ASP.Net Sitemap Creator
vedwards
Member
600 Points
120 Posts
Re: Syntax Error
Nov 24, 2003 06:50 PM|LINK