|
An easy way would be to use the AjaxControlToolkit HtmlEditor[^]. Save the resultant data to the database and view back in the editor or a label as required. You'll need to encode the data (see here to get started: HttpServerUtility..::.HtmlEncode[^]. You can display the data by reversing the process.Tychotics: take us back to the moon
"Life, for ever dying to be born afresh, for ever young and eager, will presently stand upon this earth as upon a footstool, and stretch out its realm amidst the stars."
H. G. Wells
|
|
|
|
|
| Thank you for your prompt response. I appreciate that! Tunsten
|
|
|
|
|
Hi ,
Please help me to convert a dataset to Excelsheet ?
With Regards.
|
|
|
|
|
You can refer to the following code:
public int ExportToExcel(DataTable schemaTable, string tableName, string filePath, DataTable source)
{
string connString = "Provider = Microsoft.Jet.OLEDB.4.0 ;Persist Security Info=False; Data Source = " + filePath + ";Extended Properties=Excel 8.0;";//'HDR=Yes;IMEX=1";
if(System.IO.File.Exists(filePath))
{
System.IO.File.Delete(filePath);
}
string create = "Create Table [";
create += tableName;
create += "] (";
string sourceColumn = "(";
foreach(DataRow dr in schemaTable.Rows)
{
string columnName = dr["ColumnName"].ToString();
//create string
create += "[";
create += columnName;
create += "]";
sourceColumn += "[" + columnName + "],";
string type = dr["DataType"].ToString();
switch(type)
{
case "System.Int32":
case "System.Int16":
case "System.Int64":
case "System.UInt32":
case "System.UInt16":
case "System.UInt64":
create += " INTEGER NULL,";
break;
case "System.Decimal":
case "System.Double":
case "System.Single":
create += " numeric NULL,";
break;
case "System.DateTime":
create += " datetime NULL,";
break;
case "System.Boolean":
create += " BINARY NULL,";
break;
default:
create += " varchar(";
create += dr["ColumnSize"].ToString();
create += ") NULL,";
break;
}
}
create = create.Substring(0, create.Length - 1);
create += ")";
using(OleDbConnection conn = new OleDbConnection(connString))
{
conn.Open();
using(OleDbTransaction trans = conn.BeginTransaction())
{
try
{
OleDbHelper.ExecuteNonQuery(trans, create);//create table
string insertHead = "Insert Into [" + tableName + "]" + sourceColumn.Substring(0, sourceColumn.Length - 1) + ") Values";
int result = 0;
foreach(DataRow dr in source.Rows)
{
string valueStr = "(";
for(int j = 0; j < source.Columns.Count; j++)
{
if(source.Columns[j].DataType == typeof(System.String))
{
valueStr += "'" + dr[j].ToString().Replace("'", "’") + "',";
}
else if(source.Columns[j].DataType == typeof(System.DateTime))
{
string date = dr[j].ToString();
if(date == string.Empty)
{
valueStr += "null,";
}
else
{
valueStr += "'" + date + "',";
}
}
else
{
valueStr += dr[j].ToString() + ",";
}
}
string insert = insertHead + valueStr.Substring(0, valueStr.Length - 1) + ")";
result += OleDbHelper.ExecuteNonQuery(trans, insert);
}
trans.Commit();
return result;
}
catch
{
trans.Rollback();
throw;
}
}
}
}
April
Comm100 - Leading Live Chat Software Provider
modified 27-May-14 8:43am.
|
|
|
|
|
Thank You. 
|
|
|
|
|
hai friends
Can anyone pls help in finding why checkbox change event is not firing which is put inside a gridview.
Whenever I checks the checkbox the page is posting back but the event is not firing or is not called, why so?
Autopostback and runat= server etc are set..
Thanks in advance 
Santhosh
Santhosh
|
|
|
|
|
Santhosh Sebastian Mattathil wrote: finding why checkbox change event is not firing
Can you post the code so that any one can find it...
|
|
|
|
|
I am using Visual Studio Web Developer 2008, CSS 2.1
Browser Firefox 3.5.8, IE 6.0.2900
I am trying to add this menu described here
[], but it is causing all the master page components to change positions.
I created a master page following tutorials elsewhere and the problem mainly comes with the Menu bar, I created a custom menu bar to suit my needs, rather than using the inbuilt menu, but i am guessing because of the menu the webpage components are out of place in
1)Firefox: there is a Nav div on the left hand side of the page
Structure of intended webpage
------------------------------
Logo Title
Dotted Line
Menu
Dotted Line
Nav Main Content page
(25%) (margin-left:30%;)
footer
This is how i am trying to arrange the page but in firefox the Nav falls to the right, CSS setting justify:left dosent help.
2)In Internet Explorer
The menu appears vertical rather than horizontal
Please find the code to my Master Page below, however note that i am NOT trying to use the asp:menu item for a menu, and using a customized menu. Because of which my master page is all over the browser.
I would really appreciate if anyone can provide any sort of suggestions.
Please find Master Page below.
<%@ Master Language="C#" AutoEventWireup="true" CodeFile="MasterPage.master.cs" Inherits="MasterPage" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<title>Untitled Page</title>
<link href="StyleSheet.css" type="text/css" rel="Stylesheet" />
<script language="javascript" src="menu.js" type="text/javascript" ></script>
</head>
<body>
<div id="outer">
<div id="header">
<div id="lhead">
<img alt="logo1" src="Images/team1.jpg" style="height: 45px; width: 44px"/>
<a href="Default.aspx" style="color:Black; text-decoration:none" ><i><b>TEAM</b></i></a>
</div>
<div id="rhead">
<img alt="logo2" src="Images/team6.jpg" style="height: 46px; width: 50px" />
<img alt="logo3" src="Images/team3.jpg" />
<img alt="logo4" src="Images/team5.jpg" style="height: 44px; width: 54px" />
<img alt="logo5" src="Images/team4.jpg" style="height: 43px; width: 56px" />
</div>
<b id="team definition" style="color:Black; text-decoration:none; font-size:x-small;
font-weight:lighter; display:block; text-align:left;">REDEFINING EXCELLENCE</b>
<ul id="menu1">
<li><a href="#">home</a></li>
<li><a href="#"
onmouseover="mopen('m1')"
onmouseout="mclosetime()">products & services</a>
<div id="m1"
onmouseover="mcancelclosetime()"
onmouseout="mclosetime()">
<a href="#">engineering services</a>
<a href="#">engineering products</a>
<a href="#">it services</a>
</div>
</li>
<li>
<a href="#"
onmouseover="mopen('m2')"
onmouseout="mclosetime()">about us</a>
<div id="m2"
onmouseover="mcancelclosetime()"
onmouseout="mclosetime()">
<a href="#">company history</a>
<a href="#">achievements & awards</a>
<a href="#">company policies</a>
<a href="#">future growth & vision</a>
</div>
</li>
<li>
<a href="#"
onmouseover="mopen('m3')"
onmouseout="mclosetime()">careers</a>
<div id="m3"
onmouseover="mcancelclosetime()"
onmouseout="mclosetime()">
<a href="#">career path</a>
<a href="#">type of jobs</a>
<a href="#">current openings</a>
</div>
</li>
<li>
<a href="#"
onmouseover="mopen('m4')"
onmouseout="mlosetime()">help & support</a>
<div id='m4'
onmouseover="mcancelclosetime()"
onmouseout="mclosetime()">
<a href="#">technical support</a>
<a href="#">feedback form</a>
</div>
</li>
<li>
<a href="#">contact us</a>
</li>
<li>
<a href="#">site map</a>
</li>
</ul>
</div>
<div id="body1">
<div id="nav">
<h4>Navigation</h4>
<ul>
<li>text1</li>
<li>text2;/li>
<li>text3;/li>
</ul>
</div>
<div id="main">
<p>Main Content -- text
<div id="footer">
<p>Footer text -- text </p>
</div>
</div>
</div>
</body>
</html>
Please reply, thanks.
|
|
|
|
|
When i assign the html table to the hiddenfield value using javascript i am getting the error like this:
"A potentially dangerous Request.Form value was detected from the client (ctl00$ContentPlaceHolder1$hd2="<TBODY>
<TR>
<TD c...")."
I used the javascript function like this:
var element = document.getElementById("aspnetForm");
var store1 = document.getElementById("tb1");
document.getElementById("ctl00_ContentPlaceHolder1_hd2").value = store1.innerHTML.toString();
Help me how to solve this
|
|
|
|
|
Having angular braces "<" with in a text box, hidden field, text area, etc., triggers this error during server post. ASP.NET engine thinks that malicious code has been injected into the request stream and stops processing the request and raises this error, when it encounters such a situation.
To over come this, either replace the angular braces with their HTML code "<" - & l t ; ">" - & g t ; [with out the spaces] or else set ValidateRequest="false" on the page directive of the page.
This web page has examples for both solutions Allowing HTML Formatted User Input in ASP.NET [^]
NOTE: The later would make your page susceptible to injection attacks.
|
|
|
|
|
I made the validationRequest property to false
now the problem is solved but the table is displaying along with the td and tr tags in excel how can i solve this
|
|
|
|
|
What exactly are you trying to do?? Your original post has nothing about writing to an excel!?
|
|
|
|
|
i want to import the html table that is dynamically generated to excel to get the table i am using the javascript function and i am using the value stored in hidden field to display in excel
string html = hd2.Value;
Response.Cache.SetExpires(DateTime.Now.AddSeconds(1));
Response.Clear();
Response.AppendHeader("content-disposition", "attachment;filename=FileName.xls");
Response.Charset = "";
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.ContentType = "application/vnd.ms-excel";
this.EnableViewState = false;
Response.Write("\r\n");
Response.Write(html);
Response.End();
|
|
|
|
|
Hi everyone,
Can anyone tell me how to create and send a email in .net 3.5 .
In which template do i create it.
Does a windows form application work or do i need to use the web applications.
Wat all settings must be done.
I have done the SMTP settings in my system and its working.
explain wit with the code.
Please help
i am stuck from 2 days.
I am a beginner
|
|
|
|
|
You can send email by both windows as well as Web app.It does not depend on the type of application.Check yor requirement and accordingly choose the type of template.
and How to send mails, have a look to the following link
Sending emailCheers!!
Brij
|
|
|
|
|
Hi dude,
I am using a windows app.
will the code given in the link provided by you work ??????
|
|
|
|
|
No problem.The code will work for windows application also.But you need to use different namespace that is System.Net.MailCheers!!
Brij
|
|
|
|
|
Don't post to multiple forums
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
|
Hello Friends,
Recently i have tried to load a excel data into a data table.But when it load data into data table some of cell of data table left blank.But there have data into excel cells.I have not found any special character in those cell.I made column format into text.
|
|
|
|
|
Excel by default has a very loose type binding, i.e. if you set the column's formatting to text and insert a numeric value in it then it treats the data as text. When you set the format to numeric and enter textual data it changes the type to general which accepts all data values.
Now, Datatables in ADO.NET are type sensitive and are tight binding. When you execute a query against a cell range in excel .NET sets the datatype of the column as the data type of the first cell in that column in excel. Now if there is data of other type in that row then that data is ignored when reading the cells and is left as NULL in the data table.
As far as I know the cell formatting does not matter, the ADO.NET engine analyzes the data in the first cell and sets the data type. You cannot control the way it is done. So, if you have text data and numeric data in the same column then make sure that the fist row has text data than numeric data.
HTH!
|
|
|
|
|
I am trying to incorporate Authorize.net SIM implementain with my asp.net website.
I want to use relay respone so that customer can check transaction status. i have included the following code for relay response
in Receipt.aspx.cs page I am writing following code to get transaction informaion
string ResponseReasonText = Request.Form["x_response_reason_text"];
My problem is that when i click the submit button in gatewaty page after enter credit card information then each time i get the following error.
An error occurred while trying to report this transaction to the merchant. An e-mail has been sent to the merchant informing them of the error. The following is the result of the attempt to charge your credit card.
This transaction has been approved.
It is advisable for you to contact the merchant to verify that you will receive the product or service
I did not found what i am going to mistake. Please if any one have complete code in c# or getting any error in my code please reply me.
|
|
|
|
|
I am having the same problem. Did you get it to work?
|
|
|
|
|
Hi friends,
I am working on ActiveX Control.I need to use Cab file in the "Codebase" attribute.I came across a code like
<OBJECT id="OurActiveX" name="OurActiveX" classid="clsid:121C3E0E-DC6E-45dc-952B-A6617F0FAA32" VIEWASTEXT codebase="OurActiveX.cab"></OBJECT>
How to Create .ini , cab files and how to include the .ini file into cab files?
|
|
|
|
|
Hi
i hav problem on crystal report in asp.net.Its don't show the printing toolbar in local host and when i upload it to my host server its give me error.how to solve all this prob?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
