C#

public void FindUser(String userName)
{
       
  DirectoryEntry entry = GetDirectoryEntry(); // Get the directory entry you're interested in.
  DirectorySearcher search = new DirectorySearcher(entry);

  string filter = string.Format("(&(ObjectClass=user)(cn='{0}'))", userName);

  search.Filter = filter;

  foreach (SearchResult result in search.FindAll())
  {
    try
    {
       System.DirectoryServices.DirectoryEntry de = result.GetDirectoryEntry();
       Console.WriteLine("WhenCreated : " + de.Properties["WhenCreated"].Value.ToString());
       Console.WriteLine("User Name   : " + de.Properties["sAMAccountName"].Value.ToString());
    }
    catch (Exception ex)
    {
    }
  }
}

DbConnection con = new SqlConnection(connectionstring);
DbCommand command = con.CreateCommand();
command.CommandType = CommandType.Text;
command.CommandText = "select * from dbo.DemoTable where 0=1";
command.Connection.Open();
using (IDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection))
{
    DataTable table = reader.GetSchemaTable();
    //foreach (DataColumn column in table.Columns)
    foreach(DataRow row in table.Rows)
    {
        //Console.WriteLine(string.Format("{0}: {1}",column.ColumnName,column.DataType.ToString()));
        Console.WriteLine(string.Format("{0}: {1}", row.Field<string>("ColumnName"), row.Field<Type>("DataType").ToString()));
    }
}
command.Connection.Close();
Console.WriteLine("Done");
Console.ReadKey();

SELECT name
from sys.types  
where user_type_id in 
(	
	select user_type_id	
	from sys.parameters 	
	WHERE object_id = OBJECT_ID('@schema.@storedProc')	
	and name='@paramName'
)

Inverso1 wrote:

for getting the input parameters for a stored proc

SRJ92 wrote:

The first thing I need to know is how to select a top result in a list, so that its highlighted, just like when you click.

SRJ92 wrote:

Then when I press enter I want to select the list item…

SRJ92 wrote:

My question is however, how do you connect to another form ?

SRJ92 wrote:

I need to know a quickly print and print preview a rich text box

I are Troll

Form1 myForm = new Form1();

void Button1_Click(object sender, EventArgs e)
{
  myForm.Show(this);
}

I are Troll

Socket socket;
Queue<Data> pendingData;
bool sending;

public void SendAsync (Data data)
{
    if (sending)
    {
	pendingData.Add(data);
    }
    else
    {
	sending = true;
	socket.BeginSend(data, new Callback(SendCallback));
    }
}

private void SendCallback ()
{
    socket.EndSend();
	
    if (pendingData.Count > 0)
    {		
        socket.BeginSend(pendingData.DequeueReasonableAmountOfData(), new Callback(SendCallback));
    }
    else
    {
        sending = false;
    }
}