I've managed to put together some code to retrieve data from a sql file. I plan to connect to a sql server that are operated by a database program, that update the registry every 10 sec.
Before I try to connect my program to the sql database, I need to know if my program will prohibit other progrograms to read and write to the database.
My program:
Imports System.Data.SqlClient
Public Class Form1
Dim SQLRead As SqlDataReader
[Code].....
I need to read the email from the mail server that is in my intranet from my application server.
View 9 RepliesIam using VB.net to read an XML file in to SQL server. I am using VBs XML parser to read nodes, elements, etc. When an element's value contains a LE symbol and I insert the string in SQL, the resultant SQL record contains an Equal sign and not an LE.
I cannot examine the string for this character before inserting into SQL because I cannot find an ANSII equivalent. Normally I could find it with iPositiion = Instr("XML String", chr(??)). That does not work because there does not seem to be a number for the ?? that represents a LE. Someone suggested using 263 but that is a small o with a accent. iPosition = Instr("XML String", chr(263)) returns a -1, i.e. chr(263) was not found.
I have an SQL database set up on my web server. Is it possible to read from a table in that database and display a value in a textbox, for example? I want to store valid values in a server database and then check the entered values in the application against the server values.
View 2 RepliesBeen away from coding for almost 10 years, trying to get back into it but am a bit rusty. I have been asked to write a program that will allow users on a network to write hire data, driver data, job calander etc to a SQL database. The program works perfectly at the moment apart from one thing.
The program must allow the users to add an image to a drivers record to have on file, I have read loads of different forums, tutorials etc on how to do this and have managed to get my program to size the image properly and store it as binary data (i think) in the SQL database. I am now having problems doing the reverse and making the program read from the database and display the image in a picture box, the following is my code to save to the database
vb.net
Private Sub OpenFileDialog1_FileOk(ByVal sender As System.Object, ByVal e As System.ComponentModel.CancelEventArgs) Handles OpenFileDialog1.FileOk
Dim strm As System.IO.Stream
[Code]....
I understand that there may be easier ways to do this, this is simply the way I did this years ago, if any one can give me any pointers or any tips on how to read from the DB and display the image in a picturebox
I want to read pdf file in the database sql server
but i want to read from my application or open adobe reader
It turns out I wasn't checking the path that it was looking up, quite silly of me. Once I tracked that problem down and corrected the offending path, the reading worked just fine. Still baffled at the MSSQL issue, since the articles average less than 10 000 bytes.
Clarification:I am unsure if some of you are under the impression that the file I am trying to read is on my local machine. It resides on the web, on the same server as the script that is accessing it. Just in a different directory.
I wrote an online help desk application that includes articles. One problem I have run into is some of the articles are too long, and get truncated when I put them into my MSSQL database. I tried using TEXT and VARCHAR(MAX) as the data type, but it would still get truncated.So I decided that I would put the articles that are too long into a text file, and have my application read the text file from there. I got this code working in my development environment, but it does not work live:
[Code]...
At first, I thought it was because I did not change the /dev path prefix to /hlpdsk. But even after I changed it, it bombed out. What am I doing wrong?
how to read the registry and get all SQL server instances and databases installed and assign them to an array so I can then into the info into a datagridview?
View 9 RepliesI want to make something to read the text/strings sent to a server and maybe detect if the server is crashed or not and something to and some thing to send text/strings to a server maybe using winsock P.S. I also want to make something to crash my server.
View 2 RepliesHow to read users in sql server in vb .net. i want to synchronise users from sql with users from my application.
View 2 RepliesI'm trying to get a single field back from the data. (I am searching by a primary key so I should get 0 or 1 answer). Please help. The table that I am querying has one entry with user = someone, input to several columns with the ans column having "a good answer"
Code:
Dim reader As SqlDataReader
Dim par As SqlParameter
Dim result As String
[Code]...
I have a jpeg file in my C drive from my vb.net application I want to binary read it and store it in SQL server.
View 1 Replieshow i read data from Sql server and write that in .csv file with vb.net , after that saving the .csv file with my own name and path? what must i do? for information data in sql like this one:
[Code]....
how to work with XML.I need to create an multilingual application and need to save the controls captions in sql table with xml data typei started the following:[code]I know this is not very professional but thats all i did until know in SQLNow i have a problem in VB.NET i don't know how to read an xml data type (How to get the value from variables).If somebody can give me an exmaple how to read the xml than i would continue translating for each objects in the form where name is like the variable "btnLogin" and give it the controls.text property to the variables value.
View 5 RepliesI hate to ask this question on this forum, but I'm having a lot of trouble finding it on these online tutorials. Basically, I'm learning about SQL, VB.NET, and how to glue the two together, and I've learned about using SqlCommand.executeScalar() to get the first entry in a table. But that's all it's really good for, right? Or is there something more to the story here?
Basically, I'm wanting to ask about how to pull in a FULL table from a SQL database while using VB.NET, as well as how to pry substrings and stuff from it. Again I'm having to ask this on this forum because all these online tutorials seem to ignore the subject completely.
I need to solve the following problem:- Create a server application which generates a random number every second- Have any number of client applications access the current random number through a dll (associated to the server) at anytime How would I do this? Anyone has a prototype VB.Net code for the server which does this kind of thing? I'm pretty sure I know how to write the client code.
View 5 RepliesI am after some code that read several mailboxes on a particular server on the network and bring me back the date of the last mail within each one. Is this possible ?
View 2 RepliesI'm trying to create a VBasic executable to read a SQL server database and produce a mailing list.I have the SQL routine working fine and had set it up as a stored procedure, but I've just discovered the manager I've written this for is an Access-type and does not have SQL Server installed on her machine. So, I figured I'd make a front end in VBasic.
Dim con As New SqlClient.SqlConnection
con.ConnectionString = "Data Source=mySQLServer;User ID=Username;Password=myPass;"
con.Open()
I am developing a program that send sms to cellphone using a datacard.I can read the com port from the server if i run the program from the server, but i run the program from the terminal y read the com port of the terminal, but i need to read the port from the server for use datacard. What can i do? My code for read com port.
Function checkPort() As String
Dim intPort, X As Long
Dim strAbierto As String[code].........
Basicly I want to create a server that can read data sent by multiply clients and give feedback to them I have found some tutorials before but its only oneway trafic (Client>>>>Server) and the server crashes as soon as the client is disconnected
ps. If its a tutorial with VB it will be nice other visual codes are also good
I was just wondering if it's possible to create an app that interacts with a database hosted on a web server... or is it only possible using VB.NET? Also if it is possible, is there any good documentation or tutorials I could reference?
View 2 RepliesI need to develop a service and install it into a w2003 box to read excel files a then process its info. The process is as follows, users will upload excel files using FTP and then my service must take those files, validate and then update a SQL Server DB.
The application runs fine on my computer but on the server it asks for the libraries but when I try to install the MS office 2003 Primary Interop Assemblies, system displays "Please install Microsoft Office 2003 before installing the product".
I'd prefer to stay away of any server upgrade as we should require OKs, etc.. so, is there a simple way to just read excel files without having to install any update in the server.
I am trying to read JSON data from a server to a dataset object, any idea on how this can be done. I have tried using the DataContractJsonSerializer class but it only seems to work for objects.
JSON Data
{
"firstName": "John",
"lastName": "Smith",
[code]....
The code above works to an object, but I want to parse the JSON data to a dataset object.
I know how to select items from an array with LINQ, but what I can't figure out how to do is access a database using an IQueryable. I connected the database to my project, added two classes from the database to the "LINQ to SQL" .dbml file and saved it. In my programming assignment, I am not supposed to create a data source (table thing) to display the data, but update my own interface manually. In order to do it, I was told to instantiate this:
Private dogs As System.Linq.IQueryable(Of Dog)
(Dog is a class that I added to my .dbml file from the database file)Also, I am told it involves using a method
.AsEnumerable.ElementAt(index As Integer)
Trying to use asp.net for the first time. I want to read a single value from a sql server database.
I have configured the SqldataSource as:
CODE:
I have the above asp:SqlDataSource code on the website page. The connection string is in the web.config file. When I run the page it is all works but the required data is not shown. Am I right to think that where I dragged the sqldatasource entity is where the data result should be shown?
im trying to make a little application that will read an fps server chat log.the chat logs are plain text files that come in the format :
Billy says: yada yada yada
Bob says: mooo
on certain key phrases (which will be user defined) it will reply (also user defined) now my problems. (there are many). most of which stem from not actually knowing any syntax for this language.firstly im suffering something of a huge brain fart with trying to read only the last line. i have it currently reading though the whole file and counting line numbers but then i just hit a wall . what do i do with the line number? i cant find a simple way to stop and come then have it check again after a couple of seconds for a new line? allegedly filestream can seek the end of the file however all my attempts to do anything with filestream have met with absolutle failure.
this is what i currently have for this, and it works to some degree
FileReader = New IO.StreamReader(OpenFileDialog1.FileName)
Do While FileReader.Peek <> -1
txtln = FileReader.ReadLine()
[code]....
i have the remnants of both the options ive considered in there, and its almost doing what i need it to . i just have no idea what to put into the last section to make it wait for another line to be added to the text file, or use the linenumber to make it check back from there for more lines. i cant seem to find a wait/sleep/pause so i just dont know.
my other problem is one of file access. i am aware of some properties of filestream that allow for a shared read/write access for other programs . however as i stated before . i have had no success even getting this simple peice of code to work with filestream.
I've been scrambling my brain to figure out how to access my FTP server thing to get a list of text files in a folder and to edit the contents of those files online.
View 1 RepliesI've got a bunch if labels that are changed as a user inputs data into a form of mine. The Labels are changes with js on the client side. I then after all the submission are in put use a vb script to pull the string values from these labels. The problem is the vb net part is not reading the new values of these labels. Anyway I can get it to read the new values? I have over 40 labels.
[Code]...
Quote:
Dim conReader As New StreamReader(con.GetStream)
Dim conCont As String = conReader.ReadLine
It just reads the first line of the server I'm trying to connect to, I want to make it read all the messages that the server is sending. btw, con is: Dim con As New TcpClient
I have a VB.Net project that creates a new Webbrowser instance which then navigates to a page in order to read the HTML into a variable ( then modify this before displaying in a visable webbrowser).The issue i have is that the webbrowser navigate just reads the page from the cache and does not read it from the server.
View 2 Replies