|
Frnds,
I have got 200 varibles, that i want to insert in database.
Im confused, how to do that..
HELP!!!!
|
|
|
|
|
Contact your client, tell them you are stealing from them. Seriously, if you are confused at this basic a level, you should choose more simple tasks and work through them until you have enough experience to take on tasks like this.
You insert them with SQL, there's really no other way. You can use transactions, if you want to make it all or nothing, apart from that, that's all there is.
this also has NOTHING to do with ASP.NET.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Dear,
I stored my 200 values in an array and that 200 values represent one record.
It is easy to insert 'n' record, that i did N no. of times with MAX of 20 values but this is first time im supposed to insert this large no. of values.
So donno how to do... Im trying... may be it take some time.... but i will find that... THATS SURE.
|
|
|
|
|
sachees123 wrote: I stored my 200 values in an array and that 200 values represent one record.
OK, so you need one SQL statement, one insert. The syntax is the same, although if you have 200 values in one record, it seems likely that your database design is a disaster.
sachees123 wrote: Im trying...
What have you tried ? It really helps us to see what you've tried, as well as telling us that you HAVE tried to do more than to ask here. Tell us what you did, what the error is, what is going wrong, then we're more likely to offer help based on what you tell us.
I still don't see the issue, tho, an insert is an insert. Why do you have 200 records ? Like I said, that sounds like a terrible design to me.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Actully i have an OMR sheet that contain 200 questions and that 200 response is for one person/sheet. So dont think the database design is a DISASTER.
Now wat i tried is ...... my mind is not working... the one time effort is to write all those 200 variables.
but i want some simple method and im sure there is....some simple method... to do this sort of job. And that too with an array..
|
|
|
|
|
sachees123 wrote: Actully i have an OMR sheet that contain 200 questions and that 200 response is for one person/sheet. So dont think the database design is a DISASTER.
I think it is. I think you need to store questions and answers in a format that allows for you to easily add and remove questions, instead of having to change your DB to do so.
sachees123 wrote: Now wat i tried is ...... my mind is not working... the one time effort is to write all those 200 variables.
but i want some simple method and im sure there is....some simple method... to do this sort of job. And that too with an array..
OK, I see. Well, if your values in your array are in the same order they are in the DB, you can loop through the array and add the items, building SQL in a loop. Of course, this will leave you open for SQL injection attacks, but if you can't be bothered writing a stored proc or paramaterised query, then that seems to be the solution you are asking for.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
MAN,
I DID it and in a very simple way.... as i told u...
mail me ... if u wanna know...
but no doubt... thanks a lot for replying me... thanks
|
|
|
|
|
Well, the way I suggested was simple. Your database design still sucks, however.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Why you don't redesign database?
Instead having 200 columns in one table, separate it and create some tables manage by relations between them.
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
Yes. that's kind of what I said.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Yes,If I am in his/her place then sure I'm gonna redesign maybe all database maybe too including software application.
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
hi,
Anybody can able to tell me how to expire my cookie on browser close
|
|
|
|
|
I am not sure that you can, if you can, it will be in javascript, and it will not be reliable.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
I am not sure but if you didn't give expiration time to cookie it will automatically remove when your application close.
May this help you
Viral.
|
|
|
|
|
What makes you think this is true ?
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
|
may i ask you what makes you think this is not true?
|
|
|
|
|
I didn't mean to imply that ( but thanks for the 1 vote ). I had not heard of it, and so I was hoping for a link so I could find out about it. Thanks for the link.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Christian Graus wrote: ( but thanks for the 1 vote ).
Sorry for my comment. And also I didn't vote you 1.
|
|
|
|
|
Christian Graus wrote: What makes you think this is true ?
He is right. A cookie with unspecified expiration only lasts till the current session.
Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
|
We encrypt the config in one machine using, export RSA Key. we import into another machine.
But we can issue a Decrypt command at the deployed machine and see the content if logged in as administrator. How to over come this?
Thank you,
Rajaraman
|
|
|
|
|
Make sure your network is secure. If you could not decrypt it, it would be kind of useless, right ?
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Thanks,Yes, we need to decrypt only using ASP.Net System Account
Which means i want to protect against done using other accounts or manual.
Or some other ways to protect against doing decrypting outside IIS.
|
|
|
|
|
I am new to this feature..adding web service to client application in visual studio 2005.
When I add the web service ..I am getting all the methods in the header generated but I am unable to get the method with same name and different parameters..
can anybody help me out ..please ????
thanks in advance
Ashok
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
