Execute stored procedures

[anniejacob]

Hi,
i have made a dynamic form in C# where in the textboxes r made dynamically .
so now i have too run some stored procedures.
normally when u write code for the textboxes associated with it as

SqlCommand mysql1 = new SqlCommand("usp_calDiameter", coon);
mysql1.CommandType = CommandType.StoredProcedure;
mysql1.Connection = coon;
mysql1.Parameters.Add(new SqlParameter("@Flowrate", Flowrate));
mysql1.Parameters.Add(new SqlParameter("@SpecificVelocity", SpecificVelocity));
mysql1.Parameters.Add(new SqlParameter("@PSFID", PSFID));


but the prob is that im makin textboxes dynamically so if anyone could help me with the code to execute stored procedures using this dynamic textboxes


hope u people could help me out soon


Bye........

[shweta123]

Hi,

How are you creating the textbox dynamically? If you will create it like this
you will be able to access its value

system.web.ui.webcontrols textbox name=system.web.ui.webcontrols.textbox()

[anniejacob]

Hi,

How are you creating the textbox dynamically? If you will create it like this
you will be able to access its value

system.web.ui.webcontrols textbox name=system.web.ui.webcontrols.textbox()

im using a windows application .
i created textboxes using

TextBox textboxes = new TextBox();
this.Controls.Add(textboxes);

can u help me to execute the stored procedures further

[shweta123]

Hi,

TextBox textboxes = new TextBox();
textboxes.Name = "textbox1"

this.Controls.Add(textboxes);

SqlCommand mysql1 = new SqlCommand("usp_calDiameter", coon);
mysql1.CommandType = CommandType.StoredProcedure;
mysql1.Connection = coon;


'Assign value of textbox in a parameter

Dim p1 as new SqlParameter
p1.Value=this.controls(""textbox1").Text
.......................
.....................
mysql1.Parameters.Add(p1)

[anniejacob]

hi,
in the last post u had given the code as
'Assign value of textbox in a parameter

Dim p1 as new SqlParameter
p1.Value=this.controls(""textbox1").Text
.......................
.....................
mysql1.Parameters.Add(p1)


but then im makin dynamic textboxes so then how 2 pass parameters 4 each.
so then i will have to use some general statement that will take all the parameters 4 as many textboxes present on that form.


In the form im makin, i have to pass some input values that will execute some stored procedures n will give out the output in the same form in textboxes


so i have many stored procedures also that is to b executed in the same form which will calculate the values 4 the textboxes.

so can anyone help me sort it out.

[shweta123]

Hi,

If "textbox1" is one of your textboxes.You can check for it as

for i=0 to me.controls.count
if me.controls(i).Name = ""textbox1" then
'Assign it to the paramter
p1.value= me.controls(i).Text
end if
next