Click here to Skip to main content
15,899,126 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: Interesting problem - Interaction between controls on a page and controls embeded within a user control Pin
AlexeiXX327-Sep-08 10:27
AlexeiXX327-Sep-08 10:27 
GeneralRe: Interesting problem - Interaction between controls on a page and controls embeded within a user control Pin
Tina P27-Sep-08 11:45
Tina P27-Sep-08 11:45 
GeneralRe: Interesting problem - Interaction between controls on a page and controls embeded within a user control Pin
AlexeiXX327-Sep-08 12:54
AlexeiXX327-Sep-08 12:54 
GeneralRe: Interesting problem - Interaction between controls on a page and controls embeded within a user control Pin
Tina P27-Sep-08 14:10
Tina P27-Sep-08 14:10 
GeneralRe: Interesting problem - Interaction between controls on a page and controls embeded within a user control [modified] Pin
AlexeiXX327-Sep-08 16:55
AlexeiXX327-Sep-08 16:55 
GeneralRe: Interesting problem - Interaction between controls on a page and controls embeded within a user control Pin
Tina P28-Sep-08 0:28
Tina P28-Sep-08 0:28 
GeneralRe: Interesting problem - Interaction between controls on a page and controls embeded within a user control Pin
AlexeiXX328-Sep-08 5:51
AlexeiXX328-Sep-08 5:51 
QuestionQuestion regarding formatting/ displaying data in a drop down list Pin
Tina P26-Sep-08 0:41
Tina P26-Sep-08 0:41 
hey guys, I have a drop down list which is supposed to show a combination of two dates (lets say insert date and pull date) separated by a underscore or something. The problem is that I only want the date to be shown and not the time (it's putting in a default time 12 AM in there) Now I could call ToShortDateString on the date that is being returned if I only had a single date coming back but since I'm getting a SQLDataReader object back, I can't even call that on it.

here is the code that I'm using:

public static SqlDataReader getDatesByWellId(Int32 wellId)
        {
            string dsn = System.Configuration.ConfigurationManager.ConnectionStrings["AMasterConnectionString1"].ConnectionString;
            SqlConnection conn = new SqlConnection(dsn);
            String query = "Select Convert(Varchar,InstallDate)+'  '+Convert(Varchar,PullDate) As DateInfo  From tblAssemblyMaster With (NoLock) Where WellId=" + wellId + " " + "Order By InstallDate Asc";
            SqlCommand cmd = new SqlCommand(query, conn);
            conn.Open();
            SqlDataReader sdr = cmd.ExecuteReader();

            return sdr;
        }


Is there anything that I can do to fix this? Like I said earlier all I wanna display is a date range for instance something like this: 4/11/2007 - 6/19/2008. Can someone shed some light on this!

Thanks
Tina
AnswerRe: Question regarding formatting/ displaying data in a drop down list Pin
NeverHeardOfMe26-Sep-08 0:50
NeverHeardOfMe26-Sep-08 0:50 
GeneralRe: Question regarding formatting/ displaying data in a drop down list Pin
Tina P26-Sep-08 21:05
Tina P26-Sep-08 21:05 
Questionserver.tranfer path error Pin
imranafsari26-Sep-08 0:26
imranafsari26-Sep-08 0:26 
AnswerRe: server.tranfer path error Pin
droth1726-Sep-08 1:54
droth1726-Sep-08 1:54 
QuestionCheck checkbox values in checkboxlist from database help (c#) Pin
AdamskiR26-Sep-08 0:11
AdamskiR26-Sep-08 0:11 
QuestionGet file name out of path Pin
varsh1226-Sep-08 0:01
varsh1226-Sep-08 0:01 
AnswerRe: Get file name out of path Pin
NeverHeardOfMe26-Sep-08 0:07
NeverHeardOfMe26-Sep-08 0:07 
GeneralRe: Get file name out of path Pin
J4amieC26-Sep-08 0:35
J4amieC26-Sep-08 0:35 
GeneralRe: Get file name out of path Pin
NeverHeardOfMe26-Sep-08 0:45
NeverHeardOfMe26-Sep-08 0:45 
QuestionReplace function is not working on ASP Pin
Amit Battan Ror25-Sep-08 23:00
Amit Battan Ror25-Sep-08 23:00 
AnswerRe: Replace function is not working on ASP Pin
NeverHeardOfMe25-Sep-08 23:28
NeverHeardOfMe25-Sep-08 23:28 
Questionwant to open a link Pin
UD(IA)25-Sep-08 22:10
UD(IA)25-Sep-08 22:10 
AnswerRe: want to open a link Pin
meeram39525-Sep-08 22:39
meeram39525-Sep-08 22:39 
QuestionChange the aspx page extension Pin
Kurle25-Sep-08 20:57
Kurle25-Sep-08 20:57 
AnswerRe: Change the aspx page extension Pin
meeram39525-Sep-08 21:13
meeram39525-Sep-08 21:13 
AnswerRe: Change the aspx page extension Pin
N a v a n e e t h25-Sep-08 21:15
N a v a n e e t h25-Sep-08 21:15 
AnswerRe: Change the aspx page extension Pin
Guffa25-Sep-08 22:09
Guffa25-Sep-08 22: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.