im trying to read a database that is online. My goal is to be able to store a database online, and be able to edit it through my application and the web (the web part is done). all that remains is the application.
View 5 Repliesi have maid a simple login system in vb.net here is my current code
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
If TextBox1.Text = "http://mywebsite.com/usernames.txt" Then
Form2.Show()
Me.Hide()
[code]....
I believe I have 2 problems. First, I have 1 program (VB6) that reads and stores emails from a department mailbox into a database. This program uses mapi and CDO. I have a 2nd program written in VB 2008 that displays the email information that was stored in the database. Everything works fine except the user now needs all formatting to be displayed ie highlighted, bolded text, etc contained in the email. The first problem is the email is stored in the database as plain text. I don't know how to get HTML formatted text from MAPI/CDO. Secondly, if I did store the email message in HTML format, would I be able to display in a .NET control on the form other than using the Web Browser?
View 5 RepliesI need to make an application in which a vb.net application takes in a XML file from a url and display it in my program. An example of a place to get a url would be [URL] then take the contents of this and read it into my program.
View 2 RepliesDownloading the string would use too much, is there a way i can read it straight from the WebPage without having to download it? It's a a two row table.
I need to compare a TextBox entry to something in the List -first row- and then pull some data from the second row.
I am trying to read a xml file that is posted online through my windows app. What I am trying to do is get a value of one of the elements and then set that value to a string in my windows app.
View 2 RepliesWhy is this not working for me? What is wrong with my code below? I am trying to read a stored proc and applying values to labels. Getting error that say "Incorrect syntax near CareerInner".........
Private Sub LoadData()
' Define data objects
Dim conn As SqlConnection
[Code]......
how to read all the tables returned by SQL Stored Procedure? My Stored procedure returns two tables:
ID Name
-----------
1 Jeff
2 Joe
[code]....
i want to read data from both of these tables. I tried using SQLDataReader and then populating into datatables but then i can only read the values of 1st table. I want to read both the table values. How do i do it?
After browsing the internet on how to read RDF Triples, the only things i came up with were user created libraries and so on. Some MSDN documentation on Microsoft's website confused me as well, as trying to import the Namespace shown was not possible. (Maybe it's possible just in C#? no idea).So how would someone read an RDF Triple using VB.NET? RDF is an XML format in which data is stored in triples: subject, predicate, object.
Example:
<rdf:RDF
xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
xmlns:dc="http://purl.org/dc/elements/1.1/">[code]....
Can any one provide me the link or give me an idea how to read all the tables returned by SQL Stored Procedure?
My Stored procedure returns two tables:
ID Name
-----------
1 Jeff
2 Joe
ID Pages
----------
1 2
i want to read data from both of these tables. I tried using SQLDataReader and then populating into datatables but then i can only read the values of 1st table. I want to read both the table values. How do i do it? please let me know if you guys have any ideas how to deal with this.
I friend and I are trying to work our way through this, and right are having some issues in terms of getting vb.net to connect to an online sql server. We have found lots of resources to connect to local sql servers but nothing about connecting to an online one. I was wondering if this is possible as we are trying to be build an inventory and pos system for a small company we have, which can be accessed through the vb program from any computer as long as it has an active web connection.
View 1 RepliesHow do you connect to an online database? Let's say it's located at www.abc.com/app_data/thisfile.mdb. What would you enter for as the DatabaseFile in the following code?
Dim DatabaseFile as string = ????
Dim connection_builder As New OleDb.OleDbConnectionStringBuilder
connection_builder = New OleDb.OleDbConnectionStringBuilder
connection_builder.DataSource = Me.DatabaseFile
connection_builder.Provider = "Microsoft.Jet.OLEDB.4.0"
connection_builder.Add("Jet OLEDB:Database Password", Password)
Return New Data.OleDb.OleDbConnection(connection_builder.ConnectionString)
Our database has been having some occasional troubles and this seems to be presenting a problem in my new app. How should I test to make sure the database is up before sending SQL statements to it? We are using Oracle 11g and I am using odp drivers, VB.net 2010, .net framework 4.0.
View 4 Replies[url] i found this in youtube but unfortunately i got error, i used filefreak as a free hosting site...i got wrong username or password even i typed it correctly!
Is there another way to have a login system that compare in online database hosting site?
How hard is this. i need to send information from a text box to a website(i not done the website yet) which is anothing il be asking abot.I have basic vb.net skills. so can follow what i am doing. just not great
View 8 RepliesHi,in my application i have to read from an excel files and check the value of every cell i'm using an OleDb connection to open it and reading but i have this issue if some of the cells in the excel sheet is having this warning when i try to read it returns DBNull .knowing that i can not force the user for not having this warning ...i have to solve this within my code .
View 5 RepliesI have mysql database in my website (server) .How can i connect to this database using vb.net?
I am only able to connect to local mysql database on my computer.[code]...
I just created some program, using an online database. You can login, register...But the problem is: everything works but how do I fetch data from the user's sql table?I include the project (all connections) over here ->>DOWNLOAD<<-. I use freedb.net....
View 4 RepliesI just created some program, using an online database.You can login, register...But the problem is: everything works but how do I fetch data from the user's sql table?
View 8 RepliesConnecting to a Online MySQL Database using .Net?
View 4 Repliesi got some problems with my connection to a MySQL database so this is my code:
Dim conn As MySqlConnection
'connect to DB
conn = New MySqlConnection()
[Code].....
I got this Database that is Online thats hosted through the Website and uses MySQL, and the Tables have some Data I like to Read From. Heres what I got
vb
Public Sub testconnect()
Dim sqlconn As String = "Server=63.247.93.106;Database=viina_schoolbook;User=---; Password=---;"
[Code]....
Dim
sqlquary2 = "GET Status from Members
WHERE Username='" & UsernameTextBox.Text &
"';"
[Code]....
save an Image to an online database in .net?
View 1 RepliesIn my Database application same of the operations can cause a bit of a delay, especially the ones that invoke more than one query on the DB.... In Windows (or was it in Java?) I have encountered this progress bar that doesn't gradually fill in but rather just shows this block of bars that moves from left to right in a loop...basically not showing exact info regarding the progress but simply showing that something is happening....Anybody knows what I'm talking about? And if so, if there is a way to implement this in VB? Kind of in a way that it appears when the function is called and starts looping until the function reaches its last lines and then disappears?
View 3 RepliesI am having a small problem... I can connect to a local MySql Database using:
SQLConn.ConnectionString = "Data Source=servername;" & _
"Initial Catalog=databasename;" & _
"User ID=username;" & _
"Password=userpassword;"
Where servername is "localhost". I need to make a connection to an online database (same data structure). What should I put at the servername in that case? I do have all the info about the database in question (Domain, Ip, etc...). Which part should i use?
Currently I have this "commands" to access to a database in my computer:
Public conn As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source= " & System.AppDomain.CurrentDomain.BaseDirectory & "bd2.mdb;Persist Security Info=False;")
Dim strSQL As String = SQLcommand
Public cmd As New OleDbCommand(strSQL, conn)
My question is: Is there a way to connect to that database online?
Example: bd2.mdb is on [URL]
im trying to read a online txt file and its not working [code]but it has a uri error i think in doing it wrong but need help with how im doing it wrong, all i want to do is read the text from a file online not from the system should be easy.
View 1 RepliesUsually, the text file that would need to be read and processed would be local (on the computer the program is run), but for this example, we need to get the data from an online text file.
I have searched on google for nearly an hour now and haven't found anything of any real use. One of the earlier projects we submitted used a similar target, and I managed to get it working fine, however I dont have the original source code with me and I cannot remember how I did it.
I believe I used a Net.WebRequest method of some sort, because I had tried using StreamReader and ended up with an URI error or something like that.
Is it possible for Forms to check for certain entries in an online mysql database and to create new ones? (login/registration)
View 8 Replies