Want to display the data in the table

Debasis Mohapatra

7y1kLearn iOS Programming

Please find the below code. My data is saved propelry ,now i want to display the data in the table.

[HttpPost]

public ActionResult Addmobile(Models.mobile mobile) //pass the model name as parameter

{

if (connection.State == ConnectionState.Open)

connection.Close();

connection.Open();

try

{

SqlCommand cmd = new SqlCommand("Mobile_ins",connection);

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.AddWithValue("@Mobile_brand",mobile.Mobile_brand);

cmd.Parameters.AddWithValue("@mobile_model", mobile.mobile_model);

cmd.Parameters.AddWithValue("@mobile_price", mobile.mobile_price);

cmd.Parameters.AddWithValue("@mobile_description", mobile.mobile_description);

cmd.Parameters.Add("@output", SqlDbType.Int, 0);

cmd.Parameters["@output"].Direction = ParameterDirection.Output;

cmd.ExecuteNonQuery();

ViewBag.Msg = "Thank You";

int i = Convert.ToInt32(cmd.Parameters["output"].Value);

if (i == 1)

{

string query = "select * from [dbo].[mobile]";

SqlDataAdapter dap = new SqlDataAdapter(query, connection);

DataTable dt = new DataTable();

dap.Fill(dt);

if (dt.Rows.Count > 0)

{

for (int x = 0; x < dt.Rows.Count; x++)

{

}

catch (Exception ex)

{

//throw;

}

finally

{

if (connection.State == ConnectionState.Open)

connection.Close();

}

return View("Mobile");

}

///////view code

Mobile_Brand	Mobile_Model	Mobile_Price	Mobile_Description

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Laxmidhar Sahoo7y ago
your code looks ok .But give break point and convey the point of err
0
Andra Chahar7y ago
There is a simple and quick way. To use Spire.Xls to import dataTable to a html file.
Workbook workbook = new Workbook();
Worksheet sheet = workbook.Worksheets[0];
sheet.InsertDataTable(dt, true, 1, 1);
sheet.SaveToHtml("sample.html");

http://www.nuget.org/packages/FreeSpire.XLS/
0
Debasis Mohapatra7y ago
Mr Reddy,

Yes , it's working

using SudentRegistration_MVC_Project.Models;

Model code

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
namespace SudentRegistration_MVC_Project.Models
{
public class mobile
{
public int id { get; set; }
public string Mobile_brand { get; set; }
public string mobile_model { get; set;}
public int mobile_price { get; set; }
public string mobile_description { get; set; }
public List MobileList { get; set; }
}
}

0
Sreekanth Reddy7y ago
Hi Debasis,

I think we can transfer model itself directly...
0
Jenith Thakkar7y ago
Welcome, if my answer was helpful for you then please kindly accept it.
+1
Debasis Mohapatra7y ago
Dear Laxmidhar,

Thank you for your reply.
Please find the below code.

It's a controller

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using System.Data;
using System.Configuration;
using System.Data.SqlClient;
using System.Reflection;
using SudentRegistration_MVC_Project.Models;
namespace SudentRegistration_MVC_Project.Controllers
{
public class MobileController : Controller
{
SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["aspnetdbConnectionString"].ConnectionString);

// GET: Mobile
public ActionResult Addmobile()//First change the name Of Action as u need, then Right click on the action name and add the view.Next Right click on the action name and go the view
{
mobile mobile = new mobile();

mobile.MobileList = getallmobile();

return View("mobile", mobile);
}
[HttpPost]
public ActionResult Addmobile(mobile mobile) //pass the model name as parameter
{
if (connection.State == ConnectionState.Open)
connection.Close();
connection.Open();

try
{
SqlCommand cmd = new SqlCommand("Mobile_ins",connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Mobile_brand",mobile.Mobile_brand);
cmd.Parameters.AddWithValue("@mobile_model", mobile.mobile_model);
cmd.Parameters.AddWithValue("@mobile_price", mobile.mobile_price);
cmd.Parameters.AddWithValue("@mobile_description", mobile.mobile_description);
cmd.Parameters.Add("@output", SqlDbType.Int, 0);
cmd.Parameters["@output"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
ViewBag.Msg = "Thank You";

}
catch (Exception ex)
{
//throw;
}
finally
{
if (connection.State == ConnectionState.Open)
connection.Close();
}
mobile.MobileList = getallmobile();
return View("Mobile",mobile);
}
private List getallmobile()
{
DataTable dt = new DataTable();
try
{
if (connection.State == ConnectionState.Open)
connection.Close();
connection.Open();
string query = "select * from [dbo].[mobile]";
SqlDataAdapter dap = new SqlDataAdapter(query, connection);
dap.Fill(dt);
}
catch (Exception ex)
{
//throw;
}
finally
{
if (connection.State == ConnectionState.Open)
connection.Close();
}

return ConvertDataTable(dt);
}
private static List ConvertDataTable(DataTable dt)
{
List data = new List();
foreach (DataRow row in dt.Rows)
{
T item = GetItem(row);
data.Add(item);
}
return data;
}
private static T GetItem(DataRow dr)
{
Type temp = typeof(T);
T obj = Activator.CreateInstance();
foreach (DataColumn column in dr.Table.Columns)
{
foreach (PropertyInfo pro in temp.GetProperties())
{
if (pro.Name == column.ColumnName)
pro.SetValue(obj, dr[column.ColumnName], null);
else
continue;
}
}
return obj;
}
}
}

0
Debasis Mohapatra7y ago
Thank You Jenith, i got your idea now it's working fine.
+1
Laxmidhar Sahoo7y ago
SqlDataAdapter dap = new SqlDataAdapter(query, connection);
Dataset ds = new Dataset();
dap.Fill(ds);
0
Jenith Thakkar7y ago
I can give you a hint to do this
-you need to store datatable to viewdata
-run viewdata loop in view code and bind all td's

for more details refer this link

https://www.c-sharpcorner.com/UploadFile/db2972/datatable-in-viewdata-sample-in-mvc-day-3/
https://stackoverflow.com/questions/18395085/foreach-loop-for-tables-in-mvc4
+1