In line code in

Hi,

I have a problem with the <asp:SqlDataSource. The thing that I try to do is to create a SQL statement. I am not sure if this can be done or not ( just started asp.net).

Something like this:

Dim Test1 As String

Dim Test2 As String

Dim Test3 As String

Dim Test4 As String

Test1 = Request("xmbr")

Test2 = Request("xSEL")

Test3 = Request("xpro")

Test4 = "SELECT [jedan], [dva], [tri], [cetiri], [pet] FROM [pet1] where " & (Test1) & " " & (Test2) & "'" & (Test3) & "'"

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:FinGateConnectionString %>" SelectCommand="<%= Test4%>">

The problem is that is giving me an error that I cant figure out.

-------------------------------------------------

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 '<'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

-------------------------------------------------

Thanks.

Nbdg_28

tutorials.aspx?id=1

That being said, you can use a SQL statement (Select [Field list] from [Table name] where Field1=@Field1 and Field2=@Field2, etc

Then, inside your SQLDataSource, use the parameters section to assign where the data for each parameter is coming from.

Re: In line code in
Hi,

I'm trying to use inline code inside my sqldatasource..

<asp:Parameter Name="CREATION_DATE" Type="DateTime" DefaultValue= '<%System.DateTime.Now.ToString()%>' />

This gives me an error saying input string was not in correct format..

Could someone help me in this?

Re: In line code in Hi, I'm trying to use inline code inside my sqldatasource.. <asp:Parameter Name="CREATION_DATE" Type="DateTime" DefaultValue= '<%System.DateTime.Now.ToString()%>' /> This gives me an error saying input string was not in correct format.. Could someone help me in this?

Re: In line code in
Hi,

I'm trying to use inline code inside my sqldatasource..

<asp:Parameter Name="CREATION_DATE" Type="DateTime" DefaultValue= '<%System.DateTime.Now.ToString()%>' />

This gives me an error saying input string was not in correct format..

Could someone help me in this?