how to create 400 fields in VB 6.0 and stodre data in SQL server 2000

[linsha]

Hi...
I want to whether there is any possibility in creating 400 text boxes and labels inorder to create 400 fields in SQL. If created using control array then which is the way to see the text boxes for data entry? is it possible to create 400 fields in a table in SQL? do you know the code to connect SQL server 2000 to VB 6.0 in Windows 98 or Windows XP professional? the main purpose for using VB is to skip about 70 text boxes if the entry is eg., '2'. to make data entry easier for about 20000 records is this the apt method or is there any other method other than this? instead of SQl, is it better to use SAS?
if the data entry is done using VB then how to do? is there any other method then please inform me as early as possible.is it possible to do in this way?
sicerely
lin

[debasisdas]

Hi
linsha
Welcome to TSDN.

You have reached the right place for knowledge shairing.

Here you will find a vast resource of related topics and code.

Feel free to post more doubts/questions in the forum.

But before that give a try from your side and if possible try to post what/how you have approached to solve the problem.

It will help Experts in the forum in solving/underestanding your problem in a better way.

Please follow the posting guidelines in every new post/reply.

Please specify your post/question clearly.

Dont expect others to guess and solve your problem.

Here the experts share there knowledge and try to guide you.

And dont expect the complete code and logic from the forum.

[linsha]

hi...
Let me know why its getting late to get a reply or solution for my doubts

[debasisdas]

Because th experts are not sitting idle.

They have their own work to do.

Experts share there knowledge in the forum in there spare time only.

Please have patience.

[debasisdas]

1.yes u can create 400 text boxes on the form.
but for that u need to create control arrays as u cant put more than 255 controls with different names.
2.To see the control u need proper designing or try using the ZOrder property.
or try using container controls like TAB,FRAME or SSTAB.
3.Yes it is possible to create 400 fields in a table in SQL.
4. the code is same irrespective of 98/2k/xp.


Please try this and post back when uare finished .

[linsha]

thankyou for your reply . Let me try it .
lin

[bhavin dave]

how i can use in multiple login from in visual basic with sql server.

[hariharanmca]

how i can use in multiple login from in visual basic with sql server.

Can u explain why and where you are useing that

(Because,If you do that all your process get the same thing, for that you can use one logine form multipule time)