كود للبحث بين تاريخين

 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim dss As New DataSet
        Dim adq As New SqlClient.SqlDataAdapter

        Dim cmdw As New SqlClient.SqlCommand
        cmdw.Connection = sqlcon
        cmdw.CommandType = CommandType.Text
        cmdw.CommandText = "Select HAdd_Doc,convert(varchar,ZDate,103) as ZDate,Supplier,Payment,KindOfTrans from Adddoc where convert(varchar,ZDate,103) between '" & DateTimePicker1.Value.ToString & "' and  '" & DateTimePicker2.Value.ToString & "'"
        adq.SelectCommand = cmdw
        adq.Fill(dss, "Adddoc")
        DataGridView1.DataSource = dss.Tables("Adddoc")

    End Sub

محمد فؤاد تركي كتب:

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

        Dim dss As New DataSet

        Dim adq As New SqlClient.SqlDataAdapter



        Dim cmdw As New SqlClient.SqlCommand

        cmdw.Connection = sqlcon

        cmdw.CommandType = CommandType.Text

        cmdw.CommandText = "Select HAdd_Doc,convert(varchar,ZDate,103) as ZDate,Supplier,Payment,KindOfTrans from Adddoc where convert(varchar,ZDate,103) between '" & DateTimePicker1.Value.ToString & "' and  '" & DateTimePicker2.Value.ToString & "'"

        adq.SelectCommand = cmdw

        adq.Fill(dss, "Adddoc")

        DataGridView1.DataSource = dss.Tables("Adddoc")



    End Sub

ياريت كوت بالسى شارب جزاك الله كل خير 

DataSet dss = new DataSet();

SqlClient.SqlDataAdapter adq =new SqlClient.SqlDataAdapter();

SqlClient.SqlCommand cmdw =new SqlClient.SqlCommand("",sqlcon);

cmdw.CommandType = CommandType.Text;

cmdw.CommandText = "Select HAdd_Doc,convert(varchar,ZDate,103) as ZDate,Supplier,Payment,KindOfTrans from Adddoc where convert(varchar,ZDate,103) between '" + DateTimePicker1.Value.ToString() & "' and  '" + DateTimePicker2.Value.ToString() + "'";

adq.SelectCommand = cmdw;

adq.Fill(dss, "Adddoc");

DataGridView1.DataSource = dss.Tables["Adddoc"];