DataSource Controls :: Unable To Get Correct Syntax?
Jul 7, 2010
I am just not able to get the syntax right for the below code,
Dim HeaderCount As Integer = readerXML.HeaderCount()
Dim NewTable As String
NewTable = "CREATE TABLE " + tbCustomerFileName.Text +
" (" +
" RowId smallint" +
" IDENTITY(1,1)" +
" PRIMARY KEY CLUSTERED,"
For I = 0 To [HeaderCount]
NewTable = NewTable + readerXML.Item(I) + " DEFAULT 'New Position - title not formalized yet'," + " varchar(50) NOT NULL,"
Next [I]
+ ")" ...this part gives me an error ssaying incorrect syntax.
I am trying to upload an excel file and based on the number of headers in the file, I want to generate columns, however I am just not able to get this going because i am getting syntax error, the main problem being I am not able to put the brackets at the right place.
I have a listview (userid, users) and a checkbox. I would like to select the checkbox and store the userid in a textbox then into a session page. I am having issues with the code as it seems incorrect, due to the listview1.row.
I am using 3 tables and are trying to get the correct info belonging to the correct id. Like this: I go to a page and here i want to see the information from the 3 tables using a specific id.
I have written this so far in a query:
[Code]....
My problem is that the last line does not work and i am uncertain how to make this work? How to write it correctly that is.
I want to do a LIKE clause in an SQL statement. What is the proper syntax if this if my informaiton.I want to select personID, personName, personBuilding From Table: main27WHERE personName has the Name 'Smith' in it. Note that person Name is set up as: Last Name, First Name = Smith, John.The query works fine in my access database, but I am trying to put it in a VB.net application and I can't get it to pull any records when there are 18.
when trying to update the db from the edit page, i would likt to take one field from the formcollection change things in it and update the model with the changed field.
In my web.config, I have attached a SQL express database .. as follows: <add name="eHNDBConnectionString" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename="C:UsersDell-XPS1330DocumentsVisual Studio 2005WebSitesWebSite4eHNDB.mdf";Integrated Security=True;Connect Timeout=30;User Instance=True" providerName="System.Data.SqlClient" />
I need to upload this to my web server so I need to remove the local link .. I tried:
.. but i keep getting this error message when i try to open the page that accesses the DB. An attempt to attach an auto-named database for file eHNDB.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
1- what is the correct syntax to use in my web.comfig?
2- when online, i'm gonna be using sql server and not sql express .. what considerations / changes should i apply as well?
I am trying to update the database with the edited data. However, it did not manage to read the edited data from the textbox. It returned the retrieve data that I have done in the Page_Load instead. Is there any part of the code that I have written wrongly? I did manage not to use <EditItemTemplate> in my past project and manage to update the database with the same logic.
<aspx> <!-- This DataList is created to view Personal Information --> <asp:DataList ID="personal_dl" runat="server"> <ItemTemplate> <table> <tr> <td style="width: 100px; text-align: left;"> <asp:Label ID="first_lbl" runat="server" ForeColor="Black" Font-Size="11px" Text="First:"></asp:Label></td> <td style="width: 350px"> <asp:TextBox ID="first_tb" runat="server" Width="341px" Font-Size="11px" Text='<%# Eval("FIRST") %>'> </asp:TextBox> </td> </tr> <tr> <td style="width: 100px; text-align: left"> <asp:Label ID="name_lbl" runat="server" Font-Size="11px" ForeColor="Black" Text="Name:"></asp:Label> </td> <td style="width: 350px"> <asp:TextBox ID="name_tb" runat="server" Width="341px" Font-Size="11px" Text='<%# Eval("NAME") %>'> </asp:TextBox> </td> </tr> <tr> <td style="width: 100px; text-align: left;"> <asp:Label ID="id_lbl" runat="server" ForeColor="Black" Font-Size="11px" Text="ID:"> </asp:Label> </td> <td style="width: 350px"> <asp:TextBox ID="id_tb" runat="server" Width="341px" Font-Size="11px" Text='<%# Eval("ID") %>'> </asp:TextBox> </td> </tr> <tr> <td style="width: 100px; text-align: left;"> <asp:Label ID="contact_lbl" runat="server" ForeColor="Black" Font-Size="11px" Text="Contact No.:"> </asp:Label> </td> <td style="width: 350px"> <asp:TextBox ID="contact_tb" runat="server" Width="341px" Font-Size="11px" Text='<%# Eval("TELEPHONE_HP") %>'> </asp:TextBox> </td> </tr> <tr> <td style="width: 100px; text-align: left;"> <asp:Label ID="add_lbl" runat="server" ForeColor="Black" Font-Size="11px" Text="Address:"> </asp:Label> </td> <td style="width: 350px"> <asp:TextBox ID="add_tb" runat="server" Width="341px" Font-Size="11px" Text='<%# Eval("ADDRESS") %>'> </asp:TextBox> </td> </tr> </table> </ItemTemplate> </asp:DataList> <br /> <div style="text-align: center; color: Red; width: 460px;"> <asp:Label ID="errorMsg_lbl" runat="server" /> <asp:Button ID="edit_btn" runat="server" Text="Update" /> <asp:Button ID="createBtn" runat="server" Text="Insert" /></div> <aspx.vb> Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load 'display information in datalist Dim login As String = Session("login") Dim id As String = Session("id") bindDataList(personal_dl, getPersonalContent(login, id)) 'display necessary DataList personal_dl.Visible = True 'declare fields Dim i As Integer Dim first_tb, name_tb, id_tb, contact_tb, add_tb As New TextBox For i = 0 To personal_dl.Items.Count - 1 first_tb = personal_dl.Items(i).FindControl("first_tb") name_tb = personal_dl.Items(i).FindControl("name_tb") id_tb = personal_dl.Items(i).FindControl("id_tb") contact_tb = personal_dl.Items(i).FindControl("contact_tb") add_tb = personal_dl.Items(i).FindControl("add_tb") 'set fields as ReadOnly - cannot edit first_tb.ReadOnly = False name_tb.ReadOnly = False id_tb.ReadOnly = False contact_tb.ReadOnly = False add_tb.ReadOnly = False Next End Sub
Protected Sub edit_btn_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles edit_btn.Click 'declare fields Dim i As Integer Dim first_tb, name_tb, id_tb, contact_tb, add_tb As New TextBox Dim id As String = Session("id") For i = 0 To personal_dl.Items.Count - 1 first_tb = personal_dl.Items(i).FindControl("first_tb") name_tb = personal_dl.Items(i).FindControl("name_tb") id_tb = personal_dl.Items(i).FindControl("id_tb") contact_tb = personal_dl.Items(i).FindControl("contact_tb") add_tb = personal_dl.Items(i).FindControl("add_tb") Next Dim myConnection As OleDbConnection = dbConnection() Dim cmd As New OleDbCommand Dim sqlStatement As String Dim condition As String condition = "UPDATE staff " + _ "SET ((FIRST= @FIRST), (NAME = @NAME), (ID= @ID), (TELEPHONE_NO = @CONTACT_NO), (ADDRESS = @ADDRESS)) " + _ "WHERE (ID= @id)" sqlStatement = condition cmd.CommandText = sqlStatement cmd.CommandType = CommandType.Text cmd.Parameters.AddWithValue("@FIRST", first_tb) cmd.Parameters.AddWithValue("@NAME", name_tb) cmd.Parameters.AddWithValue("@ID", id_tb) cmd.Parameters.AddWithValue("@TELEPHONE_NO", contact_tb) cmd.Parameters.AddWithValue("@ADDRESS", add_tb) cmd.Parameters.AddWithValue("@ID", id) cmd.Connection = myConnection Try myConnection.Open() cmd.ExecuteNonQuery() Catch ex As Exception Finally If myConnection.State = ConnectionState.Open Then myConnection.Close() End If End Try 'display information in datalist Dim login As String = Session("login") bindDataList(personal_dl, getPersonalContent(login, id)) End Sub
What is the correct syntax in VB.net 2008 web developer in SQL to do a WHERE clause where the data is >= to the current date? I can't figure out how you pass now into the SQL statement.
Dim connStr As String = " Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=W:PatioOrderApp_DataPatio.mdb" Dim con As New OleDb.OleDbConnection(connStr) Dim instr As String = " INSERT INTO tOrders([first_name],[last_name],[order],[comment]) Valuse(?,?,?,?)" If IsValid Then Using con Using cmd As New OleDb.OleDbCommand(instr, con) cmd.CommandType = CommandType.Text cmd.Parameters.AddWithValue("first_name", DBNull.Value) cmd.Parameters.AddWithValue("last_name", DBNull.Value) cmd.Parameters.AddWithValue("order", DBNull.Value) cmd.Parameters.AddWithValue("comment", menuDrinks.SelectedItem.ToString) con.Open() cmd.ExecuteNonQuery() End Using End Using con.Close() End If
I have this Insert statement working fine: [Code]....
It inserts a new record into a single table. The PK is a field named QID.what the equivalent Update code would be? I'm not sure of the syntax for the Update values (old and new) and Where clause.I'm assuming something beginning with: existingQ.Update
here is my update query syntax.my problem is.if i update only logo1 and logo3 with null logo2 and img null then my query should be update the other record.just dont update null value record but other should be update.but below my query can not update any record.
UPDATE tbitem set itemname= @itemname,note=@note, price=@price,qty=@qty,logo1=@logo1, logo2=@logo2,logo3=@logo3,img=@img where id =@id and @logo1 is null and @logo2 is null and @logo3 is null and @img is null
I hv Writte nA sql Query in whic hi want to use an Inner join as well as THe left OUter Join in it ..i hv written it in the sql server it executes properly.but when i run the same code ..from my application .it starts gving the Error Incorrect Syntax Near Keyword INNER..
working with sql server 2005/ visual studio 2005 asp.net c# i just wanted to know ... to insert a date to the database in a field that gets "dateTime" i need to insert the origin syntax. what is the right syntax for the datetime in the database? and to invent for users to insert a wrong sytax ... wich validations i need to put on the field? same question on the type "image" in database it gets like a jpg file? how do i insert an image to the database? If i have a textbox that contain a number ... and i want to ask somthing about the number. how do i do it ? .... like i now that i need to convert it to int i tried this way but it didnt work:
Incorrect syntax near '>'. I made a listview with some dropdownmenu and selectboxes to select from untill the query shows in the listview.
Now the query goes well and shows the first page of 4 rows as I wanted it.
The pager shows 5 pages and if I a want to click on the next page I get this message.
Incorrect syntax near '>'. 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: Incorrect syntax near '>'.
<asp:SqlDataSource ID="SqlDataSource4" runat="server" ConnectionString="<%$ ConnectionStrings:AvcilarEvleri %>" SelectCommand="SELECT * FROM Tabel1 WHERE ((([Regio_Object] = @Regio_Object) AND ([Plaats_Object] = @Plaats_Object) AND ([Wijk_Object] = @Wijk_Object) AND (Prijsklasse => @Prijsklasse1) AND (Prijsklasse <= @Prijsklasse2) AND (Prijsklasse => @Prijsklasse3) AND (Prijsklasse <= @Prijsklasse4 AND (Oppervlakte_Object => @Oppervlakte_Object1) AND (Oppervlakte_Object <= @Oppervlakte_Object2)) AND ((Type_Object = @Type_Object1) OR (Type_Object = @Type_Object2) OR (Type_Object = @Type_Object3)))"> <SelectParameters> <asp:ControlParameter ControlID="DropSehir1" Name="Regio_Object" PropertyName="SelectedValue" Type="String" /> <asp:ControlParameter ControlID="DropIl1" Name="Plaats_Object" PropertyName="SelectedValue" Type="String" /> <asp:ControlParameter ControlID="DropDownList5" Name="Wijk_Object" PropertyName="SelectedValue" Type="String" /> <asp:ControlParameter ControlID="DropFiyat1" Name="Prijsklasse1" PropertyName="SelectedValue" Type="String" /> <asp:ControlParameter ControlID="DropFiyat2" Name="Prijsklasse2" PropertyName="SelectedValue" Type="String" /> <asp:ControlParameter ControlID="DropFiyat3" Name="Prijsklasse3" PropertyName="SelectedValue" Type="String" /> <asp:ControlParameter ControlID="DropFiyat4" Name="Prijsklasse4" PropertyName="SelectedValue" Type="String" /> <asp:ControlParameter ControlID="DropMetre1" Name="Oppervlakte_Object1" PropertyName="SelectedValue" Type="String" /> <asp:ControlParameter ControlID="DropMetre2" Name="Oppervlakte_Object2" PropertyName="SelectedValue" Type="String" /> <asp:ControlParameter ControlID="CheckBoxList1" Name="Type_Object1" PropertyName="SelectedValue" /> <asp:ControlParameter ControlID="CheckBoxList1" Name="Type_Object2" PropertyName="SelectedValue" /> <asp:ControlParameter ControlID="CheckBoxList1" Name="Type_Object3" PropertyName="SelectedValue" /> </SelectParameters> </asp:SqlDataSource>
And the code;
Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Button1.Click
Panel1.Visible = False Panel4.Visible = False Panel5.Visible = False Panel6.Visible = False Panel7.Visible = False Panel8.Visible = False Panel9.Visible = False Panel10.Visible = False Panel2.Visible = True Panel3.Visible = True Dim strchklist As String = "" Dim li As ListItem For Each li In CheckBoxList1.Items If li.Selected Then strchklist += ",'" & li.Value & "'" End If Next If strchklist = "" Then Response.Write("No item Selected") End If SqlDataSource4.SelectCommand = "SELECT * FROM Tabel1 WHERE ([Regio_Object] = @Regio_Object) AND (Plaats_Object = @Plaats_Object) AND (Wijk_Object = @Wijk_Object) AND (Prijsklasse >= @Prijsklasse3) AND (Prijsklasse <= @Prijsklasse4) AND (Oppervlakte_Object >= @Oppervlakte_Object1) AND (Oppervlakte_Object <= @Oppervlakte_Object2) AND Kamers_Object IN (" & strchklist.Substring(1) & ")" SqlDataSource4.DataBind() End Sub
I am sure it has something to do with the query because and with the checkboxes.
I'm using the following code to select a number of fields from a Table, this works perfectly, however I actually want to select from a stored procedure not a table and im not sure what the correct syntax is,
I have a problem with my SQL statement that only needs to show future dates in the Gridview.I use vb, vs 2005.I want a DateTime Field(TEndDate) to act as a control field in that only future dates (WHERE TEndDate >= Now.Date.Date) should be returned.It asks for my paramaterized value when I'm building the query.I'm unsure about the source I should select for the query.(The options are: None/Control/Cookie/Form/Profile/Querystring/Session)I'm losing my mind with this!Here is my code:
Where can I find documentation on the syntax that is expected for LinqDataSource.Select? It seems to be different from what I would do with Linq inline in C# code. For example, concatenateing something in Linq I would normally just do this in the projection:
new { FullName = (person.FirstName + " " + person.LastName ) } However, with a LinqDataSource the only way I've found to do this is like this: new ( String.Concat(person.FirstName, " ", person.LastName) as FullName)
I literally spent hours trying to figure this out, and only succeeded when I found a blog where someone gave this verbatim as an example. So I still don't understand why the syntax is different, the braces versus parens, aliasing, Concat operators. Next time I do this I want a better understanding so I am not playing this guessing game. It's like being handed a compiler, and trying to write a program when you don't know what language the compiler compiles.1. Are there different "flavors" of Linq? Like a VB Linq, and C# Linq?2. If so, is the LinqDataSource using a VB flavor of Linq?3. Really, what is really important to me, where can I find documentation on this particular falvor of Linq that the LinqDataSource expects? The documentation for the LinqDataSource itself gives nothing more than extremely simplistic examples.
I'm using DAAB from MS Ent Library 4.1. I have this function in my DAL that returns a dataset.
[Code]....
However, it is failing with this error:Failed to convert parameter value from a String to a Boolean. But if I use SqlDbType.VarChar instead it works fine. I want to use Char b/c that is the correct datatype in SQL.In my SP the param is @CUSTNMBR char(15). In my database table the field is also char(15).
I've created an Expression Web form with a SQL datasource which is doing a query/select statement.Somehow it appears that I'm making a syntax error. When I divide the query in two and execute them separate, it works fine.I need to filter for an EventType, Region and Today's date + a custom interval (like 7 day's for a week)he parameters come from a search form where the user can select these values via a dropdown list.The two separate (and working) queries within my form are:Query nr.1 :
"Select * from Events WHERE (([EventType] LIKE '%' + @EventType + '%') AND ([Region] LIKE '%' + @Region + '%'))"> <asp:formparameter DefaultValue="%" FormField="EventType" />
