Pgmer

See if this helps u... [CODE] Try Dim starttime As New DateTime Dim endtime As New DateTime Dim duration As New TimeSpan endtime = DateTimePicker2.Text starttime = DateTimePicker1.Text duration = TimeValue(DateTimePicker2.Text) - TimeValue(DateTimePicker1.Text) Dim Dur As Integer = duration.Hours Dur = (Dur * 60) / 30 For i As Integer …

Before executing take the query and run in sql server so u will come to know where the syntax is going wrong..

U cant make exe from web app. DLL's or ASPX pages have to be moved to the Server and you need to set the virutal directory for the application in IIS.

i vote for C#. If ur staring then start with C#... :)

you can do this in ur select statement from SQL while loading the data... [CODE]SELECT Active= convert(bit,0),* from ur table name[/CODE]

Following links may help you. [URL="http://www.codeproject.com/KB/vb/Screen_Shot.aspx"]http://www.codeproject.com/KB/vb/Screen_Shot.aspx[/URL] [URL="http://www.vbforums.com/showthread.php?t=287803"]http://www.vbforums.com/showthread.php?t=287803[/URL]

Cant you do it at the back end? it will be easy for you.

So you need to check if already an instance of form is opened or not.. u can use singleton pattern.

[CODE]If ((DataGridView1.Columns.Count = 0) Or (DataGridView1.Rows.Count = 0)) Then Exit Sub End If 'Creating dataset to export Dim dset As New DataSet 'add table to dataset dset.Tables.Add() 'add column to that table For i As Integer = 0 To DataGridView1.ColumnCount - 1 dset.Tables(0).Columns.Add(DataGridView1.Columns(i).HeaderText) Next 'add rows to the table Dim …

In your second form Write public sub which takes datatable or dataset as parameter. When user selects the rows by checking the checkbox and clicks the button, instanitate the object of form 2 and prepare and pass ur datatable or dataset. And use it to show in form 2.

try this [CODE] Try Dim savefile As SaveFileDialog = New SaveFileDialog() savefile.DefaultExt = "jpeg" savefile.Filter = "All files*.*|*.*" If savefile.ShowDialog() = DialogResult.OK Then Int(Width = PictureBox1.Width) Int(Height = PictureBox1.Height) Dim Bitmap As Bitmap = New Bitmap(Width, Height) Dim rc As Rectangle = New Rectangle(0, 0, Width, Height) PictureBox1.DrawToBitmap(Bitmap, rc) Bitmap.Save(savefile.FileName, …

Can you please give more info on this? How you want to read Vcards? and all?

[CODE] Dim conn As SqlConnection Dim strCnn As String = "your connection string;" conn = New SqlConnection(strCnn) Dim icnt As Int64 = 0 conn.Open() Try If DataGridView1.Rows.Count > 0 Then Dim cmdInsert As New SqlCommand cmdInsert.Connection = conn Dim strCommandText As String Dim values As String = "" strCommandText = …

what is field? what is values? can give the details?......

are you saving ur changes by updating the database trough code?

Use autocomplete mode and Autocomplte source property of text box.

Dim str As String = StrConv(txtName.Text, VbStrConv.ProperCase) txtName.Text = str Use this while saving ur data as mentioned by Phasma... Whats the problem in it?

use MASK text box and set the pattern of phone number you want. you can also set ur custom format if you want...

[CODE] Private Sub readTextFile(ByVal fileName As String) Try If Not System.IO.File.Exists(fileName) Then Exit Sub Dim strContent As String() strContent = System.IO.File.ReadAllLines(fileName) Dim x As String = "" Catch ex As Exception messagebo.show(ex.tostring) End Try End Sub[/CODE]

You should create the login form with two text box and one button. textboxes for user name and password. once user enters the username and password u should authenticate with ur database if user is authenticated then hide the login form and show the main form...

This is called cascaded combobox. In cmb1 Selected index changed event you need to filter the records of dataset which urusing to bind the cmb2 using dataview and then bind the filtered resultset to cmb2.

Try this [CODE] Select EMpNAME,AMT,DEPTNAME from (SELECT tbl_employee.E_Name as EMpNAME,sum(tbl_Salary.Amt) as AMT,tbl_Dpt.DeptName as DEPTNAME FROM tbl_employee INNER JOIN tbl_Salary ON tbl_employee.eid = tbl_Salary.eid INNER JOIN tbl_Dpt ON tbl_Salary.eid = tbl_Dpt.eid WHERE tbl_employee.eid ='E101' GROUP BY tbl_employee.E_Name,tbl_Dpt.DeptName) as A [/CODE]

[CODE] Dim str1 As String = "Your string" RichTextBox1.Text = str1 RichTextBox1.SelectionStart = RichTextBox1.Find(str1) RichTextBox1.SelectionFont = New Font(RichTextBox1.Font, FontStyle.Bold) [/CODE] New Font(RichTextBox1.Font, FontStyle.Bold) is having many overloaded methods probalbly you can get something there

Use the form closing event

What is ur problem? Ur asking for code for above?

Use convert.int(txtbkletnum1.text) or use txtbkletnum1.value instead of .text

If cn.State = ConnectionState.Closed Then again u need to initilize the connection like cn=new Sqlconnection and cn.connectionstring=connectionInfo

Try below code.. it works for me... [CODE] Dim fBrowse As New OpenFileDialog With fBrowse .Filter = "RTF files(*.rtf)|*.rtf|doc Files(*.doc)|*.doc|All files (*.*)|*.*" .FilterIndex = 1 .Title = "Select any file" End With [/CODE]

Any error in catch block?

you mean you want to show the IE in windows form?

Try using dataset and set display member and value member to combo. in Select statement itself get the distinct bank names.

[CODE] Dim strS As String() = Nothing Dim actaulstring As String = "" strS = TextBox1.Text.Split(">") actaulstring = strS.GetValue(1) strS = actaulstring.Split("<") actaulstring = strS(0) [/CODE]

ur doing Select max(regnum) from order, Where is is the insert statement? str is getting dbnull values i guess.

[CODE] Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim numtoDisturbute As String numtoDisturbute = Trim(txtSource.Text) If numtoDisturbute.Length = 0 Then Exit Sub Dim arr As New List(Of String) For Each Cha As Char In numtoDisturbute arr.Add(Cha) Next For i As Integer = 0 To arr.Count …

Data grid shows the records in Columns only.... Whats ur problem? Explain plz

in ExcelWorkSheetObject.SaveAs(ExcelSheetName) method perorm the step. After saving all the data make ProgressBar1.Maximum = 100.

What is the error? or what is the problem? plz explain

For this u need to write procedure to delete row from db or SQlL statement by passing the condition to delete. And load the new set of data and bind back to grid.

What is your code for this? Please post ur code and the problem with the code.

Is button3_Click is submit? If yes where is ur insert statement?

You need to get the row from grid and loop through the cells And assign to textboxes.

Select @@rowcount from table where stu_name like ='kevin'

You need to prepare the insert statement and connections to ur DB. And run the query using command object. There are multiple similar threads u can refer to or google will help u.

How your loading the combobox in form 1? are u using dataset?

you need to get the coordinates of mouse pointer and Set the location of panel to that new coordinates

you need to copy the database in client machine, by making copylocal=true property. So whenver you publish it takes the new file to build and copy in user machine.

You need to use either datareader or dataadapter methods to get the data from DB and then assign to textboxes by looping through ur dataset or datareader.

At which line the error is? And what is the error description ?

Combobox1.text

[CODE] Try Dim cn As SqlConnection Dim strCnn As String = "Your data base connection string" cn = New SqlConnection(strCnn) cn.Open() Dim comm As New SqlCommand("Your sp or Command text to get the data from DB", cn) '' If ur using Sp then Commandtype= CommandType.StoredProcedure if it is Text then …