Click here to Skip to main content
15,887,596 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: Does SOAP protocol assure data transmit? Pin
ZHAOBING_NTU18-Jan-10 23:22
ZHAOBING_NTU18-Jan-10 23:22 
QuestionSessionID to be stored in the URL Pin
indian14318-Jan-10 13:32
indian14318-Jan-10 13:32 
AnswerRe: SessionID to be stored in the URL Pin
Prosanta Kundu online18-Jan-10 17:13
Prosanta Kundu online18-Jan-10 17:13 
AnswerRe: SessionID to be stored in the URL Pin
Brij18-Jan-10 19:51
mentorBrij18-Jan-10 19:51 
QuestionRetrieve value from Details View Pin
Samb198518-Jan-10 10:53
Samb198518-Jan-10 10:53 
QuestionProblem with paging with Grid View and Details View Pin
Samb198518-Jan-10 10:42
Samb198518-Jan-10 10:42 
Questionread from excel Pin
arkiboys18-Jan-10 4:55
arkiboys18-Jan-10 4:55 
AnswerRe: read from excel Pin
Stryder_118-Jan-10 5:58
Stryder_118-Jan-10 5:58 
Hi,

Not sure how automated of a process you are looking for, but a simple fix is to add a way to pass in the name of the first sheet - text box if graphical interface, or command line parameter if console app. During your processing you would swap out the name in the string:

string strSheet = "Sheet1"; // assign appropriate user entry here

OleDbDataAdapter cmd = new OleDbDataAdapter("SELECT * FROM [" + strSheet + "$]", strConn);

// alternately, replace with string builder if you want to be more efficient...
GeneralRe: read from excel Pin
arkiboys18-Jan-10 21:41
arkiboys18-Jan-10 21:41 
QuestionCrystal Report Pin
mgomathi18-Jan-10 4:53
mgomathi18-Jan-10 4:53 
QuestionDivide single column into five in gridview Template [modified] Pin
trinhitc18-Jan-10 3:24
trinhitc18-Jan-10 3:24 
AnswerRe: Divide single column into five in gridview Template Pin
Anurag Gandhi19-Jan-10 1:58
professionalAnurag Gandhi19-Jan-10 1:58 
QuestionClient Centric or Server Centric Pin
AndyInUK18-Jan-10 2:18
AndyInUK18-Jan-10 2:18 
AnswerRe: Client Centric or Server Centric Pin
RichardGrimmer18-Jan-10 4:30
RichardGrimmer18-Jan-10 4:30 
GeneralRe: Client Centric or Server Centric Pin
AndyInUK18-Jan-10 4:59
AndyInUK18-Jan-10 4:59 
GeneralRe: Client Centric or Server Centric Pin
RichardGrimmer18-Jan-10 6:11
RichardGrimmer18-Jan-10 6:11 
QuestionHelp: AJAX disables my Server Code from running! Pin
awedaonline18-Jan-10 1:06
awedaonline18-Jan-10 1:06 
AnswerRe: Help: AJAX disables my Server Code from running! Pin
Not Active18-Jan-10 2:03
mentorNot Active18-Jan-10 2:03 
GeneralRe: Help: AJAX disables my Server Code from running! Pin
awedaonline18-Jan-10 3:21
awedaonline18-Jan-10 3:21 
GeneralRe: Help: AJAX disables my Server Code from running! Pin
Not Active18-Jan-10 5:00
mentorNot Active18-Jan-10 5:00 
QuestionASP.NET ChatRoom (With C# Coding) Pin
jojoba201018-Jan-10 0:33
jojoba201018-Jan-10 0:33 
AnswerRe: ASP.NET ChatRoom (With C# Coding) Pin
Steve Westbrook18-Jan-10 4:53
Steve Westbrook18-Jan-10 4:53 
QuestionSeperate Comment line.. Pin
Ramkumar_S18-Jan-10 0:20
Ramkumar_S18-Jan-10 0:20 
AnswerRe: Seperate Comment line.. Pin
dan!sh 18-Jan-10 0:48
professional dan!sh 18-Jan-10 0:48 
GeneralRe: Seperate Comment line.. Pin
Ramkumar_S18-Jan-10 18:48
Ramkumar_S18-Jan-10 18:48 

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.