Re: How to select the Server - C# Discussion Boards

4-Nov-07 1:26

Hello
How i can let the user select the server on my Pc instead of writting it?

any help will be greatly appreciated

Assaf

Koltz4-Nov-07 1:34

Koltz

4-Nov-07 1:34

What do you mean?
What server do you whant to select?

Assaf824-Nov-07 1:47

4-Nov-07 1:47

i do project where i want to run it on any computer
this project connect the database on that Pc
through dataconnection which contain the severName and the database
so i do a form let the user specify those value.
The user write the Server in a textBox,
and he chose the database from a combobox

my question is there any method to collect the name of my sever ?

Thanks a lot

Assaf

I Believe In GOD4-Nov-07 2:05

I Believe In GOD

4-Nov-07 2:05

Hi , Have a good Day

if SQL Server Installed on the same PC With your Application

(Not a network connection)

Simply :
Type Your Server Name "(local)" With out the Quotation , But included the Arc's
(local) (local) (local) Smile | :)

----
if you are planing to use your Application on the Other NetWork Pc's
please let me know , I have a Super class For Doing This Wink | ;-)

Kind regards

I know nothing , I know nothing

Assaf824-Nov-07 2:08

4-Nov-07 2:08

yes i plan to use my app. on other Pc

Thanks in advance Stark

Assaf

I Believe In GOD4-Nov-07 2:14

I Believe In GOD

4-Nov-07 2:14

using System;<br />
using System.Text;<br />
using System.Runtime.InteropServices;<br />
<br />
	public class SqlLocator<br />
	{<br />
		[DllImport("odbc32.dll")]<br />
		private static extern short SQLAllocHandle(short hType, IntPtr inputHandle, out IntPtr outputHandle);<br />
		[DllImport("odbc32.dll")]<br />
		private static extern short SQLSetEnvAttr(IntPtr henv, int attribute, IntPtr valuePtr, int strLength);<br />
		[DllImport("odbc32.dll")]<br />
		private static extern short SQLFreeHandle(short hType, IntPtr handle); <br />
		[DllImport("odbc32.dll",CharSet=CharSet.Ansi)]<br />
		private static extern short SQLBrowseConnect(IntPtr hconn, StringBuilder inString, <br />
			short inStringLength, StringBuilder outString, short outStringLength,<br />
			out short outLengthNeeded);<br />
<br />
		private const short SQL_HANDLE_ENV = 1;<br />
		private const short SQL_HANDLE_DBC = 2;<br />
		private const int SQL_ATTR_ODBC_VERSION = 200;<br />
		private const int SQL_OV_ODBC3 = 3;<br />
		private const short SQL_SUCCESS = 0;<br />
		<br />
		private const short SQL_NEED_DATA = 99;<br />
		private const short DEFAULT_RESULT_SIZE = 1024;<br />
		private const string SQL_DRIVER_STR = "DRIVER=SQL SERVER";<br />
	<br />
		//private SqlLocator(){}<br />
<br />
		public static string[] GetServers()<br />
		{<br />
			string[] retval = null;<br />
			string txt = string.Empty;<br />
			IntPtr henv = IntPtr.Zero;<br />
			IntPtr hconn = IntPtr.Zero;<br />
			StringBuilder inString = new StringBuilder(SQL_DRIVER_STR);<br />
			StringBuilder outString = new StringBuilder(DEFAULT_RESULT_SIZE);<br />
			short inStringLength = (short) inString.Length;<br />
			short lenNeeded = 0;<br />
<br />
			try<br />
			{<br />
				if (SQL_SUCCESS == SQLAllocHandle(SQL_HANDLE_ENV, henv, out henv))<br />
				{<br />
					if (SQL_SUCCESS == SQLSetEnvAttr(henv,SQL_ATTR_ODBC_VERSION,(IntPtr)SQL_OV_ODBC3,0))<br />
					{<br />
						if (SQL_SUCCESS == SQLAllocHandle(SQL_HANDLE_DBC, henv, out hconn))<br />
						{<br />
							if (SQL_NEED_DATA ==  SQLBrowseConnect(hconn, inString, inStringLength, outString, <br />
								DEFAULT_RESULT_SIZE, out lenNeeded))<br />
							{<br />
								if (DEFAULT_RESULT_SIZE < lenNeeded)<br />
								{<br />
									outString.Capacity = lenNeeded;<br />
									if (SQL_NEED_DATA != SQLBrowseConnect(hconn, inString, inStringLength, outString, <br />
										lenNeeded,out lenNeeded))<br />
									{<br />
										//throw new ApplicationException("Unable to aquire SQL Servers from ODBC driver.");<br />
									}	<br />
								}<br />
								txt = outString.ToString();<br />
								int start = txt.IndexOf("{") + 1;<br />
								int len = txt.IndexOf("}") - start;<br />
								if ((start > 0) && (len > 0))<br />
								{<br />
									txt = txt.Substring(start,len);<br />
								}<br />
								else<br />
								{<br />
									txt = string.Empty;<br />
								}<br />
							}						<br />
						}<br />
					}<br />
				}<br />
			}<br />
			catch //(Exception ex)<br />
			{<br />
				#if (DEBUG)<br />
				#endif <br />
				txt = string.Empty;<br />
			}<br />
			finally<br />
			{<br />
				if (hconn != IntPtr.Zero)<br />
				{<br />
					SQLFreeHandle(SQL_HANDLE_DBC,hconn);<br />
				}<br />
				if (henv != IntPtr.Zero)<br />
				{<br />
					SQLFreeHandle(SQL_HANDLE_ENV,hconn);<br />
				}<br />
			}<br />
	<br />
			if (txt.Length > 0)<br />
			{<br />
				retval = txt.Split(",".ToCharArray());<br />
			}<br />
<br />
			return retval;<br />
		}<br />
	}<br />

This Class return All the SQL Server , from the Other PC's on the network
by using this Function GetServers

(THIS CLASS RETURN ONLY THE PC'S That SQL SERVER INSTALLED ON IT)

P.S
it's return String Array Which is easily Can add to combo box

Kind regards ,

I know nothing , I know nothing

Jimmanuel4-Nov-07 4:52

Jimmanuel

4-Nov-07 4:52

Ever heard of SMO? All of that gets replaced with 5 lines of code:

DataTable dtServers = SmoApplication.EnumAvailableSqlServers(false);
foreach (DataRow row in dtServers.Rows)
{
  string sqlServerName = row["Server"].ToString();
  if (row["Instance"] != null && row["Instance"].ToString().Length > 0)
      sqlServerName += @"\" + row["Instance"].ToString();
}

SMO Essentials[^]
MSDN[^]

Paul Conrad4-Nov-07 6:10

Paul Conrad

4-Nov-07 6:10

I like that approach better Big Grin | :-D

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

Koltz4-Nov-07 6:26

Koltz

4-Nov-07 6:26

Realy nice solution, thanks!

I Believe In GOD5-Nov-07 4:42

I Believe In GOD

5-Nov-07 4:42

yeah I hear of it , thank for you

but I am still using VS 2003 . NET 1.1 Which didn't support the SMO

thank you so much for this information

kind regards

I know nothing , I know nothing

Jimmanuel5-Nov-07 4:56

Jimmanuel

5-Nov-07 4:56

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();
}

Assaf824-Nov-07 2:25

4-Nov-07 2:25

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

Check which line was clicked?

Ed.Poore4-Nov-07 2:58

Ed.Poore

4-Nov-07 2:58

Take a look at the SqlDataSourceEnumerator[^] class.

My Blog[^]

Gadjuka4-Nov-07 1:03

Gadjuka

4-Nov-07 1:03

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??

Colin Angus Mackay4-Nov-07 1:23

Colin Angus Mackay

4-Nov-07 1:23

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.

Upcoming FREE developer events:
* Glasgow: SQL Server Managed Objects AND Reporting Services ...

My website

Anthony Mushrow4-Nov-07 1:45

Anthony Mushrow

4-Nov-07 1:45

Or you could just get the cursor position after the user clicks.

My current favourite word is: Waffle

Cheese is still good though.

Kristian Sixhøj4-Nov-07 1:49

Kristian Sixhøj

4-Nov-07 1:49

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"

Re: Check which line was clicked? [modified]

Anthony Mushrow4-Nov-07 3:04

Anthony Mushrow

4-Nov-07 3:04

No, no, no, no no. I meant the regular cursor -> |
Not the mouse cursor Roll eyes | :rolleyes:

. 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.

Kristian Sixhøj4-Nov-07 3:07

Kristian Sixhøj

4-Nov-07 3:07

Oh, I didn't know that Big Grin | :-D

Edit:
The Undefeated: You're looking for textBox1.Cursor.HotSpot.ToString();
or textBox1.Cursor.HotSpot.X and textBox1.Cursor.HotSpot.Y Smile | :)

-- 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"

Gadjuka4-Nov-07 4:30

Gadjuka

4-Nov-07 4:30

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().

Kristian Sixhøj4-Nov-07 4:44

Kristian Sixhøj

4-Nov-07 4:44

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; // cursor's X position on the textbox
textBox1.Cursor.HotSpot.Y; // cursor's Y position on the textbox
textBox1.Cursor.HotSpot.ToString(); // return the position as {X = x, Y = y}

Virtual1ty

"Any fool can learn from his own mistakes, but a wise man learns from mistakes of others"

Daniel Grunwald4-Nov-07 5:03

Daniel Grunwald

4-Nov-07 5:03

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).