如何在不使用模型的情况下将数据集值绑定到MVC中的Webgrid? [英] How to bind the dataset value to a Webgrid in MVC without using a model?
问题描述
我有一个类似下面的Controller代码。我没有使用模型,我希望将数据集值绑定到MVC中的webgrid
string strFileType = Path.GetExtension (file.FileName)。ToLower();
var fileName = Path.GetFileName(file.FileName);
var path = Path.Combine(Server.MapPath( 〜/ Content / Upload),fileName);
file.SaveAs(path);
string connString =;
if(strFileType.Trim()==。xls)
{
connString =Provider = Microsoft.Jet.OLEDB.4.0;数据源=+路径+;扩展属性= \Excel 8.0; HDR =是; IMEX = 2 \;
}
否则if( strFileType.Trim()==。xlsx)
{
connString =Pro vider = Microsoft.ACE.OLEDB.12.0;数据源=+路径+;扩展属性= \Excel 12.0; HDR =是; IMEX = 2 \;
}
string query =SELECT [id],[Name],[Marks],[Grade] FROM [Sheet1 $];
OleDbConnection conn = new OleDbConnection(connString) ;
if(conn.State == ConnectionState.Closed)
conn.Open();
OleDbCommand cmd = new OleDbCommand(查询, conn);
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds) ;
我希望数据集对象中的值显示为webgrid。
;
OleDbConnection conn = new OleDbConnecti on(connString);
if(conn.State == ConnectionState.Closed)
conn.Open();
OleDbCommand cmd = new OleDbCommand(query,conn);
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
DataSet ds = new DataSet();
da。填充(ds);
我希望数据集对象中的值显示为webgrid
I have a Controller code something like below. I haven't used a model and I wish to bind the dataset value to a webgrid in MVC
string strFileType = Path.GetExtension(file.FileName).ToLower();
var fileName = Path.GetFileName(file.FileName);
var path = Path.Combine(Server.MapPath("~/Content/Upload"), fileName);
file.SaveAs(path);
string connString = "";
if (strFileType.Trim() == ".xls")
{
connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=2\"";
}
else if (strFileType.Trim() == ".xlsx")
{
connString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + ";Extended Properties=\"Excel 12.0;HDR=Yes;IMEX=2\"";
}
string query = "SELECT [id],[Name],[Marks],[Grade] FROM [Sheet1$]";
OleDbConnection conn = new OleDbConnection(connString);
if (conn.State == ConnectionState.Closed)
conn.Open();
OleDbCommand cmd = new OleDbCommand(query, conn);
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
I want the value in the dataset object to be displayed as webgrid.
";
OleDbConnection conn = new OleDbConnection(connString);
if (conn.State == ConnectionState.Closed)
conn.Open();
OleDbCommand cmd = new OleDbCommand(query, conn);
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
I want the value in the dataset object to be displayed as webgrid.
这篇关于如何在不使用模型的情况下将数据集值绑定到MVC中的Webgrid?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!