i have a format for printing and printin must be done in that format only also the page setup shud be shown i tried this code but not gettin anything with the format so plz help
Try
Dim con As New SqlConnection("conn str")
Dim cm As New SqlCommand
cm.Connection = con
cm.Connection.Open()
cm.CommandText = "Insert into table values(" & Val(txtbillno.Text) & ",'" & txtadd.Text & "','" & txtname.Text & "')"
cm.ExecuteNonQuery()
cm.CommandText = "Insert into table values(" & Val(txtadd.Text) & ")"
cm.ExecuteNonQuery()
Catch ex As Exception
MsgBox(ex.Message)
End Try
Me.Refresh()
Me.PrintDialog1.ShowDialog()
so what will be the code for tht format
its an excel sheet format
so do i hv to use file system????
n import it from thr how to do it
plz help.....