Click here to Skip to main content
15,847,903 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: session is cleared Pin
JustWorking10-Feb-10 22:46
JustWorking10-Feb-10 22:46 
GeneralRe: session is cleared Pin
R22k10-Feb-10 22:54
R22k10-Feb-10 22:54 
AnswerRe: session is cleared Pin
joelle@scope10-Feb-10 23:38
joelle@scope10-Feb-10 23:38 
GeneralRe: session is cleared Pin
R22k11-Feb-10 0:54
R22k11-Feb-10 0:54 
GeneralRe: session is cleared Pin
joelle@scope11-Feb-10 0:57
joelle@scope11-Feb-10 0:57 
GeneralRe: session is cleared Pin
R22k11-Feb-10 0:59
R22k11-Feb-10 0:59 
QuestionHow to open excel in asp.net??? Pin
JC.KaNNaN10-Feb-10 22:07
JC.KaNNaN10-Feb-10 22:07 
AnswerRe: How to open excel in asp.net??? Pin
saini arun10-Feb-10 22:49
saini arun10-Feb-10 22:49 
You can read excel into a dataset and then can dispay it easily using grid view of whatever control you prefer.

int workSheetNumber = 0;

OleDbConnection ExcelConnection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + FilePathWithName + ";Extended Properties=Excel 8.0;");

                OleDbCommand ExcelCommand = new OleDbCommand();
                ExcelCommand.Connection = ExcelConnection;
                OleDbDataAdapter ExcelAdapter = new OleDbDataAdapter(ExcelCommand);

                ExcelConnection.Open();
                System.Data.DataTable ExcelSheets = ExcelConnection.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
                string SpreadSheetName = "[" + ExcelSheets.Rows[workSheetNumber]["TABLE_NAME"].ToString() + "]";

                DataSet ExcelDataSet = new DataSet();
                ExcelCommand.CommandText = @"SELECT * FROM " + SpreadSheetName;
                ExcelAdapter.Fill(ExcelDataSet);

QuestionI want to add, edit and delete data from table using gridview in Asp.net? Pin
mdrizwan_110-Feb-10 21:03
mdrizwan_110-Feb-10 21:03 
AnswerRe: I want to add, edit and delete data from table using gridview in Asp.net? Pin
i gr810-Feb-10 21:26
i gr810-Feb-10 21:26 
GeneralRe: I want to add, edit and delete data from table using gridview in Asp.net? Pin
mdrizwan_111-Feb-10 5:05
mdrizwan_111-Feb-10 5:05 
GeneralI need Help with FTP browser ! Pin
mgexpression10-Feb-10 21:01
mgexpression10-Feb-10 21:01 
Questionhow to use menu control using database... Pin
hi_everybody10-Feb-10 20:42
hi_everybody10-Feb-10 20:42 
QuestionModalPopupExtender confirmation not working in <asp:CommandFiel in grid view Pin
Vishnu Narayan Mishra10-Feb-10 19:59
Vishnu Narayan Mishra10-Feb-10 19:59 
QuestionHow to refresh Parent particular griview? Pin
JC.KaNNaN10-Feb-10 19:53
JC.KaNNaN10-Feb-10 19:53 
AnswerRe: How to refresh Parent particular griview? Pin
Gaurav Dudeja India10-Feb-10 19:56
Gaurav Dudeja India10-Feb-10 19:56 
GeneralRe: How to refresh Parent particular griview? Pin
JC.KaNNaN10-Feb-10 20:50
JC.KaNNaN10-Feb-10 20:50 
QuestionHow to assign the total value of a column to the footer? Pin
TeiUKei10-Feb-10 19:34
TeiUKei10-Feb-10 19:34 
AnswerRe: How to assign the total value of a column to the footer? Pin
Gaurav Dudeja India10-Feb-10 19:54
Gaurav Dudeja India10-Feb-10 19:54 
NewsGoogle API - graph Pin
Member 395625710-Feb-10 19:17
Member 395625710-Feb-10 19:17 
GeneralRe: Google API - graph Pin
nainakarri10-Feb-10 19:58
nainakarri10-Feb-10 19:58 
GeneralRe: Google API - graph Pin
Member 395625710-Feb-10 20:36
Member 395625710-Feb-10 20:36 
GeneralRe: Google API - graph Pin
Anurag Gandhi10-Feb-10 21:42
professionalAnurag Gandhi10-Feb-10 21:42 
QuestionFind How many Enter Key Press Pin
sjs4u10-Feb-10 18:55
sjs4u10-Feb-10 18:55 
AnswerRe: Find How many Enter Key Press Pin
Anurag Gandhi10-Feb-10 19:19
professionalAnurag Gandhi10-Feb-10 19:19 

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.