[RESOLVED] Dynamic Fill-up of Data

Hello guys!

I'm using ASP.NET2.0 by using Visual Web Developer 2005 (VWD).

I am starting to build my first project and it uses SQL 2005.

My database will contain a table wherein there will be a field for IP addresses. This field is where I will "write" all IP addresses.

Therefore, I plan to create an application in VWD wherein by just clicking a button, it will automatically fill up the IP addresses field with all the IP addresses I need (i.e., from 192.168.0.1 to 192.168.0.255).

My problem is how can I dynamically add data to my table?

Thank you very much!

Quote:

---

Originally Posted by bullettrick

all the IP addresses I need

---

What determines what IP addresses you need? Is it just 192.168.0.1-.255?

If it's that static a choice, then create a stored procedure that performs 255 insert statements into the table. You could make the SP loop from 1 to 255. Know any T-SQL?

Actually, after I posted that question, I felt stupid.

All I need is a simple INSERT statement! Hehe.

Thanks a lot for still answering!