Satyam_1

Hi, i want to total the values in column9 in Patientdatagridview to a textbox1. here is my code but it displayes each value, not the total. e.g. if values are 200, 200, 200 then it should display 600 but here it says 0200200200 Private Sub Button1_Click(ByVal sender As System.Object, ByVal …

Hi, I hv vb.net applivcation. I have following CODE1 to save data & to prevent duplicate data entry into table. The following code I put in button save event. However I want to put this CODE2 in perticluar textbox e.g. here SpecimenNoTextBox. so that when the user enter duplicate SpecimenNo.it …

In vb.net application I have 10 Textbox and value entered by Barcode scanner So when one Textbox1 get the value by Barcode scanner the focus moved automatically to another Textbox2 and so on. I have this code but its working. Private Sub A1TextBox_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) …

In vb.net application, I have a dgv. the data from dgv are transferred to textboxes when row are selected. I print these textbox as report using e.graphics. after printing perticular row data , that row is removed from dgv. (i filtered the dgv by "NotPrinted"). I want with a single …

In vb.net application , I open the form2 from form1 by btn event with following code. But if the user minimise it and again open it from the button event, there are 2 forms in the taskbar... I want the same form2 is opened everytime without multiplication of forms in …

I have put digital signature as picturebox in vb.net form To print the picturebox, i used following code. But the print of signature is very light in color. How can i improve the or darken the signature. The code in print document event is E.graphics.DrawImage(Me.PictureBox1.Image,50,100,100,50)

I have vb.net application. I have following code to print dgv. but when i print, all the page get printed. How can I print selected pages to be printed with pagesetup. Public Class Form2 Dim mRow As Integer = 0 Dim newpage As Boolean = True Private Sub Button1_Click(ByVal sender …

In vb.net application I have Form1 & Form2. When user enter data and save it by btnsave event in form1, the Form2 should show msgbox "New entry" in form2 while its still open. How can set this event?

Hi, I have vb.net application In the form there are 2 RichtextBox. To print the data in richtextbox I am using e.graphics method. This is my code to print them.... The size of printing Richtextbox are fixed.. If Richtextbox1 has more data than the print area , then print does …

In vb. Net application i have a combobox with properties- custome source autocomplete Dropdownstyle- dropdown I use string method to autocomplete combobox from custom source of database. I want to cleat text from the combobox after save button event. I use following code for that but its not working. Combobox.selectedindex=-1

I have vb.net application and have a richtextbox.. I want set the lines limit to 12 and after 12 lines the user will not allow to enter text. How can i do this?

Hi, I have vb.net application. In the form I have print button and when I do print, after printing the form is closed. so I have to reopen the form. I tried much, but I am not able solve the problem. Please help me. I put following code in print …

hi, I have dgv1 that contains amount column, and dgv2 that also have amount aolumn. I have following code to sum total vlaues of dgv1. but i want display both column vlaues from both dgv in to single textbox. how can i do this? Dim total As Integer For Each …

HI, I have a form1 with datagridview, and same datagridview in form2. both have databindingsource so when I update any data in form1 it should reflect the changes in form2, when both are open. Here is some what could i get, but its not refreshing the data. form 2 load …

HI I have vb.net with ms access database application. I want to create log in form Here is my code but when enter the details and hit Login button it says"datatype mismatch error" Dim con As New OleDbConnection Dim cmd As New OleDbCommand Dim rd As OleDbDataReader con.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data …

I have developed an application in vb.net with MS access. In a form I have a Datagridview and I retrieve the data by databindingsource. I am copying the data from datagridview to textbox and then to another table in database. I want- after being copied the color of selected row …

I have vb.net application with MS access database. I use following code to autocomplete textbox from database. the problem is that, although its working but more frequently it gives an error "AccessViolationException was unhandled----Attempted to read or write protected memory. This is often an indication that other memory is corrupt." …

I have vb.net application with SQL server express. Here is my code to save data to database, but itn not working. Here ID is not the primary key. Imports System.Data.SqlClient Imports System.Data Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click Dim cmd As New SqlCommand Dim …

Hello I have a vb.net application with MS access database. I want to run LAN in 3 pc by this application. So it possible or which SQL method shuold I adopt for LAN connectivity. I started to convert my database in SLQ express but I am not succeed .

I have vb.net application with MDF-Sql database. I retrieves data from Table in MDF-Sql into datagridview by TableAdaptermanager/binding navifator. Although it displays data but when I want to save by this code, its not working.This code is working in vb.net with OleDb application but not here. Is there any another …

Hi, I have an vb.net application linked to Oledb database. here is my code in Button_Click event to prevent duplicate entry with same ID, ID is not the primary key in database. Although it shows "Record Already" Exists", but I am not able to save data with new ID, to …

I am using vb.net application with OleDb database. In the form there is a richtextbox I want to print it and here is my code for that. But it prints all text in the RichTextBox in a single line and it goes beyond the page margins. It doesn't print the …

I have form with many labels and textbox. All these generates a report . I want to print it out in MS Word format and also set print privew. Here is my code for print for single textbox but i don't print in MS word. So what to do? Private …

I have following code for date and time in vb.net. I am not able to set timer in the textbox 4 and 5. What could be there in timer1 event? Dim theDate As Date theDate = Format(Now(), "short date") TextBox1.Text = theDate Dim mytime As System.DateTime Dim hours As Double …

I am using vb.net with OleDb database. Following is my code, although i am to search database but not able to save after making changes. It displays following error at Command.ExecuteNonQuery level as OleDbException was unhandled, Data type mismatch in criteria expression. Imports.Sysytem.Data.OleDb Private Sub Form1_Load(ByVal sender As System.Object, ByVal …

i am using vb.net application with OleDb database. In a form i have Search,Add,Edit,Delete buttons for the data. Although search data is working but Add,Edit,Delete are not working. Here is my code. Imports System.Data.OleDb Public Class Form1 Dim CN As New OleDb.OleDbConnection Private Sub Form1_Load(ByVal sender As System.Object, ByVal e …

i have a vb.net form linked to database access-Table1 In the form three checkbox as HB,TC and 2 textbox-ID,Age I am using following code but is its not working. If Hbtxt.Checked Then cmd = New OleDbCommand("insert into Table1(ID,Age,Hb) values ('" & IDtxt.Text & "','" & Agetxt.Text & "','" & Hbtxt.Text …

I have a textbox that select system time. and second textbox. In the second textbox i want to add time which is 2 hrs late from first textbox. How can i do it?

I have table-accessonbook and second table as report register I want to fetch data from one table as name,age,sex with unique id from 2nd table i want fetch Hb with same id so that when i enter peticular id it should fetch data from both tables linked to that id. …

Hi I have a form in vb.net that contains textbox as ID, Name, Age, Sex, Hb, BG. in database access i have 2 tables as Table1 and Table2. The Table1 contains ID,Name,Age,Sex and Hb. The Table2 contains ID,Name,Age,Sex and BG. I want to save data as ID,Name,Age,Sex, BG to table2 …