What 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]...
Is that possible to get current Enumerator (...or iterator? Don't know which tern is the correct one) in a LINQ query ? For example, I try to create a XML output (via LINQ to XML) of all currently loaded assemblies. [code] is it possible to somehow get current "index" (counter?) from LINQ's Selects? I would like to use it in XML. [code]
View 1 RepliesI'm using the Details View control of VWD asp.net 2008
I have a users database table. One of the columns contain the "uniqueidentifier" user's profile ID, created by VWD (from the automatic profiles table).
From my table, I would like to select only the data pertaining to the logged in user.
How do I get the current unique user profileID in general and then how do I use that for my query?
In the configure data source option of the control, I select the check box for "Return Only Unique IDs" and the WHERE option. In this new window I select the Column to the profile userID ... "=" and then assumed I should select Source: "Profile".
Now what should the parameter properties or value be to select only the current logged userID?
OR how can I do this just in C#? There doesn't seem to be any code behind after instering a DB with the VWD controls?
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 am working on my datagridview to get the current cell value from the column. I have three columns which I want to get the cell value from the second column.[code]...
View 7 RepliesI'm trying the fetch only the date within the current and return how many rows Dim dc as new dataclassesdatacontext dim q=from p in dc.worktime where p.name.equals(session("name") and p.date ).count what I should I put after "p.date" ? And if I want to search for the record which there are record that are insert five days earlier, how to do that ? use (datetime.now - 5) ?
View 3 RepliesI have a button coded on my screen that copies pre-typed text to the clipboard so all I have to do is paste the info where I need it to go.Problem is that in my original pretyped text in Word I have the text setup to always insert the current date in on my page. How can I format my code here to insert the current date in the string?
Private Sub CommandButton9_Click()
Dim MyText As DataObject, TextStr As String
Set MyText = New DataObject
[code]...
i need to convert the current line that is selected/displayed in listbox into a string
View 1 RepliesI need to get the url of the web browser (check what website it is on) and then convert it to string so it can go in a textbox or wherever.
View 11 RepliesI 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")
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 have following link in a.aspx file:
<a href="a.htm" target="iframe">A</a>
I want to set link from a.aspx.vb page according to what person is viewing the page. How can i change this so that if user clicks on link it will replace current frameset contained in current window with a url provided according to user?
Or in another way:
How will i replace href code in aspx page by giving it value from aspx.vb page?
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 RepliesI 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 Replies