|
Hi,
I have a problem with the exception "Value does not fall within the expected range" and I haven't quite figured out what is wrong in my code.
I have a store procedure that has a declared char for input. The store procedure is used by a Crystal Report filename.
I want to pass a char from C# application that calls the Crystal report and passes a character to it.
Somehow, I got the exception.
I wonder if the character type in VS .Net 2005 is not compatible with a character type in SQL Server 2000.
Any help? Thanks.
Kyah
|
|
|
|
|
It is not really clear in your post just what your are doing and who is generating the problem. You talk about Crystal reports and that is one source of errors, AND you talk about VS vs. SQL Server.
To try and fire some help in the dark -- you will probably have to talk to your DBA first before talking to us. You may also need to go into more details as to how this character is defined, who it is passed to, and so on. Basically, when a problem occurs you need to investigate all aspects of every possible endpoint that generates a potential error.
For example: a character is normally a character. However if you have a setting somewhere (or a type definition) that defines a character as being UNICODE then you will need to consider the fact that you are passing a UNICODE character into a database that is defined as ASCII instead of UNICODE.
However with Crystal Reports in the middle, the error could be from Crystal -- but you don't say. You also do not indicate if the call into the Crystal thing has worked in prior versions of VS or not. That can make a huge difference in the cause of the problem.
Do the homework and then try asking the question after you have done so.
|
|
|
|
|
Hi,
I have a problem with the exception "Value does not fall within the expected range" and I haven't quite figured out what is wrong in my code.
I have a store procedure that has a declared char for input. The store procedure is used by a Crystal Report filename.
I want to pass a char from C# application that calls the Crystal report and passes a character to it.
Somehow, I got the exception.
I wonder if the character type in VS .Net 2005 is not compatible with a character type in SQL Server 2000.
Any help? Thanks.
Kyah
|
|
|
|
|
It's really impossible to tell without first seeing some code.
You should at least try running the software under the debugger and see where the error is occurring. When you find that, post some of that code here--just the relevant pieces--and we should be able to better diagnose your problem.
Tech, life, family, faith: Give me a visit.
I'm currently blogging about: I luv teh choco
The apostle Paul, modernly speaking: Epistles of Paul
Judah Himango
|
|
|
|
|
the code is very simple.
void proc()
{
...
callreport(1, 'o');
...
}
void callreport(int a, char b)
{
reportJob = new ExReport() //The ExReport is a Crystal Report connected to
// SQL Server 2000 reported by a store
//procedure with one input type char
reportJob.SetParameterValue(0,b); //"The error happened at this line
...
}
That's all.
The code looks simple but it gave me a lot of headache. Thanks
|
|
|
|
|
I have Dundas Gauge for .NET Version 1.6 [for Visual Studio 2005 ] can I use it with .NET 2003
o O º(`'·.,(`'·., ☆,.·''),.·'')º O o°
»·'"`»* *☆ t4ure4n ☆* *«·'"`«
°o O º(,.·''(,.·'' ☆`'·.,)`'·.,)º O o°
|
|
|
|
|
That's probably something you'd have to ask the Dundas people. My guess is no, unless they say "designed for Visual Studio 2005" but didn't actually use any .NET 2 APIs (where VS2005 uses .NET 2 exclusively).
Tech, life, family, faith: Give me a visit.
I'm currently blogging about: I luv teh choco
The apostle Paul, modernly speaking: Epistles of Paul
Judah Himango
|
|
|
|
|
We make versions of the Dundas Gauge product for .Net 1.0, 1.1 and 2.0
So, as long as you install the version for VS 2003 then everything is fine.
If you only received the 2005 version, just email or call your sales rep at Dundas and ask for the VS2003 version as well (you will recieve it at no extra charge).
Troy Marchand
Dundas Software
-- modified at 19:01 Sunday 23rd April, 2006
|
|
|
|
|
Hi Guys!
Is there any tool out there that can be used to convert a Win32 Assembly(dll) to .NET (dll or code).
I would highly appriciate if some1 has an answer!
 ....Happy Programming....
o O º(`'·.,(`'·., ☆,.·''),.·'')º O o°
»·'"`»* *☆ t4ure4n ☆* *«·'"`«
°o O º(,.·''(,.·'' ☆`'·.,)`'·.,)º O o°
|
|
|
|
|
No, there isn't, and for good reason. One cannot map every single Win32 call into a .NET call. There are usually equivalents or replacements, but certainly no line-for-line equivalence.
|
|
|
|
|
Why won't this code work?
using System;
using System.Windows.Forms;
namespace Practice
{
class Practice
{
public static void Main()
{
// declare and assign a string variable called human
string human;
human = "Walking & talking life";
// declare and assign an int variable called mind
int mind;
mind = 100;
// Print the value of the variables to the console
Console.WriteLine(mind);
Console.WriteLine(human);
}
}
class Continued
{
public static void notMain()
{
MessageBox.Show(human);
MessageBox.Show(mind);
}
}
}
|
|
|
|
|
You did not mention what did not work, but I can guess it is the line:
MessageBox.Show(mind);
unlike Console.WriteLine, MessageBox.Show does not have an overload that takes an int. Try:
MessageBox.Show(mind.ToString());
--------
"I say no to drugs, but they don't listen."
- Marilyn Manson
|
|
|
|
|
The human and mind variables are only visible inside the Main method. To do what you want you need something like this:
class Practice
{
public static string human;
public static int mind;
public static void Main()
{
human = "Walking & talking life";
mind = 100;
}
}
class Continued
{
public static void notMain()
{
MessageBox.Show(Practice.human);
MessageBox.Show(Practice.mind);
}
}
|
|
|
|
|
I'm writing a Windows Forms application which gets data through a Web
Service. I'm trying to use the IIS HTTP 1.1 native compression. In order to
do that I've added the following methods to the proxy class generated by
Visual Studio:
protected override WebRequest GetWebRequest(Uri uri)<br />
{<br />
WebRequest request = base.GetWebRequest(uri);<br />
request.Headers.Add("Accept-Encoding", "gzip, deflate");<br />
return request;<br />
}<br />
<br />
protected override WebResponse GetWebResponse(WebRequest request)<br />
{<br />
HttpWebResponseDecompressed response = new HttpWebResponseDecompressed(request);<br />
return response;<br />
}
The HttpWebResponseDecompressed class receives the compressed response and
decompress it. This is what is happening: if I remove the second line from
the GetWebRequest method (which adds the header), all the 9 requisitions that
I make on the program's initialization have answer. But when the header is
added, only the first 4 requisitions receive answer (the answer is correctly
compressed).
I've enabled the ASP.NET trace (which generates the trace.axd page) so that
I could see the requests received by IIS and the last 5 do not appear. If I
put a breakpoint in the GetWebRequest method, the breakpoint is hit but they
do not reach IIS.
Can anyone tell me what is happening or what can I do?
Thanks
|
|
|
|
|
I am planning to have an application where a menu will be populated dynamically.
Say the menu for the application is as below:
File Test Help
Test1
Test2
By selecting Test1 and Test2 menu I am intending to load a form from the DLL which inherits a base class used in the main application. This class has a Show method to show the child form which is the part of the DLL. I have difficulty passing the main form as parent form. Since I am novice in C# I am trying to follow the standard method as shown below. Is there any other way to achieve it?
CLib.Class1 cls = new CLib.Class1();
<br />
cls.Parent = this;
cls.Show();
In my show method I have code like below:
frmChild frm = new frmChild();<br />
frm.MdiParent=Parent;<br />
frm.Show();
Second thing, lets us say I maintain the Menu Option name and the DLL name in a INI file or XML file. I can populate the menu option dynamically but how I will use the DLL.
Thanks in advance for your kind guidance.
|
|
|
|
|
1. Answering your first question is a bit difficult because you didn't specify where the code resides in. What exactly is this? I assume you are not in the parent form... What is the error you are getting?
2. Reflection is the way to go:
using System.Reflection;
Assembly assembly = Assembly.LoadFile("C:\\MyDll.dll");
MyBaseClass cls = assembly.CreateInstance("CLib.Class1");
The LoadFile call is only needed once so you could make this on startup once and then just call CreateInstance several times.
|
|
|
|
|
Thank you very much Robert for your quick response.
It seems I could not present my case properly. Here I am trying again.
I have a main application with MDI form with common menu items.
The modules will be available to a user depending upon from which department s/he is from. For example we will have a table to store the user and what module is available to that user
UserID
Module
And another table which contains the module name, and the menu text, that will be shown on the menu and corresponding DLL file name for that module.
Module
Menu Name
DLLFile
These DLL files will have a common method called show(). On the click event of the menu item, the show method basically will load the MDI Child form from the DLL and pass the MDI form reference of the main application as the parent form. With this the menu items on the child form will appear on the main menu of the MDI window.
Hope I made it clear this time.
Thanking you in for your kind help.
|
|
|
|
|
First you would have your parent form:
public class Daddy : Windows.Forms.Form {}
Now that form owns the menu and thus would handle the event for each menu selection. So then your event handler would be something like this: (WARNING: My machine with VS died last night so I'm tinkering with a very bad memory to write this!!!)
// using menuitem.Text append namespace and load it as object child.
MenuItem item = (MenuItem) sender;
// I am not sure of the method below or format but generally....
Assembly assembly = Assembly.LoadFile(path+item.Name);
IBaseChild child = (IBaseChild)assembly.LoadFile( nameSpace + item.Value );
child.MDIParent = this;
child.Show();
-- modified at 17:25 Tuesday 18th April, 2006
|
|
|
|
|
I didn't understand your requirement fully, but assuming that you're trying to load menu,froms and assmblies dynamically (all are unknown to you), can be be done this way:
<br />
public void invokeProcess (string assemblyName, string strModName) <br />
{<br />
Assembly assembly = Assembly.LoadFrom (assemblyName);<br />
<br />
foreach (Type type in assembly.GetTypes ()) <br />
{<br />
if (type.IsClass == true) <br />
{<br />
if (type.FullName != strModName + "." + strModClass) <br />
{<br />
continue;<br />
}<br />
<br />
object ibaseObject = Activator.CreateInstance (type);<br />
<br />
frmDummy frmParent = new frmDummy();<br />
frmParent.MdiParent = this;<br />
<br />
object[] arguments = new object [] {frmParent};<br />
<br />
foreach (MemberInfo mi in type.GetMember(strModEntry))<br />
{<br />
type.InvokeMember (mi.Name.ToString(), <br />
BindingFlags.Default | BindingFlags.InvokeMethod,<br />
null,<br />
ibaseObject,<br />
arguments);<br />
}<br />
}<br />
}<br />
}
hope this will help.
|
|
|
|
|
Thank you vatzcar for your time and kind help![Rose | [Rose]](https://codeproject.freetls.fastly.net/script/Forums/Images/rose.gif) . After going through your code, I changed my strategy. Previously I was planning a show method in a class file (in DLL) will take the reference of the MDI form, after that it will show the menu form, in the DLL as child form. Now I am planning to standardise the main form name as frmMenu in all the DLL files. With this the code will be moved to the click event of the menu in the main application. The click event of the menu will call LoadDLL with corresponding assembly name.
private void LoadDLL(string assemblyName)
{
Assembly assembly = Assembly.LoadFrom (assemblyName);
foreach (Type type in assembly.GetTypes ())
{
if (type.IsClass == true)
{
object ibaseObject = null ;
if (type.Name == "frmMenu")
{
ibaseObject = Activator.CreateInstance(type);
Form frmT = (Form)ibaseObject;
frmT.MdiParent = this;
frmT.Show();
}
}
}
}
It is working fine . Is it optimized code?
Thank you.
|
|
|
|
|
I'm glad that somehow i could help you  I think it's optimized. And don't thank me, it's the Dev community who deserve 'cause this is what they tought me through the time 
|
|
|
|
|
Hi,
I need to call a webservice which needs to use a pool of database connections to read and write data in the DB. But a traditional webservice will create and destroy the connections as it is called and disguarded, but this will mean new connections to the DB all the time.
This has a big hit on performance.
Therefore I need some way of maintainig a pool of connections which is constantly open and available to all instances of the webservice to use(at least one per database) to ensure performance. But how can this be done?
I have done some tests using global.asax, but this does not work.
I also can not find anything on the web.
Can anybody help?
regards
Jason
|
|
|
|
|
Hi,
I need to call a webservice which needs to use a pool of database connections to read and write data in the DB. But a traditional webservice will create and destroy the connections as it is called and disguarded, but this will mean new connections to the DB all the time.
This has a big hit on performance.
Therefore I need some way of maintainig a pool of connections which is constantly open and available to all instances of the webservice to use(at least one per database) to ensure performance. But how can this be done?
I have done some tests using global.asax, but this does not work.
I also can not find anything on the web.
Can anybody help?
regards
Jaso
|
|
|
|
|
Hi,
I need to call a webservice which needs to use a pool of database connections to read and write data in the DB. But a traditional webservice will create and destroy the connections as it is called and disguarded, but this will mean new connections to the DB all the time.
This has a big hit on performance.
Therefore I need some way of maintainig a pool of connections which is constantly open and available to all instances of the webservice to use(at least one per database) to ensure performance. But how can this be done?
I have done some tests using global.asax, but this does not work.
I also can not find anything on the web.
Can anybody help?
regards
Jaso
|
|
|
|
|
Why flood the board with 3 of the same question? If you thought your message didnt post did it occur to you to CHECK before reposting (or hitting submit again and again) 
Connections to databases like MSSQLServer are pooled by the provider, trying to re-invent connection pooling will lead to WORSE performance, I promise!
-- modified at 11:08 Tuesday 18th April, 2006
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
