Click here to Skip to main content
15,918,268 members
Home / Discussions / ASP.NET
   

ASP.NET

 
Questionhyperlink in gridview Pin
vikas shukla7-Jul-09 22:58
vikas shukla7-Jul-09 22:58 
AnswerRe: hyperlink in gridview Pin
Manas Bhardwaj7-Jul-09 23:06
professionalManas Bhardwaj7-Jul-09 23:06 
AnswerRe: hyperlink in gridview Pin
Zafar A khan 7-Jul-09 23:34
professionalZafar A khan 7-Jul-09 23:34 
QuestionDisplay PopUp on schedule time and date. Pin
Ajeet mittal7-Jul-09 22:54
Ajeet mittal7-Jul-09 22:54 
AnswerRe: Display PopUp on schedule time and date. Pin
Zafar A khan 7-Jul-09 22:58
professionalZafar A khan 7-Jul-09 22:58 
GeneralRe: Display PopUp on schedule time and date. Pin
janakiraman_T26-Jul-09 20:59
janakiraman_T26-Jul-09 20:59 
QuestionExcel to MySQL Pin
astrovirgin7-Jul-09 22:27
astrovirgin7-Jul-09 22:27 
AnswerRe: Excel to MySQL Pin
Zafar A khan 8-Jul-09 0:12
professionalZafar A khan 8-Jul-09 0:12 
Read Records one by one from the sheet and insert it into the desired table. the below function will help you in returning table from the Excel Sheet but the sheet name should be Sheet1. if change ..then change the code i have highlighted with underline(bold)


public DataTable getDataFromXLS(string strFilePath)
{
try
{
string strConnectionString = string.Empty;
strConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + strFilePath + ";" + "Extended Properties=Excel 8.0;";
OleDbConnection cnCSV = new OleDbConnection(strConnectionString);
cnCSV.Open();
OleDbCommand cmdSelect = new OleDbCommand(@"SELECT * FROM [Sheet1$]", cnCSV);
OleDbDataAdapter daCSV = new OleDbDataAdapter();
daCSV.SelectCommand = cmdSelect;
DataTable dtCSV = new DataTable();
daCSV.Fill(dtCSV);
cnCSV.Close();
daCSV = null;
return dtCSV;

}
catch (Exception ex)
{
return null;
}
finally { }
}
QuestionPreserving Checkbox values on changeevent of dynamically created textbox Pin
meeram3957-Jul-09 22:19
meeram3957-Jul-09 22:19 
QuestionDynamic controls Pin
KhandelwalA7-Jul-09 20:29
KhandelwalA7-Jul-09 20:29 
AnswerRe: Dynamic controls Pin
padmanabhan N7-Jul-09 20:36
padmanabhan N7-Jul-09 20:36 
GeneralRe: Dynamic controls Pin
KhandelwalA7-Jul-09 20:49
KhandelwalA7-Jul-09 20:49 
AnswerRe: Dynamic controls Pin
Zafar A khan 7-Jul-09 20:45
professionalZafar A khan 7-Jul-09 20:45 
GeneralRe: Dynamic controls Pin
KhandelwalA7-Jul-09 20:47
KhandelwalA7-Jul-09 20:47 
GeneralRe: Dynamic controls Pin
Zafar A khan 8-Jul-09 18:28
professionalZafar A khan 8-Jul-09 18:28 
Question[Message Deleted] Pin
Bataineh7-Jul-09 20:28
Bataineh7-Jul-09 20:28 
AnswerRe: web.config error Pin
Abhijit Jana7-Jul-09 20:47
professionalAbhijit Jana7-Jul-09 20:47 
GeneralRe: web.config error [modified] Pin
Bataineh7-Jul-09 20:49
Bataineh7-Jul-09 20:49 
QuestionHow to Create Excel File and Adding multiple Tabs in ASP.net2.0 without Adding Reference Pin
vandanaconedify7-Jul-09 20:07
vandanaconedify7-Jul-09 20:07 
QuestionReading word document in asp.net 1.1 Pin
Spurple7-Jul-09 19:01
Spurple7-Jul-09 19:01 
AnswerRe: Reading word document in asp.net 1.1 Pin
N a v a n e e t h7-Jul-09 20:15
N a v a n e e t h7-Jul-09 20:15 
AnswerRe: Reading word document in asp.net 1.1 Pin
Abhijit Jana7-Jul-09 20:18
professionalAbhijit Jana7-Jul-09 20:18 
Questionpass the value from javascript to c# in asp.net Pin
billcodes7-Jul-09 18:58
billcodes7-Jul-09 18:58 
AnswerRe: pass the value from javascript to c# in asp.net Pin
himanshu25617-Jul-09 19:18
himanshu25617-Jul-09 19:18 
Questionvalidation Pin
mahichandu7-Jul-09 12:04
mahichandu7-Jul-09 12:04 

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.