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 RepliesI want to read pdf file in the database sql server
but i want to read from my application or open adobe reader
I 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'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 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 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?
I am trying to create a console application that does the following:
1) read a text file
2) Save the content over to a SQL Server database
3) Use command line arguments to allow user to specify any delimited file
I need to read the email from the mail server that is in my intranet from my application server.
View 9 RepliesI have created my site using ASP.NET Personal Starter Kits 3.5. I use Visual Studio 2008 only . .with its built-in SQL Server (2005 Express) ... my database in App_Data is ASPNETDB.MDF ...I have created some of my tables also ....in ASPNETDB ..In my local PC the site was running fine ...But when I publish my site on production server it doesn't work and shows the following error
<!-- Web.Config Configuration File -->
<configuration>
<system.web>
[code].....
I have developed a VB.NET program using a strongly typed dataset. This dataset has its connection to a SQL Server 2008 R2. The software should now be additionally used offline. The database should be exported to a *.sdf database. If no connection to the SQL server is produced, the software have to try to connect to the *.sdf database.I would like to achieve:
1. Export the data in the SQL Server 2008 R2 database to a local *.sdf file.
2. This *.sdf file has to work as an alternate connection string in the strongly typed dataset.
How can I write a connection string? I has four different computer that can be connect via ethernet.How can I maintain a inserting data if to computer insert on same table at a single time..??
View 1 RepliesI am tring to make the below application work with SQL Server 2005 Database Currently it works for test.mdb, which is in the same folder with the application. How shoud I modify the MapPath to work with SQL Server.
[Code]...
i have a app in visual basic mobile 2008, so i finish but now i need to tranfer the data generate in the in the app mobile to data base in sql server 2008.
View 1 RepliesWhen I install my application, some forms are unable to connect to the database.
I say some because, when my login form works totally fine. Authentication happens.
But once I go into the main application, and open other windows, I start to get these error mesages:
[URL]
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].....
Iam 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.
Been 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 recently upgraded the MS SQL Server installed on my personal computer from 2005 Express to 2008 Express. Problem is when I try to add an SQL database file to a project using VS 2005 I get an error message saying that the version of my database server is not supported, I must have SQL Server 2005 Beta 2 or later installed. I didn't do it yet but I'm pretty sure that when I open the other projects that I included a database file to it, I'm going to get the same error.
My question is it possible to have two SQL Servers installed on my machine? If so, is it a good idea to have two DB servers in the same machine?
Ive created one database Sql Server Compact Edition 2005, with one table ("Cliente") I know that I can created my database good, but i have a problem saving information since three textbox, in my table(With columns "Nombre" "Apellido" "Cliente". In my form there is a button save ("Guardar"). When I do click in my button appear the next message : "The column cannot contain null values. [ Column name = Nombre,Table name = Cliente ] " and happen the same with apellido and Id_Cliente. And this happen becouse my code cant save the information....
This is the code
Option Explicit On
Option Strict On
Imports System
Imports System.IO
Imports System.Data
[CODE]...
And the code for my button is:
Private Sub cmdguardar_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdguardar.Click
Dim myconnection As SqlCeConnection
Dim mycommand As SqlCeCommand
[CODE]...
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]...
O/S WIndows 7
SQL Server : SQL Express 2008 R2
VB 2010 Express
SQL Server is located on the workstation so the code and the DB are on the same PC
Created a DB connection using the wizard. Tried this with Windows authentication and SQL authentication using sa
Created a Dataset and dragged the grid onto the form1.vb.
In SQL Sertver Management Studio I can update update tables using the same credentials as in the VB connection string
WHen I try to update a record in the VB Dataset it returns the error cannot update database because it is read-only
I have checked the files and folder attributes in SQL Data folder. Nothing is set to read only
I have checked SQL Server Database > Properties > Option > State > Databse Read only = false
I don't what I'm doing wrong here but I cannot get VB to update data via the dataset.
Inotice in SQL Server that the DBname now includes the full path "C:PROGRAM FILESMICROSOFT SQL SERVERMSSQL10_50.SQLEXPRESSMSSQLDATAPAYABLES.MDF" and not just the DB name. Is this becuase VB Express requires you to point to the physical DB file?
before re-inventing the wheel, i want to ask you how i can do this best: I have a VB.Net application that uses a database connection to MS SQL Server 2005 (express version). There are users that input data with the application into the database lets say once to 2x an hour to once a minute. I want to do backups like this: Once a day or once a week (in the evening) a full backup, and whenever the program/user is idle for lets say 10 Minutes, i want to do an incremental backup (so that it does not take so long until he can work on after the backup).
There are no big security issues, just copying the backup data files to a network share / a different computer or server would be fine. i guess the average db size may be 300MB, but the daily increments about 1MB.
[Code]...
I work with vb.net I have a sqlServer database and i need to migrate to a DBF database.I know that a dbf file sctructure is a hexadecimal text file.I want to generate this file without a provider...building this file with this hexadecimal structure.
View 1 RepliesI have a problem here... I'm using SQL Server as may database and developing that database in Visual Studio 2008.my problen is, when I use the STORED PROCEDURE from SQL SERVER it doesn't update/save new data on a the table. here's my coding; This is my stores procedure: when I execute this on on SQL SERVER it worked perfectly.
[Code]...
I am trying to make a copy of an existing database, I use .net framework data provider for SQL Server.I get error "Unable to connect to source server for Transfer" when it runs to oPackage.Execute().
oConnection = oPackage.Connections.New("what the providerID should be?")
oStep = oPackage.Steps.New
oTask = oPackage.Tasks.New("DTSTransferObjectsTask")[code]......