Dear CodeProject Team. I'had an application maked in C# using MessengerAPI, the app it's terminated and everything works good but I need know How can I launch my app when the microsoft messenger it's started and how can I kill my app when the microsoft messenger it's closed? Thanks in advanced.

SINCERELY. ANTHONY ACUÑA PREFERED PHRASE: SOMEBODY TELL ME WHY IS MORE REAL WHEN I DREAM THAT I AM WAKE?

HI CODEPROJECT TEAM. SOMEONE KNOW HOW INSERT A AUTONUMBER COLUMN IN EXCEL USING OLEDB?. CONNECTION STRING EXAMPLE: string cst; //Connection String cst="Provider=Microsoft.Jet.OLEDB.4.0;" +     "Data Source=c:\\file.xls;" +     "Extended Properties=\"Excel 8.0;IMEX=1;MaxScanRows=0;" +     "HDR=YES\""; OleDbConnection conn = new OleDbConnection(cst); conn.Open(); I NEED DO SOMETHING LIKE: string SQL; SQL="ALTER TABLE [sheet1$] ADD [row_id] NUMBER NOT NULL AUTONUMBER"; OleDbCommand cmd = new OleDbCommand(SQL, conn); cmd.ExecuteNonQuery(); THANKS IN ADVANCED.

SINCERELY. ANTHONY ACUÑA PREFERED PHRASE: SOMEBODY TELL ME WHY IS MORE REAL WHEN I DREAM THAT I AM WAKE?

This is the better method. dt.Columns["{COLUMN_NAME}"].ColumnMapping = MappingType.Hidden;

SINCERELY. ANTHONY ACUÑA PREFERED PHRASE: SOMEBODY TELL ME WHY IS MORE REAL WHEN I DREAM THAT I AM WAKE?

Hi mydrive22. Every application when start has a thread (Primary Thread [PT]). The Thread is a subprocess, this run at same time that PT. For example: When you walk and talk, if this process was a only process you need wait for walk process finish and start the talk process. but if you start 1 process for walk and 1 process for talk, the PT proceess is free for do anything. It's the same with forms. If you use one proceess for retrieve data, you can use the PT for do anything on the form. You need study "System.Threading", "Control.BeginInvoke", "Control.EndInvoke", "System.MulticastDelegate" I hope that this solve your problem

SINCERELY. ANTHONY ACUÑA PREFERED PHRASE: SOMEBODY TELL ME WHY IS MORE REAL WHEN I DREAM THAT I AM WAKE?

Hi DDscales. Try Using [c#] this.dataGridView1.Rows[0].DefaultCellStyle Or if you are using the a DataSet use DataBindings to set the properties with the correct datamember.

SINCERELY. ANTHONY ACUÑA PREFERED PHRASE: SOMEBODY TELL ME WHY IS MORE REAL WHEN I DREAM THAT I AM WAKE?

Hi yyyyyy87. The client need have the SQL Native Client Installed.

SINCERELY. ANTHONY ACUÑA PREFERED PHRASE: SOMEBODY TELL ME WHY IS MORE REAL WHEN I DREAM THAT I AM WAKE?

Hi Code Project Team. Please help me with this. http://www.codeproject.com/script/comments/forums.asp?msg=1753634&forumid=1649#xx1753634xx

SINCERELY. ANTHONY ACUÑA PREFERED PHRASE: SOMEBODY TELL ME WHY IS MORE REAL WHEN I DREAM THAT I AM WAKE?

Hi Alexfromto. Do you want that the oledb driver extracts all data as Text, correctly? Then you need add the follow Extended Properties: 1st: IMEX=1; 2nd: MaxScanRows=0 The first property force the OleDb Driver to read any cell of excel for determine the column type. The second establish the number of cell for every column to scan for determine de column type, the 0 value force to scan all cells.

SINCERELY. ANTHONY ACUÑA PREFERED PHRASE: SOMEBODY TELL ME WHY IS MORE REAL WHEN I DREAM THAT I AM WAKE?

he he he I'm sorry, when I was looking for "Vertical ProgressBar" I'd write "Vertical ProgresssBar". Sorry. I'd need the vertical progressbar because my form it's little limited of space, but I find space. Anyway thanks.

SINCERELY. ANTHONY ACUÑA PREFERED PHRASE: SOMEBODY TELL ME WHY IS MORE REAL WHEN I DREAM THAT I AM WAKE?

Hi Code Project Team. Someone know how set the progressbar layout to vertical direction? Thanks in advanced.

SINCERELY. ANTHONY ACUÑA PREFERED PHRASE: SOMEBODY TELL ME WHY IS MORE REAL WHEN I DREAM THAT I AM WAKE?

Hi Code Project Team. Please help me with this. http://www.codeproject.com/script/comments/forums.asp?msg=1753634&forumid=1649#xx1753634xx

SINCERELY. ANTHONY ACUÑA PREFERED PHRASE: SOMEBODY TELL ME WHY IS MORE REAL WHEN I DREAM THAT I AM WAKE?

Remember that the sintax is: using System; //All namespace to attach namespace demo {     public class demo     {         public demo()         {             //this is the constructor but if the app is console application you need de main method         }         public Main()         {             this.demo();         }         private int Occurance(string Input, string Find)         {             System.Text.RegularExpressions.Regex rx = new System.Text.RegularExpressions.Regex(Find); // to display them do this             System.Text.RegularExpressions.Match mt = rx.Match(Input);             while (mt.Success)             {                 System.Console.WriteLine("Found >>" + Find + "<< at position " + mt.Index.ToString());                 mt = mt.NextMatch();             }             // end display             return rx.Matches(Input).Count;         }         private DateTime getDate(int day, int month, int year)         {             return new DateTime(year, month, day);         }         private void compareDates(DateTime a, DateTime b)         {          &nbs

Hi Blekk. Exists two way for using. 1) if( MessageBox.Show(Handle, msg, caption, MessageBoxButtons.RetryCancel, MessageBoxIcon.Question) == DialogResult.Retry) {     //Do something... } 2) DialogResult p = MessageBox.Show(Handle, msg, caption, MessageBoxButtons.RetryCancel, MessageBoxIcon.Question); if( p == DialogResult.Retry ) {     //Do something... }

SINCERELY. ANTHONY ACUÑA PREFERED PHRASE: SOMEBODY TELL ME WHY IS MORE REAL WHEN I DREAM THAT I AM WAKE?

Hi Now_Loading. Try using: [DllImportAttribute("user32.dll")] private extern static IntPtr GetForegroundWindow(); And change "this.Handle" to "GetForegroundWindow()" GetForegroundWindow method return the Handle from the current window active. If this don't solve your problem tell me and I'll be sending you other options. By the way if you can help me with these System.Data.OleDb & Microsoft Excel I'll be thankful with you.

SINCERELY. ANTHONY ACUÑA PREFERED PHRASE: SOMEBODY TELL ME WHY IS MORE REAL WHEN I DREAM THAT I AM WAKE?

Hi Code Project Team. Someone know if it's porssible make subquerys in Excel using OleDb?

SINCERELY. ANTHONY ACUÑA PREFERED PHRASE: SOMEBODY TELL ME WHY IS MORE REAL WHEN I DREAM THAT I AM WAKE?

Hi Almerica. If you really need do it with Access, You can do it with WebServices, sending XML to client.

SINCERELY. ANTHONY ACUÑA PREFERED PHRASE: SOMEBODY TELL ME WHY IS MORE REAL WHEN I DREAM THAT I AM WAKE?

Hi Edboe. Your idea produce high sucurity risk, but yo can use the property AutoCompleteSource. Tip: Use the auto complete only for the username.

SINCERELY. ANTHONY ACUÑA PREFERED PHRASE: SOMEBODY TELL ME WHY IS MORE REAL WHEN I DREAM THAT I AM WAKE?

Hi Almerica. First, has you been thinked that if the Virtual connection to a Access Db was possible do you really want make it?. Remember this, When you open a Microsoft Access DB with OleDb, this block the file for other users. Why don't try using Free DataBases like MySQL. I'd suppouse that these have more powerful that Access.

SINCERELY. ANTHONY ACUÑA PREFERED PHRASE: SOMEBODY TELL ME WHY IS MORE REAL WHEN I DREAM THAT I AM WAKE?

Hi hdv212. Use the follow sintax: this.crystalReportViewer1.SelectionFormula = "{table.field} = value";

SINCERELY. ANTHONY ACUÑA PREFERED PHRASE: SOMEBODY TELL ME WHY IS MORE REAL WHEN I DREAM THAT I AM WAKE?

use the Launch Conditions option

SINCERELY. ANTHONY ACUÑA PREFERED PHRASE: SOMEBODY TELL ME WHY IS MORE REAL WHEN I DREAM THAT I AM WAKE?