|
[x]
Posted via EE Mobile
|
||
Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again. |
||
| Question |
|
[x]
Attachment Details
|
||
|
[x]
The Solution Rating System
|
||
With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.
Your Input Matters If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support. Thank you! |
||
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: 43: 44: 45: 46: 47: 48: 49: 50: 51: 52: 53: 54: 55: 56: 57: 58: 59: 60: 61: 62: 63: 64: 65: 66: 67: 68: 69: 70: 71: 72: 73: 74: 75: 76: 77: 78: 79: 80: 81: 82: 83: 84: 85: 86: 87: 88: 89: 90: 91: 92: 93: 94: 95: 96: 97: 98: 99: 100: 101: 102: 103: 104: 105: 106: 107: 108: 109: 110: 111: 112: 113: 114: 115: 116: 117: 118: 119: 120: 121: 122: 123: 124: 125: 126: 127: 128: 129: 130: 131: 132: 133: 134: 135: 136: 137: 138: 139: 140: 141: 142: 143: 144: 145: 146: 147: 148: 149: 150: 151: 152: 153: 154: 155: 156: 157: 158: 159: 160: 161: 162: 163: 164: 165: 166: 167: 168: 169: 170: 171: 172: 173: 174: 175: 176: 177: 178: 179: 180: 181: 182: 183: 184: 185: 186: 187: 188: 189: 190: 191: 192: 193: 194: 195: 196: 197: 198: 199: 200: 201: 202: 203: 204: 205: 206: 207: 208: 209: 210: 211: 212: 213: 214: 215: 216: 217: 218: 219: 220: 221: 222: 223: 224: 225: 226: 227: 228: 229: 230: 231: 232: 233: 234: 235: 236: 237: 238: 239: 240: 241: 242: 243: 244: 245: 246: 247: 248: 249: 250: 251: 252: 253: 254: 255: 256: 257: 258: 259: 260: 261: 262: 263: 264: 265: 266: 267: 268: 269: 270: 271: 272: 273: 274: 275: 276: 277: 278: 279: 280: 281: 282: 283: 284: 285: 286: 287: 288: 289: 290: 291: 292: 293: 294: 295: 296: 297: 298: 299: 300: 301: 302: 303: 304: 305: 306: 307: 308: 309: 310: 311: 312: 313: 314: 315: 316: 317: 318: 319: 320: 321: 322: 323: 324: 325: 326: 327: 328: 329: 330: 331: 332: 333: 334: 335: 336: 337: 338: 339: 340: 341: 342: 343: 344: 345: 346: 347: 348: 349: 350: 351: 352: 353: 354: 355: 356: 357: 358: 359: 360: 361: 362: 363: 364: 365: 366: 367: 368: 369: 370: 371: 372: 373: 374: 375: 376: 377: 378: 379: 380: 381: 382: 383: 384: 385: 386: 387: 388: 389: 390: 391: 392: 393: 394: 395: 396: 397: 398: 399: 400: 401: 402: 403: 404: 405: 406: 407: 408: 409: 410: 411: 412: 413: 414: 415: 416: 417: 418: 419: |
<%@ Control Language="C#" AutoEventWireup="true" CodeFile="seznam_test.ascx.cs" Inherits="test_seznam_test" %>
<br /><br />
<b>Natisni seznam >>></b> <asp:ImageButton runat="server" ID="imgButtList" ImageUrl="~/ikone/icon_Excel2007.gif" OnClick="imgButtEx_Click" /> <asp:ImageButton runat="server" ID="ImageButtWord" ImageUrl="~/ikone/icon_Word2007.gif" OnClick="imgButtWo_Click" />
<br /><br /><br />
<asp:GridView ID="GridView1" runat="server" DataSourceID="sqlDataSource1" AutoGenerateColumns="false" CssClass="headertable" DataKeyNames="ID" >
<%--http://miha.ef.uni-lj.si/admin/govorilne/izpisPregleda.asp--%>
<%--Style="border-color: #cccccc; border-width:2px; border-bottom-style:solid;"--%>
<HeaderStyle CssClass="headertr"/>
<RowStyle CssClass="itemtemplate2" />
<%--<SelectedRowStyle CssClass="selectedrowcolor" />--%>
<Columns>
<%--<asp:BoundField Visible="false" SortExpression="ID" DataField="ID" />--%>
<asp:TemplateField HeaderText="Priimek in ime" SortExpression="priimek" >
<ItemTemplate>
<asp:Label runat="server" ID="lblSodelavec" Font-Size="11px" Text='<%#"<b>" + Eval("priimek").ToString() + " " + Eval("ime").ToString()+ "</b>" + " " + Eval("izobrazba").ToString() %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Prostor" SortExpression="prostor">
<ItemTemplate>
<asp:Label runat="server" ID="lblProstor" Text='<%#Eval("prostor") %>' Font-Size="11px"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Dan" SortExpression="gudan">
<ItemTemplate>
<asp:Label ID="lblDan" runat="server" Font-Size="11px" Text='<%# govorilneure.dansprememba(Eval("gudan")) %> '></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Ura" SortExpression="guura">
<ItemTemplate>
<asp:Label runat="server" ID="lblUra" Font-Size="11px" Text='<%#Eval("guura", "{0:t}")%>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Opomba" SortExpression="guopomba">
<ItemTemplate>
<asp:Label Font-Size="11px" runat="server" ID="lblOpomba" Text='<%#Eval("guopomba") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField ShowHeader="True" HeaderText="P" >
<ItemTemplate>
<%--<asp:ImageButton ImageAlign="Middle" ID="LinkButtonToggleDefaultChecked" SkinID="iconCheckedDisabled" runat="server" BackColor="white" CausesValidation="False"
visible='<%# (bool) Eval("guspr") %>' CommandName="ToggleDefault" ForeColor="black" Enabled="false" />
<asp:ImageButton ImageAlign="Middle" ID="LinkButtonToggleDefaultUnChecked" SkinID="iconUnCheckedDisabled" runat="server" BackColor="white" CausesValidation="False"
visible='<%# !(bool) Eval("guspr") %>' CommandName="ToggleDefault" ForeColor="black" Enabled="false" />
--%>
<asp:CheckBox runat="server" ID="chckBoxGS" Enabled="false" Checked='<%# (bool) Eval("guspr") %>' Visible='<%# (bool) Eval("guspr") %>' />
<asp:Image runat="server" ID="imgGuSpr" ImageUrl='~/ikone/je.gif' Visible='<%# (bool) Eval("guspr") %>' />
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
<asp:SqlDataSource runat="server" ID="sqlDataSource1" ConnectionString="<%$ ConnectionStrings:Conn %>"
SelectCommand="ISELECT" SelectCommandType="StoredProcedure">
</asp:SqlDataSource>
<br /><br /><br />
c# code
protected void imgButtEx_Click(object sender, EventArgs e)
{
//this.GridView1.Columns[2].Visible = false;
GridView1.AllowPaging = false;
//GridView1.Columns.RemoveAt(0);
//GridView1.Columns.Add("priimek");
//GridView1.Columns.RemoveAt(5);
GridView1.DataBind();
govorilneure.PrepareControlForExport(GridView1);
govorilneure.Export2("Govorilneure.xls", GridView1);
}
protected void imgButtWo_Click(object sender, EventArgs e)
{
Control control;
//this.GridView1.Columns[2].Visible = false;
GridView1.AllowPaging = false;
//GridView1.Columns.RemoveAt(0);
//GridView1.Columns.Add("priimek");
//GridView1.Columns.RemoveAt(5);
GridView1.DataBind();
govorilneure.PrepareControlForExport(GridView1);
//for (int i = 0; i < control.Controls.Count; i++)
//{
// Control current = control.Controls[i];
// if (current is CheckBox)
// {
// control.Controls.Remove(current);
// control.Controls.AddAt(i, new LiteralControl((current as CheckBox).Checked ? "~/ikone/je.gif" : " "));
// //control.Controls.AddAt(i, new LiteralControl((current as CheckBox).ApplyStyle =
// }
// //if (current.HasControls())
// //{
// // govorilneure.PrepareControlForExport(current);
// //}
//}
govorilneure.Export4Word("Govorilneure.doc", GridView1);
}
class:
#region priprava kontrole (ex GridViewExportutil)
//public class GridViewExportUtil
//{
/// <summary>
/// Replace any of the contained controls with literals
/// </summary>
#region priprava kontrole v plain text
public static void PrepareControlForExport(Control control)
{
//as namesto is ; as vrne null, is pa ne
for (int i = 0; i < control.Controls.Count; i++)
{
Control current = control.Controls[i];
if (current is LinkButton)
{
control.Controls.Remove(current);
control.Controls.AddAt(i, new LiteralControl((current as LinkButton).Text));
}
else if (current is ImageButton)
{
//je.gif
//ImageUrl="~/ikone/je.gif"
//"~/ikone/je.gif
control.Controls.Remove(current);
control.Controls.AddAt(i, new LiteralControl((current as ImageButton).AlternateText));
}
else if (current is HyperLink)
{
control.Controls.Remove(current);
control.Controls.AddAt(i, new LiteralControl((current as HyperLink).Text));
}
else if (current is TextBox)
{
control.Controls.Remove(current);
control.Controls.AddAt(i, new LiteralControl((current as TextBox).Text));
}
else if (current is DropDownList)
{
control.Controls.Remove(current);
control.Controls.AddAt(i, new LiteralControl((current as DropDownList).SelectedItem.Text));
}
else if (current is HiddenField)
{
control.Controls.Remove(current);
}
else if (current is CheckBox)
{
control.Controls.Remove(current);
control.Controls.AddAt(i, new LiteralControl((current as CheckBox).Checked ? "~/ikone/je.gif" : " "));
//control.Controls.AddAt(i, new LiteralControl((current as CheckBox).ApplyStyle =
//? "True" : "False";
}
if (current.HasControls())
{
govorilneure.PrepareControlForExport(current);
}
}
}
public static void Export4Word (string fileName, Control gv)
{
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.Buffer = true;
HttpContext.Current.Response.AddHeader(
"content-disposition", string.Format("attachment; filename={0}", fileName));
HttpContext.Current.Response.ContentType = "application/vnd.ms-word";
HttpContext.Current.Response.Charset = "";
HttpContext.Current.Response.Write("\r\n");
HttpContext.Current.Response.Write("<html ");
HttpContext.Current.Response.Write("xmlns:o='urn:schemas-microsoft-com:office:office' ");
HttpContext.Current.Response.Write("xmlns:w='urn:schemas-microsoft-com:office:word' ");
HttpContext.Current.Response.Write("xmlns='http://www.w3.org/TR/REC-html40'>");
HttpContext.Current.Response.Write("<head>");
HttpContext.Current.Response.Write("<!--[if gte mso 9]> <xml> <w:WordDocument> <w:View>Print</w:View> <w:Zoom>100</w:Zoom> <w:DoNotOptimizeForBrowser/> </w:WordDocument> </xml> <![endif]-->");
HttpContext.Current.Response.Write("<META HTTP-EQUIV='Content-Type' CONTENT='text/html; charset=windows-1250'>");
HttpContext.Current.Response.Write("<meta name=ProgId content=Word.Document>");
HttpContext.Current.Response.Write("<meta name=Generator content='Microsoft Word 9'>");
HttpContext.Current.Response.Write("<meta name=Originator content='Microsoft Word 9'>");
//HttpContext.Current.Response.Write("<style>");
//HttpContext.Current.Response.Write("p.MsoFooter, li.MsoFooter, div.MsoFooter{margin:0in;margin-bottom:.0001pt;mso-pagination:widow-orphan;tab-stops:center 3.0in right6.0in;font-size:8.0pt;}");
//HttpContext.Current.Response.Write("p.MsoHeader, li.MsoHeader, div.MsoHeader{margin:0in;margin-bottom:.0001pt;mso-pagination:widow-orphan;tab-stops:center 3.0in right6.0in;font-size:8.0pt;}");
//HttpContext.Current.Response.Write("@page Section {margin:1.0in 1.0in 1.0in 1.0in;mso-header-margin:.5in;mso-footer-margin:.5in;mso-footer: f1;mso-header: h1;mso-paper-source:0;}");
//HttpContext.Current.Response.Write("div.Section {page:Section;}");
//HttpContext.Current.Response.Write("</style>");
HttpContext.Current.Response.Write("</head>");
HttpContext.Current.Response.Write("<body>");
//vsebina dokumenta word (izvo~ena kontrola)
HttpContext.Current.Response.Write("<div>");
//HttpContext.Current.Response.Write("<h4><span style=" + "'color:#BF1428;'><b>" + naslov + " ");
//if (vrstaaplikacije == 2)
//{
// HttpContext.Current.Response.Write(StLetoMesec.StudijskoLeto.DolociStLeto_NacPO_String());
//}
HttpContext.Current.Response.Write("</b></span></h4>");
//HttpContext.Current.Response.Write("<span style=" + "'color:red;'><i>" + opomba + "</i></span>");
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
gv.RenderControl(oHtmlTextWriter);
HttpContext.Current.Response.Write(oStringWriter.ToString());
HttpContext.Current.Response.Write("</div>");
////Header
//HttpContext.Current.Response.Write("<div style='mso-element:header;' id=h1><p class=MsoHeader style='text-align:left;'><span style='mso-tab-count:1'></span>" + DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString() + "");
//HttpContext.Current.Response.Write("<span style='mso-tab-count:16'></span>Stran <span style='mso-field-code:\" PAGE \"'></span> od <span style='mso-field-code:\" NUMPAGES \"'></span></p></div>");
////Footer
//HttpContext.Current.Response.Write("<div style='mso-element:footer;' id=f1><p class=MsoFooter style='text-align:center;'>Copyright © 1997-2008 EF WebTeam. Vse pravice pridr~ane.</p></div>");
//HttpContext.Current.Response.Write("</body>");
HttpContext.Current.Response.Write("</html>");
HttpContext.Current.Response.Flush();
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.End();
}
#endregion
//}
#region Export druga verzija
public static void Export(string fileName, GridView gv)
{
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.AddHeader(
"content-disposition", string.Format("attachment; filename={0}", fileName));
HttpContext.Current.Response.ContentType = "application/ms-excel";
// Response.ContentEncoding = System.Text.Encoding.Default;
//HttpContext.Current.Response.Charset = "UTF7";
//HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.Default;
using (StringWriter sw = new StringWriter())
{
using (HtmlTextWriter htw = new HtmlTextWriter(sw))
{
// Create a table to contain the grid
Table table = new Table();
// include the gridline settings
table.GridLines = gv.GridLines;
// add the header row to the table
if (gv.HeaderRow != null)
{
govorilneure.PrepareControlForExport(gv.HeaderRow);
table.Rows.Add(gv.HeaderRow);
}
// add each of the data rows to the table
foreach (GridViewRow row in gv.Rows)
{
govorilneure.PrepareControlForExport(row);
table.Rows.Add(row);
//table.Rows.Remove[1];
}
// add the footer row to the table
if (gv.FooterRow != null)
{
govorilneure.PrepareControlForExport(gv.FooterRow);
table.Rows.Add(gv.FooterRow);
}
// render the table into the htmlwriter
table.RenderControl(htw);
// render the htmlwriter into the response
HttpContext.Current.Response.Write(sw.ToString());
HttpContext.Current.Response.End();
}
}
}
#endregion
#region koda za export v excel dokument verzija 2
public static void Export2(string fileName, GridView gv)
{
string studijskoleto = DateTime.Now.Year.ToString();
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.AddHeader(
"content-disposition", string.Format("attachment; filename={0}", fileName));
HttpContext.Current.Response.ContentType = "application/ms-excel";
HttpContext.Current.Response.Charset = "utf-8";
HttpContext.Current.Response.Write("<meta http-equiv=Content-Type content=\"text/html; charset=windows-1250\">\n");
HttpContext.Current.Response.Write("<html xmlns:o='urn:schemas-microsoft-com:office:office'\n" +
"xmlns:x='urn:schemas-microsoft-com:office:excel'\n" +
"xmlns='http://www.w3.org/TR/REC-html40'>\n" +
"<head>\n");
HttpContext.Current.Response.Write("<style>\n");
HttpContext.Current.Response.Write(@".number {mso-number-format:0\.00;}\n");
HttpContext.Current.Response.Write("@page");
HttpContext.Current.Response.Write("{margin:1.0in 1.0in 1.0in 1.0in;\n");
HttpContext.Current.Response.Write("mso-header-margin:.5in;\n");
HttpContext.Current.Response.Write("mso-footer-margin:.5in;\n");
HttpContext.Current.Response.Write("mso-header-data:'&L &D &T&RStran &P od &N';");
//<%Response.Write(DateTime.Now.Year); %>
HttpContext.Current.Response.Write("mso-footer-data:'Copyright © 1997-" + studijskoleto + " EF WebTeam. Vse pravice pridr~ane.';");
HttpContext.Current.Response.Write("mso-page-orientation:portrait;}\n");
HttpContext.Current.Response.Write("</style>\n");
HttpContext.Current.Response.Write("<!--[if gte mso 9]><xml>\n");
HttpContext.Current.Response.Write("<x:ExcelWorkbook>\n");
HttpContext.Current.Response.Write("<x:ExcelWorksheets>\n");
HttpContext.Current.Response.Write("<x:ExcelWorksheet>\n");
HttpContext.Current.Response.Write("<x:Name>Sheet 1</x:Name>\n");
HttpContext.Current.Response.Write("<x:WorksheetOptions>\n");
//spravi vse podatke na eno stran!!!
//HttpContext.Current.Response.Write("<x:FitToPage/>");
HttpContext.Current.Response.Write("<x:Print>\n");
HttpContext.Current.Response.Write("<x:ValidPrinterInfo/>\n");
//HttpContext.Current.Response.Write("<x:FitHeight>" + maxdolzinatisk + "</x:FitHeight>");
//HttpContext.Current.Response.Write("<x:FitWidth>" + maxsirinatisk + "</x:FitWidth>");
HttpContext.Current.Response.Write("<x:PaperSizeIndex>9</x:PaperSizeIndex>\n");
HttpContext.Current.Response.Write("<x:HorizontalResolution>600</x:HorizontalResolution\n");
HttpContext.Current.Response.Write("<x:VerticalResolution>600</x:VerticalResolution\n");
HttpContext.Current.Response.Write("</x:Print>\n");
HttpContext.Current.Response.Write("<x:Selected/>\n");
HttpContext.Current.Response.Write("<x:DoNotDisplayGridlines/>\n");
HttpContext.Current.Response.Write("<x:ProtectContents>False</x:ProtectContents>\n");
HttpContext.Current.Response.Write("<x:ProtectObjects>False</x:ProtectObjects>\n");
HttpContext.Current.Response.Write("<x:ProtectScenarios>False</x:ProtectScenarios>\n");
HttpContext.Current.Response.Write("</x:WorksheetOptions>\n");
HttpContext.Current.Response.Write("</x:ExcelWorksheet>\n");
HttpContext.Current.Response.Write("</x:ExcelWorksheets>\n");
HttpContext.Current.Response.Write("<x:WindowHeight>12780</x:WindowHeight>\n");
HttpContext.Current.Response.Write("<x:WindowWidth>19035</x:WindowWidth>\n");
HttpContext.Current.Response.Write("<x:WindowTopX>0</x:WindowTopX>\n");
HttpContext.Current.Response.Write("<x:WindowTopY>15</x:WindowTopY>\n");
HttpContext.Current.Response.Write("<x:ProtectStructure>False</x:ProtectStructure>\n");
HttpContext.Current.Response.Write("<x:ProtectWindows>False</x:ProtectWindows>\n");
HttpContext.Current.Response.Write("</x:ExcelWorkbook>\n");
HttpContext.Current.Response.Write("</xml><![endif]-->\n");
HttpContext.Current.Response.Write("</head>\n");
HttpContext.Current.Response.Write("<body>\n");
//HttpContext.Current.Response.Write("<h4><span style=" + "'color:#BF1428;'><b>" + naslov + " ");
//if (vrstaaplikacije == 2)
//{
// HttpContext.Current.Response.Write(StLetoMesec.StudijskoLeto.DolociStLeto_NacPO_String());
//}
//HttpContext.Current.Response.Write("</b></span></h4>");
//HttpContext.Current.Response.Write("<span style=" + "'color:red;'><i>" + opomba + "</i></span>");
//render the htmlwriter into the response
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
gv.RenderControl(oHtmlTextWriter);
HttpContext.Current.Response.Write(oStringWriter.ToString());
HttpContext.Current.Response.Write("</body>");
HttpContext.Current.Response.Write("</html>");
HttpContext.Current.Response.End();
}
|
Advertisement
| Hall of Fame |