20,285 Topics
 | |
| | Sub empno() ComboBox2.Items.Clear() sql = "select empno from tbl_empinfo" If rs.State = 1 Then rs.Close() rs.Open(sql, conn) Do While rs.EOF = False ComboBox2.Items.Add(rs(0).Value) rs.MoveNext() Loop End Sub how do i write this for an access connection???  |
 | Need help while working with timer.... I am trying to do the database restoring part.... When the user clicks on the restore database button the progress bar shud be shown and as soon as the restoring is completed the progress bar shud stop and display success msg... Right now I …  |
| | Actually I'm doing a project to maintain the company info, here i wanted to write a code to check whether the company id already exists or not. that is if the id 123 is already present in the access database then it shuld show the msg that it already exist. … |
| | How do you display an image in a dgv..i can display all the other info in the table, just need to know how to display an image. |
| | i have here a code that add timeintextbox and timeouttextbox to calculate for the total hours work. my problem is that i want to subtract 1hour in the total hours work for the break time..please any idea on how should i do this? Dim TimeA As Date Dim TimeB As … |
| | so i am using visual basic express edition 2010 i am now able to select an image and displaying it in the picture box. now i need to run a c code (its exe file) by clicking a button in the vb form. i was able to this too by … |
| | Hi all, I want to create a crystal report. Before print the document I want to see the output first, and then give the print command. On print button, But the problem is I have dot-matrix printer and I the page size is fix. So how can I overcome this … |
| | hi while resetting text box value to blank it gives error txt_cash_acc.text='' Error : conversion from type 'DBNull' to type 'String' is not valid.// thank you in advance |
| | I have to use a basic ByRef and ByVal in a program and its not showing up in the labels when I hit the calculate button. The program I am creating is very basic and it calculates your age, nextyear age, month born, astrological sign, days old and seconds old. … |
| | I have always used Excel.interop before but I thought oledb would be simpler because, for this application, I only have to read the data which it can't seem to do. It accesses the file alright because I can't open the file while I am at a breakpoint. It attempts to … |
| | i have a database table and it has some column with duplicate values , and i want to get that column value of the table in a combobox, but i want every value single time not repeatedly ... i tried but it is still giving me all values in the … |
 | Creating a Report in Visual Studio 2008 In this section, you create a report that draws its information from the sample Microsoft Access database that ships with Crystal Reports. To create a report with secure data from the Your database follow these steps . 1. In Solution Explorer, right- click … |
| | When I try debugging this, it comes up with an error on the line "If txtUsername.Text = ds.Tables("AddressBook").Rows(inc).Item(1) Then". It says NullReferenceException was unhandled. Object reference not set to an instance of an object. Public Class MainLogin Dim MaxRows As Integer Dim inc As Integer = 0 Dim con As …  |
| | Hello everyone. Please I am writing an system application for a company that must generate inquiry id and order id automatically. Whenever a customer makes a new inquiry or new order by clicking the add button, an automatic number should be displayed in the text box and when it's saved, … |
 | # vb.net 2008 # Hi there! I am a college student of **Southern Leyte State University - Tomas Oppus** from **Philippines** taking Bachelor of Science in Information Technology. Can you help me on how to code the timer in **vb.net 2008**? We are using this in our research as completion … |
| | Hi all! I think I need some help moving data from one table to another. Here is the scenario: I have two tables, tblDetails (studentID,Name, Class.....) and tblPhysics (StudentID.....). Now, I want to SELECT StudentID from tblDetails WHERE Class = 1 (SELECT tblDetails.StudentID FROM tblDetails WHERE tblDetails.Class = '1') So … |
| | Hi guyz, My problem is when i am saving a record in MySQL Database there is an error occured "Incorrect datatime value 3/20/2011 for COLUMN DATE at ROW 1" I used Date as my DataType in MySQL server? Can anyone fix my error ?? |
| | Hi All, I have Code on PC1. and Access DB on PC2 . I have shared Folder on PC . And very much able to access from PC1 with full ownership. Now I was trying to connect Msaccess from PC1 using below code. cnn.Provider = "Microsoft.ACe.OLEDB.12.0" cnn.Open "Data Source=\\192.168.0.1\Public\tels.accdb;Persist Security … |
| | Hello everyone Anybody to help me with this please How can make an app that will check the server/URL if it's Online/offline using visual basic 2010 I know that i can just ping it using the CMD but i want something that will be in the app i'm aiming to … |
 | Not sure what I am doing wrong but let me try to explain my issue. I have a single combobox on my form that I use to load external settings. If I load, lets say, 100 settings in to this combobox then I clear the combobox via Combobox1.items.clear(), then try … |
| | I would like to know how to open any file by using the codes!!! |
| | hello! i have one button . i want when i click it it will print preview a microsoft document from my desktop. is it possible? how to do it? thank you~ |
| | Hi, I am stuck on this two sqldatadapater and sqldatareader,we can display records in listview by using this sqldatadapter and sqldatareader.my question which is more effecient and secured to use?does this two matters in populating data in database?  |
| | SYTAX ERROR ON UPDATE STATEMENT, PLZ HELP, I CNT FIGURE IT OUT GUYZ Private Sub SubmitButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles SubmitButton.Click Try conn.Open() mystring = "UPDATE ClientLogIn SET Password = '" & PasswordTextBox.Text & "' WHERE ClientID = '" & ClientIDTextBox.Text & "' AND Username = … |
 | Hi, Is it possible to send an email from SMTP server, for example from do_not_reply@xxxx.xxx.com, without have the server credential (username and password) inside my code? I tried one code, it works, but it send from my email account. Not from SMTP server. I also tested several code but I … |
| | i need help with changing a text box for a calculator ex: 1. if (textbox3.text = 0) then (textbox.text = 1) 'i need help with that thx |
 | Please help me I got a error:Incorrect syntax near ')'. It pointed to the update_product.ExecuteNonQuery() Dim update_product As SqlCommand = New SqlCommand("Update sell Set Mode_Of_Payement(Cash)='" & TextBox9.Text & "',Payement='" & TextBox6.Text & "',Balance='" & TextBox8.Text & "', Mode_Of_Payement(Cheque)='" & TextBox9.Text & "',Cheque_No='" & TextBox4.Text & "' where Bill_No='" & txtbillno.Text … |
| | Hello dear ALL I am working with a form in vb.net which have the follwing attribute i.e BOOK TITLE(text box) , CATEGORY NAME(combo box) ,YEAR PUBLISHED(t.box) and SAVE button .the CATEGORY combo pickup data from CATEGORY TABLE on cat_name . on back end (SQL SERVER) there are two tbl i.e … |
| | Public Class txtSurname Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim cn As OleDb.OleDbConnection 'Dim con As OleDb.OleDbConnection Dim dbProvider As String Dim dbSource As String Dim DS As New DataSet Dim DA As OleDb.OleDbDataAdapter Dim sql As String dbProvider = "PROVIDER=Microsoft.Jet.OLEDB.4.0;" dbSource = "Data … |
| | Hi, can you help me please how can i populate data from my listview using sqldatareader. by the way can you please explain me why is it that listview in first column we call item but the other column we call it subitems.can you please enligthen my mind on this.I … |
| | create a project that generates 5 random integers from 100-999. store them into an array. Re-display the numbers in a list box. calculate the sum and product of the 5 numbers and display them in label. use procedures and functions. |
| | Hi, is it possible to code column header in listview during run time? can you please give me some idea on this.Thank you in advance. |
| | Hello again. Generating item codes for my inventory system became complex when the panel said that this must be the format of the generated ID number: "CATEGORY-ITEMNAME-ITEMINDEX" For example: School Supplies - Coupon Bond short- Second Item in the database would result to an item ID : SCS-CBS-002. Advanced thank … |
| | Thank all you for last replies here i hve a problem in my project . I have 2 form . In frm1 i have a datagridview which contain all information of student i.e ID, NAME , CLASS No. , ADDRESS , Department and course . In this form i hve … |
| | Hi, I have a bar chart to display information. I also have a vertical line indicate the limit of Y-value. For example, I set the limit to 25. So now I want the color of column bar to change to red color if the column exceed the limit. I tried … |
| | When reading from an access database, my code is like this: Private Sub PaidNavigateRecords() If ds.Tables("Paid").Rows(inc).Item(1) <> "" Then txtRanch.Text = ds.Tables("Paid").Rows(inc).Item(1) Else txtRanch.Text = "" End If If IsDate(ds.Tables("Paid").Rows(inc).Item(2)) = True Then txtDate.Text = ds.Tables("Paid").Rows(inc).Item(2) Else txtDate.Text = "" End If If ds.Tables("Paid").Rows(inc).Item(3) <> 0 Then txtInvoice.Text = ds.Tables("Paid").Rows(inc).Item(3) … |
 | i have two MySQL tables with the following structures CREATE TABLE tbldepartments ( departmentID TINYINT( 2 ) UNSIGNED NOT NULL AUTO_INCREMENT, department VARCHAR( 20 ) UNIQUE NOT NULL, PRIMARY KEY ( departmentID ) ) and CREATE TABLE tblemployees ( employeeID SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT, departmentID TINYINT( 2 … |
| | Hello , I'm making tetris in vb.net and i'm working with an image in a picture box that falls and with classes , my whole program works but hen my image falls it actually copies itself , does anyone know an eraser function or something or a method how to …  |
| | I want to filter the datagridview on Search button click,i am using 3-tier architecture,the grid should be updated with the search result |
| | Hello everyone I'm creating an application in visual basic 2010, "I'm very new to this" What i want to do now is to make a monitor to check the status of the website server (If it's up or down) I know that i can just ping it using CMD"command" But … |
| | Hello, I have a PDA which is working properly but now i need to use it in other application like if my active window is Microsoft Word and I want to read a barcode and to get it value where the cursor is placed in the document , how can … |
 | Hello Community, I need help with this script, i can't seem to use this to switch beteen dll files that contain a form eg. if i use it to open a form from the dll file called "Dll One" then when i click the button again it still opens the … |
| | Hi all, I had originally installed MS SQL Server 2008 R2 in my C: when I was developing the application. While I had the SQL DErver in my C:, everything was fine, no problems at all. Then I began getting low disc space messages, so I uninstalled it from my … |
| | I've been through post after post after post for the last few hours trying to figure this out... im new to the XML parsing stuff so I am starting to get frustrated. Here is a sample of the XMl im trying to parse: <level id="1"> <prop n="PROPERTY" v="VALUE"/> </level> <level … |
| | Hello all! Hopefully there is someone out there who can help me with what I need to achieve. Goal: Loop through XML file, reading node by node searching for a node with a specific attribute with a specific value, then write to another attribute of said node found. I feel … |
| | Hello Community, I was wondering if there is a way to make grid transition in visual studio using the language visual basic. Please help... |
| | i want to connect the sql dabase to vb.net form. can anyone tel me how to do it. i tired google. but it only says about ms access database. please help me |
 | I have a program below that I want to display when checkbox is checked and hide when unchecked. I created a Message Label for it but the thing is that when its unchecked, my messagelabel and message displays.... Pls is there a way I can hide the message without the … |
| | Need help building a Shipping Calc with some limitation really confused on how to word and code this program. Below is the code I already have after creating the form. This is my assignment Weight of the Package (in kilograms) / Shipping rate per Mile 2kg or less / $0.01 … |
| | Hi, I need to fill a toolstripcombobox with dates. The values in the toolstripcombobox need to be sorted by date. The database field that I am pulling to fill this toolstripcombobox has the following fixed format: 201201, 201211. So, I first need to convert the retrieved values from YYYYMM to … |
The End.