|
you could try SQL DMO instead - it's the predecessor to SMO which has most of the same functionality, in this case:
static public string[] GetSQLServers()
{
List<string> retval = new List<string>();
SQLDMO.Application sqlApp = new SQLDMO.ApplicationClass();
SQLDMO.NameList serverList = (SQLDMO.NameList)sqlApp.ListAvailableSQLServers();
foreach (string server in serverList)
{
retval.Add(server);
}
return retval.ToArray();
}
|
|
|
|
|
I try the value (local) but it not working it give me an error:
"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"
but when i put the name of the server: Toshiba-owner\Dev
everything go well.
Thanks
Assaf
|
|
|
|
|
|
My question seems simple, but I really can't find the answer!
How can I check which line in a TextBox the user has clicked on with the mouse??
|
|
|
|
|
It has been a while, but I vaguely remember it is with Selection. When you click the cursor is moved to where you click and the current selection is updated (even if the selection length is zero, i.e. nothing is selected). From the position of the selection you can work out which line has been clicked on.
|
|
|
|
|
Or you could just get the cursor position after the user clicks.
My current favourite word is: Waffle
Cheese is still good though.
|
|
|
|
|
Wouldn't the form's top-left corner have to be at 0,0 at all times for that to work properly? I mean, if the user moves the form around, the cursor position will vary every time he/she clicks.
Virtual1ty "Any fool can learn from his own mistakes, but a wise man learns from mistakes of others"
|
|
|
|
|
No, no, no, no no. I meant the regular cursor -> |
Not the mouse cursor . There should be a property for the text box, i think its either textBox.Cursor, textBox.Cursor.Position, or textBox.CursorPosition. Or something like that anyway.
Of course, that would give you the index of the current letter the cursor is next to, it would then be up to you to figure out what line that was, perhaps by looking for all newline symbols that occure before it (Environment.NewLine, or "\r\n")
My current favourite word is: Waffle
Cheese is still good though.
|
|
|
|
|
Oh, I didn't know that
Edit:
The Undefeated: You're looking for textBox1.Cursor.HotSpot.ToString();
or textBox1.Cursor.HotSpot.X and textBox1.Cursor.HotSpot.Y
-- modified at 9:14 Sunday 4th November, 2007
Virtual1ty "Any fool can learn from his own mistakes, but a wise man learns from mistakes of others"
|
|
|
|
|
Hmm, TextBox.Cursor seems to be what kind of mouse cursor is displayed when over the TextBox.
I think they call the "|" a caret...but there is only one member that is called something like that - ScrollToCaret().
|
|
|
|
|
Yes, TextBox.Cursor can also return what cursor is used for the textbox. But it can also
return the cursor's position on the textbox:
textBox1.Cursor.HotSpot.X;
textBox1.Cursor.HotSpot.Y;
textBox1.Cursor.HotSpot.ToString();
Virtual1ty "Any fool can learn from his own mistakes, but a wise man learns from mistakes of others"
|
|
|
|
|
That's not the cursor position, that's the hotspot position.
If you want the cursor position, textBox1.PointToClient(Control.MousePosition).
If you want the caret position, use textBox1.SelectionStart (when nothing is selected, this property returns the caret position).
|
|
|
|
|
you should also consider the WordWrap property
in your solution..
why you want to do this ??
When you get mad...THINK twice that the only advice
Tamimi - Code
|
|
|
|
|
|
The function below should read an xml file and parse the elements and content, and I'm updating it to read the element content and the attribute values. So far the problem is with reading element content.
When the code uses method System.Xml.XmlReader.ReadElementContentAsString(), the code raises an exception (see Error).
However when the code using the above method is commented out the code is reading xml attributes.
On another note, any guidelines (for beginners) for validating XML and creating an XSD schema for validating it? My understanding is that this is the way suggested by w3c.
Less specifically, there are other ways of validating XML, including XmlSchemaValidator class, which would be most recommended?
.NET Framework 2.0
Error
------
System.Xml.XmlException: 'Element' is an invalid XmlNodeType. //INVALID?!
at System.Xml.XmlReader.FinishReadElementContentAsXxx()
at System.Xml.XmlReader.ReadElementContentAsString()
at TestConsole1.Program.readXMLFile(String _fileName) in C:\Documents and Set
tings\user\My Documents\Visual Studio 2005\Projects\TestConsole1\TestConsole1\Pr
ogram.cs:line 79
WhiteSpace:
Element:
Text:
Element:
Text:
Element:
Text:
WhiteSpace:
System.Xml.XmlException: 'Element' is an invalid XmlNodeType.
at System.Xml.XmlReader.FinishReadElementContentAsXxx()
at System.Xml.XmlReader.ReadElementContentAsString()
at TestConsole1.Program.readXMLFile(String _fileName) in C:\Documents and Set
tings\user\My Documents\Visual Studio 2005\Projects\TestConsole1\TestConsole1\Pr
ogram.cs:line 79
WhiteSpace:
WhiteSpace:
Element:
Text:
WhiteSpace:
WhiteSpace:
Press any key to continue . . .
using System;
using System.Collections.Generic;
using System.Text;
using System.Xml;
namespace TestConsole1
{
class Program
{
static void Main(string[] args)
{
readXMLFile("sample.xml");
}
static private void readXMLFile(string _fileName)
{
int ws = 0;
int pi = 0;
int dc = 0;
int cc = 0;
int ac = 0;
int et = 0;
int el = 0;
int xd = 0;
int tx = 0;
XmlTextReader textReader = new XmlTextReader(_fileName);
while (textReader.Read())
{
XmlNodeType nType = textReader.NodeType;
if (nType == XmlNodeType.XmlDeclaration)
{
Console.WriteLine("Declaration:" + textReader.Name.ToString());
xd = xd + 1;
}
if (nType == XmlNodeType.Comment)
{
Console.WriteLine("Comment:" + textReader.Name.ToString());
cc = cc + 1;
}
if (nType == XmlNodeType.Attribute)
{
Console.WriteLine("Attribute:" + textReader.Name.ToString());
ac = ac + 1;
}
if (nType == XmlNodeType.Element)
{
try
{
Console.WriteLine("Element:" + textReader.Name.ToString());
el = el + 1;
}
catch (XmlException ex)
{
Console.WriteLine(ex.GetBaseException());
Console.WriteLine(ex.InnerException);
}
}
if (nType == XmlNodeType.Entity)
{
Console.WriteLine("Entity:" + textReader.Name.ToString());
et = et + 1;
}
if (nType == XmlNodeType.Entity)
{
pi = pi + 1;
}
if (nType == XmlNodeType.DocumentType)
{
Console.WriteLine("Document:" + textReader.Name.ToString());
dc = dc + 1;
}
if (nType == XmlNodeType.Whitespace)
{
Console.WriteLine("WhiteSpace:" + textReader.Name.ToString());
ws = ws + 1;
}
if (nType == XmlNodeType.Text)
{
Console.WriteLine("Text:" + textReader.Name.ToString());
tx = tx + 1;
}
}
}
}
}
Jon
|
|
|
|
|
Does the node which causes the error contain child elements? The MSDN documentation for the XmlReader.ReadElementContentString method states:
This method reads the start tag, the contents of the element, and moves the reader past the end element tag. It expands entities and ignores processing instructions and comments. The element can only contain simple content. That is, it cannot have child elements.
It also states that an XmlException exception will be raised when calling this method if the current element contains child elements.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
hello
I want to catch any value in the datareader begin with a special string
Sysdiagrams, if i the value begin with cath it'll be rejected
any idea will greatly appreciated
Thanks in advance
Assaf
|
|
|
|
|
you may use the string as an array ...
like arrayName[indexValue]...
and 2nd option is use a char pointer..and again you can manipulate is
as an array
rao
|
|
|
|
|
The obvious choise would be to filter out the records in the SQL query, so that the don't end up in the result in the first place.
If you absolutely don't want to do that, you can use the StartsWith method of the string class.
Experience is the sum of all the mistakes you have done.
|
|
|
|
|
Thanks StarWith is the choice
Assaf
|
|
|
|
|
how to use rss feeds in desktop applications in c#..
i have beeb trying to do so by using webbrowser control available in c#
but it just opens the website, not the rss feeds..
i tell u ..how i tried .
i gave in url .....http://rss.news.yahoo.com/rss/science
but in response some html displayd..
plz help me...
rao
|
|
|
|
|
|
creating 2-dim array from 1 -dim array
Gaurav
|
|
|
|
|
just like building a proper question from words
Regards,
mav
--
Black holes are the places where God divided by 0...
|
|
|
|
|
mav.northwind wrote: just like building a proper question from words
These days with things like google translator, it should be rather doable
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|