How to pass SQL Command and Parameters to another form?

[Tim]

Hi,

I am trying to pass a SQL Command, complete with parameters and their values
from one form to a modal form.

The modal form has;
public void GridDataPreload (System.Data.Sq lClient.SqlComm and cmdPreload)
{
}

the calling form has;
fSaleItems.Grid DataPreload(thi s.cmmSQLUpdateS aleReview);

At the point it is called the cmmSQLUpdateSal eReview has all the params and
their values in it.

When it is passed though it has the right count but none of the value names
(such as @Sale_id) and none of the values.

What has happened to them?

Tim

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

post the code where you instantiate and pass the command to the modal form.

cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Tim" <ti*@home.com > wrote in message
news:tT******** ***********@new s20.bellglobal. com...

Hi,

I am trying to pass a SQL Command, complete with parameters and their
values from one form to a modal form.

The modal form has;
public void GridDataPreload (System.Data.Sq lClient.SqlComm and cmdPreload)
{
}

the calling form has;
fSaleItems.Grid DataPreload(thi s.cmmSQLUpdateS aleReview);

At the point it is called the cmmSQLUpdateSal eReview has all the params
and their values in it.

When it is passed though it has the right count but none of the value
names (such as @Sale_id) and none of the values.

What has happened to them?

Tim

[Tim]

Hi Ignacio here is the code: I instantiate the form set the command and then
show the form modally. Hoping you can help. Tim

MM.Forms.frmSel ectSaleItems fSaleItems = new frmSelectSaleIt ems();
fSaleItems.Grid DataPreload(thi s.cmmSQLUpdateS aleReview);
this.Cursor = Cursors.Default ;
if (fSaleItems.Sho wDialog(this) == System.Windows. Forms.DialogRes ult.OK)
{
itemSelect = true;
this.EnableDisa bleNextButton() ;
this.btnReviewI tems.Enabled = true;
}

"Ignacio Machin ( .NET/ C# MVP )" <ignacio.mach in AT dot.state.fl.us > wrote
in message news:ef******** ********@TK2MSF TNGP09.phx.gbl. ..

Hi,

post the code where you instantiate and pass the command to the modal
form.

cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Tim" <ti*@home.com > wrote in message
news:tT******** ***********@new s20.bellglobal. com...

Hi,

I am trying to pass a SQL Command, complete with parameters and their
values from one form to a modal form.

The modal form has;
public void GridDataPreload (System.Data.Sq lClient.SqlComm and cmdPreload)
{
}

the calling form has;
fSaleItems.Grid DataPreload(thi s.cmmSQLUpdateS aleReview);

At the point it is called the cmmSQLUpdateSal eReview has all the params
and their values in it.

When it is passed though it has the right count but none of the value
names (such as @Sale_id) and none of the values.

What has happened to them?

Tim

[Ron]

Pass the command as an argument in the Form's constructor. That should work OK.

"Tim" wrote:

Hi Ignacio here is the code: I instantiate the form set the command and then
show the form modally. Hoping you can help. Tim

MM.Forms.frmSel ectSaleItems fSaleItems = new frmSelectSaleIt ems();
fSaleItems.Grid DataPreload(thi s.cmmSQLUpdateS aleReview);
this.Cursor = Cursors.Default ;
if (fSaleItems.Sho wDialog(this) == System.Windows. Forms.DialogRes ult.OK)
{
itemSelect = true;
this.EnableDisa bleNextButton() ;
this.btnReviewI tems.Enabled = true;
}

"Ignacio Machin ( .NET/ C# MVP )" <ignacio.mach in AT dot.state.fl.us > wrote
in message news:ef******** ********@TK2MSF TNGP09.phx.gbl. ..

Hi,

post the code where you instantiate and pass the command to the modal
form.

cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"Tim" <ti*@home.com > wrote in message
news:tT******** ***********@new s20.bellglobal. com...

Hi,

I am trying to pass a SQL Command, complete with parameters and their
values from one form to a modal form.

The modal form has;
public void GridDataPreload (System.Data.Sq lClient.SqlComm and cmdPreload)
{
}

the calling form has;
fSaleItems.Grid DataPreload(thi s.cmmSQLUpdateS aleReview);

At the point it is called the cmmSQLUpdateSal eReview has all the params
and their values in it.

When it is passed though it has the right count but none of the value
names (such as @Sale_id) and none of the values.

What has happened to them?

Tim