how do you retrieve a specific record from a database. i have a database with records of stock an i need to be able to check the stock for specific items on the database. The collumn is quantity and im trying to retrieve the integer value based on oledb querry "SELECT Quantity FROM Stock WHERE ItemID=ITemID"
btw i have tried oledb data reader but don't seem to understand it .
I hav a web service which pull records from a database and I am hosting these services in IIS which works fine but I am trying to retrieve the record and display the record in a listbox displaying the time field as the text for that record.I have created the following function
public sub get_data()
dim dt as new data.dataTable
dim service as ws webservice.webservice
[code]...
i want to create login form in VB.NET i will done a lot of work like inserting data and also retrieving data but i want to know that how can i get specific record from data base and want to match with my input .
Imports System.Data.OleDb
Public Class frmmain
Dim da As OleDbDataAdapter
[Code].....
Here is the structure of my database: i have textbox1 and textbox2 and 8 checkboxes in my ASP.NET (VB.NET) webform.i want to retrieve the seats on the particular dates means if i enter 11/12/2010 in textbox1 then in textbox2 the output would be from seat_select column, let say (1,2,3) where date would be 11/12/2010
If i enter 13/12/2010 in textbox1 then in textbox2 the output would be 1,2
I want it to take the text from the text box and use that to search the badge column from the db and tell me if it exists or not.[code]...
View 3 RepliesI have now wasted over two days going round & round in circles with the pathetic excuse for a Help System Microsoft now makes us put up with (& nearly blown my monthly broadband data cap doing so).I have lost count of the links that do not exist.The Give Feedback option also does not work (I do not like Microsoft Outlook, & in spite of having set Windows Mail as the default mail that doesn't work either!).Every VB example I have downloaded has failed to operate as it should (if at all), so surprise, surprise nor does my implementation of what they say is how to do it! please give me the "exec summary" version of what I need, ON ONE PAGE which is: Correct way (& syntax) to (in VB code):
1 Open an existing SQL compact 3.5 database THAT IS WHERE I SPECIFY - NOT WHERE the wizards keep saying it is(it against my instructions)!
2 Search to see if a particular record exists in the database (eg WHERE ColumnName. FieldContents = ContentsImLookingFor)?
3 Retrieve the found record into my own record buffer?
3 Add the record if it does not exist?
4 Change the record?
5 Delete the record?
6 Close the database?
The rest I will do MY WAY, a thousand times faster & more efficiently than anything I've seen "documented" so far. Surely that is not a huge ask requiring GBs of "Help" garbage leading nowhere?I've only been programming for 25 years (but not in this environment),
I am trying to check a record in database before inerting a new record here is my code but problem is when i enter a names first alphabet it imediatly populate massage. i want to check it after entering whole name
Private Sub TextBox1_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles TextBox1.KeyPress
Try
Dim cnString As String = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" &
[CODE]...
How can i retrieve last updated EmpID form sql database.
View 1 RepliesI have a problem with my program, and it's really bad because I need to burn it to disk within 12 hours and I can't get it to work: If I create a record, add information to it and click on Next Record, the ID, Status and Notes boxes content will change but the rest of the controls contents are carried over to the next record and I don't know why or how. It was working perfectly but now it stopped and I never done anything.
View 8 RepliesI have records in a database. Each record has a Picture path in it eg. "C:\Pics\Image1.jpg". I would like to display a record from my database and also the picture for that record, in a .rdlc report in vb .net 2008. i have succeded in displaying the record but just can't get the picture to show. I am using an Imagebox in the report.
View 2 RepliesWhen I to connect to remote host to retrieve sql record...
it execute to few minute will get his error message... but there is already work perfectly and get connected... it loop it a few record only will occur this error...
"Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host."
I had tried to use SQL statement to retrieve data record from SQL server, but when the database grow, the query speed getting slower. I just want to get most recent 5 records, any way to make it fast? Below is the SQL
SELECT Top (5) EventNumber, IP, DateTime, DateTimeStamp, EsdMaxLog, EsdMaxLin, EsdMaxAbs, EsdCntAll, EsdCntLast, SvMax, SvCurrent, EsdLimLog, EsdLimLin,
EsdLimAbs, Distance, SvRange, CdmFilter
[code]....
Having a bit of block trying to get comments for a specific post. Working with MVC 3 and VBNET. A post url looks like /Blog/Post/1. I can display the post without problem but need to get the comments for PostId=1 from the Comments table. I tried a Linq inner join statement
Dim results = From P In _rdsqlconn.Posts Where P.PostId = id Join c In _rdsqlconn.Comments On P.PostId Equals c.PostId Select P
Public Class RDSQLConn
[Code]....
However a SQL query such as the one below works just fine. Can i just pass in this sql statement to my EF?
Select * From Posts INNER JOIN Comments on dbo.Posts.PostId = Comments.PostId where dbo.Posts.PostId = 1
Anyone knows how to get the line number of a specific line in a .txt file?[code]...
View 17 RepliesI have an Intel Hex file with multi-line hex values -
100000010203320AE1100580099A23F0E26007E3
1001000E0223625AF16004800A9F24F0B2701742
I need to retrieve specific values in some addresses. E.g. If I want to read the 8th byte of the first line, 0x0A and the 9th byte of the second line, 0xF1, how to read them by opening this file?
I have only recently discovered the world of fetching online data using XML functions in VB.NET and it has been working well so far. Unfortunately I have hit a hurdle and am unsure as to how I should proceed. Until now I have been working with simple XML files where there was only 1 value to retrieve with a specific XML element path. Now I have an XML which looks like this (apostrophes to represent indentation):
<?xml version='1.0' encoding='UTF-8'?>
<eveapi version="1">
''<currentTime>2007-12-12 11:48:50</currentTime>
''<result>
''''<rowset name="characters" key="characterID" columns="name,characterID,corporationName,corporationID">
[Code] .....
I need to have the program assign the first row's name attribute to one combo box, the second to another combo box and the same with the last.
I have a access database with these columns. USER_ID,COUNT,TIMES
Let say the current record is this:
USER_ID,COUNT,TIMES
STEVE20,24,1.5
Now I want to updated the current count record and times, but before updating I want the old record to be added to the new record. What should be my query?
I am using a not equal operator <> in my sql statement but it doesn't retrieve any record which is not equal to the selected date.
CODE:
Command = New SqlCommand("SELECT * FROM [Products] WHERE [ParkingStartDate] <> @StartDate", myConn)
Command.Parameters.AddWithValue("@StartDate", StartDate1)
I have a simple application for taking Customer orders and their Products. I am using Visual Studio 2008 Express Edition and MS Access 2007.My application uses multiple forms. One of the forms is an Add form from where a New Customer along with his/her details like address, phone, city, state etc can be added. Another form is for the Product Details to be added.I want to know how to retrieve a CustomerID from an MS Access 2007 database for either the newly added Customer or an existing one and insert multiple rows or records for the same CustomerID, as a Customer can order multiple products. I am using the following code for the Add button:
Private Sub cmdAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdAdd.Click
[code]......
how to retrieve record from table that i have done using the select query but i want those data to display in the text boxes.
View 4 RepliesI have a datagridview that is filled by a query in the dataabse via the DataSource property.What I want to retrieve some infomation from the record that a user selects in the DataGridView. How do I do that? i've been looking for some time now but I can;t figure it out.
View 6 RepliesI am attempting to loop through each record in dtlist and compare it to each record in dtsold get the distances and retrive the max value I get an error on the line:
[Code]...
I need to know how to retrieve data from a specific place in a .txt file.[code]...
Also, how would I write to Jim and not Name, or how would I write to 52 and not Age?
I know this has to be a very simple answer but I seem to be overlooking it. I have an Access database that I have conected to and have created a DataSet. The DataSet consists of one table with several rows and a bunch of columns. What I am trying to do is get the data for one specific row and column so that I can use this data is some calculations. I can position the row if I need to but I can't figure out how to get the data in the specific column I need.
View 3 RepliesI do encounter interest problem when I am using VBNet2008 and SQL Server 2000. I am developing Window Application and one of the form I am using SQL String with Date between to retrieve specific data from SQL SERVER 2000 Table and it's not working and generated this error message:
Invalid column name strFromDate
Invalid column name strToDate
Here are the overall coding:
Dim sqlconn As SqlConnection
Dim sqlcmd As SqlCommand
Dim DA As SqlDataAdapter
Dim DR As SqlDataReader
[Code] .....
I got the following code from codeproject.com:
Dim objOL As Outlook.Application
Dim objNS As Outlook.NameSpace
Dim objFolder As Outlook.Folders
[Code].....
Now, I got as far as making the default folder the Inbox. What I would like to do is to extend the functionality by retrieving only a specific person's emails and extracting and saving whatever attachments he/she sends. Also, I get the following error when the code reaches the Dim Atmt as Outlook.Attachment part: Public member 'Attachment' on type 'Object' not found. I need this function to retrieve the attachments. I've tried different things, but nothing's worked.
I have used .NET and ShDocVw for years to grab data off webpages without any issues I couldn't overcome. This website has me beat though. It seems like such as easy task to grab the titles and other information off a library search page, but I can't see the data to be able to grab it. Usually, I just look in the DOM, but the data wasn't there. I did a view source, but the data wasn't there.
View 1 Replieshow to view the next record and previous record in the database.? just like in the picture below.? what condition should we use.?
View 8 RepliesImports System.Data.SqlClient
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim connetionString As String
Dim connection As SqlConnection
[code]....
How would I access a specific record and put it into a variable to compare against user input?I have a table CASHIERS and part of that table is a BadgeID and a PIN number. What I want to do is when a cashier swipes there badge to logon to a POS.. it searches the DB to see if the cashier exists. Then, once it establishes that they do exist, it pulls their PIN # and prompts them to enter it. It compares the data retrieved from the DB to the data that they entered.
I am using crystal report to make my report. But problem is that I cant use same SQL Command there in report parameter because its different. I am going to show you my code so that you can understand it. I have a report & a form where I have one text box one button & one crystal report viewer. I have imported all fields by using report wizard. Even I have created parameter(name) there. So that user can get specific record by typing it there in the text box. However here is my code for button1:
Imports CrystalDecisions.CrystalReports.Engine
Imports CrystalDecisions.Shared
Public Class Form1
[Code]......
It means it will not show student`s ID & name again & again. On the top of the report it will show student`s ID & name for once & depending on ID it will show student`s mark on report. I guess I have to use something like that Select * from result where text1.text = name of the parameter. But problem is that I cant use same command there in formula workshop.