bulk insert - form collections for novice

[Sean]

HI There,

I am making the transition from asp to asp .net, I am currenty writing an
application that requires a bulk insert from a webform into SQL server,
normally I would just create rows of html textboxes and then use the
Request.Form.Count property to collect each field. What I would like to know
is what is a good way of doing this in asp.net? Do I need to create an array
of textboxes or can I do this fro a datagrid?
Sean - Thanks in advance

[Steve C. Orr [MVP, MCSD]]

I'm not following you 100%, but it sounds like its probably a good job for
either a datagrid or a repeater. Repeaters are more manual but give you
additional flexibility. Datagrids are more automatic but have limitations.

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net
"Sean" <se**********@shopsmart.com.au> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...

HI There,

I am making the transition from asp to asp .net, I am currenty writing an
application that requires a bulk insert from a webform into SQL server,
normally I would just create rows of html textboxes and then use the
Request.Form.Count property to collect each field. What I would like to know is what is a good way of doing this in asp.net? Do I need to create an array of textboxes or can I do this fro a datagrid?
Sean - Thanks in advance

[Sean]

HI Steve,

If I have a datagrid can I create empty textboxes in coumns? do you have any
code snippets?

Sean

"Steve C. Orr [MVP, MCSD]" <St***@Orr.net> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...

I'm not following you 100%, but it sounds like its probably a good job for
either a datagrid or a repeater. Repeaters are more manual but give you
additional flexibility. Datagrids are more automatic but have limitations.
--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net
"Sean" <se**********@shopsmart.com.au> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...

HI There,

I am making the transition from asp to asp .net, I am currenty writing an application that requires a bulk insert from a webform into SQL server,
normally I would just create rows of html textboxes and then use the
Request.Form.Count property to collect each field. What I would like to

know

is what is a good way of doing this in asp.net? Do I need to create an

array

of textboxes or can I do this fro a datagrid?
Sean - Thanks in advance

[Alan Ferrandiz Langley]

I don't think a Repeater or Datagrid is a good option for this. You can use
ASP.NET TextBox controls to achieve what you want. Just create a regular
form with as many ASP.NET TextBox controls as you want and then you can use
this code to collect values from your ASP.NET Textbox controls. Be aware
that any control you create is a child of <FORM>
(System.Web.UI.HtmlControls.HtmlForm) so you will first have to find it as a
control of your Page class, once you have found it in the control collection
you have to iterate in the HtmlForm's control collection to find the TextBox
controls. You can then add the values to an ArrayList class (a dynamic
array) and retrieve each value by its index

Hope this helps
Alan Ferrandiz
MCT;MCDBA,MCSD
MSF Practitioner

Dim aValues As New ArrayList()
Dim iCount As Integer

If Page.IsPostBack Then
Dim ctlFormulario, ctlControl As Control
For Each ctlFormulario In Me.Controls
If TypeOf (ctlFormulario) Is
System.Web.UI.HtmlControls.HtmlForm Then
For Each ctlControl In ctlFormulario.Controls
If TypeOf (ctlControl) Is TextBox Then
aValues.Add(CType(ctlControl, TextBox).Text)
Response.Write(aValues(iCount) & "<BR>")
iCount += 1
End If
Next
End If
Next
End If

"Sean" <se**********@shopsmart.com.au> escribió en el mensaje
news:#3**************@TK2MSFTNGP12.phx.gbl...

HI Steve,

If I have a datagrid can I create empty textboxes in coumns? do you have any code snippets?

Sean

"Steve C. Orr [MVP, MCSD]" <St***@Orr.net> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...

I'm not following you 100%, but it sounds like its probably a good job for

either a datagrid or a repeater. Repeaters are more manual but give you
additional flexibility. Datagrids are more automatic but have

limitations.

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net
"Sean" <se**********@shopsmart.com.au> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...

HI There,

I am making the transition from asp to asp .net, I am currenty writing an application that requires a bulk insert from a webform into SQL server, normally I would just create rows of html textboxes and then use the
Request.Form.Count property to collect each field. What I would like

to know

is what is a good way of doing this in asp.net? Do I need to create an

array

of textboxes or can I do this fro a datagrid?
Sean - Thanks in advance

[Sean]

HI Alan,

Thanks for answering my question, just one other thing. If I need to create
rows of textboxes with the same name how can I acheive this? given that I
get errors if two controls have the same name.

Sean
"Alan Ferrandiz Langley" <af********@online.labroe.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...

I don't think a Repeater or Datagrid is a good option for this. You can use ASP.NET TextBox controls to achieve what you want. Just create a regular
form with as many ASP.NET TextBox controls as you want and then you can use this code to collect values from your ASP.NET Textbox controls. Be aware
that any control you create is a child of <FORM>
(System.Web.UI.HtmlControls.HtmlForm) so you will first have to find it as a control of your Page class, once you have found it in the control collection you have to iterate in the HtmlForm's control collection to find the TextBox controls. You can then add the values to an ArrayList class (a dynamic
array) and retrieve each value by its index

Hope this helps
Alan Ferrandiz
MCT;MCDBA,MCSD
MSF Practitioner

Dim aValues As New ArrayList()
Dim iCount As Integer

If Page.IsPostBack Then
Dim ctlFormulario, ctlControl As Control
For Each ctlFormulario In Me.Controls
If TypeOf (ctlFormulario) Is
System.Web.UI.HtmlControls.HtmlForm Then
For Each ctlControl In ctlFormulario.Controls
If TypeOf (ctlControl) Is TextBox Then
aValues.Add(CType(ctlControl, TextBox).Text)
Response.Write(aValues(iCount) & "<BR>")
iCount += 1
End If
Next
End If
Next
End If

"Sean" <se**********@shopsmart.com.au> escribió en el mensaje
news:#3**************@TK2MSFTNGP12.phx.gbl...

HI Steve,

If I have a datagrid can I create empty textboxes in coumns? do you have

any

code snippets?

Sean

"Steve C. Orr [MVP, MCSD]" <St***@Orr.net> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...

I'm not following you 100%, but it sounds like its probably a good job for either a datagrid or a repeater. Repeaters are more manual but give you additional flexibility. Datagrids are more automatic but have

limitations.

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net
"Sean" <se**********@shopsmart.com.au> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...
> HI There,
>
> I am making the transition from asp to asp .net, I am currenty writing

an

> application that requires a bulk insert from a webform into SQL server, > normally I would just create rows of html textboxes and then use the
> Request.Form.Count property to collect each field. What I would like to know
> is what is a good way of doing this in asp.net? Do I need to create

an array
> of textboxes or can I do this fro a datagrid?
>
>
> Sean - Thanks in advance
>
>

[Alan Ferrandiz Langley]

I guess you mean controls with the same ID, which is the property that
identifies a control in the server. Well an ID has to be
unique as far as i know, but if you want to have something like a name that
is exactly the sameto your TextBox controls, you can add an attribute to the
Attributes collection of your TextBox controls.

The first time page loads you add an attribute to each TextBox control and
when the page is doing a postback you check in every control that attribute
you added. In my case i added an attribute called MyName and set it to the
value "MyId".

Alan Ferrandiz Langley
MCT, MCSD, MCDBA
MSF Practitioner

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load

Dim aValues As New ArrayList()
Dim iCount As Integer

If Page.IsPostBack Then ' page is doing postback
Dim ctlFormulario, ctlControl As Control
For Each ctlFormulario In Me.Controls
If TypeOf (ctlFormulario) Is
System.Web.UI.HtmlControls.HtmlForm Then
For Each ctlControl In ctlFormulario.Controls
If TypeOf (ctlControl) Is TextBox Then
If CType(ctlControl,
TextBox).Attributes.Item("MyName") = "MyId" Then
aValues.Add(CType(ctlControl, TextBox).Text)
Response.Write(CType(ctlControl,
TextBox).Attributes.Item("MyName") & "<BR>")
Response.Write(aValues(iCount) & "<BR>")
iCount += 1
End If
End If
Next
End If
Next
Else ' first time page loads, add same attribute to your TextBox
controls
TextBox1.Attributes.Add("MyName", "MyId")
TextBox2.Attributes.Add("MyName", "MyId")
TextBox3.Attributes.Add("MyName", "MyId")
TextBox4.Attributes.Add("MyName", "MyId")
TextBox5.Attributes.Add("MyName", "MyId")
End If

End Sub
"Sean" <se**********@shopsmart.com.au> escribió en el mensaje
news:eS**************@tk2msftngp13.phx.gbl...

HI Alan,

Thanks for answering my question, just one other thing. If I need to create rows of textboxes with the same name how can I acheive this? given that I
get errors if two controls have the same name.

Sean
"Alan Ferrandiz Langley" <af********@online.labroe.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...

I don't think a Repeater or Datagrid is a good option for this. You can use

ASP.NET TextBox controls to achieve what you want. Just create a regular
form with as many ASP.NET TextBox controls as you want and then you can

use

this code to collect values from your ASP.NET Textbox controls. Be aware
that any control you create is a child of <FORM>
(System.Web.UI.HtmlControls.HtmlForm) so you will first have to find it as a

control of your Page class, once you have found it in the control collection

you have to iterate in the HtmlForm's control collection to find the

TextBox

controls. You can then add the values to an ArrayList class (a dynamic
array) and retrieve each value by its index

Hope this helps
Alan Ferrandiz
MCT;MCDBA,MCSD
MSF Practitioner

Dim aValues As New ArrayList()
Dim iCount As Integer

If Page.IsPostBack Then
Dim ctlFormulario, ctlControl As Control
For Each ctlFormulario In Me.Controls
If TypeOf (ctlFormulario) Is
System.Web.UI.HtmlControls.HtmlForm Then
For Each ctlControl In ctlFormulario.Controls
If TypeOf (ctlControl) Is TextBox Then
aValues.Add(CType(ctlControl, TextBox).Text)
Response.Write(aValues(iCount) & "<BR>")
iCount += 1
End If
Next
End If
Next
End If

"Sean" <se**********@shopsmart.com.au> escribió en el mensaje
news:#3**************@TK2MSFTNGP12.phx.gbl...

HI Steve,

If I have a datagrid can I create empty textboxes in coumns? do you have

any

code snippets?

Sean

"Steve C. Orr [MVP, MCSD]" <St***@Orr.net> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...
> I'm not following you 100%, but it sounds like its probably a good

job for

> either a datagrid or a repeater. Repeaters are more manual but give you > additional flexibility. Datagrids are more automatic but have
limitations.
>
> --
> I hope this helps,
> Steve C. Orr, MCSD, MVP
> http://Steve.Orr.net
>
>
> "Sean" <se**********@shopsmart.com.au> wrote in message
> news:%2****************@TK2MSFTNGP12.phx.gbl...
> > HI There,
> >
> > I am making the transition from asp to asp .net, I am currenty writing an
> > application that requires a bulk insert from a webform into SQL

server,

> > normally I would just create rows of html textboxes and then use

the > > Request.Form.Count property to collect each field. What I would

like to

> know
> > is what is a good way of doing this in asp.net? Do I need to

create an > array
> > of textboxes or can I do this fro a datagrid?
> >
> >
> > Sean - Thanks in advance
> >
> >
>
>

[sean]

HI Alan,

I tried your code as it was and I could not get it to work at all, I change
some of the properties and it seems now to be working but iterates through
the controls a number of times. I have tried to exit the for loop when the
last control has been displayed but this is not working, what am I doing
wrong?

Sean - thanks in advance for your answer.
Dim aValues As New ArrayList()
Dim iCount As Integer
Dim counter as Integer

If Page.IsPostBack Then
'Dim myConnection as New
SqlConnection(ConfigurationSettings.AppSettings("c onnectionString"))

'myConnection.Open()

Dim ctlFormulario, ctlControl As Control
For Each ctlFormulario In Me.Controls
'If TypeOf (ctlFormulario) Is
System.Web.UI.HtmlControls.HtmlForm Then
If TypeOf (ctlFormulario) Is
System.Web.UI.WebControls.TextBox Then
'For Each ctlControl In ctlFormulario.Controls
For Each ctlControl In ME.Controls

If TypeOf (ctlControl) Is TextBox Then
aValues.Add(CType(ctlControl, TextBox).Text)
response.write (CType(ctlControl, TextBox).ID & "<BR>")
Response.Write(" " & aValues(iCount) & "<BR>")

iCount += 1
counter += 1

If CType(ctlControl, TextBox).ID = "txtPrice6"
Then Exit For

'Dim myCommand As New SqlCommand("ListingAddFertigation",
myConnection)
'myCommand.CommandType = CommandType.StoredProcedure
End If
Next
End If
Next
End If

!--- form code snippet

<tr>
<td><asp:TextBox id="txtQuantity6" width="30" maxlength="30" runat="server"
/></td>
<td><asp:TextBox id="txtDescription6" width="150" style="height:55px;"
maxlength="250" runat="server" /></td>
<td><asp:TextBox id="txtSize6" width="30" maxlength="30" runat="server"
/></td>
<td><asp:TextBox id="txtMaterial6" width="150" style="height:55px;"
maxlength="250" runat="server" /></td>
<td><asp:TextBox id="txtPrice6" width="30" maxlength="30" runat="server"
/></td>
</tr>
"Alan Ferrandiz Langley" <af********@online.labroe.com> wrote in message
news:#E**************@TK2MSFTNGP10.phx.gbl...

I guess you mean controls with the same ID, which is the property that
identifies a control in the server. Well an ID has to be
unique as far as i know, but if you want to have something like a name that is exactly the sameto your TextBox controls, you can add an attribute to the Attributes collection of your TextBox controls.

The first time page loads you add an attribute to each TextBox control and
when the page is doing a postback you check in every control that attribute you added. In my case i added an attribute called MyName and set it to the
value "MyId".

Alan Ferrandiz Langley
MCT, MCSD, MCDBA
MSF Practitioner

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load

Dim aValues As New ArrayList()
Dim iCount As Integer

If Page.IsPostBack Then ' page is doing postback
Dim ctlFormulario, ctlControl As Control
For Each ctlFormulario In Me.Controls
If TypeOf (ctlFormulario) Is
System.Web.UI.HtmlControls.HtmlForm Then
For Each ctlControl In ctlFormulario.Controls
If TypeOf (ctlControl) Is TextBox Then
If CType(ctlControl,
TextBox).Attributes.Item("MyName") = "MyId" Then
aValues.Add(CType(ctlControl, TextBox).Text) Response.Write(CType(ctlControl,
TextBox).Attributes.Item("MyName") & "<BR>")
Response.Write(aValues(iCount) & "<BR>")
iCount += 1
End If
End If
Next
End If
Next
Else ' first time page loads, add same attribute to your TextBox
controls
TextBox1.Attributes.Add("MyName", "MyId")
TextBox2.Attributes.Add("MyName", "MyId")
TextBox3.Attributes.Add("MyName", "MyId")
TextBox4.Attributes.Add("MyName", "MyId")
TextBox5.Attributes.Add("MyName", "MyId")
End If

End Sub
"Sean" <se**********@shopsmart.com.au> escribió en el mensaje
news:eS**************@tk2msftngp13.phx.gbl...

HI Alan,

Thanks for answering my question, just one other thing. If I need to create

rows of textboxes with the same name how can I acheive this? given that I

get errors if two controls have the same name.

Sean
"Alan Ferrandiz Langley" <af********@online.labroe.com> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...

I don't think a Repeater or Datagrid is a good option for this. You can

use

ASP.NET TextBox controls to achieve what you want. Just create a

regular form with as many ASP.NET TextBox controls as you want and then you can use

this code to collect values from your ASP.NET Textbox controls. Be

aware that any control you create is a child of <FORM>
(System.Web.UI.HtmlControls.HtmlForm) so you will first have to find it as

a

control of your Page class, once you have found it in the control

collection

you have to iterate in the HtmlForm's control collection to find the

TextBox

controls. You can then add the values to an ArrayList class (a dynamic
array) and retrieve each value by its index

Hope this helps
Alan Ferrandiz
MCT;MCDBA,MCSD
MSF Practitioner

Dim aValues As New ArrayList()
Dim iCount As Integer

If Page.IsPostBack Then
Dim ctlFormulario, ctlControl As Control
For Each ctlFormulario In Me.Controls
If TypeOf (ctlFormulario) Is
System.Web.UI.HtmlControls.HtmlForm Then
For Each ctlControl In ctlFormulario.Controls
If TypeOf (ctlControl) Is TextBox Then
aValues.Add(CType(ctlControl,

TextBox).Text) Response.Write(aValues(iCount) & "<BR>")
iCount += 1
End If
Next
End If
Next
End If

"Sean" <se**********@shopsmart.com.au> escribió en el mensaje
news:#3**************@TK2MSFTNGP12.phx.gbl...
> HI Steve,
>
> If I have a datagrid can I create empty textboxes in coumns? do you

have any
> code snippets?
>
> Sean
>
> "Steve C. Orr [MVP, MCSD]" <St***@Orr.net> wrote in message
> news:%2****************@TK2MSFTNGP10.phx.gbl...
> > I'm not following you 100%, but it sounds like its probably a good job for
> > either a datagrid or a repeater. Repeaters are more manual but

give you

> > additional flexibility. Datagrids are more automatic but have
> limitations.
> >
> > --
> > I hope this helps,
> > Steve C. Orr, MCSD, MVP
> > http://Steve.Orr.net
> >
> >
> > "Sean" <se**********@shopsmart.com.au> wrote in message
> > news:%2****************@TK2MSFTNGP12.phx.gbl...
> > > HI There,
> > >
> > > I am making the transition from asp to asp .net, I am currenty

writing

> an
> > > application that requires a bulk insert from a webform into SQL
server,
> > > normally I would just create rows of html textboxes and then use

the > > > Request.Form.Count property to collect each field. What I would like to
> > know
> > > is what is a good way of doing this in asp.net? Do I need to

create

an

> > array
> > > of textboxes or can I do this fro a datagrid?
> > >
> > >
> > > Sean - Thanks in advance
> > >
> > >
> >
> >
>
>