- Strength to Increase Rep
- +0
- Strength to Decrease Rep
- -0
- Upvotes Received
- 1
- Posts with Upvotes
- 1
- Upvoting Members
- 1
- Downvotes Received
- 1
- Posts with Downvotes
- 1
- Downvoting Members
- 1
REHAN LOVE YOU MORE THAN YOU LOVE REHAN
- Interests
- Developing Desktop Application Using VB.Net
43 Posted Topics
Hi every one . Recently i complete my project on libraray managment system which work perpectly on my system. Now the problem is that when i Execute my project on other system it show error at con.open i.e it mean that connection string not set in this system . Now … | |
Hello every one . I have a piece code in VB.net which work perfectly. but now i convert that code to C# Which give me the follwing error. "No suitable Method found to override" my VB.Net Code is Here Protected Overrides Sub onload(ByVal e As EventArgs) startPosX = Screen.PrimaryScreen.WorkingArea.Width - … | |
Re: Try like this Dim MyConnection As New OleDbConnection("provider=Microsoft.ACE.OLEDB.12.0; Data Source='" & path & "'; Extended Properties=Excel 12.0;") 'Update Query Dim updt As OleDbCommand = New OleDbCommand("Update [Sheet1$] Set [Inventory on Hand] = '" & Label4.Text & "' where [ITEM CODE] = '" & Label5.Text & "'", MyConnection) MyConnection.Open() updt.ExecuteNonQuery() MyConnection.Close() … | |
Re: Private Sub btnSearch_Click ( ByVal sender As System . Object , ByVal e As System . EventArgs ) Handles btnSearch . Click Dim i As Integer dgvPatienttrack . Rows . Clear () If txtParegno . Text = "" Then MessageBox . Show ( "Enter a patient registration number!" ) txtParegno … | |
Re: Hi sashyn01 ! your update query does not contain WHERE clause that's why it Update all record. write code like this If txt_UserPassword.Text = txt_ReTypeUserPassword.Text Then 'MY FIRST UPDATE STATEMENT '1. sql.CommandText = "UPDATE tbl_Users SET UserName = '" & txt_UN.Text & "', UserPassword = '" & txt_UserPassword.Text & "', … | |
Re: Plz show your Table .... What data Type there Of start_date | |
Re: Use this code: Dim str As String = "abcd1234" MsgBox(str.Substring(Math.Max(0, str.Length - 4))) | |
Hi All, What Wrong with my QUERY ! it show Repetition of Record in INNER Join i.e when i have 3 record in database it show it 9 time using This query.... SELECT dbo.EmployeeSetup.EmpID, dbo.EmployeeSetup.EmpName, dbo.EmployeeSetup.FatherName, dbo.EmployeePayment.Designation, dbo.EmployeePayment.Department, dbo.EmployeePayment.Salary, dbo.EmployeePayment.Advance, dbo.EmployeePayment.Deduction, dbo.EmployeePayment.OvertimeAmount, dbo.EmployeePayment.PaymentDate, dbo.EmployeePayment.ModeOfPayment, dbo.EmployeePayment.NetPay, dbo.EmployeePayment.PayMonth, dbo.EmployeePayment.Fine, dbo.EmployeePayment.Fund, dbo.EmployeePayment.Insurence, dbo.EmployeePayment.Tax, … ![]() | |
Re: use this code on Page_Load Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load If Not IsPostBack Then Dropdownlist1() Dropdownlist2() '' Fill ur Dropdownlist End If End Sub | |
Hi every one ! i am try to Bind Dropdownlist from Gridview .... what i am trying to do i fill my GridView from dataBase .. when i select a Row From Grid it Fill TextBoxes But show error in *"'cmbNature' has a SelectedValue which is invalid because it does … | |
Re: fill the combobox from database , . . . And use the Query " select * from tbl where name like '% "& Cmb.Text &"%' " on TextChanged Event on the combobox. | |
Hi every one ! i need to generate a key generator program any one help me. there is one Label and one Button on my Form. e.g i want to generate a random number on Button_click Event like this i.e. g12tu-7bhg5-khd9k-kh88f kdj44-jk73n-khjk6-88dkg | |
hi everyone i am try to write a code for a checkbox that work like a radioButton dynamicaly in vb.net. i.e. if i have 5 check box and i try to check the first one other will become unchecked. Second with same code if i increase the number of check … | |
how to code vb.net connection string support to all computers? normally we are puting connction string like this. con = New SqlConnection ("Server=REHAN-PC \SQLEXPRESS;Initial Catalog=library;Integrated Security=true") con.Open() but the thing is when we are going to put this application to another computer we have a trouble. Now what to do? … | |
hi all. I want to fill the Listview from a mssql database in vb.net but it not show all the data in Listview. I have the followning code. Dim sSQL As String Dim lvwItem As New ListViewItem() sSQL = "SELECT field1, field2, field3 FROM tablenam e " sSQL = sSQL … | |
Re: create a new form and add three textBoxs with label i.e value 1 , value 2 , sum. on Main form select the grid and goto property then Event - Click . Double click and add the follwing code. Dim frm as new form1 Dim i As Integer i = … | |
Re: What u want to show in labell from ur database . Show the content of database | |
Re: Select your gridview and go to property and then Event & then select MouseClick event and Double click . Then add the follwing Code Dim i As Integer i = DataGridView1. CurrentRow.Index textbox1.Text = DataGridView1. Item(0, i).Value TextBox2. Text = DataGridView1. Item(1, i).Value fextBox3. Text = DataGridView1. Item(2, i).Value textbox3. … | |
Re: Use Update commond on Update Button to update data. Qurey = "Update Tabename Set column2 =' "& TextBox1.Text &" ' , column2 =' "& textbox2.text &" ' where column_Id= '"& TextBox3.text &" ' " | |
Re: select your TextBox and then goto properties window and set MaxLength to 4. Or double click your form and write on load form TextBox1.MaxLength = 4 | |
Re: For i As Integer = 1 to 50 Step 2 Console.writeline(i) Next | |
Re: make your company id primery key in database. Now add the follwing code to your save button Try 'Initialize factory, connectionstring, adapter, command , etc. doInsert() write insert commond here Catch ex As Exception If ex.Message. IndexOf("Company_ID") Then MsgBox ("Duplicate data entry found") Else MsgBox("An unexpected error occured: " & … | |
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 … | |
Re: try this Process.Start(''Calc.exe'') instead of Calc.exe write your Exe file name with path. | |
Re: Data Adapter Object can put tabld into data set as a whole. While Data Reader can put data in data set by adding one by one row. | |
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 … | |
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 … | |
Re: Select Your textbox and then goto properties then select Event then in Event double click on keypress and add the follwing code If Not Char.IsDigit (e.KeyChar) Then e.Handled = True End If now run you program | |
i made a login table and i am filling records in it through my datagridview but when i delete all the records and make the table empty and then when i put the record in the login table it takes 1 no ahead of last deleted record .i want it … | |
hi i want to Maintain login and logout time details for each user and store those details into my database... (each time the user loggedin) and when the user Exit the application it store logout time in database what is the efficient way to do this.. need ur suggetsions.. | |
I have been searching and having no luck...So anyway, what I need is a way to copy tab1's controls or items (like textboxes,datagridview etc) and then have them pasted into a new tab. This would be done through a "New Tab" button. When that button is pressed, a new tab … | |
Re: what you want to do . . . | |
hi every one i have a datagridview that show my data in columns. what i'm trying to accomplish is that after choosing a row and pressing edit button a new form will open and split the row for the right text boxes to update the data. the datagridview row shows … | |
Hello every one and thank you all for your sweet replies. I am making a project in VB.NET, after the completion of project, is it possible to install it in anyone's computer? I mean to say, the project which I have made in VB.NET 2008, can be only run through … | |
AOA. Dear friends i am a final year student of BCS . I am working on project with Title "HOSTEL MANGMENT SYSTEM" . I am confuse in project i.e what type of form it need. So if any one have idea about this project so plz help me. Thanks in … | |
Dear All ! I have a table titled Customer_DETAIL I want to check and make sure That there are no other records in the table that have The same CustomerID . The CustomerID are FK's From customer table. How can I check for duplicates so they do not create duplicate … | |
ASALAM ALIKUM Dear !... I'm doing INVENTORY PROJECT... I'm using Ms sql 2005 as BACK-END... My tables are PURCHASE and SALES... In PURCHASE table, fields are CODE(primary key), PRICE, DATE, TOTAL, QTY... when I'm entering datas in form and when i click submit, the data stored on database... but when … | |
hi friends, i have a problem with using vb.net application, i want to restore my database from my vb.net application so that user clicks the restore button an OpenDialog open which Open the .bak and then restore the database to a state befor backup taken. i try the follwing code … | |
hi every one! I am creating an application in vb.net with sql server 2005 at backend. I have a table PURCHASE Order with 3 colunn i.e PO_Id ,Cus_id and PO_QTY . In front end i have a SAVE button, two TexTbox 'POrder no' , 'Order Qty' and combobox 'cutomer NAME' … |
The End.