Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Insert Multiple Variables into the same SQL Data field

Posted on 2004-09-23
3
Medium Priority
?
200 Views
Last Modified: 2010-04-23
Hello Experts!

I am still new to Visual Basic.NET, and I have seemed to run into an obstacle I can readily solve.  Here is what I am trying to do.  I am writing a custom record insertion form to generate hyperlinks and insert them in to a Database table Data field.  The content of the hyperlinks need to be based on user input.

For example: <a href=http://server/[user input from textbox1]/[more user input from textbox2].pdf>[Display Text from textbox3]</a>

I have been able to insert into the target data field from a textbox a which the user has input information, and assigned it to a button to load and return the newly inserted data, however I need the whole hyperlink to be inserted into the same target data field.

I have tried to add variables in between the single quotes required to define a variable in a sql statement with the “&” and the “+”.  At design time Visual Basic does not have a problem with it, but a run time it fails.

Does anybody know of an effective way to accomplish this?  I need the whole hyperlink to insert into the target data field.


Here is the code I have so far:


Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim dataset1 As New DataSet
        dataset1 = New DataSet("dataset1")

        Dim ConnectionString As String = "Provider=SQLOLEDB.1;Integrated Security=SSPI;data sourc" & _
        "e=LOGSOHFIL01;persist security info=False;initial catalog=MasterFileIndex"

        Dim Connection1 As OleDbConnection = New OleDbConnection(ConnectionString)

        Dim Command1 As OleDbCommand = _
        New OleDbCommand("INSERT INTO test (First_Name, Last_Name, Info) values ('" & TextBox1.Text & "  ', ' " & TextBox2.Text & " ', '" & TextBox3.Text & "') select* FROM test")
        Command1.CommandType = CommandType.Text

        Connection1.Open()
        Command1.Connection = Connection1

        Dim OleDbDataAdapter1 As OleDbDataAdapter = New OleDbDataAdapter

        OleDbDataAdapter1.SelectCommand = Command1
        OleDbDataAdapter1.Fill(dataset1, "authors")

        DataGrid1.SetDataBinding(dataset1, "authors")
        Connection1.Close()
    End Sub

    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

    End Sub
End Class


Thanks for your help!
0
Comment
Question by:ndegioia
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 4

Author Comment

by:ndegioia
ID: 12179541
I found my own answer:)  All i had to do was to write the collect all of the data and place the rest of the HTML for the hyperlink code into one variable and send it to sql.

0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 12376741
PAQed, with points refunded (50)

Computer101
E-E Admin
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s quite interesting for me as I worked with Excel using vb.net for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

618 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question