By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,218 Members | 1,111 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,218 IT Pros & Developers. It's quick & easy.

What i must use to create this form?

P: n/a
Hello!

I have strange and simple problem....
I am starting developer. I need to create webform, that will insert my data
into SQL 2005 database.
My idea is to make something like MS Access Form-Subform. I'm typing data,
pressing "Add" and i see it on datagrid below. So I can type second datas,
press "Add" and now i will see two records below.

I'm using .NET (2.0), SQL 2005.

My form have two regions on one page:
- I - few texboxes, two dropdownlists (here are records from specific
tables), one button "Add"
- II - (here I need something like datalist), one button "Send to SQL"

How should look that engine?
I have ready:
- region I with textboxes and SQLcommand, that is inserting records now
into SQL database
- dataset with datatables and relations between

How to insert data into dataset and then insert it into datalist?
What I must use?

Thanks
Leszek
Oct 30 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a

on the post back use an sqlcommand to insert the data and another sqlcommqnd to requery the table to get the records desired and
bind to the gridview



"marek zegarek" <ma***@zegarek.plwrote in message news:u0**************@TK2MSFTNGP03.phx.gbl...
Hello!

I have strange and simple problem....
I am starting developer. I need to create webform, that will insert my data into SQL 2005 database.
My idea is to make something like MS Access Form-Subform. I'm typing data, pressing "Add" and i see it on datagrid below. So I can
type second datas, press "Add" and now i will see two records below.

I'm using .NET (2.0), SQL 2005.

My form have two regions on one page:
- I - few texboxes, two dropdownlists (here are records from specific tables), one button "Add"
- II - (here I need something like datalist), one button "Send to SQL"

How should look that engine?
I have ready:
- region I with textboxes and SQLcommand, that is inserting records now into SQL database
- dataset with datatables and relations between

How to insert data into dataset and then insert it into datalist?
What I must use?

Thanks
Leszek


Oct 31 '06 #2

P: n/a
As I sad, I have form with few controls to type data.
When I push button "Add", i want to add it to datalist. Not to the database.
Then i need to add second, and third, and etc row with new data into this
datalist.
Then on finish will be button "Save" (for example), that will save all into
database.

How to add something to this datalist wiithout using sqlconnection?


Użytkownik "Jon Paal" <Jon[ nospam ]Paal @ everywhere dot comnapisał w
wiadomości news:u8**************@TK2MSFTNGP04.phx.gbl...
>
on the post back use an sqlcommand to insert the data and another
sqlcommqnd to requery the table to get the records desired and bind to the
gridview



"marek zegarek" <ma***@zegarek.plwrote in message
news:u0**************@TK2MSFTNGP03.phx.gbl...
>Hello!

I have strange and simple problem....
I am starting developer. I need to create webform, that will insert my
data into SQL 2005 database.
My idea is to make something like MS Access Form-Subform. I'm typing
data, pressing "Add" and i see it on datagrid below. So I can type second
datas, press "Add" and now i will see two records below.

I'm using .NET (2.0), SQL 2005.

My form have two regions on one page:
- I - few texboxes, two dropdownlists (here are records from specific
tables), one button "Add"
- II - (here I need something like datalist), one button "Send to SQL"

How should look that engine?
I have ready:
- region I with textboxes and SQLcommand, that is inserting records now
into SQL database
- dataset with datatables and relations between

How to insert data into dataset and then insert it into datalist?
What I must use?

Thanks
Leszek



Oct 31 '06 #3

P: n/a
Hi there,

how about something like this:

1. Create and populate a dataset object and bind it to the datalist control/
2. When the user clicks ADD, read the new record values that were entered,
and add a new DataRow to the dataset, then rebind the dataset again to the
datalist control.

3. When user clicks save, loop through the items in the dataset, and insert
them all into the database.

regards,
Paul

"marek zegarek" <ma***@zegarek.plwrote in message
news:er*************@TK2MSFTNGP03.phx.gbl...
As I sad, I have form with few controls to type data.
When I push button "Add", i want to add it to datalist. Not to the
database.
Then i need to add second, and third, and etc row with new data into this
datalist.
Then on finish will be button "Save" (for example), that will save all
into database.

How to add something to this datalist wiithout using sqlconnection?


Użytkownik "Jon Paal" <Jon[ nospam ]Paal @ everywhere dot comnapisał w
wiadomości news:u8**************@TK2MSFTNGP04.phx.gbl...
>>
on the post back use an sqlcommand to insert the data and another
sqlcommqnd to requery the table to get the records desired and bind to
the gridview



"marek zegarek" <ma***@zegarek.plwrote in message
news:u0**************@TK2MSFTNGP03.phx.gbl...
>>Hello!

I have strange and simple problem....
I am starting developer. I need to create webform, that will insert my
data into SQL 2005 database.
My idea is to make something like MS Access Form-Subform. I'm typing
data, pressing "Add" and i see it on datagrid below. So I can type
second datas, press "Add" and now i will see two records below.

I'm using .NET (2.0), SQL 2005.

My form have two regions on one page:
- I - few texboxes, two dropdownlists (here are records from specific
tables), one button "Add"
- II - (here I need something like datalist), one button "Send to SQL"

How should look that engine?
I have ready:
- region I with textboxes and SQLcommand, that is inserting records now
into SQL database
- dataset with datatables and relations between

How to insert data into dataset and then insert it into datalist?
What I must use?

Thanks
Leszek




Oct 31 '06 #4

P: n/a
I made it 2 hours ago :)
I didn't knew, how to do this, but now everything is ok :)

I will use your 2) to rebind.

Thanks Milsnips!

Użytkownik "Milsnips" <mi******@hotmail.comnapisał w wiadomości
news:uy**************@TK2MSFTNGP04.phx.gbl...
Hi there,

how about something like this:

1. Create and populate a dataset object and bind it to the datalist
control/
2. When the user clicks ADD, read the new record values that were entered,
and add a new DataRow to the dataset, then rebind the dataset again to the
datalist control.

3. When user clicks save, loop through the items in the dataset, and
insert them all into the database.

regards,
Paul

"marek zegarek" <ma***@zegarek.plwrote in message
news:er*************@TK2MSFTNGP03.phx.gbl...
>As I sad, I have form with few controls to type data.
When I push button "Add", i want to add it to datalist. Not to the
database.
Then i need to add second, and third, and etc row with new data into this
datalist.
Then on finish will be button "Save" (for example), that will save all
into database.

How to add something to this datalist wiithout using sqlconnection?


Użytkownik "Jon Paal" <Jon[ nospam ]Paal @ everywhere dot comnapisał w
wiadomości news:u8**************@TK2MSFTNGP04.phx.gbl...
>>>
on the post back use an sqlcommand to insert the data and another
sqlcommqnd to requery the table to get the records desired and bind to
the gridview



"marek zegarek" <ma***@zegarek.plwrote in message
news:u0**************@TK2MSFTNGP03.phx.gbl...
Hello!

I have strange and simple problem....
I am starting developer. I need to create webform, that will insert my
data into SQL 2005 database.
My idea is to make something like MS Access Form-Subform. I'm typing
data, pressing "Add" and i see it on datagrid below. So I can type
second datas, press "Add" and now i will see two records below.

I'm using .NET (2.0), SQL 2005.

My form have two regions on one page:
- I - few texboxes, two dropdownlists (here are records from specific
tables), one button "Add"
- II - (here I need something like datalist), one button "Send to SQL"

How should look that engine?
I have ready:
- region I with textboxes and SQLcommand, that is inserting records now
into SQL database
- dataset with datatables and relations between

How to insert data into dataset and then insert it into datalist?
What I must use?

Thanks
Leszek




Oct 31 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.