Click here to Skip to main content
15,888,454 members
Home / Discussions / C#
   

C#

 
GeneralRe: Http 502 and 503 errors Pin
led mike21-Jul-08 5:59
led mike21-Jul-08 5:59 
GeneralRe: Http 502 and 503 errors Pin
George_George21-Jul-08 19:26
George_George21-Jul-08 19:26 
GeneralRe: Http 502 and 503 errors Pin
N a v a n e e t h21-Jul-08 16:48
N a v a n e e t h21-Jul-08 16:48 
GeneralRe: Http 502 and 503 errors Pin
George_George21-Jul-08 19:24
George_George21-Jul-08 19:24 
GeneralRe: Http 502 and 503 errors Pin
N a v a n e e t h22-Jul-08 17:00
N a v a n e e t h22-Jul-08 17:00 
GeneralRe: Http 502 and 503 errors Pin
George_George31-Jul-08 2:30
George_George31-Jul-08 2:30 
QuestionMaximum buffer size while displaying to the grid Pin
tasumisra17-Jul-08 21:36
tasumisra17-Jul-08 21:36 
QuestionExcel data to dataset Pin
Sunil Wise17-Jul-08 20:52
professionalSunil Wise17-Jul-08 20:52 
Hi everyone,

i am developing one application in that i need to get data from excel sheet to the dataset after that i'll have some calculations to do.
In the excel sheet i have one column [dateregistered] the date format in that column is (mm/dd/yyyy hh:mm) i want the date format to be (mm/dd/yyy) from sql query.
i have written a query below which is giving me error
Syntax error (missing operator) in query expression 'CONVERT(varchar ,[dateregistered],103) Dates'.

here i am getting the data directly from excel sheet not from sql server
so i want know how to use convert function for retriving data from excel sheet
<br />
string sql = "select   CONVERT(varchar ,[dateregistered],103) Dates,[user],[client facility],sum([payroll score])LC from [sheet1$] group by [user],[client facility], CONVERT(varchar ,[dateregistered],103) order by [docQscribe user]";<br />
da = new OleDbDataAdapter(sql, con);<br />
ds = new DataSet();<br />
da.Fill(ds,"Table1");<br />

AnswerRe: Excel data to dataset Pin
Sunil Wise17-Jul-08 21:29
professionalSunil Wise17-Jul-08 21:29 
QuestionWMI “Printer job status “is not working in Windows service Pin
Rajesh_K_Sharma17-Jul-08 19:39
Rajesh_K_Sharma17-Jul-08 19:39 
AnswerRe: WMI “Printer job status “is not working in Windows service Pin
Abhijit Jana17-Jul-08 21:23
professionalAbhijit Jana17-Jul-08 21:23 
GeneralRe: WMI “Printer job status “is not working in Windows service Pin
Rajesh_K_Sharma17-Jul-08 21:50
Rajesh_K_Sharma17-Jul-08 21:50 
QuestionHow to get the List of Database Server Pin
wasimsharp17-Jul-08 18:34
wasimsharp17-Jul-08 18:34 
AnswerRe: How to get the List of Database Server Pin
wasimsharp17-Jul-08 20:09
wasimsharp17-Jul-08 20:09 
GeneralRe: How to get the List of Database Server Pin
Jimmanuel18-Jul-08 2:13
Jimmanuel18-Jul-08 2:13 
GeneralRe: How to get the List of Database Server Pin
wasimsharp19-Jul-08 1:47
wasimsharp19-Jul-08 1:47 
QuestionRegistry Pin
damianrda17-Jul-08 18:30
damianrda17-Jul-08 18:30 
AnswerRe: Registry Pin
Simon P Stevens17-Jul-08 22:55
Simon P Stevens17-Jul-08 22:55 
AnswerRe: Registry Pin
enginço17-Jul-08 23:38
enginço17-Jul-08 23:38 
GeneralRe: Registry Pin
Simon P Stevens18-Jul-08 1:48
Simon P Stevens18-Jul-08 1:48 
GeneralRe: Registry [modified] Pin
enginço18-Jul-08 2:42
enginço18-Jul-08 2:42 
GeneralRe: Registry Pin
Simon P Stevens18-Jul-08 7:25
Simon P Stevens18-Jul-08 7:25 
QuestionDatabinding dropdown in C# Pin
sabraham17-Jul-08 17:24
sabraham17-Jul-08 17:24 
AnswerRe: Databinding dropdown in C# Pin
nelsonpaixao18-Jul-08 14:58
nelsonpaixao18-Jul-08 14:58 
GeneralRe: Databinding dropdown in C# Pin
sabraham23-Jul-08 12:07
sabraham23-Jul-08 12:07 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.