20,285 Topics
 | |
| | hi all, i am working on small RMS and got problem to print receipt using pos printer. the expected out put is like that. 1. XYZ Ltd 2. London, Uk 3. 4. 5. 6. Transaction #: 100 7. Date: 11/12/2008 Time: 09:10:10 8. Cashier: Fred 9. 10. Item Qty Unit … |
 | hi all , i now working on new project that have a class for table includes the add , delete , and update function how i can call them in vb??? this one of the class Imports System.Data Imports System.Data.SqlClient Public Class BOQSectionsAndParts Private _BOQSectionsAndParts_ID as Integer = 0 Private …  |
| | Hi, I've been working on getting a GUI connected to a database so I can input data into the database. However when getting to the 'making a save button' I get this problem on line 14: Private da As New SqlDataAdapter("Select Name, Number, Email From Contacts", cs) Private ds As … |
| | Hi I accidently double click on the toolbar and now ALL button on toolbar are gone. I want to reset it to default and get my buttons back. How to do that I tried to write click on Toolbar then Reset toobar , still no good I even tried reinstall … |
| | I am writing a program that has to read a text file for a string that is surrounded by [ ]. I then want to grab the text behind it which is surrounded by ( ). The string i want to grab is in the same line as the one … |
| | I have several classes that can raise same event: classA, classB, classC all can RaiseEvent "DlFinished", "TableUpdated", "ReportProgress". Since all 3 classes give me about the same information, I created an user control which displays the data. Now this may not be the best way to handle this situation, but … |
 | Hello. I started making my software and i using database. When I select record in database and click Delete Button i got error message: **Update requires a valid DeleteCommand when passed DataRow collection with deleted rows.** The code of my Delete Button is: Private Sub DeleteMember_Click(ByVal sender As System.Object, ByVal …  |
| | I 'm doing an application using vb.net 2008 and sql 2005 i want to know whether it is possible load data into message box from database when form is loaded...... |
| | Hi! I'm having a problem in database.. I have this SQL for my vb.net project Sql = "SELECT STUDENTS.stud_id, STUDENTS.stud_no, [stud_last] & '" & Me.Label1.Text & "' & [stud_first] AS Expr1, STUDENTS.gender00, STUDENTS.course00, SECTION00.sec_code, STUDENTS.Q1, STUDENTS.Q2, STUDENTS.Q3, STUDENTS.Q4, STUDENTS.Q5, STUDENTS.Q6, STUDENTS.Q7, STUDENTS.Finals, STUDENTS.username00, STUDENTS.stud_id FROM SECTION00 INNER JOIN STUDENTS ON … |
| | Hi how can I print a new document for each datarow in my datagridview?. I have the PrintDocument procedures separately. Thanks in advance |
| | Hi All, Any one can help me how to use TAPI to control the IP phones? How to get started with? What all i should install and configure? I searched in net before posting it here but its too confusing for me. As this is my attempt in this area.. … |
 | please help.. how to program nodes(like in binary tree) the root node is (1) then left(LNode) is (2) and right(RNode) is (3).. then for (2)- LNode of (4) RNode (5).. for 3-- LNode(6) RNode(7)..so on.. how can i do that.. then the numbers are in the database.. Thanx |
| | Ok, here is my question. I got this code working (Yeah it isn't really complex I know, but I'm a beginner anyway) and I couldn't make it work when using a class variable for the strTotalCost and decTotalCost variables and passing decTotalCost to the strTotalCost to show the calculated price. … |
| | i added some text boxes and button in group box and entered its code . Later i added tab control and i cut the group box and pasted on tab control. now the codes are not working. when i double click it dosen goes to old code i type but … |
| | Dim MapString(41, 7) As String Private Sub MapForm_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load 'mapfile to array Dim StrSplit(), LineRead As String Dim x, y As Integer 'open the file Dim sreReader As StreamReader = New StreamReader("MapFile.txt") 'x and y must be to 0 x = 0 y = … |
| | this might be a silly question :-) but just for reference asking that System.Drawing.Graphics is a reference type ? or value type ? I mean when creating objects like this Protected Overrides Sub OnPaint(ByVal e As System.Windows.Forms.PaintEventArgs) Dim i As Integer = 10 Dim g As Graphics = Graphics.FromHwnd(Me.Handle) g.DrawString(i, …  |
| | Hello, my code is not transferring the selected row data into the targeted text boxes on the other form when i click or select the row, i need help here , that the code Private Sub DataGridView2_CellContentClick(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DataGridView2.CellContentClick If Me.DataGridView2.CurrentRow.Selected = True … |
| | hi guys, i have a datagridviewcheckboxcolumn1 that is bound to a field in a database. i want to set it as checked or uncheked programaticly, does any one know how??  |
| | How does one who is encountering VB.Net for the first time start. Sandra |
| | Function cek_code(ByVal pid As String) As Boolean Dim sql As String = "select count(P_Id) from Profit_margin where P_Id = '" & ComboBox2.Text & "'" Dim cmd As New SqlCommand(sql, myConnection) Dim dr As SqlDataReader Dim value As Boolean = False Try myConnection.Open() dr = cmd.ExecuteReader(CommandBehavior.CloseConnection) While dr.Read If dr(0) > … |
| | Can you guys please tell me whats wrong on my code. Im trying to get the data of Title, Author, Price, Stock from DB and output it on my textboxes. Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load connstring = "Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Csrp2_DB.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True" conn.ConnectionString … |
| | I have defined a procedure under the click event of the button as follows. [code] Private Sub btnSearch_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSearch.Click [COLOR="Green"] 'Validate Department[/COLOR] If cmbDepartment.SelectedItem = Nothing Then MsgBox("Please select a department", MsgBoxStyle.Information, "Notification") cmbDepartment.Focus() Exit Sub End If End Sub [/code] I … |
 | i'm just a newbie in dealing with master details in datagridview. i have a two datagridview. first is the employees record and the other one is file(which contains the file path of csv files). my backend is ms access database.one database with two tables. Now, when im going to click … |
 | I have beeb unable to figure out how to get data from a list view. It needs to be a multislect, and I need to get the data from a specific column. my listview consists of a 3 column with data populated from a database. I am after the data … |
| | good day, is there a way to put date values in a variable, that is coming fromo the database? something like dim dates as dates (select * from table1 where id = id ) dates = date BETWEEN collumn1 and collumn2 of table1 well its not working of course, its … |
 | hi i have to open a text file from an OpenFileDialog as an Array into a listbox. The data in the text file are dates and a number in this format, "01/06/2010,106". what i need to do then is get the the 5 highest dates and the 5 lowest dates … |
| | Hi, I've problem in displaying image on my rdlc (Microsoft Report Viewer) report. I took picture box on my report and made its properties as SOURCE=EXTERNAL, VALUE=Parameters!Path.value where Path is my Report Parameter. Below is the code to display image on Report load event: Dim paramList1 As New Generic.List(Of ReportParameter) …  |
 | gud day. I have 2 collumn from my database. DateHired ( datarow.item(5)) and EndofContract (datarow.item(6)) on my form i have 2 datetimepicker to record the employees previous jobs, i need to avoid overlapping on the employees recent recorded jobs. e.g if date hired is 01/02/2012 and end of contract is … |
| | Dim major As String = TextBox1.Text Dim depa As String = TextBox2.Text Dim sname As String = TextBox3.Text Dim tbStudent As DataTable Dim dcPrimaryKey(0) As DataColumn tbStudent = sqlDataset.Tables("Major") Dim c As Integer 'selecting the entire rows from dbase myCommand = New SqlCommand("SELECT count(*) FROM Major", myConnection) myConnection.Open() 'sqlquery1 = … |
| | I don't know how to implement this. I tried several times. but the button was only visible if the picturebox is already in the width of the frm(Me.WIdth) Public Class Form1 Private Sub Timer1_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer1.Tick Static XInteger As Integer = PictureBox1.Left Static … |
| | please someone help me..im doing my final project and below is my code for the registration form..after i fill up all my form and it will appear a msg box that i can only register once...the data is not being inserted in the database..im using ms access...please2....do help me...i dont … |
| | Ok, What i need is a Login script that will verify the information that is on a MySQL database. What people will do is sign up on a website and their Login information will be stored on the database. Then they will be able to login to a special members … |
| | Hi everyone, I am now having problem with the First,Previous,Next,Last button to retrieve data. > Public Class DailyExpenses > > Dim connection As New SqlClient.SqlConnection > Dim cmd As New SqlClient.SqlCommand > Dim da As New SqlClient.SqlDataAdapter > Dim ds As New DataSet > Dim i As Integer = 0 … |
| | hello guys, can anyone help me with this plz?? i have a datagrid view that is bound to a database, and the is a checkbox that is also bound to a flg in this database. i want to put some conditions on checking or unchecking this flg. what event do … |
| | hey i am having three columns "fname", "mname", "lname" in one table... i want to take each column's DISTINCT value without relating fields in one query.. i mean distinct of "fname" in first column, distinct of "mname" in second column and distinct of "lname" in third column can anyone help …  |
| | Hi, I'm trying to export data from excel sheet to my grid, I'm using the foll code, but I get an error at DataGridView1.Rows.Add(), saying rows cannot be added programmatically. Private Sub btnexport_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnexport.Click Dim xlsApp As Microsoft.Office.Interop.Excel.Application Dim xlsbook As Microsoft.Office.Interop.Excel.Workbook … |
| | I like so many others seek out code snippets from time to time to provide some functionality. Most are easy to incorporate. But I have not yet figured out how to use a function, like below. How does one call something like this in another program? Private Function Search(path As … |
| | I have an issue where, in a recursive situation, I need the path of each file in a directory, but only from the top folder to the filename... not any system type files. Is there a way to set up an enum or "For Each" type of loop that would … |
| | Hi, i am new on vb.net.i want to link two forms. a button on form 1 when clicked it opens form 2 but not in new windows but it replace form 1 on the same window. |
| | Hello! It's me again. I making a library software and I using DataBase. When I remove any record from database and then click save i got a error message: **Update requires a valid DeleteCommand when passed DataRow collection with deleted rows.** , and one line of code with yellow background: … |
| | I'm trying to have my winform check for changes in textboxes, combo boxes and masked textboxes. I've found a way for one textbox, but how can I do this for all of the textboxes as well as ones on other tabpages? Private Sub Textbox_Textchanged(ByVal sender As System.Object, ByVal e As … |
| | How to show save dialog box in dot net 2003 using vb dot net |
| | Hello. I working on my Library software and I using database for my project. When i click save icon I save my record and when I close program and open it again, database is empty. All my records always gone! But when i create new project again and make new …  |
| | Hey All! I have created a database application which read and write data in Ms Access. It works well on my computer but when i try to install the same application via installer package to another computer, and run it, it gives me error that i dont have the database. … |
| | hi all! i have two combo box in my program one has the subteam for example if you click the 1st combo box, the items would be A1 A2 A3 A4 A5 what i want to happen is that if i chose A1 only the members of team A1 would … |
| | Private Sub DataGridView1_CellContentClick(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DataGridView1.CellContentClick frmDisplayLockerInfo.Show() frmDisplayLockerInfo.TextBox2.ReadOnly = False frmDisplayLockerInfo.TextBox3.ReadOnly = False frmDisplayLockerInfo.TextBox4.ReadOnly = False frmDisplayLockerInfo.TextBox5.ReadOnly = False frmDisplayLockerInfo.TextBox6.ReadOnly = False frmDisplayLockerInfo.TextBox7.ReadOnly = False frmDisplayLockerInfo.TextBox8.ReadOnly = False frmDisplayLockerInfo.TextBox9.ReadOnly = False frmDisplayLockerInfo.TextBox10.ReadOnly = False frmDisplayLockerInfo.TextBox11.ReadOnly = False frmDisplayLockerInfo.TextBox12.ReadOnly = False frmDisplayLockerInfo.TextBox13.ReadOnly = False frmDisplayLockerInfo.TextBox15.ReadOnly …  |
| | Hi, is there a way to get the FTP Welcome banner (not the welcome message, but the banner)? What I'm trying to do is to discover several AXIS security cameras over a network using FTP. When I try to FTP into a camera using cmd.exe, the camera answers like: C:\>ftp … |
 | hi, I am recently very curious to know how I can make a connection between two computers which are not in a local network. I googled a lot but there are always solutions for local IPs Now I know that I should make a server and a client to send … |
| | Hello all! I have hit a small bump in my development of a program I am working on. Basically what I need to happen is this; for each item in the listview it executes a SQL query to input values into a database. In this case it pulls the quantity … |
| | hello guys, can anyone help me with this plz?? i have a datagrid view that is bound to a database, and the is a checkbox that is also bound to a flg in this database. i want to put some conditions on checking or unchecking this flg. what event do … |
The End.