how can query creating schmename and duedate

Alter PROCEDURE sp_over
(
@vParty_Id varchar(50),
@dDue_Date datetime,
@dtF datetime
)
AS
begin



select vLoan_No As LoanNumaber,dIssue_Date As Date,vParty_Id As CustomerName,dcLoan_Amt As LoanAmount,dDue_Date As DueDate from tbl_LoanMaster

WHERE vParty_Id>=@vParty_Id and dDue_Date<=@dtF and vStatus='N'

end

string vParty_Id = "";
DateTime dtF;

********

LoanEntryBL objLoanEntryBL = new LoanEntryBL();

******
private void frmOverdueRegister_Load(object sender, EventArgs e)
{

fnFill();
DataTable dt = new DataTable();
dataGridView1.DataSource = dt;
dataGridView1.Columns[0].Width = 75;
dataGridView1.Columns[1].Width = 75;
dataGridView1.Columns[2].Width = 68;
dataGridView1.Columns[3].Width = 230;
dataGridView1.Columns[4].Width = 72;
dataGridView1.Columns[5].Width = 68;
}

private void fnFill() //selected iteam combox
{
try
{
DataTable dt = new DataTable();
dt = null;
string WhereCondition = "";
dt = objSchemeMasterBL.fnSearchSchemeMaster(WhereCondition);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{

cmbScheme.DisplayMember = "vScheme_Name";
cmbScheme.ValueMember = "iSchemeID";

cmbScheme.DataSource = dt;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}


******************
private void btnExit_Click(object sender, EventArgs e)
{
this.Close();
}

*************** dtF //The type 'ORCHID.frmOverdueRegister' already contains a definition for 'dtF'
private void button1_Click(object sender, EventArgs e)
{
DateTime dtF;

DataTable dt = new DataTable();
dt = objLoanEntryBL.fnOverdueRegister(vParty_Id, dtF);

}
frist one declare dtF

Please tell me in what condition you need the output

Regards,
Iftikar

send me  the qury and stored procedure pleaaase

private void button1_Click(object sender, EventArgs e)
{
string vParty_Id = "";
DateTime dtF;

DataTable dt = new DataTable();
dt = objLoanEntryBL.fnOverdueRegister(vParty_Id, dtF);//Error

//dataGridView1.DataSource = dt;///////// correct sir but error in dt
//dataGridView1.Columns[0].Width = 75;
//dataGridView1.Columns[1].Width = 75;
//dataGridView1.Columns[2].Width = 68;
//dataGridView1.Columns[3].Width = 230;
//dataGridView1.Columns[4].Width = 72;
//dataGridView1.Columns[5].Width = 68;

}


// EROOR Use of unassigned local variable 'dtF'

try like this

dt = objLoanEntryBL.fnOverdueRegister(vParty_Id, dtF);
dataGridView1.DataSource = dt;

Regards,
Iftikar

dt error:'dt' is a 'variable' but is used like a 'method'

dt = objLoanEntryBL.fnOverdueRegister(vParty_Id, dtF);
dataGridView1.DataSource = dt(cmbScheme.Text, dtF);

slect query
*******
Alter PROCEDURE sp_over                       
(    
  @vParty_Id varchar(50),                  
 @dDue_Date datetime,       
 @dtF datetime       
)                        
AS                         
 begin                            
                         
        
         
select  vLoan_No As LoanNumaber,dIssue_Date As Date,vParty_Id As CustomerName,dcLoan_Amt As LoanAmount,dDue_Date As DueDate from tbl_LoanMaster                
     
WHERE vParty_Id>=@vParty_Id and dDue_Date<=@dtF  and vStatus='N'    

end


query correct checking and  dt error // checking

i m still not clear about in what condition you need the output

Regards,
Iftikar

sql correct ans replay

try like this

public DataTable fnOverdueRegister(string vParty_Id, DateTime dtF)
        {
            DataTable dt = new DataTable();
            dt = objLoanEntryDL.fnOverdueRegister(vParty_Id, dtF);

return dt;
        }

Regards,
Iftikar

pls ans sir

pls check code error the bl**'ORCHIDBL.LoanEntryBL.fnOverdueRegister(string, System.DateTime)': not all code paths return a value


btn
*********
            string vParty_Id = "";
            DateTime dtF;
            DataTable dt = new DataTable();
            dt = objLoanEntryBL.fnOverdueRegister(vParty_Id, dtF);
            dataGridView1.DataSource = dt(cmbScheme.Text, dtF);
            dataGridView1.Columns[0].Width = 75;
            dataGridView1.Columns[1].Width = 75;
            dataGridView1.Columns[2].Width = 68;
            dataGridView1.Columns[3].Width = 230;
            dataGridView1.Columns[4].Width = 72;
            dataGridView1.Columns[5].Width = 68;


bl*********
   public DataTable fnOverdueRegister(string vParty_Id, DateTime dtF)
        {
            DataTable dt = new DataTable();
            dt = objLoanEntryDL.fnOverdueRegister(vParty_Id, dtF);
        }

Dl**********

  public DataTable fnOverdueRegister(string vParty_Id, DateTime dtF)
        {
            Connection con = new Connection();
            con.OpenConnection();
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = con.conSql;
            cmd.CommandText = "sp_over ";
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@vScheme", vParty_Id);
            cmd.Parameters.AddWithValue("@DateFrom", dtF);
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataTable dt = new DataTable();
            da.Fill(dt);
            con.CloseConnection();
            return dt;
        }

sql**********
Alter PROCEDURE sp_over                       
(    
  @vParty_Id varchar(50),                  
 @dDue_Date datetime,       
 @dtF datetime       
)                        
AS                         
 begin                            
                         
        
         
select  vLoan_No As LoanNumaber,dIssue_Date As Date,vParty_Id As CustomerName,dcLoan_Amt As LoanAmount,dDue_Date As DueDate from tbl_LoanMaster                
     
WHERE vParty_Id>=@vParty_Id and dDue_Date<=@dtF  and vStatus='N'    

end

can you explain in detail?

Regards,
Iftikar

one query using display duelist customername

pls Ans Sir