|
Instead of calling my stored procedure n number of times in a loop how can i call the stored procedure once. I don’t want to pass the values as varchar as it is not a fixed length. I am not going to have high volume data and hence sqlbulkcopy is not required. Is there another way?
|
|
|
|
|
Civic06 wrote: Instead of calling my stored procedure n number of times in a loop how can i call the stored procedure once. I don’t want to pass the values as varchar as it is not a fixed length. I am not going to have high volume data and hence sqlbulkcopy is not required. Is there another way?
Start by explaining wtf it is your doing.
Why are you calling it in a loop?
If it needs to be in a loop why do you want to call it just once?
Why do you not want to use a variable length field?
From what your saying the answer is use x if you need x otherwise use y if you need y...
|
|
|
|
|
Civic06 wrote: mber of times in a loop how can i call the stored procedure once
Don't put your stored procedure in the loop if you only want it called once.
Hogan
|
|
|
|
|
I have a SP which takes in two parameters. One parameter is fixed length. The other depends on what the user has selected from the checkboxlist control. I could either put this in a loop sending the first parameter and the second (depending on how many values were checked in the checkboxlist). OR
I could concatenate the second parameter and send it as a string (however, i don't know how long this string can get...as varchar is max of 8000)
OR
is there another way?
|
|
|
|
|
With Sql Server 2005 you can varchar(MAX) to get unlimited space. if your on 2000 or below then yep you have to chunk it.
|
|
|
|
|
I've never had a need to use conditional compilation before, so I have very little experience with it. Is there a way to do your #define directivess in a single place?
I want to set 2 define variables, and include certain menu items in the presents of each. (different features allowed in different editions of the same project). But I would like to avoid having my #define directives in the designer file where the autogenerated code is and the forms code file where the event handlers are. Is there a way to do this? I know this approach has other problems as well, any changes that alter the designer file will toss my changes to the wind for one thing.
If not I can of course build and add my menu items manually outside of the designer file, but it would be nice to have them there at design time too.
|
|
|
|
|
BoneSoft wrote: Is there a way to do your #define directivess in a single place?
In the properties for the project. Right-click the project in the solution explorer. Click Properties from the menu. In the new window that opened up select the "Build" tab and look for "Conditional Compilation Symbols"
BoneSoft wrote: But I would like to avoid having my #define directives in the designer file where the autogenerated code is and the forms code file where the event handlers are
You can't put them in there anyway - Visual Studio will overwrite them.
BoneSoft wrote: Is there a way to do this?
You could put them in the form's load and have it remove the UI elements you don't want if you want the menu items available at design time.
Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
"I wouldn't say boo to a goose. I'm not a coward, I just realise that it would be largely pointless."
My website
|
|
|
|
|
Yeah, I know. I was looking at loading them after startup. But then I have ordering issues. Removing them on load is a good idea. And I never noticed the conditional section in the project properties. Thanks.
|
|
|
|
|
Hi,
you dont need to include #define statements at all, you can define symbols in the
project properties dialog, under Build/General/Conditional Compilation Symbols.
That is what I do when I run two different projects (one .NET 1.1, one .NET 2.0)
on the same source files, to make sure my code works for both; doing so I can compensate
for slight differences between both .NET versions (e.g. method name changes in Dns class).
So I suggest you use Designer to set up your project in one way, then add #if #endif blocks
to modify it in your code files (e.g. after InitializeComponents) for the alternative way;
now change your defines manually in the property dialog; you could even add configurations
(say multiple debug configurations with different #defines).
|
|
|
|
|
Actually, I'm thinking about having different project files for each edition while keeping the same code. In this situation, it seems a more reasonable approach than moving shared functionality to a control library. Thanks for the suggestion.
|
|
|
|
|
Hi all
I want to access variables declared in the global asax page to a asmx page.
I declared variables as static public and then in asmx page i accessed it as
global.variable name..but i am not getting value assinged to it..Can any one give me a idea why its not getting values in the variable
Advance in thanks
Regards
DilipRam
|
|
|
|
|
Probabaly need to see your code, but it is a really bad idea to use a static var in global.asax. If you have an application wide varible you should use the application object, it is just like session. It can be set in an event in the global.asax or anywhere else for that matter. If the var is supose to be user specific then you need to use the session object.
Ben
|
|
|
|
|
Hi
Thanks for the reply.Here is the part of my code.
XMLCacheComm = new XMLCacheComm();
In Application_Start of global asax page
Application["XMLCacheComm"] = XMLCacheComm;
and in constructor XMLSportsIn() of webservice written as
XMLCacheComm XMLCacheComm1 = Application["XMLCacheComm"] as XMLCacheComm;
and in a method of webservice,when i call
XMLCacheComm1.SendMessage()..here i am getting object reference not set to an instance of an object
Any idea
Regards
DilipRam
|
|
|
|
|
When you create it in the application_start you have to assign it a variable
XMLCacheComm _xmlCacheComm= new XMLCacheComm();
In Application_Start of global asax page
Application["XMLCacheComm"] = _xmlCacheComm;
This line:
XMLCacheComm XMLCacheComm1 = Application["XMLCacheComm"] as XMLCacheComm;
You might want to double check to see if the item is there. Something like:
if (Application["XMLCacheComm"] != null)
{
XMLCacheComm XMLCacheComm1 = Application["XMLCacheComm"] as XMLCacheComm;
}
else
{
XMLCacheComm _xmlCacheComm= new XMLCacheComm();
Application["XMLCacheComm"] = _xmlCacheComm;
}
Hope that helps.
Ben
|
|
|
|
|
Hi Thanks for the reply.I got out the object error.but i am not getting values inside it..inside the global i will get the count as 2 but inside webservice its count is getting as 1...why is this happening
Regards
DilipRam T
|
|
|
|
|
I am not that familar with the XMLCacheComm object, so I am not sure what the Count property refers to. So I am not sure why the count would be 1 or 2.
Ben
|
|
|
|
|
Thanks Ben.I was assigning application variable at the initialization part.when i assigned it in section where i want actually, i am getting the value.Any way thanks for your replies.
Expecting a positive replies in future
Thanks
Regards
DilipRam
|
|
|
|
|
Hi,
I have a web page C#, written and working.
I now need to see and validate certain controls on my page beginning with 'dt'.
In VS2005 i can happily type ...
foreach (Control ctrl in MyPage.Controls ) and it would list them and then I can use them
This doesn't work in VS2003. Any suggestions welcome?
|
|
|
|
|
My guess would be that you don't have a page called MyPage in VS2003.
Ben
|
|
|
|
|
kubben wrote: My guess would be that you don't have a page called MyPage in VS2003
|
|
|
|
|
If this was meant to be helpful, you are an idiot.
I've got it now though......
foreach (Control c in Page.FindControl("MyPage").Controls)
Cheers
|
|
|
|
|
Sorry I offended you. I guess I should leave being funny up to others. I just thought something looked wrong with the MyPage.Controls. Glad you figured it out.
Ben
|
|
|
|
|
Hello Everyone,
Does c# uses it's own predefined keywords for input and output if yes plz let me know
Thnx in advance
|
|
|
|
|
The Knowledge wrote: Does c# uses it's own predefined keywords for input and output if yes plz let me know
Input/output to/from where?
Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
"I wouldn't say boo to a goose. I'm not a coward, I just realise that it would be largely pointless."
My website
|
|
|
|
|
no, the C# (or C or C++ or Java) language does not have special keywords for input/
output. They rely on classes to do your I/O. See for instance SerialPort, Graphics,
File (and all the stream stuff) etc.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
