CommonSense
New Member
The following code is generating an error:<BR>"Incorrect syntax near '='."<BR>on the line:<BR>assetsCmd.Fill(assetsData, "Assets");<BR><BR>Can anyone help?<BR><BR>::code::<BR><BR>String assetGrabber = "SELECT id, filename, lastmodified, description FROM assets WHERE extranet_id=";<BR>assetGrabber += whichXnet;<BR>assetGrabber += " AND page_id=";<BR>assetGrabber += whichPage;<BR><BR>SqlDataAdapter assetsCmd = new SqlDataAdapter(assetGrabber, Conn);<BR> <BR>DataSet assetsData = http://aspmessageboard.com/archive/index.php/new DataSet();<BR>assetsCmd.Fill(assetsData, "Assets");<BR><BR>assetsGrid.DataSource=assetsData.Tables["Assets"].DefaultView;<BR>assetsGrid.DataBind();<BR><BR>----------<BR>Thanks,<BR>Ben<BR><BR><BR><BR>