bigzos

[CODE]Public Class Form5 Dim connection As OleDb.OleDbConnection Dim mystr As String Dim cmd As OleDb.OleDbCommand Dim adp As OleDb.OleDbDataAdapter Dim ds As New DataSet Private Sub Form5_FormClosing(ByVal sender As Object, ByVal e As System.Windows.Forms.FormClosingEventArgs) connection.Close() End Sub Private Sub Form5_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load mystr …

public class Student{ private String name; public Student(String name) {this.name=name; } public void setName(String sett){ name=sett;} public String getName() {return(name);} } public class Swaptest{ public static void swap(Student p,Student q){ Student temp; temp=p; p=q; q=temp; } public static void main(String a[]) {Student s1=new Student("John"); Student s2=new Student("Mary"); swap(s1,s2); System.out.println("s1="+s1.getName()); System.out.println("s2="+s2.getName()); …

Why system.out.println(011) prints 9 and not 3?

One of the problems with datediff function is that even if the two dates are 31-12-2011 and 01-01-2012,it will show the difference as 1 year.How to overcome this problem????

Hey,,I tried the following code to retrieve data from an excel file,apply query and save the result of query to another excel file. Now there are two problems: One,I am getting the required data but some reduntant unwanted data too. Second,It only works if the excel file, from which the …

Hey guys,I have an excel sheet with one of the columns as name .There are many rows with same name and I wish to mail all the rows with same person name to that person(given there is a column specifying email address).I will be thankful for your suggestions. The following …

I have a database of asset information with asset age as one of the columns..now i wish to display all the assets which crossed 4 years in the current year ..any suggestions will be appreciated!

Hey guys,, i am working on an application titled Asset Management for my b.tech major project.The company under which i am pursuing it only asked me to include sumitting asset information,,retrieving information and generating reports and editing of data with admin login.I made all that but my college faculty is …

This is my login form [CODE] Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim con As New OleDbConnection("Provider=Microsoft.jet.oledb.4.0;data source=C:/Users/Space Era/Documents/User.mdb") Dim cmd As OleDbCommand = New OleDbCommand("SELECT * FROM Users WHERE userid = '" & TextBox2.Text & "' AND password = '" & TextBox1.Text & …

I am able to save the datagridview as an excel sheet but everytime i do it,the previously saved file gets replaced which i do not want..i want the file to be saved with a new name everytime [CODE]Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click Dim …

Hey Guys, I am trying to create this application which can display the free space and the total space of logical drives,,I am very close but there is some little mistake which I am not being able to find out..Please help,,here is the code [CODE]Public Class Form2 Private strDrive As …

I retrieved data from access in vb10 between two dates and here is the code for dat: [CODE]Imports System.Data.OleDb Public Class Form4 Dim con As OleDbConnection Dim cmd As OleDbCommand Dim dr As OleDbDataReader Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Try con = New …

I have a login form coded as : [CODE] Imports System.Data.OleDb Public Class Form2 Dim ctr As Integer Private Sub Ok_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim con As New OleDbConnection("Provider=Microsoft.jet.oledb.4.0;data source=C:/Users/Space Era/Documents/User.mdb") Dim cmd As OleDbCommand = New OleDbCommand("SELECT * FROM Users WHERE userid = …

Hey,i am working on a module in vb 10..i have to retrive data from the database between two dates...i have used the following code but not able to get ny output,,nt even an error [code] Imports System.Data.OleDb Public Class Form4 Dim con As OleDbConnection Dim cmd As OleDbCommand Dim dr …