how can query creating schmename and duedate

Question

Scheme bind combobox(Schem A Scheme B) perioddate(closedate) A=365 and b=4 date in datepicker show btn ****** query creating scheme and dDue_Date(closing) checking but no closing list nameparty display partylist select vLoan_No As LoanNumaberdIssue_Date As DatevParty_Id As CustomerNamedcLoan_Amt As LoanAmountdDue_Date As DueDate from tbl_LoanMaster vScheme and dDue_Date eg: in an scheme A open loan 500 inthis sitvatio closing date display date of (365) scheme A combobox select amount no closing list display at time datepicker select date:

Safeer Safeer · Answer

i need that family registration sir...plz

JAYESH AJ · Answer

Alter PROCEDURE sp_over ( @vParty_Id varchar(50) @dDue_Date datetime @dtF datetime ) AS begin select vLoan_No As LoanNumaberdIssue_Date As DatevParty_Id As CustomerNamedcLoan_Amt As LoanAmountdDue_Date As DueDate from tbl_LoanMaster WHERE vParty_Id>=@vParty_Id and dDue_Date end

Safeer Safeer · Answer

while am entering save button saving only house no address phone no and owner name.. datagridview datas does not saving the table or database

Safeer Safeer · Answer

please send me the stored procedure and the qury

JAYESH AJ · Answer

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 { 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

Iftikar Hussain · Answer

Please tell me in what condition you need the output Regards Iftikar

Safeer Safeer · Answer

send me the qury and stored procedure pleaaase

JAYESH AJ · Answer

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'

Iftikar Hussain · Answer

try like this dt = objLoanEntryBL.fnOverdueRegister(vParty_Id dtF); dataGridView1.DataSource = dt; Regards Iftikar

JAYESH AJ · Answer

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 LoanNumaberdIssue_Date As DatevParty_Id As CustomerNamedcLoan_Amt As LoanAmountdDue_Date As DueDate from tbl_LoanMaster WHERE vParty_Id>=@vParty_Id and dDue_Date end query correct checking and dt error // checking

Iftikar Hussain · Answer

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

JAYESH AJ · Answer

sql correct ans replay

Iftikar Hussain · Answer

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

JAYESH AJ · Answer

pls ans sir

JAYESH AJ · Answer

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 LoanNumaberdIssue_Date As DatevParty_Id As CustomerNamedcLoan_Amt As LoanAmountdDue_Date As DueDate from tbl_LoanMaster WHERE vParty_Id>=@vParty_Id and dDue_Date end

Iftikar Hussain · Answer

can you explain in detail? Regards Iftikar

JAYESH AJ · Answer

one query using display duelist customername

Iftikar Hussain · Answer

Hi If the period days in Year then try like this select vLoan_No As LoanNumaberdIssue_Date As DatevParty_Id As CustomerNamedcLoan_Amt As LoanAmountdDue_Date As DueDate from tbl_LoanMaster where scheme_name and period_days>=DATEDIFF(yy f rom  todate ) for month select vLoan_No As LoanNumaberdIssue_Date As DatevParty_Id As CustomerNamedcLoan_Amt As LoanAmountdDue_Date As DueDate from tbl_LoanMaster where scheme_name and period_days>=DATEDIFF(mm f rom  todate ) for day select vLoan_No As LoanNumaberdIssue_Date As DatevParty_Id As CustomerNamedcLoan_Amt As LoanAmountdDue_Date As DueDate from tbl_LoanMaster where scheme_name and period_days>=DATEDIFF(dd f rom  todate ) Regards Iftikar

JAYESH AJ · Answer

pls Ans Sir