C#

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