Comments by vasini - CodeProject

vasini 11-Mar-13 13:54pm View

Thanks for the response. Can you please let me know in detail of this and any examples you have. Thank you.

vasini 5-Mar-13 10:31am View

Thanks for the answer. But it includes records when inst is NULL. I need includes records when its passed else just condition with type.

vasini 22-Feb-12 13:56pm View

Sorry about the requirements. I have "type" as P, S and I. If Type is P and S, I have to take record for P. If Type is S and I then take S. In all other cases take P.

Thanks for your help.

vasini 22-Feb-12 12:46pm View

It did not work out. It is displaying all the records.

vasini 20-Apr-11 10:45am View

Thank you for sending me the link. Do you know anything I can use direct BCP in C# code? Can I use xp_cmdshell in C# in generating the csv/tab file?
Thanks for your help.

vasini 19-Apr-11 11:58am View

Thank you so Much. It worked for me.

vasini 13-Apr-11 10:35am View

I am using the same to get the sheet names. But one of my sheet name has special characters in it. Its faling to read that sheet name by using OLEDB.

string firstSheetName = "Test- Sheet!"

OleDbAdapter oleAdapter = new OleDbAdapter ("SELECT * FROM [" + firstSheetName + "$]", dbConnection);

Do you have any idea for this?
Thanks

vasini 13-Apr-11 10:34am View

Thanks for your response.

I used IMEX. Its considering the Column names with special characters. But I need the sheet names with special characters. I am using OLEDB and importing the data from that sheet which has special characters in it.

Can you pls help me in getting sheet names?

Thanks

Comments by vasini (Top 8 by date)