hi,

fetch your leave start date and end date
startdate = stdt
enddate = nddt

if currentdate >= stdt AND currentdate <= nddt
{
msgbox (".....")
}

Hi,

dataGrid.DataBind() statement is missing.

dataGrid = new DataGridView();
this.Controls.Add(dataGrid);

dataGrid.DataSource = dataSet.Tables["Vertexes"];
...

hi
you can do this using TreeView

Hi,
oConn.open() statement is missing

(Data Source=NAWINSQL050;Initial Catalog=AlbatrossDB; Integrated Security=true)

oConn.open()

objFormatOut =...

Private Sub Button5_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button5.Click
Try
oConnOleDb = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data...

try this

Dim con as new OledbConnection
con = new OledbConnection (constring)
con.open()

Dim cmd as new OledbCommand
cmd = new OledbCommand("Delete Query",con)
cmd.ExecuteNonQuery()

Hi,
pls post your code

Hi,
try this

ds1.Merge(ds2);
dataGridView1.DataSource = ds1.Tables[0];
dataGridView1.DataBind();

Dim con as new OledbConnection
con = new OledbConnection (constring)
con.open()

Dim cmd as new OledbCommand
cmd = new OledbCommand("Delete Query")
cmd.ExecuteNonQuery()

cmd.Dispose()...

Hi,

Dim con as new Oledbconnection
con = new Oledbconnection(constring)
con.open()

Dim cmd1 as new OledbCommand
cmd1 = new OledbCommand("Insert Query",con)
cmd1.executenonquery()

while dr.Read()
idcombo.Items.Add(dr(0))
end while

idcombo.Items.Add(dr(0))

Hi,

dim con as new DqlConnection
con = new Sqlconnection(constr)
con.open()

dim objSqlCommand as new SqlCommand
dim objdr as SqlDataReader

objSqlCommand = new SqlCommand ("YOUR QUERY")

Hi,

open Project -> "Project name" Properties
open application tab from left
select form name from startup form dropdown list

Hi,

private void button1_Click(object sender, EventArgs e)
{
txt1 = textBox1.Text;
txt2 = textBox2.Text;
String connectionString =...

Try
Dim ObjSqlDataAdapter As SqlDataAdapter
Dim ObjDataSet As New DataSet
ObjSqlConnection = New SqlConnection(ConnectionString)

If...

Hi,


Private Sub frmDesigner_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles Me.KeyPress
If Asc(e.KeyChar) = Keys.Enter Then
...

''' <summary>
''' FUNCTION TO CALCULATE SUM OF TWO TIME VALUES
''' PASS TWO DATE VALUES AS STRING
''' </summary>
Function GetTimeSum(ByVal dt1 As String, ByVal dt2 As String) As...

hi,

I think messagebox will not work in ASP.NET.
you can solve it through JAVA SCRIPT

Hi,


imports System.Data.OleDb

Dim con As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=DATABASE PATH")
con.Open()


If solved please mark as solved

Hi,

I want to Convert

1. HTML file into PDF file and
2. PDF file into HTML file
through code in vb.net or c#.net without using third party component

Hi

SqlConnection ObjConn = new SqlConnection(ConnectionString);

if (ObjConn.State != ConnectionState.Open)
{
ObjConn.Open();
}...

Send me your VB.NET code

CrystalReportViewer1.Visible = false;

Try this


DataSet objDs;
int i = 0;

protected void Button1_Click(object sender, EventArgs e)
{
if (i == 0)
{

Private Sub CloseToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CloseToolStripMenuItem.Click

CrystalReportViewer1.ReportSource = Nothing

...

Hi,


Take one button and on that Click write this code

Hi,

There is WHILE loop to read the records
i.e. WHILE dr.read()

so it will read all the records one by one

Hi,

try this


Dim conn As OleDbConnection
Try
conn = New OleDbConnection(My.Settings.ConnectionString)
conn.Open()
Dim asql As String = "Select...

Hi,


CrystalReportViewer1.ReportSource = Nothing



If ur problem solved ,pls marked Solved

using System;
using System.Data;
using System.Data.SqlClient;

string sConnectionString = "Integrated Security=SSPI;Initial Catalog=;Data Source=localhost;";

SqlConnection objConn = new...

using System;
using System.Data;
using System.Data.SqlClient;

string sConnectionString = "Integrated Security=SSPI;Initial Catalog=;Data Source=localhost;";

SqlConnection objConn = new...