I am working with VB in asp.net, The basic problem is, I want to pair up the elements in a string, exactly like request.QueryString() will do to the elements in the query string of the web page.
[Code]...
i'm currently making an app that needs to run a query between two dates. this app will run automatically, so i need to put the dates as today and yesterday, essentially.
[Code]...
Private Sub txtname_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles txtname.TextChanged
myConnection.Open()
[CODE]...
I want to four digit code like Abneesh than first query finding max of A and second string take string A than code generate like A001----------A999
I make a query in coding. But I got conversion error.My query is below
Dim strSelect As String = ""
strSelect = "SELECT " & _
"Description As [Desc], " & _
[code].....
Exception error is like
Conversion from string "iif(CurCons = 0, " to type 'Double' is not valid
Actually, in my report, i wanna show if it's zero then '-'. If i set it in this string.I got another error like below The provider could not determine the Decimal value. For example, the row was just created, the default for the Decimal column was not available, and the consumer had not yet set a new Decimal value.
From da.Fill
Dim cmd As New OleDbCommand(strDynamic, m_DBConn)
Dim da As New OleDbDataAdapter(cmd)
da.Fill(ds, "tblCur")
In my project I need to log all queries executed against my database. As an example we can use the staff user data here. In that class I have a function generating the command with the parameters as follows:
[Code]...
Should be simple, but can't figure out how to do it.
Want:
<a href="/sites/folder/page.aspx?variable=123456">Test</a>
By:
<a href="/sites/folder/page.aspx?variable=<% Request.QueryString("variable1") %>">Test</a>
I've tried <%# and <%= not expecting either of them to work, but trying them out.
Right now me filling a combobox by this way.
[Code]...
By this way combobox CmbId is storing above sql query ouput. But now i want to get above query ("Select Name from StudentDetails where Id=10 ") result to store in a variable string. How can i do this ?
How to encrypt query string in vb.net ?
View 2 RepliesWhat I want to do is take the full contents of the address bar and see if everything after the site path (i.e. everything after the question mark), contains a certain string, and if it does then return a path using the site URL and that string. An example and some code to make things understandable:
[Code]...
I have a SQL query string that gets the top 5 records from a database however 3 variables are passed with the sql query that gets specific data.[code]
View 5 RepliesSome one built a terrible database and it's now up to me to put the data they captured in a new database that's been designed.
I am querying a table and pulling out its text and sending that text into the new database via a query[code]...
Should be simple, but can't figure out how to do it.
Want:
<a href="/sites/folder/page.aspx?variable=123456">Test</a>
By:
[code].....
I have a query string that takes the value from a text box and passes it via a query string to a different web page. I need to add a hidden imput (state=MN) but can't get it to work. Everything I have tried hasn't worked.[code]
View 7 RepliesI create a hyperlink that when clicks generates a url like so:
[URL]
And I read it into a text box like so:
Me.txtTags.Text = CType(Request.QueryString("Tag"), String)
But the result of this is that the textbox txtTags will only contain C and doesnt have the ++. I tried [URL]and the # is missing as well. But if I look at the address bar these values are there....
I had been using this way for while, and it seems it work fine with char and numbers.
Dim MyVar1 as String = "Hello"
Dim MyVar2 as Integer = 1
Dim MySQL = "Select * from table where field1 = '<field1>' and Field2 = <field2>"
MySQL = MySQL.Replace("<field1>",MyVar1).Replace("<field2>",MyVar2)
msgbox(MySQL)
But, when I have to deal with blob field, where I store "wav file" for example, I had to read it as array of bytes, and the only way I find to insert the array of bytes in my query string is by using the command.AddParameter
Dim myfile As System.IO.FileStream = System.IO.File.OpenRead("full_wav_file_path")
Dim myArray(myfile.Length) As Byte
myfile.Read(myArray, 0, (myfile.Length))
[Code] .....
Is there another way to insert it without addParameter?
Im currently working on a project to build an application for Windows Mobile 6.I have a SQL query string:
Dim connectionString2 As String = "Data source = " + path + "HC.sdf"
Dim cmdText2 = "SELECT * FROM BigC_Rangsit_0_"
I want to substitute the table name ie. BigC_Rangsit_0_ with a variable which contains the table name.say, during runtime the user selects a table from the dropdown list , that variable should be substituted with the selected table name dynamically in the SELECT statement.
Dim cmdText2 = "SELECT * FROM "selected table name VARiable""
well, I need the right syntax for this.
I'm trying to view data by entering SQL in textbox.There's no error at below codes but I can't view my data.It shows me blank report. Did I missed something?
[Code]...
I am using the method described in the following LINK and I am using the following code to encrypt:
'Page1.aspx
Protected Sub butEncrypt_Click(sender As Object, e As EventArgs) Handles butEncrypt.Click
Dim QueryString As String = "type=Int&pk=" & _primaryKey
QueryString = Tools.encryptQueryString(QueryString)
Response.Redirect(/SearchResults.aspx?Val=" & QueryString)
End Sub
and then finally de-encrypt:
[Code]...
I'm writing an ASP web application with VB back-end. What I'd like to do is generate a url and display this in control on the page. For example if I have a label and a button on the form. The label is blank. When the button is clicked the following code fires:
Protected Sub btnGenerate_Click(ByVal sender As Object, ByVal e As EventArgs) Handles btnGenerate.Click
label1.Text = "Hello"
End Sub
What I'd like to have is a url that would point to my ASP Page with the words "Hello" in the label.
I have a Gridview on a page that have: CountryID, value 2 columns.There are another 2 text boxes on the pageI added a hyperlink field to the Gridview and I want onclick it will take me to another page with a Gridview that have datasource to query based on values of these 3 controls:-
(1) CountryID ofthe row user clicked
(2) textbox1
(3) textbox2
[code]......
I'm trying to create a sql query to search within an Access table that is showing inside a datagrid.
The search criterias used in the "where" bit are retrieved from info entered by the user in 3 textboxes and 1 DateTimePicker control. The first 2 fields are String type, the 3rd field is a date type (entered by the user using the DateTimePicker) and the last field in the DB table is Integer type.[ode]...
I am trying to add data to another column in my table.I have the following string insert which works:"insert into MyTable(ImageID,Image) values(" + TextBox1.Text +"," +" @pic)"The data I wish to add is in TextBox2.How do I correctly concatinate it?
View 5 RepliesI need to pass a string variable into a wql query:
Dim booking As String = System.Configuration.ConfigurationManager.AppSettings("PlayersFile")
Dim query1 As New WqlEventQuery( _
[Code]......
However, I'm uncertain how to make the variable booking parsable by the query.
I would like to query a string that only reads a last character.
sqlstmt = "select * from table where Area like'%A'"
Dim cmd4 As New SqlCommand(sqlstmt, con2)
da = New SqlDataAdapter(cmd4)
ds = New DataSet
[code].....
I have the above codes but i've got '-1' if nothing to read..
two aspx pages that i have.
First one is a table with results populated from the sql server backend. The first holds the "FirstName". I want this to have a hyperlink, so when i click on this, it should goto the second aspx page and show all the data in sql server for that "Firstname". the data is in 3 other tables based on firstname, which is phone, address and hobbies.So -
FirstName
Samuel --> clicked on it
redirect to second page -
Samuel -
Phone Address Hobbies
3104445656 123 main st Climbing
if i need a querystring or is there another solution (better solution). Also how do i capture the querystring in second page?
this is my vb.net code -
in the subroutine i have -
Private Sub xxx()
[code].....
I am wondering how to replace two variables in a query from selections that the user makes. One variable is chosen by a combo box called cboYEARMONTH and the other is selected from a list view called employeeListView. I know that I can use .replace to insert the YearMonth into the string but, how do I also replace the EmployeeID in the query string?
[Code]...
SQL String with multi line query
View 14 RepliesThis is probably so simple however my brain has decided it wants a night off. I am trying to write a program that uses SQL queries for various tasks but I need it to allow the user to be able to use which ever name they want for the database name. therefore I need to be able to reference the database as a string variable. For Eg:
[Code]...
this code will not pass the query string to default3.aspx on Image Button [code]
View 1 Replies