Okay, I've made a local database now and everything is okay. But I don't want the normal data grid view, I want to display the information in a list view. How can I do that? Do I have to make some sql queries or something?
View 8 RepliestxtMsg.Text = "Message from " & e.MSISDN & " . Message - " & e.TextMessage &ControlChars.CrLfand i want to change it to insert into a listview instead.Eg inserting the e.MSISDN information into a FROM column of the listview.
View 2 RepliesI'm trying to insert information from a form to an Access database. I get the error: Object reference not set to an instance of an object. It points the line: dsWHNewRow = WHds.Tables("WeightHeight").NewRow() in the btnAdd_Click Sub. I'm sure I'm missing something but don't know what to look for.
Public Class WeightHeightPopup
Dim WHcon As New OleDb.OleDbConnection
Dim dbWHProvider As String[code].......
I'm trying to add information to a SQL database. I've had trouble getting it to update (and I'm only doing one entry at a time!). However, even one at a time gives me trouble. The red line of code gives me this error: Update requires a valid InsertCommand when passed DataRow collection with new rows. what I'm doing wrong--I think it may be syntax, but I'm think the parameters are correct.
[Code]...
I'm having a problem with loading my MS Access Database. I can get it to load but it won't load in a row. My friend told me to try this but it puts all the information in a column instead of putting all the information spread out accross the row.
Here's my code:
Dim lb_Connection As New OleDb.OleDbConnection
lb_Connection.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE = pass_database.mdb"
Dim lb_SelectCommand As New OleDb.OleDbCommand
[Code] .....
Also I'll attach an image of what the program does when I load it.
I have been working on this for days and cannot figure out whats going on. I have a listview that displays information from a database. The program takes care of the rest. It's a reminder program that shows the next month due,days remaining, months remaining, and name. I have the program where I want it and it work great, but I want to add a bi-weekly to it.
Here's code well some of it.
Private Sub loadbills()
Me.openstate()
Dim i As Integer
lstView.Items.Clear()
[CODE]...
i'm have a payment form and a listview in this form. i'm adding about 3 item in the listview, so it has 3 row. but how can i insert the items in one of the column into database.
for example for listview
id item netmount
123 Stock1 113.00
[code]....
right now i'm trying to google some related article about LINQ to better understand it. But I came across with this issue been googling to find some answer but I didn't get lucky so here my problem.
For Each lvItem As ListViewItem In lv_orderlist.Items
passSQL = "INSERT INTO t_selling_history (f_product_id_fk, f_qty, f_qty, f_user_id_fk, f_created_dt, f_trans_status)" _
[code].....
I'm trying to add information to a ListView from a BackgroundWorker thread. I thought I could do this in this manner:
vb.net
Private Delegate Sub _ListView(ByVal lvi As ListViewItem)
Public Sub test(ByVal lvi As ListViewItem)
[Code].....
When I attempt to run the "test" sub the BackgroundWorker, I get an error:
Argument not specified for parameter 'lvi' of 'Public Syb test(lvi as System.Windows.Forms.ListViewItem)'.
Is there something I need to specify when declaring the sub, or in the sub itself?
i was coding vb6 since 4 years.and few month ago i decided to learn Vb.net and i'am working with VS08I'm would use this Socket class HereBy jmcilhinneyBut i need to replace ComboBox by a ListView and i don't really know how to do that because the both don't work
View 4 RepliesI would like to know if it is possible if the columns of the listview can be resized automatically based on the information in the listview?
View 4 RepliesI'm using a OleDB connection to a access database. I'm entering a row into the database to set some user preferences. What i need to get is get back the row ID of the row I just entered. I'm more familiar with PHP and with PHP I use use this entry
[Code]...
Public Class ReceiptSpectacles
Private Sub ReceiptSpectacles_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[code].....
The program is currently trying to pull information from three different database tables and compiling the information onto one screen, to do this i am using three different connections and a function to handle the data at each stage. The issue is as my code hits PageLoadStage of "2" and runs the QueryDatabase() Function i am encountering an error of: "OleDB exception unhandled: No value given for one or more of the required parameters." This occurs on line 15 of the first code snippet. Can anyone explain this and/or identify any code issues if that is the cause.
[Code]...
My university has a website that students can use to check stuff like their lesson schedules, latest grades, exam times, etc. Just general information about you and your study (after you have logged in of course).For interested, this is the website (not much use without a login obviously, but still): [URL]I have been thinking lately that it would be nice to have a desktop application that could give me the same information. However, I have absolutely no idea how that would work, and whether or not it is even possible. I mean, technically it should be possible for me to get the information (how else does the website get it) provided it is not secured (even when using the correct login details). I am sure the website communicates with a database somewhere. Does that mean I could theoretically also communicate with the database (probably: read from it only, not write) for example by executing queries?If that is possible, how do I figure out which queries to use for the different pieces of information? Obviously I don't know the details of the database so I can't just send a random query and expect it to work...
View 8 RepliesI have to use a northwind database to display customer and order information. Populate a combo box with the CompanyName sorted in alphabetic order. Display the customer information in bound labels and the order information in a grid. For customers, display id,name,title,phone. For orders display the order id order date required date and shipped date. how to connect the access database file to vb.
View 3 RepliesCurrently I have been using mysql connectors to send and retreive information from my database. Someone suggested that a web service (wdsl? etc) would be a more efficient way of sending information both ways.
View 9 Repliesi have this code
Public Sub insertMe(ByVal MyQuerrys As String)
On Error GoTo errorhandler
Dim constring As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source =
[code].....
I am trying to insert data into my database but no database is being added. The file is being opened as the date modified changes each time I try to add data. Below is my
Try
cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=W:Textvertisingdatabase.accdb;")
cn.Open()
[Code] .....
Database table is called SMS. No data is being inserted to the database.
First Steps I have a code to generate A I have another line of code that will generate another code from A (called B)
2nd Step I want in a table two columns, one for A one for B
I want the data A and B to be inserted in the database after the First Steps is done. Ex. line #1 of the table, B shud be the generated code for A.
I'm able to do the first step, but i don't know how i shud insert the data to the database?
I created table named "tb_sale" using ms access 2007, it has 5 columns (date, product, qty, price, total)
I created a listview which has same columns with tb_sale (date, product, qty, price, total) Then, I dragged a datagrid (tb_saledatagridview) from tb_sale to the form, hoping i can insert multiple records from listview to tb_saledatagridview.
I manage to insert record from listview to unbound datagrid, but not for bound datagrid. code that I can use to insert and save data from the listview to tb_saledatagridview.
I have a form that contains a Textbox + Three sets of radiobuttons.
my project idea is to store in any database the values selected or entered by the user.
Textbox goes Name.
First set of radiobuttons are the job position - manager - superviser etc....
Second set "" "" the Period (Shift)- day - nite
Third set "" "" The Condition - part-time - full-time
Anyway, my problem is how to insert those values into a database, something very simple such as MSAccess (is possible?)
I have made a small form where I have bound textbox with records from database.Although my code for inserting and updating the record seems fine and working. But when I view the database, tables i see no inserts/updates made there. But When I run my application again, I see the records in the bound textbox but only for some seconds (for around 1 and half minutes), although they are not shown in the database (tables) actually.
When I close the application and run again it after 1-2 minutes there are no more records bound to the textbox, since no records at all.How can this be possible. I don't have any idea what's going on.
I have been using visual studio 2008 and sql server.Code I have been using for ::
'Update the Records Private Sub btnUpdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnUpdate.Click
[Code]...
How i can insert information from the Row in datagridview into textboxes?now i made an access db then i made 7 textboxes to add information in my db no how i can reverse this action :
that i select any row to show the information every thing in his text box ?
i am developing a vb.net 2008 application. I use oledb to connect to oracle is there any way to insert a clob field in oracle from vb.net 2008 ?
View 1 Repliesi am a beginner level member of vs2008i had create a interface. In Daily Transec.vb form i cant insert, edit, delete, go prev and net data. already i had created a localdatabase as "Expense"need you help to complete itso this is request to u that plz chk the link file and complete the DailyTran.vb form. nothing else
View 2 RepliesI need to import data from Excel into a MySQL 5 database. The format of the column in excel is set to "Time". the field value looks something like this:
17:20:00 If I do this in my vb.net
strTimeIn1 = Trim(jobdt.Rows(j).Item(7).ToString)
I get this in my Immediate window when debugging:
"12/30/1899 4:10:00 PM"
what's the correct way to convert that string to a time value so I can insert into a datetime field in my database with no issues.
I have seen listview controls before that do not show any type of ID. (ie: Items in an order). So when I delete this row, how does it know which row to delete in my database? There could be many rows with the same exact data but each belonging to a different order. Would there be a hidden column with the record ID in it? If it is a hidden column, how would I go about this?
I've used this method for returning id's for ComboBox's and Listbox's:[URL]
I'm quite new into the programming game, I've been working on this program for a few weeks now, and its coming along, but the method I searched for entering new rows of data into my table doesn't seem to update my tables after I try entering data. I have a feeling it may be something very simple that i am over looking.
Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)
Handles Button4.Click
Dim conn As New SqlConnection("my datasource")
[code].....
I am using this code to Add rows to a SQL database, and it adds the row to the SQL database if column 7 is not null. After it adds the row to the SQL database, it deletes it from the Access Dataset, and updates the Access Database. Sometimes double rows seem to get inserted into the database, so I'm thinking there is an error in my logic somewhere here.
Dim rowcount As Integer = AccessDataSet.AccessTbl.Rows.Count
Dim y As Integer = 0
For x = 0 To rowcount - 1
txtRow = AccessDataSet.AccessTbl(y)
If IsDBNull(txtRow(7)) = False Then
[Code] .....