|
Hello gurus,
I'd like to know how I can enumerate the SQL Server instances on the local machine?
How can do this in C#?
For example, if I have installed the default instance, an the instance named "TOTO" on my system, I wish to see the two names in my enumaration (local and TOTO).
Best regards.
Fred.
Note: the sample in VS 7.1 that uses ODBC does not work with SQL Server 2005 and VS2005.
There is no spoon.
|
|
|
|
|
|
I was talking about this sample. it does not work on VS 2005 & SQL Server 2005...
There is no spoon.
|
|
|
|
|
Did you try to convert project for VS2005?
|
|
|
|
|
yes, I have converted it.
I have started the browser service and I could run it.
But it enumerates the SQL Servers on the local network, not the instances on the local machine.
For example, if I have two instances (default and TOTO), I should get the MSSQLSERVER service that runs for the default instance, and MSSQLSERVER$TOTO service that runs for the TOTO instance... I wish to retrieve this information.
Best regards.
There is no spoon.
|
|
|
|
|
|
Details
I used C#.Net 2005 and SQL 2000 as back end.
I wrote stored procedure to retrieve record (for the report) from the server.
I used Crystal Report (C#.Net 2005) to prepare the report and CrystalReportViewer to display it.
I also wrote codes in “Code View” of a Form to load the report.
The report runs perfectly in isolation.
The report also runs very well from the Application prior to deployment.
Problem
The report however, could not be loaded after deployment.
It generate an error “Load Report Failed”
Assumption
I suspect the absence of required file(s) that should be added during deployment in order to aid the loading of a crystal report file, since the report runs in “IDE” before deployment or do you think otherwise?
• Please assist in solving my problem so that I can deploy appropriately.
Banjo Ayorinde
|
|
|
|
|
Hi guys
I have created a webservice in VS2003, and I have some webmethods and classes in it. Those webmethods are shown in the client applicaiton after adding a web reference to it, but not the classes i created in web service.
How do I make my classes in WS to display in the client application?
Can anyone help in this?
Here is the sample code:
namespace WebserviceNS
{
public class MyService: System.Web.Services.WebService
{
[WebMethod]
public void MyMethod()
{
//...//
}
}
public class MyClass
{
public MyClass()
{
//...//
}
public void ClassMethod()
{
//...//
}
}
}
Here MyClass is not shown in the client side. Do I have to declare any attribute for displaying?
Thanks
Muthu.
|
|
|
|
|
try something like this:
public class MyClass : Microsoft.Web.Services2.WebServicesClientProtocol,IMyClass
IMyClass is an interface you declare for your class.
|
|
|
|
|
Hi
When you create a webservice and import it in another project as WebReference, a Wrapper - Dll is automatically created (similarly like when you reference a COM - Library).
This Library Implements the WebService as Class AND all Types that are returned by any call of a Method of that webservice.
so.
if you have a class in your Web-Service -dll that is never returned (or used as Parameter) by a call of the webservice, you will not get this class on the client side.
greets
m@u
|
|
|
|
|
hi!
I've recently started to try to learn programming in C#. Never programmed before - but it is fun.
Most things go well, but now I've a problem as follows:
I've got a windows form with a richtextbox object (in fact it's the richtextboxextended - object I've found on this site;))
I've got an sql-server database
I'm using a stored proc on the server for storing data
in one table of this database is a field, which is formated in ntext (also have one in binary format)
I want to store the data which is in the richtextbox to the database field.
Normally I do the following:
cmdsql.Parameters.Add("@fb_PP_VL",this.ochk_VL.Checked);
now I want to add a parameter for the rtf-field also.
I've thought this to be the right form:
cmdsql.Parameters.Add("@fm_PP_Note",Convert.ToByte(this.ortb_Note.RichTextBox.Rtf));
but this is definitely wrong 
So what do I have to do?
Salgerion
|
|
|
|
|
The table in the database must first hold another field for storing the rich text of your RTB object. The field should be of type varchar(255) if your text never extends more than 255 characters. If 255 chars aren't enough, you can instead use a field of type text.
Once this is in place, you can add a parameter to your Stored Procedure, and have the procedure write the inputted text to the database. You do not need to convert the rich text box's RTF to bytes first. (FWIW, you were trying to conver the whole RTF to a single byte, which of course won't work.) Just pass the RTF in as the parameter value, no conversion needed, and it should work.
|
|
|
|
|
Thanks a lot. it's working now
Salgerion
|
|
|
|
|
hi
i have a free table which is in foxpro...
i want to read it
is it possible if so how?????????
thanks
|
|
|
|
|
What do you mean by free?
Anyway, you should be able to read it via odbc.
|
|
|
|
|
|
Hello,
I have created a simple window application (DVD player) using DirectShow, Visual C# in .NET Framework 2 enviroment.
How can I create a single file that can be downloaded from internt out of all my codes so the end user simply can download and install my simple home-made window application and use it?
I also would like to know if they need anything specific on thier computer or just the simple windows OS is enough as thier platform to run my simple window application?
Thank you guy for helping out and have a great day.
Khoramdin
-- modified at 8:59 Friday 9th February, 2007
|
|
|
|
|
Khoramdin wrote: I also would like to know if they need anything specific on thier computer or just the simple windows OS is enough as thier platform to run my simple window application?
there would have to be .net framework 2.0 and directx installed
Khoramdin wrote: How can I create a single file that can be downloaded from internt out of all my codes so the end user simply can download and install my simple home-made window application and use it?
to tell the truth I don't get the "out of all my codes" part, but I guess you want to create an instalation file.. in your solution (i guess you're using visual studio) add a setup project..
the othear way is using click-once (project->preferences->publish)
life is study!!!
|
|
|
|
|
Hello Seishin,
Thanx for the help. It worked out and managed to make the instalation file.
Have a great weekend, mate.
Khoramdin
|
|
|
|
|
Hi everyone,
well I got two simple questions I wanna ask so here they are:
1. How can I lock the combobox (in a Windows Application) so that its text isnt editable but you can select the values from it?
2. What is the regular expression for a natural number (0,1,2...) that I can use to validate a field for a zero or positive number?
thanks in advance
Rocky
|
|
|
|
|
1. I think you have to set the DropDownStyle property to ComboBoxStyle.DropDownList.
2. [0-9]+
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook www.troschuetz.de
|
|
|
|
|
I post this under C# as there is no Crystal-Specific category, and I use C#.
I am using an online report viewer to view Crystal Reports. The viewer inherits from ReportDocument, and I am able to access the ReportDocument in code.
I am attempting to retrieve the following from the report:
1. The values of the parameters sent to the stored procedure which returns data to the parent-level report. (I am able to see the parameter names in ParameterFields)
2. The values returned to the parent-level report by this stored procedure.
3. The values that are displayed by the report once incomming data has been processed by the formulas on the report.
(The above would apply for subreports as well.)
As yet I have not succeeded, and was hoping someone may be able to shed some light on this issue, if it is possible.
Thanks
chazv
|
|
|
|
|
OS : windows XP
Visual studio : 2003
I cound not hide the curosr in RichTextBox. How can I
hide the cursor.Anybody help me. 
Continue...
|
|
|
|
|
Did you try Cursor.Hide()?
|
|
|
|
|
please send in some code related to iris recognization/authemtication like algorithms+programs for edge detection algorithms(canny edge detection algo),pattern matching feature encoding ,filters(gabor filter),haar wavelet,hough transform,normalisation segmantation on an image( a grayscale image eye image).
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
