Click here to Skip to main content
15,440,714 members
Home / Discussions / C#
   

C#

 
GeneralRe: Executing few lines of code on Windows Store app installation Pin
Pete O'Hanlon1-Jul-14 1:31
mvaPete O'Hanlon1-Jul-14 1:31 
QuestionMSI installer, deployment Pin
ankum1630-Jun-14 18:17
Memberankum1630-Jun-14 18:17 
AnswerRe: MSI installer, deployment Pin
Bernhard Hiller30-Jun-14 20:24
MemberBernhard Hiller30-Jun-14 20:24 
QuestionHow to add ScrollViewer to usercontrol in MVVM by josh smith. Pin
vijendra malik30-Jun-14 16:45
Membervijendra malik30-Jun-14 16:45 
AnswerRe: How to add ScrollViewer to usercontrol in MVVM by josh smith. Pin
Kornfeld Eliyahu Peter30-Jun-14 19:18
professionalKornfeld Eliyahu Peter30-Jun-14 19:18 
Questionbetween two Datetimepicker using Pin
Nishant.Chauhan8029-Jun-14 19:30
MemberNishant.Chauhan8029-Jun-14 19:30 
AnswerRe: between two Datetimepicker using Pin
Eddy Vluggen29-Jun-14 22:28
professionalEddy Vluggen29-Jun-14 22:28 
AnswerRe: between two Datetimepicker using Pin
OriginalGriff29-Jun-14 22:59
mveOriginalGriff29-Jun-14 22:59 
Try:
C#
using (SqlConnection con = new SqlConnection(strConnect))
    {
    con.Open();
    using (SqlCommand cmd = new SqlCommand("SELECT * FROM myTable WHERE MyDateColumn BETWEEN @ST AND @END", con))
        {
        cmd.Parameters.AddWithValue("@ST", dtpStart.Value);
        cmd.Parameters.AddWithValue("@EN", dtpEnd.Value);
        using (SqlDataReader reader = cmd.ExecuteReader())
            {
            while (reader.Read())
                {
                int id = (int) reader["iD"];
                string desc = (string) reader["description"];
                Console.WriteLine("ID: {0}\n    {1}", iD, desc);
                }
            }
        }
    }

Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952)
Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)

GeneralRe: between two Datetimepicker using Pin
V.30-Jun-14 3:16
professionalV.30-Jun-14 3:16 
GeneralRe: between two Datetimepicker using Pin
OriginalGriff30-Jun-14 4:26
mveOriginalGriff30-Jun-14 4:26 
QuestionWinforms vs MFC Pin
shiftwik29-Jun-14 17:50
Membershiftwik29-Jun-14 17:50 
AnswerRe: Winforms vs MFC Pin
PIEBALDconsult29-Jun-14 18:10
professionalPIEBALDconsult29-Jun-14 18:10 
AnswerRe: Winforms vs MFC Pin
Eddy Vluggen29-Jun-14 22:30
professionalEddy Vluggen29-Jun-14 22:30 
AnswerRe: Winforms vs MFC Pin
OriginalGriff29-Jun-14 23:01
mveOriginalGriff29-Jun-14 23:01 
QuestionEmail sending failed in asp.net c# Pin
Member 1022600129-Jun-14 5:43
MemberMember 1022600129-Jun-14 5:43 
AnswerRe: Email sending failed in asp.net c# Pin
Pete O'Hanlon29-Jun-14 6:48
mvaPete O'Hanlon29-Jun-14 6:48 
GeneralRe: Email sending failed in asp.net c# Pin
Member 1022600129-Jun-14 6:59
MemberMember 1022600129-Jun-14 6:59 
GeneralRe: Email sending failed in asp.net c# Pin
Member 102260012-Jul-14 5:32
MemberMember 102260012-Jul-14 5:32 
QuestionSave in related table ... Pin
nassimnastaran29-Jun-14 4:34
Membernassimnastaran29-Jun-14 4:34 
AnswerRe: Save in related table ... Pin
OriginalGriff29-Jun-14 5:50
mveOriginalGriff29-Jun-14 5:50 
GeneralRe: Save in related table ... Pin
nassimnastaran29-Jun-14 10:16
Membernassimnastaran29-Jun-14 10:16 
Questionexchange data between forms ? Pin
Member 245846728-Jun-14 22:10
MemberMember 245846728-Jun-14 22:10 
AnswerRe: exchange data between forms ? Pin
OriginalGriff28-Jun-14 22:19
mveOriginalGriff28-Jun-14 22:19 
GeneralRe: exchange data between forms ? Pin
Member 245846729-Jun-14 23:00
MemberMember 245846729-Jun-14 23:00 
GeneralRe: exchange data between forms ? Pin
OriginalGriff29-Jun-14 23:12
mveOriginalGriff29-Jun-14 23:12 

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.