how to give parameter ?

MANEESH AN

13y1.6kVisual Basic .NET

DLL

Connection con = new Connection();

con.OpenConnection();

SqlDataAdapter da = new SqlDataAdapter();

SqlCommand cmd = new SqlCommand();

cmd.Connection = con.conSql;

cmd.CommandText = "sp_PaymentRegisterGridView";

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.AddWithValue("@vSeries", vSeries);

DataTable dts = new DataTable();

da.SelectCommand = cmd;

da.Fill(dts);

con.CloseConnection();

return dts;

BLL

public DataTable fnPayRegDateView(string vSeries)

{

DataTable dt = new DataTable();

dt = objPaymentMasterDL.fnPayRegDateView(vSeries);

return dt;

}

DataTable dt = new DataTable();

dt = objPaymentBL.fnPayRegDateView(txtSeries.Text);I CAN'T GIVE txtseries.text....shall i give parameter name @vSeries....but not get output in front end

ALTER PROCEDURE [dbo].[sp_PaymentRegisterGridView]

(

-- @WhereCondition nvarchar(4000),

@vSeries nvarchar(20)

)

begin

-- declare @sqlQuery nvarchar(4000);

-- set @sqlQuery=

SELECT

ACC.dRPDate DATE,

ACC.cVType TYPE,

TS.vSeries SERIES,

ACC.iRPNo VOUCHERNO,

ACM.vAcName HEAD,

ACC.vNarration NARRATION,

ACC.deDRAmount DEBIT,

ACC.deCRAmount CREDIT

FROM tbl_Acc_Voucher AS ACC INNER JOIN

tblSerialNumbers AS TS ON ACC.iSeriesId = TS.iSeriesId INNER JOIN

tbl_Acc_AccountMaster AS ACM ON ACM.iAcID = ACC.iAcID

WHERE TS.vSeries=@vSeries

--+@WhereCondition

--exec sp_executesql @sqlQuery

end

RETURN

16 Replies

Know the answer? Post it — somebody with the same question will find it here.

Iftikar Hussain13y ago
Accepted answer
try like this

private void ButtonVIEW_Click(object sender, EventArgs e)
{
  frmView view = new frmView();
view.SeriesName=txtSeries.Text;
  view.Show();
  view.Location = new Point(0, 50);
}

Regards,
Iftikar
MANEESH AN13y ago
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using MagnaBL;
using System.Data.SqlClient;

namespace MAGNA
{
public partial class frmPayement : Form
{

PayementBL objPaymentBL = new PayementBL();


public frmPayement()
{
InitializeComponent();
}

#region Decleration

int G_iCoId = LoginSettings.CoId;
ClsCommonFunction objCfun = new ClsCommonFunction();
string strWhereCondition = "";
string vSeries;

#endregion

#region Function


private void frmPayement_Load(object sender, EventArgs e)
{
frmView view = new frmView();
view.@vSeries = txtSeries.Text;
//txtSeries.Text = "ALL";
//string SqlQurry = "where vSeries like '" + txtSeries.Text + "%')";
//dt = new DataTable();
//DataColumn dc1 = new DataColumn(txtSeries.Text);

}

private void FillSeries()
{

string vSeries = " where (vSeries like '" + txtSeries.Text + "%')";
// objCfun.fnLoadListbox(Listgroup, strWhereCondition);
Listgroup.BringToFront();
if (Listgroup.Items.Count > 0)
{
Listgroup.Visible = true;
}
else
{
Listgroup.Visible = false;
}

DataTable dt = new DataTable();
dt = objPaymentBL.fnPayView(strWhereCondition);
if (dt.Rows.Count > 0)
{
cmbseries.DisplayMember = "vSeries";
cmbseries.ValueMember = "vSeries";
}
}

#endregion

#region BtnControl

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

private void ButtonVIEW_Click(object sender, EventArgs e)
{

//string @vSeries = " where cVType='P' and iHeadCodeId!=0 and TS.vSeries='" + txtSeries.Text + "'";
frmView view = new frmView();

view.Show();
view.Location = new Point(0, 50);

//DataTable dt = new DataTable();
//dt = objPaymentBL.fnPayRegDateView(txtSeries.Text);
//dgvPayReg.DataSource = dt;
//if (dt.Rows.Count > 0)
//{
//dgvPayReg.DataSource = dt;
//dgvPayReg.Columns["DATE"].Width = 75;
//dgvPayReg.Columns["TYPE"].Width = 75;
//dgvPayReg.Columns["SERIES"].Width = 75;
//dgvPayReg.Columns["VOUCHERNO"].Width = 75;
//dgvPayReg.Columns["HEAD"].Width = 205;
//dgvPayReg.Columns["NARRATION"].Width = 165;
//dgvPayReg.Columns["DEBIT"].Width = 125;
//dgvPayReg.Columns["CREDIT"].Width = 125;
//}
//Labeldisplay.Text = "PressF6 For Edit Records";
//fnAmountTotal();

//objview.DTFROM.Text = DtpDateFrom.Value.Date.ToString() + "TO" + DtpDateTo.Value.Date.ToString();
}

#endregion

#region ListBox

private void txtSeries_TextChanged(object sender, EventArgs e)
{
FillSeries();

try
{
string StrWhereCondition = " where (vSeries like '" + txtSeries.Text + "%')";
DataTable dt = new DataTable();
dt = objPaymentBL.fnPayView(StrWhereCondition);
// objCfun.fnLoadListbox(Listgroup, strWhereCondition);

if (dt.Rows.Count > 0)
{
Listgroup.DataSource = dt;
Listgroup.DisplayMember = "vSeries ";
Listgroup.ValueMember = "vSeries";

Listgroup.BringToFront();
if (Listgroup.Items.Count > 0)
{
Listgroup.Visible = true;
}

else
{
Listgroup.Visible = false;
}
}
}
catch (Exception ex)
{

MessageBox.Show(ex.Message);
}

}

//private void fnFillSeriesListBox()
//{
// string strSelectQurry = "select iSeriesId,dRPDate,cVType,vSeries,iRPNo,vAcName,vNarration,deDRAmount,deCRAmount from tbl_Acc_Voucher where vSeries like '" + txtSeries.Text.Trim() + "%'";
// //if (txtvehicleno.Text.Trim().Length > 0)
// {
// DataTable dt = new DataTable();
// dt = objPaymentBL.fnPayRegDateView(strWhereCondition);

// Listgroup.BringToFront();
// Listgroup.DataSource = dt;
// fnPayRegDateView();
// Listgroup.DisplayMember = "vSeries";
// Listgroup.ValueMember = "vSeries";
// if (dt.Rows.Count > 0)
// {
// Listgroup.Visible = true;
// }
// else
// {
// Listgroup.Visible = false;
// }
// }
//}

private void txtSeries_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
if (Listgroup.SelectedItems.Count > 0)
{
txtSeries.Text = Listgroup.Text;
// txtSeries.Text = Listgroup.SelectedValue.ToString();
Listgroup.Visible = false;
}
DtpDateFrom.Focus();
}
if (e.KeyCode == Keys.Down)
{
Listgroup.Focus();
}
if (e.KeyValue == 40)
{
Listgroup.Focus();
}
}

private void Listgroup_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter)
{
if (Listgroup.SelectedItems.Count > 0)
{
txtSeries.Text = Listgroup.Text;
//txtSeries.Text = Listgroup.SelectedValue.ToString();
Listgroup.Visible = false;
}
DtpDateFrom.Focus();
}
}

#endregion

//private void GpbPayReg_Enter(object sender, EventArgs e)
//{

//}

}
}
Iftikar Hussain13y ago
please share me your code of form1.

Regards,
Iftikar
MANEESH AN13y ago
i had declared variable name like this public string SeriesName in form 2?
i got null in the value of parameter in asp.net?
i dont get textbox name in form2 which i made in form1?
Iftikar Hussain13y ago
how you are display form2 from form1?

Regards,
Iftikar
MANEESH AN13y ago
No way to get in control to type txtSeries.Text....how to get in form2
Form2 form2=new Form2();
form2.SeriesName = txtSeries.Text;
i declare public string vSeries i n form2 also
Iftikar Hussain13y ago
please declare variable name like this public string SeriesName;

Regards,
Iftikar
MANEESH AN13y ago
frmView view = new frmView();
view.@vSeries = @vSeries;

dt = objViewBL.fnPayRegDateView(@vSeries);BUT @vSeries showing null...which not showing any selected value?

I GOT AN ERROR

Procedure or Function 'sp_PaymentRegisterGridView' expects parameter '@vSeries', which was not supplied.
Iftikar Hussain13y ago
declare one public variable in your form2

public string SeriesName;

and pass the value while loading the form2

Form2 form2=new Form2();
form2.SeriesName = txtSeries.Text;

and pass this

DataTable dt = new DataTable();
dt = objPaymentBL.fnPayRegDateView(SeriesName)

Regards,
Iftikar
MANEESH AN13y ago
yes...how can i access name of text box..example txtseries.text in load event form of grid
Iftikar Hussain13y ago
you trying to pass txtSeries.Text from form1 to form2 and display the result.

Regards,
Iftikar
MANEESH AN13y ago
I HAD DESIGNED ONE TEXTBOX,ONE BUTTON,TWO DATE TIME PICKER IN A FORM.WHEN I SELECT A VALUE IN THAT TEXTBOX AND THEN CLICK THE BUTTON,ANOTHER FORM, GRID WILL DISPLAY ACCORDING TO SELECTION OF VALUE OR SERIES IN TEXTBOX.BUT MY PROBLEM IS NOT GETTING CONTROL IN KEYPAD FOR NAME OF THAT TEXTBOX IN THE FORM OF GRID.IN THE LOAD EVENT OF GRID,I HAVE TO WRITE dt = objPaymentBL.fnPayRegDateView(txtSeries.Text).HOW CAN I DO?
Iftikar Hussain13y ago
Have you declared txtSeries as server control in your design?

Regards,
Iftikar
MANEESH AN13y ago
no error message...i cant type txtseries.text........
Iftikar Hussain13y ago
Hi,
What error message you are getting while declaring like this
dt = objPaymentBL.fnPayRegDateView(txtSeries.Text);

Regards,
Iftikar
Kunal Vaishya13y ago
Hi try this

Connection con = new Connection();
con.OpenConnection();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con.conSql;
cmd.CommandText = "sp_PaymentRegisterGridView";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@vSeries", vSeries);
DataTable dts = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dts);
con.CloseConnection();
return dts;