19,728 Topics
| |
Hi. I'm using a datagridview to display data and make updates to my access database. I was able to display data from my database to the datagridview but it is not filtered. The datagridview displays all the records on my database. I tried using query builder to execute sql select … | |
Here's my SQL Statement: SELECT * FROM tblHeader WHERE Requestor='"&label1.text&"' Why doesn't it work? | |
Hello everyone, I am an Intern at a company and I mainly create scripts to update databases. I don't have the opportunity to do much "real" programming, hence the reason I am begging for some help :p I am working in visual studio and my program runs great. There is … | |
This is my code: [code] Private Sub cmdHitung_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdHitung.Click Dim tempBASIC As String If strChrDec = "." Then strFormatDec = "#,##0.00;(#,##0.00)" formatSAVE = "############0.#0" Else strFormatDec = "#.##0,00;(#.##0,00)" formatSAVE = "############0,#0" End If If Val(Format(Convert.ToDouble(txtGajiPokok.Text), formatSAVE)) > 0 Then If Trim(txtGPPilih.Text) = … | |
how do i add data from my RFID tag to my system?? | |
Greetings - I'm wondering if anyone can assist me with troubleshooting. When I login, my page displays the heading, but not the user record (formview). I am using the default membership and users tables (SQL server 2005) along with the basic login control. I have a table called 'members' where … | |
Hi there im very new to VB.net. However ive bee told its the best place for me to start if i want to program a small application for use with my family business. Basically i want to be able to enter the type of employee. Either (Manager, Help Desk or … | |
i downloaded this hotel management system in vb.net 2008 from source coders, the tables and the forms are connected via table adapters and no clear relations among the tables so i cant quite figure it out. Here is the link: [url]http://www.sourcecodester.com/visual-basic/hotel-reservation-system.html[/url] | |
hi i designed an application in vs 2008 using vb.net which uses an access db. i would like to add a feature where if one of the users of the application updated the database, another user with the same application on a different computer but with an internet connection can … | |
Hi Alls, I really need help from u all regarding how to update database using checkbox in datagridview.... i got 4 columns from my access database that is:- Columns1 = Id Coulmn2 = Name Columns3 = Status Columns4 checkbox = I need to update any data in column that have … | |
Hi there, I'm creating a program and I need to block out the keyboard completely. Including every button and key combo. Is there a way to do this? I already scoured the internet... any help would be greatly appreciated! | |
I heard somewhere that i can draw a datatable onto a local form, with the connection open.... How do i do this..?? | |
this is my code.. In my code i have succesful get table column name. But i want the first table column name showing not all. Thanks' [code] rs.Open(strSQL, adcLEDGER, ADODB.CursorTypeEnum.adOpenKeyset, ADODB.LockTypeEnum.adLockPessimistic) Flds = adrCURR.Fields TotalCount = Flds.Count For Each fld In Flds MsgBox(fld.Name) Next [/code] | |
hi all i need is the comments for this piece of code here it is: [code=vb.net] Private Sub populate() con = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _ System.Environment.CurrentDirectory.ToString() & "\DataBase.mdb") ' con.Open() dAdapt = New Data.OleDb.OleDbDataAdapter("select * from Watches", con) dSet = New DataSet dAdapt.Fill(dSet) dBind.DataSource = dSet dBind.DataMember = dSet.Tables(0).ToString() … | |
Hi all, I need a big favor to carry out a task. I want to get information in a exel sheet to a datagrid in VB.Net. For example lets say Excel sheet contains following information. ID,Name,Telephone I want to get these data into the datagrid. Can anyone suggest me a … | |
I have an application in VB6; I want to put part of its functionality onto the web. I have Visual Studio 2008 using VB, and am familiar with OO programming (in Java), VB6 programming, and with web programming, though not all in one place. I would like general advice on … | |
this is my code [code] dataGridView1.Rows.Add() dataGridView1.Item(0, dataGridView1.Rows.Count - 1).Value = cboColourCode.SelectedText.ToString dataGridView1.Item(0, dataGridView1.Rows.Count - 1).Value = txtQty.Text.Trim.ToString dataGridView1.Item(0, dataGridView1.Rows.Count - 1).Value = cboQty.SelectedText.ToString [/code] only a blank row is added in the datagrid | |
Hello guys, since I'm new here, I did some research to find similar problems but I didn't find what I needed. Well, my problem follows as this: I created a Picture Viewing application in VB.NET and I want to add two functions: a save function and a function that lets … | |
Can someone help and show me how to display using (VB.net) these two tables combined into one. I'm really struggling trying to figure this out after hours of work, I decided its time to ask for help! So in SQL Server 2005 I have the following tables... [B]Students[/B] PKId Cart_Id … | |
Wikipedia has most movies well sussed; I would like to take an excel list of movies, call up wiki page using System.Diagnostics.Process.Start("http://www.wikipedia.org/") System.Windows.Forms.SendKeys.Send("Moonraker") System.Windows.Forms.SendKeys.Send("{Enter}") , use sendkeys to enter the name of the movie from the excel list into Wiki's default search text field and {Enter} to launch. What I … | |
hi every body , I want to write a program with vb.net about calculating the GPA in my program I'll ask the user to Enter the number of courses then I'll Generate ComboBox(s) by the number of courses ... So How can I do the dynamic Generate of the combobox … | |
Hello, Is it possible to change the connection string after setting up a Data Source? I'd like to set up a Data Grid View, but the user must be able to change the location of the database file at a later time (over a network). i've been trying: My.Settings.db1ConnectionString1 = … | |
does anyone know how to subtract a certain number of days from a given date? thanks in advance for your help. Nevermind I figured it out with the help of the help index. | |
Hey All I'm busy with a program in VB.Net 2008 that performs sales. When a user clicks on the Invoice button, a record with the details of the Transaction is addedd to the Transactions table in the back-end MS Access 2007 database. The Transactions table has the following fields: LogID … | |
How to delete,update records in listview? Changes also affect the database? | |
this is my code. [code] Private Sub cmdSearch_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdSearch.Click temp = "DaftarGaji" modPY.LookUp("SELECT * FROM MS_UMR ORDER BY TAHUN", strCONNECT, 0, 1, temp) End Sub [/code] [code] Public Sub LookUp(ByVal strRecordtoSearch As String, ByVal strCONNECT As String, ByVal KeyFieldPos As Short, ByVal … | |
Good Day All, I am having issues making reference to .subitems(5) of ListViewStudents below, I can get to .subitems(4) with no issue but it tells me .subitems(5) does not exist. lsvFemaleStudents has 6 columns therefore it should have 5 subitems right? Does anyone know if there is a restriction when … | |
I'm new to this forum but I I'm trying to find an answer to my question. I've developed an application in VB.Net using the console option. This program runs from the command-prompt and is very basic. The issue I am having is: 1. I compile the program and copy the … | |
Hello everyone Im new at this thing of programming and im having trouble in saving a new record to the database, I've searched online for this problem and ive tried all the possible ways that i find in internet but i cant manage to make it work correctly This is … | |
i got 5 textbox... 1st i click at textbox1, then i press tab key then he direct go to texbox4.. how i can setting for from textbox1 then press tab key he go to textbox2.. |
The End.