Component Discussions

Issue with UpdateParameters

Kytro — Tue, 01 Dec 2009 00:51:57 GMT

I am attempting to use an UpdateCommand to update a table in SQL 2005. It is based on the OBOUT grid control.

It does not appear to update, and I am not really sure why this is happening.

Details:

<Columns>
				<obout:Column DataField="IR_Item_Number" HeaderText="Item #" Width="100" runat="server"/>	
				<obout:Column DataField="IR_Item_Description" HeaderText="Item Description" Width="220" runat="server"/>
				<obout:Column DataField="IR_M01" HeaderText="M1" Width="10%" runat="server">
				    <TemplateSettings TemplateId="editTpl" />
				</obout:Column>
				<obout:Column DataField="IR_M02" HeaderText="M2" Width="10%" runat="server">
				    <TemplateSettings TemplateId="editTpl" />
				</obout:Column>
				<obout:Column DataField="IR_M03" HeaderText="M3" Width="10%" runat="server">
				    <TemplateSettings TemplateId="editTpl" />
				</obout:Column>
				<obout:Column DataField="IR_M04" HeaderText="M4" Width="10%" runat="server">
				    <TemplateSettings TemplateId="editTpl" />
				</obout:Column>
				<obout:Column DataField="IR_M05" HeaderText="M5" Width="10%" runat="server">
				    <TemplateSettings TemplateId="editTpl" />
				</obout:Column>
				<obout:Column DataField="IR_M06" HeaderText="M6" Width="10%" runat="server">
				    <TemplateSettings TemplateId="editTpl" />
				</obout:Column>
				<obout:Column DataField="IR_M07" HeaderText="M7" Width="10%" runat="server">
				    <TemplateSettings TemplateId="editTpl" />
				</obout:Column>
				<obout:Column DataField="IR_M08" HeaderText="M8" Width="10%" runat="server">
				    <TemplateSettings TemplateId="editTpl" />
				</obout:Column>
				<obout:Column DataField="IR_M09" HeaderText="M9" Width="10%" runat="server">
				    <TemplateSettings TemplateId="editTpl" />
				</obout:Column>
				<obout:Column DataField="IR_M10" HeaderText="M10" Width="10%" runat="server">
				    <TemplateSettings TemplateId="editTpl" />
				</obout:Column>
			</Columns>
			<Templates>
			    <obout:GridTemplate runat="server" ID="editTpl">
			        <Template>
			            <div onmousedown="enterEditMode(this)" class="cellContent"><%# Container.Value %></div><input type="text" class="editTplTxt" style="display: none;" onblur="exitEditMode(this, true, false);" onkeydown="return handleKeyPress(this,event)" />
			        </Template>
			    </obout:GridTemplate>
			</Templates>
		</obout:Grid>

The update command section is:

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="Provider=SQLOLEDB; Data Source=ds1; Initial Catalog=X; User ID=X; Password=X"
            ProviderName="System.Data.OleDb"
            SelectCommand="SELECT IR_Item_Number,IR_Item_Description,IR_M01,IR_M02,IR_M03,IR_M04,IR_M05,IR_M06,IR_M07,IR_M08,IR_M09,IR_M10 FROM tbl_Item_Redirect where Left(IR_Item_Number,1)<>'E' ORDER BY IR_Item_Number"
   UpdateCommand="UPDATE tbl_Item_Redirect SET IR_M01=@IR_M01 where IR_Item_Number='00999838'">
   <UpdateParameters>
    <asp:Parameter Name="IR_M01" Type="String" DefaultValue="100" />
            </UpdateParameters>
        </asp:SqlDataSource>

I have tried using a parameter with the select statement, this appeared to work.

If the update statement does not include any parameters it works fine,

SQL Profiler shows the update statement verbatim, but nothing happens.

Greybox causing javascript error, should be easy fix

eddy556 — Thu, 03 Dec 2009 15:16:34 GMT

I am using the Orangoo greybox window. I have some javascript which works in the parent window, but not within the box. The line causing the problem is:

top.document.getElementById(editorId).value;

saying it is null, I'm guessing I should just remove the "top" bit and it should work?

set font for list while using itextsharp.dll

Vijaya.A — Wed, 02 Dec 2009 06:29:21 GMT

I am using itextsharp.dll for generating pdf from asp.net application .while writing content in pdf how to set font for the list .

Reading the PDF Forms which has the Data connection using iTextSharp

Sree Harshavardhana — Wed, 02 Dec 2009 09:40:12 GMT

Dear All,

I have a question with respect to the reading the PDF Templates which has the XML Dataconnection in it.

I am using ASP.Net application to read the PDFForm by using the iTextSharp. I am able to read PDF Form with this tool, but I am not able read the PDF Form which has XML File as Dataconnection. iTextSharp is reading all the fields in the PDF Form as XML elements, if the PDF Form contains XML as Datasource, the it's ignoring the fields and taking the XML datasource as the XML Element and not reading the values of the controls.

Is there any way to read the control values instead of the XML Datasource values?

Regards,

Sree Harshavardhana.

IIS 7 on production server problem

senzacionale — Tue, 01 Dec 2009 06:44:56 GMT

Server Error in '/' Application.
Illegal attempt to associate a collection with two open sessions
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: NHibernate.HibernateException: Illegal attempt to associate a collection with two open sessions

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[HibernateException: Illegal attempt to associate a collection with two open sessions]
NHibernate.Collection.AbstractPersistentCollection.SetCurrentSession(ISessionImplementor session) +237

NHibernate.Event.Default.OnUpdateVisitor.ProcessCollection(Object collection, CollectionType type) +184
NHibernate.Event.Default.AbstractVisitor.ProcessValue(Int32 i, Object[] values, IType[] types) +46
NHibernate.Event.Default.AbstractVisitor.ProcessEntityPropertyValues(Object[] values, IType[] types) +74

NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.PerformUpdate(SaveOrUpdateEvent event, Object entity, IEntityPersister persister) +432
NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.PerformSaveOrUpdate(SaveOrUpdateEvent event) +99

NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.OnSaveOrUpdate(SaveOrUpdateEvent event) +333
NHibernate.Impl.SessionImpl.FireSaveOrUpdate(SaveOrUpdateEvent event) +162
NHibernate.Impl.SessionImpl.SaveOrUpdate(String entityName, Object obj) +151

NHibernate.Engine.SaveUpdateCascadingAction.Cascade(IEventSource session, Object child, String entityName, Object anything, Boolean isCascadeDeleteEnabled) +139
NHibernate.Engine.Cascade.CascadeOn(IEntityPersister persister, Object parent, Object anything) +578

NHibernate.Event.Default.AbstractFlushingEventListener.CascadeOnFlush(IEventSource session, IEntityPersister persister, Object key, Object anything) +145
NHibernate.Event.Default.AbstractFlushingEventListener.PrepareEntityFlushes(IEventSource session) +387

NHibernate.Event.Default.AbstractFlushingEventListener.FlushEverythingToExecutions(FlushEvent event) +292
NHibernate.Event.Default.DefaultFlushEventListener.OnFlush(FlushEvent event) +85
NHibernate.Impl.SessionImpl.Flush() +275

ProjectBase.Data.AbstractNHibernateDao`2.CommitChanges() in D:\PROJEKTI\eMedicine\ProjectBase.Data\AbstractNHibernateDao.cs:120
EMedicine.UserControls.UsersUC.btnAdd_Update(Object sender, EventArgs e) in D:\PROJEKTI\eMedicine\eMedicine\UserControls\UsersUC.ascx.cs:390

System.Web.UI.WebControls.Button.OnClick(EventArgs e) +115
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +140
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +29

System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2981

I get this error on production server when i try to update data. In VS 2008 everytging works in release and debug mode. Problem is only on production in IIS 7 server. I figure out that if i make new virtual host (localhost/test) then start working but if i try with 192.168.2.4 or domain then i get this error.

Anyone know what can be the problem. I try many solutions but no one works.

regards

Loosing Javascript File References on async postback

noxinoobin — Mon, 30 Nov 2009 23:05:04 GMT

I am trying to use Lightwindow in a ASP.Net page to display a external website in a modal window. When it first loads the Lightwindow triggers with out a hitch but upon a async postback it no longer displays the Lightwindow but rather redirects to the specified page. I have tried registering the scripts with Page.ClientScript.RegisterClientScriptInclude as well as ScriptManager.RegisterClientScriptInclude in my Page_Load event but still the problem persists!

Any solutions?

iTextSharp - Converting existing document to pdf

inutan@gmail.com — Wed, 07 Oct 2009 14:33:24 GMT

Hello there,

How can we convert an existing text document (.doc/.docx) to pdf using iTextSharp?

I have gone through iTextSharp tutorial available at-

http://itextsharp.sourceforge.net/tutorial/index.html

but couldn't get any clue how I can achieve above.

Please help.

Thank you!

Rebex.net

preeja.preeja — Tue, 01 Dec 2009 05:41:53 GMT

Hi all,

i just tried to read mail from gmail account rebex.net.dll, but its not woking fine, could any one help me !

language c#.

thanks.

input button not working in IE

babymonsta — Mon, 30 Nov 2009 01:22:34 GMT

Im using a colour pallete from http://www.free-color-picker.com/color-picker-combo.php which works fine when I test my website in firefox, but it doesnt work in IE when I click the button. Hrre's my code

<div id="Div4" class="colorpicker301" ></div>
        <input type="button" id="b1" value=".." onclick="showColorGrid3('rgb_id1','c_id1');"/>
        <input type="text" size="10" name="ehHex" id="rgb_id1" />
        <input type="text" size="5" id="c_id1" disabled="disabled" />

Im not sure why the button when clicked, will not cause the pallete to appear. And this only happens in IE. Advice needed, thanks!

iTextSharp - MemoryStream - Compression

jhoop2002 — Wed, 25 Nov 2009 15:12:12 GMT

I am using iTextSharp in my application to fill in pdf forms. The problem I am having is that when I add the line "stamper.SetFullCompression();" the pdf file becomes corrupt and adobe can't open it.

Below are several code examples. Basically I need to create as small a pdf as resonably possible (for free). In my program I generate a pdf that is 2K+ pages and is 90MB when saving it to the memory stream, but when saving it to a filestream its 30MB (regardless of the stamper.SetFullCompression() line). Why would that be and how can I get that type of file size but with using the memory stream?

Here is the code I use open the pdf and just send it to the browser (this works)

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using iTextSharp.text.pdf;
using System.IO;

public partial class PDFtest : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        string pdfFile = Server.MapPath("pdfFile.pdf");
        MemoryStream ms = new MemoryStream();

        PdfReader reader = new PdfReader(pdfFile);
        PdfStamper stamper =
            new PdfStamper(reader, ms);

        stamper.FormFlattening = true;
        stamper.Close();

        Response.ContentType = "application/pdf";
        Response.AddHeader("Content-Disposition", "attachment; filename="pdfFile.pdf");
        Response.BinaryWrite(ms.ToArray());
    }
}

Here is the code I would like to use to compress the pdf file. However, when adobe tries to open the document it reports "the file is damaged and could not be repaired."

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using iTextSharp.text.pdf;
using System.IO;

public partial class PDFtest : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        string pdfFile = Server.MapPath("pdfFile.pdf");
        MemoryStream ms = new MemoryStream();

        PdfReader reader = new PdfReader(pdfFile);
        PdfStamper stamper =
            new PdfStamper(reader, ms);

        stamper.FormFlattening = true;
        stamper.SetFullCompression();
        stamper.Close();

        Response.ContentType = "application/pdf";
        Response.AddHeader("Content-Disposition", "attachment; filename="pdfFile.pdf");
        Response.BinaryWrite(ms.ToArray());
    }
}

Now here is the thing that is beyond what I know about working with files in memory. If I save it to the hard drive and compress the pdf file, it works - of course you have to manually open it with this code. But I don't want this app writing to the hard drive to create a pdf.

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using iTextSharp.text.pdf;
using System.IO;

public partial class PDFtest : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        string pdfFile = Server.MapPath("pdfFile.pdf");

        PdfReader reader = new PdfReader(pdfFile);
        PdfStamper stamper =
            new PdfStamper(reader, new FileStream(@"c:\test.pdf", FileMode.Create), PdfWriter.VERSION_1_5);

        stamper.FormFlattening = true;
        stamper.SetFullCompression();
        stamper.Close();
    }
}

I am using LiveCycle 8.0 to create my pdf form and .Net 2.0.

Plotting Map Points on Google Maps

Schwimms — Mon, 09 Nov 2009 16:02:40 GMT

Hi All,

I have a database with multiple map coordinates and I also have my google map and a search box but not all the code is set up. I am using visual basic. This is what I want the program to do:

- You type an address in that search box.
- After you hit submit the map shows you map points around that address by looking at my database. I would only like to show 5 miles of radius from the address that is searched. I also would only like to allow 40 map points to be populated at a time.
- You can hit a next button to see more map points.
- You can also drag the map around and it reloads the map points based on where you drag your map around to.

I think this is more complicated then I think it is. Could you help me with code?

problem with RSS after upgrade

jnc — Wed, 25 Nov 2009 17:05:59 GMT

I have just upgraded a web site from vs 2005 to 2008 everything is ok except RSS.

Along the way I also upgraded RSS to RssToolKit v2.0 and now I cannot find the GenericRssChannel what do I need to add

In my GAC I have RSSToolkit and I have the RSS DataSource and RSSHyperlink in the Toolbox

Radsplitter

mavericky — Tue, 24 Nov 2009 20:58:17 GMT

Hi All,

I have a radsplitter which is collapsible both ways - left and right. After running my application if I hover my mouse over the url of the page which contains the radsplitter, automatically another page containing image of expanding the radsplitbar gets loaded.

can anybody please help me so that there is no change when i hover my mouse over the url of the page.

thanks in anticipation,

mavericky

how to retrieve cell values of telkrit radgrid control using javascript?

dp.samantray — Mon, 16 Nov 2009 17:43:27 GMT

Hi All,

In my project I am using Telkrit rad grid control for displaying data. I have same type of 2 grids in one page and I need to compare the values each row wise and column wise. Can you please let me know how can I retrieve Cell values using javascript?I am in urgent need of this solution.

Thanks in advance...

Thanks

Durga

HTML to PDF Converter

sajesh28 — Mon, 09 Nov 2009 09:55:57 GMT

Hi members,

In our Web application we need to add three functionalities
1)HTM to PDF
2)PDF to Image
3) Re-size image

I think we need to use third party controls.is there is any third party control is available with these three functionalities?

regards,
sajesh

Free Text Box

chricholson — Wed, 18 Nov 2009 01:24:16 GMT

I have included a FreeTextBox on my page and I am looking to get the text entered and using VB enter it into my database. To find my FreeTextBox on my page I have used:

Dim FreeTextBox As TextBox = DirectCast(item.FindControl("FTBFreeTextBox"), TextBox)

as it is contained inside a content place holder and then a repeater. (I know this bit of code works as it does for other text boxes)

However, even though the FreeTextBox has a property '.Text' when I run the page I get this error:

Unable to cast object of type 'FreeTextBoxControls.FreeTextBox' to type 'System.Web.UI.WebControls.TextBox'.

Does anyone know how I can get to the '.Text' property some other way?

Changing Source of IFRAME at Runtime via SKMMENU

CSpace — Sat, 03 Jun 2006 20:36:23 GMT

Hi all,

I'm using skmmenu in a dot net 1.1 web app.

I have an aspx page with an iframe in it. The contents of the IFRAME is one .htm file or another that are already crerated, sized and look great inside the ASPX page.

When a user clicks a menu choice, I'd like the IFRAME to load the correct source htm file. As I understand from this thread (http://forums.asp.net/thread/886165.aspx) having read Bilal Haidar's reply in that thread, I included the runat="Server" and id="iframe1" (or whatever name).

My issue is how to get SKMMENU to execute the: iframe1.Attributes["src"] = "test.aspx";
that would otherwise be attached to an onclick event of a button.

I played around with <command></command> but haven't had success.

Also tried simple frame targeting in the XML - no luck.

menuItem>
   <text>About the facility</text>
   <url>whatever.htm</url>
   <target>iframe1</target>
</menuItem>

Thanks in advance for your help.

Stewart

lightbox on asp.net

kitkatz55 — Sun, 25 Oct 2009 12:58:38 GMT

i want to use Lightbox (http://www.huddletogether.com/projects/lightbox2/) on the asp.net site that i am creating. when the smaller version of an image is clicked, i want to show the actual image using lightbox.

before implementing lightbox, i used the imagebutton. here's the code:

<asp:TemplateField>
     <ItemTemplate>
          <asp:ImageButton ID="image" runat="server" ImageUrl='<%# Eval("PICTURE") %>' Width="250" Height="200" OnClick="imageButtonClick"></asp:ImageButton>
     </ItemTemplate>
</asp:TemplateField>

to implement lightbox, the format should be like this:

<a href="images/image-1.jpg" rel="lightbox" title="my caption">image #1</a>

so i tried the following code. lightbox actually worked but there is a problem in retrieving the image from the database. the image cannot be displayed.

<a href='<%# Eval("PICTURE") %>' rel="lightbox"><img src='<%# Eval("PICTURE") %>' width="120" height="100"</a>

how do i transform my code so that i will be able to implement lightbox? thank you!

ContextMenu for web controls

it-bergmann — Sun, 22 Nov 2009 18:27:19 GMT

Hi,

I like to add a ContextMenu to a GridView Control.
As google is our friend it points me to http://www.asp.net/community/control-gallery/Item.aspx?i=681 .

It seems to be up to date as the last update would for about one month but the link is broken.
Maybe there's an other location where to get it or can you suggest an other free cross browser ContextMenu I can use?

Thanks

Andre

Help with iTextsharp

uniquealex — Wed, 11 Nov 2009 21:37:27 GMT

I cannot for some reason set left and right margins for itextsharp gridview to pdf conversion. Everytime i generate PDF document the margins are .5 inches and will not change no matter what numbers i plug in into document(). Please help. Here is my code:

GridView1.AllowPaging = False
GridView1.DataBind()
'Create a table
Dim table As New iTextSharp.text.Table(GridView1.Columns.Count)
table.Cellpadding = 1
'Set the column widths
Dim widths As Integer() = New Integer(GridView1.Columns.Count - 1) {}
For x As Integer = 0 To GridView1.Columns.Count - 1
widths(x) = CInt(GridView1.Columns(x).ItemStyle.Width.Value)
Dim cellText As String = _
Server.HtmlDecode(GridView1.HeaderRow.Cells(x).Text)
Dim cell As New iTextSharp.text.Cell(cellText)
cell.BackgroundColor = _
New Color(System.Drawing.ColorTranslator.FromHtml("#008000"))
table.AddCell(cell)
Next
table.SetWidths(widths)
'Transfer rows from GridView to table
For i As Integer = 0 To GridView1.Rows.Count - 1
If GridView1.Rows(i).RowType = DataControlRowType.DataRow Then
For j As Integer = 0 To GridView1.Columns.Count - 1
Dim cellText As String = _
Server.HtmlDecode(GridView1.Rows(i).Cells(j).Text)
Dim cell As New iTextSharp.text.Cell(cellText)
'Set Color of Alternating row
If i Mod 2 <> 0 Then
cell.BackgroundColor = _
New Color(System.Drawing.ColorTranslator.FromHtml("#C2D69B"))
End If
table.AddCell(cell)
Next
End If
Next
'Create the PDF Document
Dim pdfDoc As New Document(PageSize.LETTER, 10, 10, 36, 36)
PdfWriter.GetInstance(pdfDoc, Response.OutputStream)
pdfDoc.Open()
pdfDoc.Add(table)
pdfDoc.Close()
Response.ContentType = "application/pdf"
Response.AddHeader("content-disposition", _
"attachment;filename=GridViewExport.pdf")
Response.Cache.SetCacheability(HttpCacheability.NoCache)
Response.Write(pdfDoc)
Response.End()

MSCaptcha works fine on local but not on server!

BIG-BERTA — Wed, 09 Sep 2009 11:24:17 GMT

MSCaptcha works fine on my local computer but when I place it on hosting server the image is not displayed.

Whoever knows how to fix this, please tell me?

Best ASP.Net AJAX Component Suite

narasimaperumal — Thu, 19 Nov 2009 10:29:36 GMT

Please advice me which is the best ASP.Net AJAX Component Suite.

- Telerik

- Infragistics

- DevExpress

etc..

iTextSharp asp.net Bulleted List to PDF

arny1 — Fri, 20 Nov 2009 08:47:33 GMT

Hi There,

I have a asp.net web page with some contents and a BulletedList with some international characters, I am using iTextSharp library to export to PDF format. How can I export only this BulletedList with international characters to PDF.

Any Ideas? Thanks

FCKEditorV2

simon000 — Fri, 20 Nov 2009 11:12:35 GMT

Hi,

i've inherited an asp.net 2.0 site which makes extensive use of the FCKEditorV2 component - version 2.6

The problem is that there is no hyperlink icon on the toolbar for end users to add links to external files. Searching through the folder structure for this editor I can see files (html/js) relating to adding these links but no obvious way to enable or disable them on the toolbar.

Can anyone help or at least point me in the right direction.

Thanks in advance

Low cost Obfuscator

leo2007 — Sun, 11 Mar 2007 02:29:10 GMT

I am in search of a low cost Obfuscator that can

Obfuscate Private member names.
Encrypt Strings inside functions.
Obfuscate Strong Named Assemblies.
Cost less than $100.

Is there some decent product out there? I dont need Fort Knox type of security but a avreage .NET programmer should not be able to decompile my code or see the Strings stored inside.

Thanks
Leo.