hi guys , i have a problem with my loading/refresh record in my form. i have only almost 500 record and take so long before refreshing/display the data. i have a user input form where user enter their record and while saving(direct to the database) and refreshing data i just call only my function getrec (). pls give me some idea to fix this problem. pls take a look Dim ActiveTable As New DataTable Private Sub frmRef_Userlist_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load getrec End Sub Private Sub dtBind(ByVal dt As DataTable) 'slow start here bs.DataSource = …

Member Avatar
Member Avatar
+0 forum 5

Hi guys, i have a project payroll, i need to create 3 reports (" Any kind report format ") im using databindingsource..

Member Avatar
Member Avatar
+0 forum 1

Guys, i have a project payroll system, i want to generate reports, im using databinding source to add, update, delete, data.. I need to create 3 reports "any kind report format". Example1 for payroll payslip: i have Emptable and payroll table. in emptable contains empID, empfname, emplname, etc.. and payroll table contains # of hours worked, rateperhour and rateperday, overtimeholiday, overtimeregular, grosspay, deductions, totaldeductions, and net income.. Guys i need help for my thesis.. For example in preview report: EmpID: P2012 Firstname: Emil Lastname: Acosta # of hoursworked: 8 Rateperday: 500 Rateperhour: 67 Overtimeholiday: Overtimeregular: Grosspay Deductions: TotalDeductions: Net Income: …

Member Avatar
+0 forum 0

Okay, I know some of you are looking at that title and thinking I'm quite daft because obviously I have to have a dataadapter if I have a bindingsource. And you're right, there is a dataadapter, but it's not exposed to me. I've taken over a winforms project (attached to a SQL Server database) that needs to completed quickly so am trying to work with what the other developer has rather than rewriting it all. He has an admin form with a listview and a datagridview. The idea is to allow a user to edit the lookup tables for the …

Member Avatar
Member Avatar
+0 forum 2

visual studio 2010 (vb.net window forms) access 2010 database multiple forms tab controls (2 tabs) groupboxes I have a BindingSource bound to a single row of a dataset.table The question is how to call and check the information of a single cell the cells are bound to textbox.text however on load when i call for information for those on tabpage2, they don't seem to populate fast enough to call from form_Load. I was wondering if there was a way to call they bound data directly from the biding source for example: [CODE]Private Sub frmEditCust_Load(ByVal sender As System.Object, ByVal e As …

Member Avatar
Member Avatar
+0 forum 6

Hi Daniweb, I spend a lot of time googling this problem and found no answer yet. The problem is I added a new column in my table, I have a dataset linked to that table and a source of data of my datagridview. Now, when I'm going to add a new column into my datagridview, I didn't find the new column which I added recently. Seems that the binding source is not updating whenever an update takes place. How could I add the new column without having to assign a new dataset again into my datagridview? Thanks in advanced Daniweb. …

Member Avatar
Member Avatar
+0 forum 9

I have general problem with bindingSource control In VS 2005 C# professional. In project I created new Form and: 1. added a BindingSource component named bindingSource1 and DataGridView control named dataGridView1. 2. binding bindingSource1 to data (DataSource), and the DataGridView controls to bindingSource1. 3. in bindingSource1 set properties DataMember to data. 4. adding a BindingNavigator control named bindingNavigator1 to my form. 5. seting the BindingSource property for bindingNavigator1 to bindingSource1. Program shows data from dataset and I tried delete records. I removed record using button delete from binding navigator. I dataset all working fine but binding source won’t commit any …

Member Avatar
Member Avatar
+0 forum 5

Hi.... I have a datepicker that contains an alternate key of an Access Table with a autokey primary key. [code] Private Sub DateTimePicker1_Validating(ByVal sender As Object, ByVal e As System.ComponentModel.CancelEventArgs) Handles DateTimePicker1.Validating Dim d As Date = DateTimePicker1.Value If d < Today Then MsgBox("Gelieve een datum in de toekomst te willen aangeven.") DateTimePicker1.Focus() Exit Sub End If Dim n As Integer = Me.FeestdagenTableAdapter.Fill(Me.FeestdagenDataset.Feestdagen, d) If n = 0 Then Me.FeestdagenBindingSource.AddNew() Me.DateTimePicker1.Value = d Exit Sub End If End Sub [/CODE] I have a "Save" Button [CODE] Private Sub SaveButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles SaveButton.Click Me.FeestdagenBindingSource.EndEdit() Me.FeestdagenTableAdapter.Update(FeestdagenDataset.Feestdagen) …

Member Avatar
Member Avatar
+0 forum 5

I am having a problem trying to save records in a parent / child data relation. I have to tables tblContacts & tblMember. There is a fk relation on the ContactID field. The tblContacts table is the master record. I am using a set up bound windows forms controls to do the data collection. The problem that I am having is in saving the child record. After the form is populated in both the fields and hitting the save button the items in the child record get deleted. It does add a row in the child record but only the …

Member Avatar
Member Avatar
+0 forum 1

[code] hi, i have been having an endless problem with the save button for some time and i am also new in here. Actually, here's how my problem defines: i was developing my own project in the university so what i am stack is to have save button which firstly validates what the user enters the form. for instance if the user skips the text fields, i wanted to restrict the user to fill all the form and when he completes, the save must be accomplished. here's the code i was trying to put but i was having problem saying …

Member Avatar
Member Avatar
+0 forum 5

Hello. I've programmed in VB for ages, but just started dealing with databases and VB.net. The problem I am having is related to a menustrip item. I used the data source wizard to add a database to my application, and did the drag-and-drop thing to put the details on my form. It worked great! I have the binding navigator at the top, and the labeled textboxes on my form. When I click on the button controls on the binding navigator for First, Previous, Next and Last record, it works great, pulling in the data and filing the textboxes. My problem …

Member Avatar
Member Avatar
+0 forum 1

I have a form developed using the Dataform wizard (VS 2003). The Form shows Master-Detail data. The details are showen in a Datagrid. The form automatically loads the data in the Form_load event. Now I want to store the data from the datagrid to a datatable. I am using following code to get the details showen in the datagrid into a dataview. The objdsInvoice is the dataset that holds the Invoice And Invoice_Item data. [code] Dim DV As DataView Dim tempDT As DataTable tempDT = objdsInvoice.Tables("INVOICE_ITEM").Copy tempDT.DefaultView.RowFilter = "INVOICE_NUMBER = " & Val(editINVOICE_NUMBER.Text) 'objdsInvoice.Tables("INVOICE_ITEM").DefaultView.RowFilter = "INVOICE_NUMBER = " & Val(editINVOICE_NUMBER.Text) …

Member Avatar
Member Avatar
+0 forum 5

The End.