I'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 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.
How do i read information from a mysql server and write all info on table name links to a file?
View 3 RepliesI have SQL 2005 table with columns TypeId(int) & Description(ntext datatype).
The Description column has XML file content as value in the table.
Now i want to read the data into a dataset in VB.Net. How to do it in VB.Net. I am using Winforms and VB.Net in VS 2005.
I have SQL 2005 table with columns TypeId(int) & Description(ntext datatype). The Description column has XML file content as value in the table. Now i want to read the data into a dataset in VB.Net. How to do it in VB.Net. I am using Winforms and VB.Net in VS 2005. Below i have given the xml file content.
<?xml version="1.0" encoding="Windows-1252" ?> - <SummaryPageComponent xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> - <categories>
[Code].....
I am using VB.Net 2010 and SQL Server 2005 Enterprise Edition I have created a table named customer having columns (id int, fullname varchar(50)) and id is my primary key I have created a Class Library for inserting data into the customer table. to insert data I am using following code...
Public Function insertData(ByVal TableName As String, ByVal LinkToDb As SqlConnection, ByRef Adapter As SqlDataAdapter, ByRef DS As DataSet, ByVal MyArray As ArrayList) As Integer
' ----- inserts data into table
Dim sqlCmd As SqlCommand
[Code]...
what I am trying to do is i have a table with four records and I want to write it to a txt file. I am running sql server 2000.I am able to connect to my database and I am able to right data to a txt file my only problem is it always returns the 1st row of data.
Dim FILE_NAME As String = "C: emp est2.txt"
Dim conn As New SqlClient.SqlConnection
Dim da As New SqlClient.SqlDataAdapter
[code]....
i have a jpeg file which contains table of 10-15 rows...i want to read it through vb6 and save it in database table..
View 1 RepliesI have a job in my sql server which will execute every second and insert some data for me in my table. Now, I need to do vb.net application to check whether checkouttime column in that table got data or not and if there is data then I need to get the id of that row.
How can I monitor my table's data to check whether that column got data or not.
I have a datagrid with three columns of data and i need to save all those data to a table in SQL Server.
View 6 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 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 have to do an application using VB.Net .The application must be able to capture values from ms word data table and map them to ms excel sheet. For your information, i have over 6000 files ms word document, each of them contains 4 data tables using the same format .Then i have this code for read from data table 1 in document 1:
Dim
wb As
Excel.Workbook<br/>
[Code].....
How to insert data from a populated datagrid into sql server table and how to make the values conform to the specified datatypes construct in the sql server side. Assuming the datagrid headings have already been created in the sql server side.
View 6 RepliesI am using visual basic 2008 and sql server 2008. I am trying to retrieve data from a table in sql server 2008. I am using the following code
Dim cn As ADODB.Connection
cn = New ADODB.Connection()
Dim rs As ADODB.Recordset
rs = New ADODB.Recordset
Dim cnstr As String
[Code]...
VB.NET:i want to select data from sql server 2005 DB table and displaying into text box that depends on combo box selection using VB.NET
View 1 RepliesBasicly 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 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)
I am using Visual Studio 2005. I am using a data reader to read an Excel spreadsheet and want to update a SQL Express table. The datatypes in this table mimic a software application I will eventually be passing data to and are listed in the comments in my code. No matter what I do or change, this will not run. I even populated my spreadsheet with zeros and this will not run. I have found many suggestions on the web and tried changing things but nothing seems to work. I also don't know specifically which variable is causing the error or the proper way to make sure there are no blanks in this spreadsheet.The error says "conversion from string "" to 'Double' is not valid Here is my code:
Public Sub btnUpload_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnUpload.Click
'Connect to the Excel spreadsheet
Dim xConnStr As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & txtFileName.Text & ";" & _
using a data reader to read an Excel spreadsheet and want to update a SQL Express table
I THINK this should be a fairly simple fix, but my VB newbness is holding me back.I want to add data from various CSV files into a SQL Server staging table. Each CSV file has its own quirks as far as field names, more fields than the others, etc. go, so I'll need to map each CSV structure to the staging table in code.
[code]...
But it's no good, I get this error, "Input array is longer than the number of columns in this table." at "row.ItemArray = data".
SQL Server has a Data Type of "Float". Visual Studio has a Data Type of "Decimal". In other words, if I have a variable in a VB.Net app that is defined as a "Decimal" ...can I move that value into a SQL Server Data Table column defined as a "Float"?
View 4 RepliesI am wanting to pull data out a select table and wanting to use it locally as Read Only data I am stuck on how to write the data to the local Temporary table[code]...
View 1 RepliesI have three tables in my SQL Server DB. I need to import some CSV files into these tables. First table is a Order Table, which will contain all the order level information from that customer in that CSV File. Each order has multiple items and the second table is an item level data. Third table is a mapping table which shows the mapping for each customer . for a Customer say A ,
[Code]...
I have insert a data which is in binary format into sql server database table Column type of table is Image Type. I have to read this column from a XML file,I am able to read but
[Code]...
I have exported data from a SQL Server table into a XML file and the output looks like this:
Filename = 11190.xml
Table name = LRTest
<NewDataSet>
[Code].....
Now I want to save the above XML file into my SQL Server 2005 table
With the same columns using vb.net windows forms, in every exported xml file there are 100 to 200 records. .
Is it possible to manually save data from my dataGridView to my SQL server database table?
if it is possible can some please tell me how to do it because i don't like using the data sets and reader VB has because it doesn't give me full control over the procedure.
please see the code below it all works fine its just the last two line im struggling with, which is where i am trying to save the data from the two columns in my DataGridView [code]...
i am working on my academic project in which i need to retrieve data from sql server table to textbox and image in vb.net . i am able to retrive data either in text box or only image can anyone help me out to get data in textbox as wel as image in picturebox.
View 1 RepliesI defined a database using SQL Server 2008 R2 Express, and connected to it using Visual Basic 2010 Express. For some reason though, when I use the database in the program, it wants to start off using a negative primary key.Is there any way to make the primary key only a positive number?
View 3 Replies
