Some 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]...
I'm developing an interface for users that will allow them to enter data into a database without having to know SQL. Problem is, some one out there probably does.
How can I stop them from deleting/screwing with my data when they're typing entries within my text boxes?
For example, I don't want anyone to be able to type in DELETE * or any other kind of SQL statements in a text box to ruin the DBA's day.-Nothing to see. Move along.
I've almost finished my database application, and I had an idea to insert a button that creates a copy of the database. However, when I click the button, it destroys all of the data in the file before copying. It's a 2000 .mdb Access file with 500+ rows so far.
Here's the code that handles the backup: Private Sub btnBackup_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnBackup.Click
[Code]...
I have written a program to add a timestamp to a data sheet which had the time in seconds at which a sample was taken. The sampling was done every 0.1 seconds i.e 10 Hz sampling rate.The code I wrote enables one to select a file to which the time stamp must be added, and then runs a macro from excel when you click "Add Timestamp".
I am having a problem destroying the objects though so that they don't end up hanging around in the background. If Excel is already open I do not want it to close at the end of the program, I want Excel to simply return to its state before the application was run in order to prevent losing data on another unrelated excel task which may be open. The macro which is called closes any sheets which it opens. The other problem I am having is that if the program encounters an error there are a number of Excel objects floating in the background. My code is posted below.
Imports Microsoft.Office.Interop.Excel
Imports System.Runtime.InteropServices
Public Class Form1
[code]....
disposing http listening object when program closed which located other file than my main form.I am starting http listener like this :
Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
WebServer.Main()
Klasör = "C:UsersSalihDesktopWebServerWebServerWebServerinDebugWWWRoot"
Sayfa = "index.html"
End Sub
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")
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]...
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 RepliesShould 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].....