我想在gridview中单独显示Faculty代码 [英] i want to display the Faculty code separtely in gridview
本文介绍了我想在gridview中单独显示Faculty代码的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
在excel记录中如下
星期一
会话
日期课程session1 session2
Sub Faculty Sub Faculty
18-Aug BTech1 A RJ B RK
BTech2 B SK C SV + MJ
19-Aug BTech4 i MJ j GS
BTech5 k RP l CB + RJ
我在Gridview中导出上述excel记录如下。
该代码如下
protected void btnimport_Click（ object sender，EventArgs e）
{
import（）;
}
private void import（）
{
string path = @ C：\ FACULTYT.xlsx
GvSch.DataSource = ImportExcelXLS（path，false）;
GvSch.DataBind（）;
GvSch .Visible = true;
}
public static DataSet ImportExcelXLS（ string FileName， bool hasHeaders）
{
string HDR = hasHeaders？ 是： 否;
string strConn;
if （FileName.Substring（FileName.LastIndexOf（' 。'））。ToLower（）== < span class =code-string>。xlsx）
strConn = Provider = Microsoft.ACE.OLEDB.12.0;数据源= + FileName + ;扩展属性= \ Excel 12.0; HDR = + HDR + ; IMEX = 0 \;
else
strConn = Provider = Microsoft.Jet.OLEDB.4.0; Data Source = + FileName + ;扩展属性= \Excel 8.0; HDR = + HDR + ; IMEX = 0 \< /跨度>;
DataSet output = new DataSet（）;
使用（OleDbConnection conn = new OleDbConnection（strConn））
{
conn.Open（）;
DataTable schemaTable = conn.GetOleDbSchemaTable（
OleDbSchemaGuid.Tables， new object [] { null ， null ， null ， TABLE}）;
foreach （DataRow schemaRow in schemaTable.Rows）
{
string sheet = schemaRow [ TABLE_NAME ]的ToString（）;
if （！sheet.EndsWith（ _））
{
try
{
OleDbCommand cmd = new OleDbCommand（ SELECT * FROM [ + sheet + ]，conn）;
cmd.CommandType = CommandType.Text;
DataTable outputTable = new DataTable（sheet）;
output.Tables.Add（outputTable）;
new OleDbDataAdapter（cmd）.Fill（outputTable）;
DataTable table = new DataTable（）;
table.Columns.Add（ Date， typeof （ string ））;
table.Columns.Add（ 课程， typeof （ string ））;
table.Columns.Add（ Session， typeof （ string ））;
table.Columns.Add（ 主题， typeof （ string ））;
table.Columns.Add（ Faculty， typeof （ string ））;
int irow = 0 ;
foreach （DataRow row in outputTable.Rows）
{
if （row [ 1 ]。ToString（）！= 课程&& row [ 1 ]。ToString（）！= < span class =code-string> && row [ 1 ] .ToString（）！= null ）
{
DataRow row1 = table.NewRow（）;
row1 [ 日期] = row [ 0 ]的ToString（）;
row1 [ 课程] = row [ 1 ]的ToString（）;
row1 [ 会话] = 1;
row1 [ 主题] = row [ 2 ]的ToString（）;
row1 [ Faculty] = row [ 3 ]的ToString（）;
if （row [ 2 ]！= && row [ 3 ]！= ）
table.Rows.Add（row1）;
row1 = table.NewRow（）;
row1 [ 日期] = row [ 0 ]的ToString（）;
row1 [ 课程] = row [ 1 ]的ToString（）;
row1 [ 会话] = 2;
row1 [ 主题] = row [ 4 ]的ToString（）;
row1 [ Faculty] = row [ 5 ]的ToString（）;
if （row [ 4 ]！= && row [ 5 ]！= ）
table.Rows.Add（row1）;
}
irow ++;
}
output.Tables.Clear（）;
output.Tables.Add（table）;
}
catch （例外情况）
{
throw new 异常（ex.Message + string .Format（ 工作表：{0} .File：F {1}，sheet，FileName），ex）;
}
最后
{
}
}
}
}
return 输出;
}
当我将上述excel记录输出到Gridview输出时如下
< pre lang =text>日期课程课程学科教师
18-Aug-14 BTech1 1 A RJ
BTech1 2 B RK
BTech2 1 B SK
BTech2 2 C SV + MJ
BTech4 1 I MJ
BTech4 2 J GS
BTech5 1 K RP
BTech5 2 L CB + RJ
但是在Gridview中我希望输出如下，如果教师专栏有多个教师，我想在gridview中单独显示。
gridview中的
如果教师专栏有更多的教师，我希望输出如下。
日期课程会话主题t教师
18-Aug-14 BTech1 1 A RJ
BTech1 2 B RK
BTech2 1 B SK
BTech2 2 C SV
BTech2 2 C MJ
BTech4 1 I MJ
BTech4 2 J GS
BTech5 1 K RP
BTech5 2 L CB
BTech5 2 L RJ
$ b从我的代码$ b我犯了什么错误请帮助我，
问候，
Narasiman P.
解决方案
在将教师分配到第1行[教师]时检查该行[3]& row [5]不等于null并且包含'+'或者不包含'+'然后用'+'符号拆分并向表中添加新行。
代码看起来像
if（row [3] .ToString（）。contains（+））
{
string [] str = row [3] .ToString（）。split（'+'）;
for（int I = 0; i< str.count; i ++）>
{
row1 [ 课程] = row [ 1 ]。ToString（）;
row1 [ 会话] = 1;
row1 [ 主题] = row [ 2 ]的ToString（）;
row1 [ Faculty] = str [I];
}
}
else
{
< pre lang = cs > row1 [& quot; Course& quot;] = row [1] .ToString（）;
row1 [& quot; Session& quot;] =& quot; 1& quot ;;
row1 [& quot; Subject& quot;] = row [2] .ToString（）;
row1 [Faculty] = row [3] .ToString（）;
}
In excel record as follows
Monday
Sessions
Date course session1 session2
Sub Faculty Sub Faculty
18-Aug BTech1 A RJ B RK
BTech2 B SK C SV+MJ
19-Aug BTech4 i MJ j GS
BTech5 k RP l CB+RJ
I am exporting the above excel records in Gridview as follows.
for that code as follows
protected void btnimport_Click(object sender, EventArgs e)
{
import();
}
private void import()
{
string path = @"C:\FACULTYT.xlsx
GvSch.DataSource = ImportExcelXLS(path, false);
GvSch.DataBind();
GvSch.Visible = true;
}
public static DataSet ImportExcelXLS(string FileName, bool hasHeaders)
{
string HDR = hasHeaders ? "Yes" : "No";
string strConn;
if (FileName.Substring(FileName.LastIndexOf('.')).ToLower() == ".xlsx")
strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + FileName + ";Extended Properties=\"Excel 12.0;HDR=" + HDR + ";IMEX=0\"";
else
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + FileName + ";Extended Properties=\"Excel 8.0;HDR=" + HDR + ";IMEX=0\"";
DataSet output = new DataSet();
using (OleDbConnection conn = new OleDbConnection(strConn))
{
conn.Open();
DataTable schemaTable = conn.GetOleDbSchemaTable(
OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
foreach (DataRow schemaRow in schemaTable.Rows)
{
string sheet = schemaRow["TABLE_NAME"].ToString();
if (!sheet.EndsWith("_"))
{
try
{
OleDbCommand cmd = new OleDbCommand("SELECT * FROM [" + sheet + "]", conn);
cmd.CommandType = CommandType.Text;
DataTable outputTable = new DataTable(sheet);
output.Tables.Add(outputTable);
new OleDbDataAdapter(cmd).Fill(outputTable);
DataTable table = new DataTable();
table.Columns.Add("Date", typeof(string));
table.Columns.Add("Course", typeof(string));
table.Columns.Add("Session", typeof(string));
table.Columns.Add("Subject", typeof(string));
table.Columns.Add("Faculty", typeof(string));
int irow = 0;
foreach (DataRow row in outputTable.Rows)
{
if (row[1].ToString() != "Course" && row[1].ToString() != "" && row[1].ToString() != null)
{
DataRow row1 = table.NewRow();
row1["Date"] = row[0].ToString();
row1["Course"] = row[1].ToString();
row1["Session"] = "1";
row1["Subject"] = row[2].ToString();
row1["Faculty"] = row[3].ToString();
if (row[2] != "" && row[3] != "")
table.Rows.Add(row1);
row1 = table.NewRow();
row1["Date"] = row[0].ToString();
row1["Course"] = row[1].ToString();
row1["Session"] = "2";
row1["Subject"] = row[4].ToString();
row1["Faculty"] = row[5].ToString();
if (row[4] != "" && row[5] != "")
table.Rows.Add(row1);
}
irow++;
}
output.Tables.Clear();
output.Tables.Add(table);
}
catch (Exception ex)
{
throw new Exception(ex.Message + string.Format("Sheet:{0}.File:F{1}", sheet, FileName), ex);
}
finally
{
}
}
}
}
return output;
}
When i export the above excel record in to Gridview output as follows
Date Course Session Subject Faculty
18-Aug-14 BTech1 1 A RJ
BTech1 2 B RK
BTech2 1 B SK
BTech2 2 C SV+MJ
BTech4 1 I MJ
BTech4 2 J GS
BTech5 1 K RP
BTech5 2 L CB+RJ
But in Gridview i want the output as follows, if faculty column have more than one faculty i want to display separtely in gridview.
in gridview i want output as follows, if faculty column have more that one faculty.
Date Course Session Subject Faculty
18-Aug-14 BTech1 1 A RJ
BTech1 2 B RK
BTech2 1 B SK
BTech2 2 C SV
BTech2 2 C MJ
BTech4 1 I MJ
BTech4 2 J GS
BTech5 1 K RP
BTech5 2 L CB
BTech5 2 L RJ
from my code what is the mistake i made please help me,
Regards,
Narasiman P.
解决方案
at the time of assigning Faculty to row1["Faculty"] check that row[3] & row[5] not equal to null and contains '+' or not if contains '+' then split with '+' symbol and add new row to the table.
code looks like
if(row[3].ToString().contains("+"))
{
string[] str=row[3].ToString().split('+');
for(int I=0;i<str.count;i++)>
{
row1["Course"] = row[1].ToString(); row1["Session"] = "1"; row1["Subject"] = row[2].ToString(); row1["Faculty"] =str[I];
}
}
else
{
<pre lang="cs">row1["Course"] = row[1].ToString(); row1["Session"] = "1"; row1["Subject"] = row[2].ToString(); row1["Faculty"] = row[3].ToString();
}
这篇关于我想在gridview中单独显示Faculty代码的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
