I am using a sqldatareader to read some values into a form from my database. I would like to know the number of rows returned by my query and I cant figure out how to do this. I want to use the number of rows returned so that I can redimension an array of values to the correct size. Here is my code I am working with:
[Code]...
Some tables I am dealing with have null values and are throwing errors. So far ive tried a few solutions to deal with the nulls with no success.Here are the code samples from my efforts so far;
If (r("datemodified").Equals(DBNull.Value)) Then
datemodified = String.Empty
Else[code]....
i have ran the query and it is working ok (i.e all the cols exist)
Dim myreader As SqlDataReader = cmd.ExecuteReader
'read information from the database and give the values to the arguments(column_1, and column_2)
While myreader.Read
column_1 = myreader.GetString(1)
column_2 = myreader.GetString(2)
.....
I get an error when the data returned from myreader.GetString(2) is NULL. How do I check for nulls before assigning column_2 a value?
Some tables I am dealing with have null values and are throwing errors. So far ive tried a few solutions to deal with the nulls with no success.
Here are the code samples from my efforts so far;
If (r("datemodified").Equals(DBNull.Value)) Then
datemodified = String.Empty
[code].....
When 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]
Imports
System.IO
Imports
System.Windows.Forms
Imports
[CODE]...
I don't understand why nothing is being returned from the SQL)
I'm creating a small program to read from an SQL server, loading result into an array, pivoting the array to my liking and mailing it out to selected members of a group. It's going to be run once a day with Windows schedule. I have the connection, query and mail sorted, but not the datareader to array bit.
(line 26)?
Imports System.Data
Imports System.Data.SqlClient
Imports System.Net.Mail
[CODE]...
I used this coding for a reading column name from access database. But i want how to read every field values of that particular column?
dim dr as oledbdatareader
dr.item(1).tostring
Having abit of trouble with inserting values that i have in my form into my sql database.Basically it supposed to calculate a customer who borrowed a DVD or CD. I select the date that the customer brings the returned item by selecting a datepicker. The calculation works fine, but i want to insert 3 values into my database under column names that i already have.
The table name is Trnsaction. it has the following coloumn names: Trnsaction_id Member_id Album_id issue_date return_date members_date days_delayed fine The last 3 coloumns(members_date ,days_delayed ,fine) are values i wish to add to my database. The values days_delayed and fine only pop up when i have selected my date (thats members_date) form the datepicker and selected the calculate button
populate values from a database(Access) in to vb.net form. after selecting a field from first form , the next form should display all the parameters used in the selected field from the data base. Also if do editing n press update it shuld be updated in the database.
[Code]...
Hhow can i retrieve the database values and display it on vb.net form
View 4 RepliesI have a DEM file(Digital Elevattion Model File) and I am trying to open the file,where we have Latitude and Longitude values inside the DEM file.And, Now I have opened the file using Filestream and Read the file using BinaryReader.But, I am having a trobule in getting the values of Latitude and Longitude.I am getting Byte values randomly as 1,202,31,271 etc.But, we dont have latitude and longitude values more than 180,and also I am not getting 16 bit UInt values.For example, the values should be like Latitude 20.00416666666667 and Longitude 39.99583333333333.So,read the correct Byte values of the DEM file.The code I have used till now is:
Dim fs As FileStream = New FileStream("C:UsersadminDesktopHeader and DEM fileE020N40.DEM", FileMode.Open, FileAccess.Read)
Dim rd As New BinaryReader(fs)
Dim convertDB As UInt16
For i = 0 To rd.BaseStream.Length
[code]....
I am building VB.NET application that takes data from text files that are exported from a legacy DOS program. These are written to a datatable and displayed in a datagridview. Right now my code simply loops through the datagridview and inserts the data into the database (SQL Server). There is a requirement now that the client number must be checked before the insert to see if it exists in the database. If it does, then the value of one field (tax rate) is checked against the value of the field in the datagridview. If there is a difference, then the rate is to be updated in the database and the data that was in the database is to be written to a history table for audit purposes. If the client number is not there, then we are to do the insert (which is already written). I want to know what is the most elegant and efficient solution for this problem.
I need to compare what is in the database table with what is in the datagridview, update the history table for records that exist, and then insert new records.
I'm writing an asp.net page with a simple registration form that connects to my access database and inserts the values in the table. So I have my database, my registration page, everything looks fine in my code, but there's a syntax error I can't seem to figure out. When I go on my webpage and click submit, it says : Syntax error in INSERT INTO instruction.
Here's my code:
<%@Page language="vb" explicit="true" debug="true"%>
<%@Import Namespace="System.Data"%>
<%@Import Namespace="System.Data.OleDb"%>
[CODE]...
This is my problem.I have a field set up in MS Access to Boolean YES/NO, this field is populated when the user check a checkbox on a windows form. If the user check a checkbox, the value is written as checked in the data field (MS Access).The problem is when I search for the user information, I need the information from the Data base to populate(return) to the windows form. Example: If I enter a users phone number and the user data is present, the form gets populated with the information the user previously entered which was store in the database.Example: If the user selected checkbox1 and submits the form. When I search for the user info, the check box should check(populate) because the user had checked it on submit.Here is what I have done:
[code]...
I am getting the check value correctly in the database using a Boolean.Here is one of the errors I am getting. Unable to cast object of type
'System.Boolean' to type 'System.Windows.Forms.CheckBox.I am having trouble putting the codes in a code tag or block
I am creating an xml file with LINQ as follows...
Public Sub CreateXml()
Dim db As New MDataContext
Dim Customers = <gallery columns="3" rows="3">
[code]....
Could i mix local values with the ones returned from the LINQ query...Something like the following?
Public Sub CreateXml(ByVal **Col** As String, ByVal **Row** As String)
Dim db As New MDataContext
Dim Customers = <gallery columns="& **Col** &" rows="& **Row** &">
[code]...
I'm a "Moderate" skill programmer, and am upgrading some software I've written in VB.Net (VS2008, .Net 3.5), and need to be able to accomplish the following, which I'm not sure of the best way to go about doing: The software is an information reporting dashboard for a call centre. I have a csv file being created about every 10 seconds, extracted from the telephone software, the file consists of a list of "Skills" (basically telephone line types), the number of calls received on those lines, and the number of callers who hung up (and a few other bits of information I need, but once I figure the basics out, the rest should be easy), basically looking like the following:
[code]...
I need to be able to read this csv, store the data, filter out the "Skills" to be report on (i.e. 1,2, and 5 only), add up the "Offered" and "abandoned" data associated with them and then display this information as one number (i.e. "Skills 1,2,5 - Offered: 4925, Abandoned: 13") (and then the same for the other "Skills"). This data could grow as more phone lines are added or some are taken away.I've got the code to read the data into an array working, but I've got stuck with how to filter and add up the data. I'm not even sure if I can do this with an array.
You need to read the values from an array. What Visual Basic flow construct would you need to use to perform that action? What are the important keywords to include in that construct?
View 6 RepliesUsing VB.Net, I need to read the following XML from a string variable (not a file) and pull the AuthNo, Client ID, Client Name, Supplier ID, and Supplier Name for each Dispatch contained within the XML.
I have looked at tons of examples on the web using XMLReader but I can't figure out how to pull the separate ID's and match them up with their appropriate Names and also matched up with appropriate AuthNo.[code]...
I have an EXE that creates objects based on params passed to it.Say I have textboxes named 57 and 21.I want to read the values entered by the end user.
Var1=57.text
Var2=21.text
How do I pull this data from the boxes?
Within my service i have the following function in order to take some values from my registry[code]...
View 3 RepliesI'm new to VB.net and have only a few projects under my belt. This one has me stumped!! I need to open a file and search its contents hex byte by byte. (Similar to Hex editor). On finding a particular value I need to replace it with a set hex value then write and close the file. So far I have only managed to read / write the ascii equivilant.
View 4 RepliesOn my form I have a textbox called TxtSelectedEvType. On the other hand, I have a listview called lvwBatchHist which has two columns, BatchID and EvType respectively.
Now, I want to read all the values in EvType column and compare with the value in TxtSelectedEvType.Text, if they are the same write a message EvType is the same else call a function...
i.e.,
if TxtSelectedEvType.Text = (comparing from the column 'EvType' in lvxBatchHist) Then
MsgBox ("EvType Same", MsgBoxStyle.Information, "Test")
[Code].....
What I want is to have the ability for the user once the values are entered into the Textboxes, the user has the ability to save the values for retrival a some later time. This is what I have so far
[Code]...
I am creating a windows service in .Net 4.0 and testing some functions of said service with a windows forms client by referencing the service project.The service project has an App.config file and that file looks like this: [code]a null reference error is thrown because my connection string is not loaded.The only connectionStrings that are loaded are from the machine.config file located in [code]If I create an application scope setting for the service, I can get that setting by using the My.Settings.setting so it's not like the App.config file is not being read.why are my connectionStrings not being loaded from the App.config file?When referencing a project(parent) from another project(child), the child's app.config is used even if the parent's classes are being used.Thus, I can get the connectionStrings to show up if I copy them over to the child's app.config. When trying to open it manually, my currentDirectory was of the child, not the parent (strange how it did not throw an exception - it wouldn't have been able to find the config file it just silently used the machine.config.
View 4 Replies[code]i need to read data from specific cells and assign them to other cells.
View 4 RepliesI would like to read values set in a string that's retrieved from the Web, I've already got the string in a string called Webdata.The string is like so...
"Info" {
"Name" {
"Name1""Value1"
[code]....
I need to set Value1, Value2, Value3 as strings that I can use.
I am trying to read xml nodes values from lastfm web service that look like this:
<lfm status="ok">
<results for="stinkfist" xmlns:opensearch="http://a9.com/-/spec/opensearch/1.1/">
<opensearch:Query role="request" searchTerms="stinkfist" startPage="1" />
<opensearch:totalResults>188</opensearch:totalResults>
[Code]....
I need read csv file in this format each line (value1;value2;value3;value4) and save each value to separate variables.
View 2 Repliesim having problems with reading these values from XML with XElement Im trying to get Each value between <month> and </month>
<Document>
<Element>
<status>1</status>
<data>
[code]....