Click here to Skip to main content
15,114,611 members
Home / Discussions / C#
   

C#

 
GeneralRe: Customizing Solid Edge Pin
Pete O'Hanlon3-Sep-13 3:11
mvePete O'Hanlon3-Sep-13 3:11 
GeneralRe: Customizing Solid Edge Pin
rani21073-Sep-13 3:25
Memberrani21073-Sep-13 3:25 
GeneralRe: Customizing Solid Edge Pin
Dave Kreskowiak3-Sep-13 4:38
mveDave Kreskowiak3-Sep-13 4:38 
GeneralRe: Customizing Solid Edge Pin
Rohini Shirke3-Sep-13 19:19
MemberRohini Shirke3-Sep-13 19:19 
GeneralRe: Customizing Solid Edge Pin
Dave Kreskowiak4-Sep-13 2:09
mveDave Kreskowiak4-Sep-13 2:09 
AnswerRe: Customizing Solid Edge Pin
Abhinav S2-Sep-13 23:51
MemberAbhinav S2-Sep-13 23:51 
GeneralRe: Customizing Solid Edge Pin
rani21073-Sep-13 3:07
Memberrani21073-Sep-13 3:07 
QuestionSqlDataReader is not returning all rows Pin
NarVish2-Sep-13 1:57
MemberNarVish2-Sep-13 1:57 
My SQL command returns 3 rows which is verified in a SQL GUI. I run the same code and SqlDataReader returns only 2 of them. The same sql command returns 3 rows with SqlDataAdapter. Here is my code.
ds has 3 rows.


using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["VPO"].ConnectionString))
        {
            string sql="SELECT DISTINCT A.account_id, A.fname, A.lname, 
            FROM T_Test1 A WITH (NOLOCK) JOIN T_Test2 AF WITH (NOLOCK) ON A.Account_id=AF.Account_id
            WHERE account_status = 'A' AND A.card IS NOT NULL
            AND A.dateFrom >= '09-02-2013 00:00:00' AND A.dateFrom <= '09-30-2013 00:00:00' AND  AF.code = 'INE'";
            SqlCommand command = new SqlCommand(sql.ToString(), connection);
            command.CommandTimeout = 3600;
            connection.Open();
            using (SqlDataReader reader = command.ExecuteReader())
            { 
               while (reader.Read())
               {}
            }
            DataSet ds = new DataSet();
            SqlDataAdapter da = new SqlDataAdapter(command.CommandText, connection);
            da.Fill(ds);
        }

AnswerRe: SqlDataReader is not returning all rows Pin
Simon_Whale2-Sep-13 2:08
professionalSimon_Whale2-Sep-13 2:08 
GeneralRe: SqlDataReader is not returning all rows Pin
NarVish2-Sep-13 2:37
MemberNarVish2-Sep-13 2:37 
AnswerRe: SqlDataReader is not returning all rows Pin
Simon_Whale2-Sep-13 4:11
professionalSimon_Whale2-Sep-13 4:11 
GeneralRe: SqlDataReader is not returning all rows Pin
NarVish2-Sep-13 6:35
MemberNarVish2-Sep-13 6:35 
AnswerRe: SqlDataReader is not returning all rows Pin
OriginalGriff2-Sep-13 4:46
mveOriginalGriff2-Sep-13 4:46 
GeneralRe: SqlDataReader is not returning all rows Pin
NarVish2-Sep-13 6:36
MemberNarVish2-Sep-13 6:36 
GeneralRe: SqlDataReader is not returning all rows Pin
OriginalGriff2-Sep-13 9:04
mveOriginalGriff2-Sep-13 9:04 
AnswerRe: SqlDataReader is not returning all rows Pin
Eddy Vluggen2-Sep-13 7:23
professionalEddy Vluggen2-Sep-13 7:23 
GeneralRe: SqlDataReader is not returning all rows Pin
Manfred Rudolf Bihy2-Sep-13 9:42
professionalManfred Rudolf Bihy2-Sep-13 9:42 
AnswerRe: SqlDataReader is not returning all rows Pin
Pete O'Hanlon2-Sep-13 9:45
mvePete O'Hanlon2-Sep-13 9:45 
GeneralRe: SqlDataReader is not returning all rows Pin
NarVish2-Sep-13 20:40
MemberNarVish2-Sep-13 20:40 
GeneralRe: SqlDataReader is not returning all rows Pin
Pete O'Hanlon2-Sep-13 21:22
mvePete O'Hanlon2-Sep-13 21:22 
QuestionQuestion about using an if in a string Pin
skeeterz711-Sep-13 18:35
Memberskeeterz711-Sep-13 18:35 
AnswerRe: Question about using an if in a string Pin
Dave Kreskowiak1-Sep-13 19:05
mveDave Kreskowiak1-Sep-13 19:05 
GeneralRe: Question about using an if in a string Pin
skeeterz711-Sep-13 19:31
Memberskeeterz711-Sep-13 19:31 
GeneralRe: Question about using an if in a string Pin
Dave Kreskowiak1-Sep-13 19:37
mveDave Kreskowiak1-Sep-13 19:37 
GeneralRe: Question about using an if in a string Pin
skeeterz711-Sep-13 19:46
Memberskeeterz711-Sep-13 19:46 

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.