Click here to Skip to main content
15,914,066 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: .Net 1.1 and .Ne 2.0 Pin
RichardGrimmer3-May-07 5:52
RichardGrimmer3-May-07 5:52 
AnswerRe: .Net 1.1 and .Ne 2.0 Pin
Guffa2-May-07 0:45
Guffa2-May-07 0:45 
GeneralRe: .Net 1.1 and .Net 2.0 Pin
Saranya B2-May-07 1:44
Saranya B2-May-07 1:44 
GeneralRe: .Net 1.1 and .Net 2.0 Pin
N a v a n e e t h2-May-07 3:26
N a v a n e e t h2-May-07 3:26 
AnswerRe: .Net 1.1 and .Net 2.0 Pin
Guffa2-May-07 3:30
Guffa2-May-07 3:30 
Questionneed help with inheriting 'System.MarshalByRefObject' for remoting Pin
neodeaths1-May-07 20:18
neodeaths1-May-07 20:18 
QuestionImport Excel Sheet datas into mysql Pin
vijay_831-May-07 20:17
vijay_831-May-07 20:17 
AnswerRe: Import Excel Sheet datas into mysql Pin
VaibhavTiparadi1-May-07 21:08
VaibhavTiparadi1-May-07 21:08 
//-------------------------------------------
//To Extract data from excel sheet and store it in Dataset.
private DataSet PerformQueryIntoDataSet(string strFileName,string sheetName)
{
string strConn;
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + strFileName + ";" + "Extended Properties=" + Convert.ToChar(34).ToString() + "Excel 8.0;HDR=NO; IMEX=1;" + Convert.ToChar(34).ToString();
//You must use the $ after the object you reference in the spreadsheet
OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM ["+ sheetName + "$]", strConn);
DataSet myData = new DataSet();
myCommand.Fill(myData, sheetName);
return myData;
}
//-------------------------------------------

//To get number of records in the sheet
[Datasetname].Tables["<sheet name="">"].Rows.Count;
//To extract data from table in dataset.
DataRow RowName = (DataRow)[Datasetname].Tables["<sheet name="">"].Select().GetValue(rowIndex);
string strValue = RowName[0].ToString().ToUpper().Trim();

//Then check for validation and store it in Database.

There's never a Wronge Time To Do The Right Thing !!

QuestionProblem with webclienet class uploadfile method? Pin
.NetRams1-May-07 20:11
.NetRams1-May-07 20:11 
AnswerRe: Problem with webclienet class uploadfile method? Pin
N a v a n e e t h1-May-07 21:06
N a v a n e e t h1-May-07 21:06 
QuestionError when trying to send mail Pin
anujose1-May-07 19:48
anujose1-May-07 19:48 
AnswerRe: Error when trying to send mail Pin
N a v a n e e t h1-May-07 21:07
N a v a n e e t h1-May-07 21:07 
QuestionHow to upload all files from source folder to web path. Pin
.NetRams1-May-07 19:22
.NetRams1-May-07 19:22 
AnswerRe: How to upload all files from source folder to web path. Pin
Sandeep Akhare1-May-07 19:42
Sandeep Akhare1-May-07 19:42 
GeneralRe: How to upload all files from source folder to web path. Pin
.NetRams1-May-07 20:08
.NetRams1-May-07 20:08 
AnswerRe: How to upload all files from source folder to web path. Pin
N a v a n e e t h1-May-07 21:15
N a v a n e e t h1-May-07 21:15 
GeneralRe: How to upload all files from source folder to web path. Pin
.NetRams1-May-07 23:03
.NetRams1-May-07 23:03 
GeneralRe: How to upload all files from source folder to web path. Pin
N a v a n e e t h1-May-07 23:14
N a v a n e e t h1-May-07 23:14 
GeneralRe: How to upload all files from source folder to web path. Pin
.NetRams1-May-07 23:59
.NetRams1-May-07 23:59 
QuestionHow to import excel sheet datas into mysql database Pin
vijay_831-May-07 18:39
vijay_831-May-07 18:39 
AnswerRe: How to import excel sheet datas into mysql database Pin
N a v a n e e t h1-May-07 21:17
N a v a n e e t h1-May-07 21:17 
Questionhow to store word document content into access database Memo field using Asp.net 2 Pin
maxiachun1-May-07 17:32
maxiachun1-May-07 17:32 
Questionneed help with my asp.net2 - javascipt Pin
neodeaths1-May-07 16:09
neodeaths1-May-07 16:09 
AnswerRe: need help with my asp.net2 - javascipt Pin
Psycho-*Coder*-Extreme1-May-07 16:57
Psycho-*Coder*-Extreme1-May-07 16:57 
GeneralRe: need help with my asp.net2 - javascipt Pin
neodeaths1-May-07 18:09
neodeaths1-May-07 18:09 

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.