how can i control Data Entry in 3 different table with BeginTranaction / Commit /Rollback in vb.net 2008. i am using sql server 2000 at back end and used SqlClient,SqlConnection, ExecNonQuery method.
View 1 Replies
I use in java JTable looks like a excell sheet create columns and rows and enter data in it.In vb 2008 what control i can use, I think table control layout not supported to data entry it supports control to in it and then add data .
View 1 RepliesI need to display all the data in that table but it only shows me the last entry.
db.OpenConnection()
strSQL = "SELECT * FROM BaselineTeam WHERE Process = '" & txtProcess.Text & "' " & _
"AND SubProcess = '" & txtSubProcess.Text & "'"[code]......
I am creating data entry form in vb.net. I have three tables 1.orders,2. orderdetails 3.productOrderid- Primary key for Order table and foreign key for Orderdetail table.In Dataentry form , I need when I load form , value of orderid from ordertable should automatically load in orderid colum of ordertable.
View 1 RepliesIm pretty use to doing loops (although still relative new to vb) in my code however am having difficulty setting up one that picks up an entry in one data table and then sums a field in another where records have matching criteria. Example:
[Code]...
What i am trying to do is set up a datagridview on a form that shows the summary data. The time is controlled on the form by a trackbar (output to textbox) and I started setting up a loop using (For/Next) to isolate firstly the matching entries in field 3 (time). This works fine. I then used compute to sum the the field 2. However what i want to do is to loop through table 2 and where entries match i.e. where Field 1 in table 2="A" sum matching entries in table 1 where the DateTime matches.
logic to build this kind of data entry form using grid controls in vb .net.
View 3 RepliesI have a DataGridView in a form. I want to control the entry of data in the columns with the event ChangeColumn for the associated DataTable.
View 4 RepliesI have a database containing usernames and "points". I need to increment the "points" at will. I have the table connected to a sqldatasource.
Here is my current code:
With Users
.UpdateCommand = "UPDATE Users SET points = points + 1"
.Update()
End With
This works great, except, instead of just changing the entry with the username specified by a QueryString, it changes all of the entries and adds one.The sqldatasource has the following select command:
SelectCommand="SELECT * FROM [Users] WHERE ([username] = @username)"
This command makes it so that only entries with the querystring specified username are displayed. This is really my first attempt at SQL.
[code]....
I have a sub that updates a form on certain occasions. Sometimes I need to update a form when some of the entries in my table will still have a NULL value. I used this code to prevent the sub from trying to fill the form fields with NULL data:
[Code]...
What is the best way to compare an Int entry from a table in a case statement?Using SQL server 2008 R2, Visual Basic Express with LINQ to SQL.The code I tried doesnt work:
Private Sub UpdateSetOpt()
Dim db = New ACEDataContext
Dim SRM = From q In db.Settings
[code]....
I made some progress and I am succesfully reading in reading in two columns of data to my DataGridView but now I am stuck. I have to search the first column for a particular number the read in that row and put the data in a variable to use, how do I search through this data?
Here is what I have so far:
vb
Private Sub RetrieveContacts()
Dim conn As New OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data Source=" & Application.StartupPath & "myTest.mdb")
Dim adapter As New OleDbDataAdapter("SELECT [PN], [SIZE] FROM MYTABLE", conn)
Dim dt As New DataTable("MYTABLE")
adapter.Fill(dt)
dgContacts.DataSource = dt
End Sub
Resources: Visual Studio 2008 Pro (currently in 90 days trial)
Platform: OS - Vista Home Prem 64-Bit
Language : Visual Basic
I'd like to bind my textbox into two (column)from different table is it possible to do this? I already know how to bind (one-to-one) controls and table.
I am looking to programme a button to check if an entry from a textbox exists within a table.
This will done via a button.
how I would code the button to make it query the table?
Iam trying to link a database to a website. I want the website to allow a user to make a username (OrgID) and password (OrgPassword) and have them apear in my database table (Organizer). This is the code I have so far, but I cannot get it to update the information in the database.
protected void RegisterUser_CreatedUser(object sender, EventArgs e)
{
if (txtUserName.Text != "" && OrgPassword.Text !="")
[code]....
I hope someone can help me. I have an ATM machine connected to a server. A form takes a textBox entry as a PIN number and matches it to a card number in the same table which is the primary key. The card number is in a comboBox.Selected Item. I have used a dataset to fill the comboBox as the form loads. I have tried for days and got nowhere.
View 6 RepliesI've done asp.net exclusively so long, and now I have to convert a small web app to a desktop app.
At one point in the web app, I dynamically generate a table of data and add it to a placeholder control.
I'm not sure how that would be done on a desktop app. Can anyone suggest a control or 'windows' way of doing that.
Using Table control: how to display data from connected MSSQL?
View 2 RepliesI am currently building a tool which uses access as the backend and excel as the user interface (I am unable to change the applications).I would like to be able to use the listview option, howver I haven't a clue and searching on the internet is causing me a headache.
Basically what I would like to do is get the heading names from the table in access and populate the listview, later on I will what it to look at specifc data to populate the list view.
My connections is already open, I think I'm ok witht he sql, its just the other bits.
I'm new to Visual Basic, VS2005.I've added a Table to the WebForm. At Default.aspx this code was added automatically:
[Code]...
I'm trying to create an option to select a specific entry in a SQL table if multiples exists. The Sub listed below is for a textbox (MOTxt) and a button (GotMO) for checking an MO# to pull from SQL. Based on the number entered, will populate other text boxes on the page with that row's data. There are exceptions to this, where the MONumber will be entered more than once with different data associated with each entry. So, here's my situation. If we have a duplicate MONumber listed in the table, it will populate the textboxes with the first entry it finds for an update.I would like to create a dynamic dropdownlist (that displays only if multiples are found) displaying the 'Name' field entries for each MONumber found, then once the correct name is selected from that list, to then populate the textboxes with that selected datarow.Here's my code behind:
Protected Sub GotMONum_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles GotMO.Click
Dim da As New SqlDataAdapter
[code].....
Currently we are using a VB script macro created in word to create some fairly simple forms based off of data entered on a data entry form. I am very new to VB, and I have been able to create many applications using forms, but I have absolutely no history creating reports. I have been reading up on the reports, and it looks like they are designed to use with data sources like tables. I merely want to take either data from the entry form, or from data derived internaly from processing the user entered data and populate a defined report "form". I have been searching, but there is so much on printing reports, that I feel overwhelmed. I am not looking for the exact answer as much as a link or place to look for a sample for what I want to do.
View 2 RepliesI have a form with textboxes for entering data. One of the textboxes is for entering a value that is always one character. How can I make the cursor automatically jump to the next control when a character has been entered? I'm thinking the key press and release event and then set focus but is there a better way?
View 3 Repliescreate website involving payments plus some data entry eg booking of some facilities with the main data kept at a LAN window system.
View 4 RepliesCODE:
That code works to read the entry data and to recognise the correct data, and the incorrect. However, even if entry is correct, the error msgbox will appear (x times of how many records there are in file), despite being navigated to the menu. Anyway that the Else isn't triggered when data is correct. Also for it to appear just one instead of (x times of how many records there are in file.)
I have an application that receives data input from an automated set of devices. This data stream I have managed to capture & get it into a list box which I can sort based on the Device ID & the time that the response was received.There is a set time window for the devices to transmit their data into the application and during this each device is not limited to the number of responses it can send (ie :- Device 1 can send in 2 responses where Device 3 can send in 40 responses, etc).All of the responses are captured, listed & sorted within the listbox (this bit is working ).I now need to extract the last (ie:- latest) entry in the listbox for each Device ID & this is where I am stuck. I can retrieve the last item in the list but cant seem to extract the last item for each Device ID.[code]
View 2 RepliesBasically, our users enter values onto a spreadsheet and I have been asked make the spreadsheet output to a CSV file preferably each one completed appears as a single line in the CSV.Upon examining the spreadsheet, I cannot figure out the best way of acheiving this, or if it is easily acheivable in the first place.I have attached an example of the spreadsheet data, to give it some context the spreadsheet records times that carers have visited a client, which can happen many times a day over many days per week, there is also a yes/no for each day on the sleepin.
View 5 RepliesI need to grab some data from a webpage but for me the main problem is I can't grab the data the way I want. I want to grab the data in a listview control but my code is fetching all data within any span tag (span class "inputFieldLabel" which is not required) in a single column of a listview control. I am giving the format (source) of the webpage below and my coding in vb.net (2008),
<br>
<span class="inputFieldLabel">Following Are ...</span>
<span class="inputFieldLabel">01/02/2011</span>
<span class="inputFieldLabel">And</span>
[Code].....
I am trying to create a form which will be fed by an underlying database to create multiple form fields for each entry in an underlying database table. This is for a program to monitor patients under anesthesia, and prior to surgery, the doctor will choose which monitors they will be using. Then, on the actual monitor screen which will pop up every X minutes, there will be a text box and a check box for each chosen monitor. I am relatively new to VB, so I have tried to illustrate what I am needing but using the logic that I know from my previous life in PHP.
I am using DevExpress's layout control to place the form fields, so that is the code in the middle of the first loop (on_load), and I know that part works, I just need to know how to name the fields and then recover those fields and commit the values to the database. (the text boxes are added to the database, the check boxes are used to determine if an entry is made for that monitor- i.e. at the end of surgery if a monitor is turned off). I know that my syntax for naming the fields is no where close to correct, and it probably would not work in PHP, but I remember doing something like this in a PHP application I built long ago. [Code]
How can I set a datagridview control to not add a new empty row when I add an entry?
View 2 RepliesI use VB in VS2010..My form has a textbox..I can control the keyboard entry by using the SuppressKeyPress method..However this does not work for the Menu key - I think it's the menu key - the one that looks like a combo with an arrow.This produces a large drop-down menu which I don't want.On checking various forums it appears that the following code should work..[code]
View 1 Replies
