Click here to Skip to main content
15,895,557 members
Home / Discussions / ASP.NET
   

ASP.NET

 
QuestionCreate and senda email in .net 3.5 Pin
kpuneeth73-Mar-10 19:50
kpuneeth73-Mar-10 19:50 
AnswerRe: Create and senda email in .net 3.5 Pin
Brij3-Mar-10 20:10
mentorBrij3-Mar-10 20:10 
GeneralRe: Create and senda email in .net 3.5 Pin
kpuneeth73-Mar-10 20:25
kpuneeth73-Mar-10 20:25 
GeneralRe: Create and senda email in .net 3.5 Pin
Brij3-Mar-10 21:01
mentorBrij3-Mar-10 21:01 
AnswerRe: Create and senda email in .net 3.5 Pin
Not Active4-Mar-10 0:19
mentorNot Active4-Mar-10 0:19 
Answer[Cross Post] Re: Create and senda email in .net 3.5 Pin
Scott Dorman4-Mar-10 4:36
professionalScott Dorman4-Mar-10 4:36 
QuestionReading excel data into datatable Pin
snehasish3-Mar-10 19:45
snehasish3-Mar-10 19:45 
AnswerRe: Reading excel data into datatable Pin
Dinesh Mani3-Mar-10 21:42
Dinesh Mani3-Mar-10 21:42 
Excel by default has a very loose type binding, i.e. if you set the column's formatting to text and insert a numeric value in it then it treats the data as text. When you set the format to numeric and enter textual data it changes the type to general which accepts all data values.

Now, Datatables in ADO.NET are type sensitive and are tight binding. When you execute a query against a cell range in excel .NET sets the datatype of the column as the data type of the first cell in that column in excel. Now if there is data of other type in that row then that data is ignored when reading the cells and is left as NULL in the data table.

As far as I know the cell formatting does not matter, the ADO.NET engine analyzes the data in the first cell and sets the data type. You cannot control the way it is done. So, if you have text data and numeric data in the same column then make sure that the fist row has text data than numeric data.

HTH!
QuestionAuthorize.net SIM implementation issue Pin
Sudhanshu Mani Tripathi3-Mar-10 19:43
Sudhanshu Mani Tripathi3-Mar-10 19:43 
AnswerRe: Authorize.net SIM implementation issue Pin
rhandler12-Jun-10 21:16
rhandler12-Jun-10 21:16 
QuestionHow to create cab file for ActiveXControl? Pin
Prasadsm3-Mar-10 19:28
Prasadsm3-Mar-10 19:28 
QuestionCrytal Report Problem Pin
Any_India3-Mar-10 19:07
Any_India3-Mar-10 19:07 
AnswerRe: Crytal Report Problem Pin
Any_India3-Mar-10 22:37
Any_India3-Mar-10 22:37 
QuestionLooking for ASP .net2 To tell Memory and Tasklist of WebServer Pin
AndyBot3-Mar-10 19:06
AndyBot3-Mar-10 19:06 
Questionrestrict data by lines... Pin
pranavcool3-Mar-10 18:11
pranavcool3-Mar-10 18:11 
Questionmulti-language using globaluzation and localization Pin
Amit Spadez3-Mar-10 18:10
professionalAmit Spadez3-Mar-10 18:10 
AnswerRe: multi-language using globaluzation and localization Pin
Brij3-Mar-10 19:08
mentorBrij3-Mar-10 19:08 
AnswerRe: multi-language using globaluzation and localization Pin
Amit M patel3-Mar-10 19:48
Amit M patel3-Mar-10 19:48 
QuestionBinding records taking more time with paging Pin
Member 38798813-Mar-10 17:59
Member 38798813-Mar-10 17:59 
AnswerRe: Binding records taking more time with paging Pin
Viral Upadhyay3-Mar-10 18:26
Viral Upadhyay3-Mar-10 18:26 
AnswerRe: Binding records taking more time with paging Pin
Brij3-Mar-10 18:52
mentorBrij3-Mar-10 18:52 
AnswerRe: Binding records taking more time with paging Pin
Pranay Rana3-Mar-10 18:57
professionalPranay Rana3-Mar-10 18:57 
AnswerRe: Binding records taking more time with paging Pin
Amit M patel3-Mar-10 19:56
Amit M patel3-Mar-10 19:56 
QuestionDynamic Report Builder Pin
RB@Emphasys3-Mar-10 10:18
RB@Emphasys3-Mar-10 10:18 
AnswerRe: Dynamic Report Builder Pin
T M Gray3-Mar-10 10:54
T M Gray3-Mar-10 10:54 

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.