Skip to main content

Converting DataTable to List

Calling from Controller

 public ActionResult Index()
        {
            //join use
            //change view model.
            String sql = "SELECT * FROM faculties ";
            db.List(sql);
            var dt = db.List(sql);
            var model = new Faculty().List(dt);
            return View(model);
        }

Add a method to class

List<Faculty> list = new List<Faculty>();
        public List<Faculty> List(DataTable dt)
        {

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                Faculty fac = new Faculty();
                fac.FacultyId = Convert.ToInt32(dt.Rows[i]["FacultyId"]);
                fac.Name = dt.Rows[i]["Name"].ToString();
                fac.Description = dt.Rows[i]["Description"].ToString();
                list.Add(fac);
            }
            return list;

        }

Comments

Popular posts from this blog

Using SqlDataAdapter to fill DataTable in c#

public DataTable List(string sql)         {             SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString);             SqlCommand cmd = new SqlCommand(sql, con);             DataTable dt = new DataTable();             SqlDataAdapter da = new SqlDataAdapter(cmd);             try             {                              con.Open();                 da.Fill(dt);             }             finally             {                 con.Close();          ...

Connection String in ASP.NET With SQL Server

Connection string can be placed in web.config file found in root directory of the application from .NET 3.5 onward. connection string can be specified with an xml tag  <connectionStrings>  inside  <configuration>  section of web.config file. < connectionStrings > < add name = "myConnectionString" connectionString = "Data Source=databaseServerName; database=database-name; uid=sqlUserName;password=sqlPassword; Integrated Security =True|false|SSPI (any one options) ; " providerName = " System.Data.SqlClient System.Data.SqlClient" /> </ connectionStrings > We can use local database server of SQL Server by using Data Source= (LocalDb)\MSSQLLocalDB we can attach a local database file to the app_data directory by using the property AttachDBFilename=|DataDirectory|\appDatabaseName.mdf in the connection string Connection String can be ...