Syntax Error RSS

• • Reply
  

  vedwards

  Member

  600 Points

  120 Posts

  Syntax Error

  Nov 24, 2003 04:53 PM|LINK

  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
• • Reply
  

  augustwind

  All-Star

  35860 Points

  4900 Posts

  ASPInsiders

  Moderator

  Re: Syntax Error

  Nov 24, 2003 05:58 PM|LINK

  Did the error message give you a line number, so you can tell us where the problem might be occurring?
  David Wier
  All Things Dot Net
  Stored Procs and Code in a Flash!
  ASP.Net Sitemap Creator
• • Reply
  

  vedwards

  Member

  600 Points

  120 Posts

  Re: Syntax Error

  Nov 24, 2003 06:50 PM|LINK

  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()