Yikes - wish I hadn't asked. Okay, well, I'd be looking for the first reported error and concentrate on that: Starting up database 'master'. Error: 17207, Severity: 16, State: 1. Start with that and see how far you get. (If anyone else has a better suggestion now would be the time...) me, me, me "The dinosaurs became extinct because they didn't have a space program. And if we become extinct because we don't have a space program, it'll serve us right!" Larry Niven

I think that option should be in GMAIL, and it already has that. If you download mails properly, it will start download after the last downloaded mail from your account. See how outlook does. :cool: Abhishek Sur My Latest Articles **Create CLR objects in SQL Server 2005 C# Uncommon Keywords Read/Write Excel using OleDB **Don't forget to click "Good Answer" if you like to.

Thanks for the all hard work you did for me. But my problem is that I don't want to use any dll or third party tool for do the same. I have to do it only by normal c# coding and if you find something like this, then please tell me.... coz i didn't find it....

astrovirgin wrote: The answer I got is poor. I Then you should reply the member who gave you the answer that, your solution is not working, do you have any more idea on that? Simple. Not to delete the message. astrovirgin wrote: I delete the question because I want to repost it in better manner so everyone can understand what I really need. It would be better, if you modify the existing message, rather than thinking of Repost. cheers, Abhijit CodeProject MVP Web Site:abhijitjana.net View My Recent Article

Read Records one by one from the sheet and insert it into the desired table. the below function will help you in returning table from the Excel Sheet but the sheet name should be Sheet1. if change ..then change the code i have highlighted with underline(bold) public DataTable getDataFromXLS(string strFilePath) { try { string strConnectionString = string.Empty; strConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + strFilePath + ";" + "Extended Properties=Excel 8.0;"; OleDbConnection cnCSV = new OleDbConnection(strConnectionString); cnCSV.Open(); OleDbCommand cmdSelect = new OleDbCommand(@"SELECT * FROM [Sheet1$]", cnCSV); OleDbDataAdapter daCSV = new OleDbDataAdapter(); daCSV.SelectCommand = cmdSelect; DataTable dtCSV = new DataTable(); daCSV.Fill(dtCSV); cnCSV.Close(); daCSV = null; return dtCSV; } catch (Exception ex) { return null; } finally { } }

There pleny of good code examples, look for TCP Queue IO or QIO.

Well, may be a bit very late, but i just came accross a project on sourceforge: niso8583 It contains sources fro building iso 8583 messages from xml Have no idea whether it will help you, Greetings astrovirgin wrote: I am working on ISO 8583-1987 standard. The problem is that my client is sending an XML file and I have to parse it in ISO 8583-1987 standard Where is the glue that glues together all the code snippets on The CodeProject to the ultimate solution, so I never have to work anymore?

If you're using SQL 2005 you could have a look at the PIVOT command.

I am not getting what you want to say. Where I use Server.Transfer??? Sorry.. But over the head answer...

Just saw ur question... Actually this is VERY possible. I made a code that hides the process from process tab. When u look at running process number, it stays the same, but the exe process isnt on list anymore. Quite hard to do, but possible :)

I believe you can use managed JScript or JScript.Net. http://en.wikipedia.org/wiki/JScript#Managed_JScript[^] Which javascript function do you want to use though? there is probably a better way to just do it in c#. Simon

Shyam Bharath wrote: astrovirgin wrote: When I upload the file using FileUpload it should store the file in database. Then what does the above line mean? Probably that he doesn't know how to ask a question correctly, which places him among the other 83 percent* of the posters who don't know how to ask a question correctly. ;) * Out of all statistics quoted, 83% is made up right on the spot. Despite everything, the person most likely to be fooling you next is yourself.

I have already answered in C# forum Giorgi Dalakishvili #region signature My Articles / My Latest Article[^] / My blog[^] #endregion

listen, i can´t debug that, because the way i code is different. :doh: Try this routine, may work out for you. // connection string public static string connection_string = "..." // store procedure public static string SP_whatever = "..."; // database connection (no parameters) public static void DataGridView_Fill(DataGridView dgv, string store_procedure) { SqlConnection sql_conn = new SqlConnection(connection_string); SqlCommand sql_cmd = new SqlCommand(); sql_cmd.Connection = sql_conn; sql_cmd.CommandText = store_procedure; sql_cmd.CommandType = CommandType.StoredProcedure; sql_conn.Open(); SqlDataAdapter sql_da = new SqlDataAdapter(); sql_da.SelectCommand = sql_cmd; DataTable dt = new DataTable(); sql_da.Fill(dt); sql_conn.Close(); dgv.DataSource = dt; } nelsonpaixao@yahoo.com.br trying to help & get help

Here you are: http://msdn.microsoft.com/en-us/library/fbk67b6z.aspx[^] See the last example. Giorgi Dalakishvili #region signature My Articles / My Latest Article[^] / My blog[^] #endregion

Ashfield wrote: the OP did specify sql server Oh, yes, absolutely, and he wanted it to be an SQL statement too, but after finding one way for SQL Server, another way for Oracle, another way for Ingres, and then facing MySQL, Caché, FireBird, Access, etc. I realized I already had a way that works with all of them. I aim for database agnosticism. (I do, however, prefer SQL Server.)

Either use sp_helpdb pprocedure or query master..sysdatabases. The need to optimize rises from a bad design

You can use SMO to retrieve database names from sql server instance or you can issue a query that retrieves all database names using sqlcommand object and then populate combobox. Giorgi Dalakishvili #region signature my articles My blog[^] #endregion