This is way of Reading data from ado.net.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 |
String username = ""; String query = string.Format(@"select * from user where username=@username"); string connectionString =ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; List<ActivationAnaylysis> activationAnaylysises = new List<ActivationAnaylysis>(); using (var connection = new SqlConnection(connectionString)) { connection.Open(); SqlCommand command = new SqlCommand(); //com.CommandType = CommandType.StoredProcedure; command.CommandText = query; command.CommandTimeout = 600; command.Parameters.AddWithValue("@username", "akash"); command.Connection = connection; //command.ExecuteNonQuery() //for insert/Update/Delete DataTable dt=new DataTable(); SqlDataAdapter adapter = new SqlDataAdapter(command); adapter.SelectCommand.CommandTimeout = 600; adapter.Fill(dt); // SqlDataReader reader = command.ExecuteReader(); foreach (DataRow reader in dt.Rows) { //While(reader.Read()) ActivationAnaylysis anaylysis = new ActivationAnaylysis { InvoicePrice = Convert.ToDecimal(reader["InvoicePrice"]), TotalQty = Convert.ToDecimal(reader["TotalQty"]), DealerCode = Convert.ToString(reader["DealerCode"]), DealerName = Convert.ToString(reader["DealerName"]), DealerType = Convert.ToString(reader["DealerType"]), Division = Convert.ToString(reader["Division"]), Model = Convert.ToString(reader["Model"]), ZoneName = Convert.ToString(reader["ZoneName"]), }; anaylysis.Total = anaylysis.TotalQty*anaylysis.InvoicePrice; activationAnaylysises.Add(anaylysis); } } |