Web Forms :: Display Xml Data In OWC 10 Component?
Sep 17, 2010We are using Office Web component V10.0 in ASP.NET 3.5 website. The rquiremetn is to display xml data in OWC Pivot table component. How can I acheive that?
View 1 RepliesWe are using Office Web component V10.0 in ASP.NET 3.5 website. The rquiremetn is to display xml data in OWC Pivot table component. How can I acheive that?
View 1 RepliesI am trying to stop the data flow when certain conditions happen in the script component. Like if a row in the data set has an invalid date, I dont want that dataset to be inserted in the tables or go through OLEDB Destination, rather I want the entire data flow for that dataset to stop and go back to the control flow page.
I have tried mulitple solutions but nothing worked. Conditional Split ends up inserting the correct rows, but I just dont want anyting to be inserted when one row is bad, where as I do want the entire dataset to be inserted if all rows are good.
How can I fail the component when certain conditions happen int eh script component.
i got a problem.. how i can declare template textbox in a datagrid at code behind? i already make a stored procedure and put the update query inside it.. if i declare the textbox inside code behind(.aspx.vb).. there will be an error.. " there is already a component named "txtitem1"component must have a unique name.."
Dim con As New SqlConnection(ConfigurationSettings.AppSettings("ConnectionString1"))
Dim cmd As New SqlCommand
Dim sda As New SqlDataAdapter
cmd.CommandType = CommandType.StoredProcedure
cmd.CommandText = "ETendering3"
cmd.Parameters.Add("@item", SqlDbType.NVarChar).Value = txtitem1.Text
cmd.Parameters.Add("@price", SqlDbType.Decimal).Value = txtprice1.Text
cmd.Parameters.Add("@remark", SqlDbType.NVarChar).Value = txtremark1.Text
cmd.Parameters.Add("@consump", SqlDbType.Decimal).Value = txtconsump1.Text
cmd.Parameters.Add("@value", SqlDbType.Decimal).Value = txtvalue1.Text
cmd.Connection = con
Try
con.Open()
DataGrid12.DataSource = cmd.ExecuteReader()
DataGrid12.DataBind()
Finally
con.Close()
End Try
con.Dispose()
cmd.Dispose()
con = Nothing
cmd = Nothing
_______________________________________________________
.aspx
<Columns>
<asp:BoundColumn DataField="Listing_Id" HeaderText="Listing"></asp:BoundColumn>
<asp:BoundColumn DataField="No" HeaderText="No"></asp:BoundColumn>
<asp:BoundColumn DataField="Item_Category" HeaderText="Category"></asp:BoundColumn>
<asp:TemplateColumn HeaderText="Description">
<ItemTemplate>
<asp:TextBox id=TextBox1 runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.Item_Description") %>'>
</asp:TextBox>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox id="txtitem1" runat="server"></asp:TextBox>
</EditItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="Price" FooterText=" 10/50">
<ItemTemplate>
<asp:TextBox id=TextBox3 runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.Price") %>'>
</asp:TextBox>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox id="txtprice1" runat="server"></asp:TextBox>
</EditItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="Remarks">
<ItemTemplate>
<asp:TextBox id=TextBox2 runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.Remark") %>'>
</asp:TextBox>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox id="txtremark1" runat="server"></asp:TextBox>
</EditItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="Consumption">
<ItemTemplate>
<asp:TextBox runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.Consumption") %>'>
</asp:TextBox>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox runat="server" ID="txtconsump1"></asp:TextBox>
</EditItemTemplate>
</asp:TemplateColumn>
<asp:TemplateColumn HeaderText="Value">
<ItemTemplate>
<asp:TextBox runat="server" Text='<%# DataBinder.Eval(Container, "DataItem.Value") %>'>
</asp:TextBox>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox runat="server" ID="txtvalue1"></asp:TextBox>
</EditItemTemplate>
</asp:TemplateColumn>
</Columns>
I have a label like:
<asp:Label ID="dateLabel" runat="server" Text='<%# Eval('SomeDate') %> />
This displays showing the date and time. However I just want to display the date.
I'm aware that in the code behind you can write SomeDate.ToString("dd MM yyyy");
However I want a way of doing this by changing the code in the tag instead.
I am working on ASP.Net based template editor that lets authors create text templates using Javascript inserted placeholder tags that will be filled in with dynamic text when the templates are used to display the final results.For example the author might create a template likeThe word [%12#add] was generated dynamically.he application would eventually replace the tag with a dynamic word down the road (though it's not specifically relevant to this post)The word foo was generated dynamically.Depending on the circumstances, the template may be created in a text input, textarea or a modified version of the Ajax Control Toolkit HTML Editor. There might be 40 or more of these editable elements on the page, so using lots of stripped down or modified HTML editors would probably bog the page down too much.
View 2 RepliesI would like to know how can I list for every page (child page) selected the number and id of localize component in the current page. I need this to update resources files, a button will be on the master page and when they click on it, they will go to a page which show up every data in the resource file.
View 1 Replies I have three column and I need to flexible data listing not like datagrid.
which data component can I use?[URL]
in my aspx page i have a file upload control and one image component...i want to display the image uploaded in the image component..
View 4 RepliesI'm new with ASP.NET, and this is my first project that make myself cruel. I'm trying to create a link on every row that created dynamically.(I'm using GridView). The Problem is, the onserverclick eventhandler show nothing.? Heres the code:
public void GridV_RowDataBound(object sender, GridViewRowEventArgs e) {
if (e.Row.RowType == DataControlRowType.DataRow) {
e.Row.Cells[0].Text += "<font id='12345' runat='server' color='blue'
BACKGROUND-COLOR='#9471DE' style='cursor: pointer' Title='Click this:
to view to the Root menu of the thread'><U> <a onserverclick='Submit_Click'>This is description</a></u></font>";
e.Row.Cells[0].Text += "<br/>";
e.Row.Cells[0].Text += "<div id='DataDiv' style='overflow: auto; border: 1px solid olive;
width: 888px;'>"; //height: 300ox; onscroll='Onscrollfnction();'>";
FindHttpVideo1(dDataset.Tables[0].Rows[e.Row.RowIndex].ItemArray[0].ToString(), e, 0);
e.Row.Cells[0].Text += "</div>"; } }
Here the click EventHandler on also on code behind :
protected void Submit_Click(object sender, EventArgs e) {
Label1.Text = "Hello --->"; }
I don't want use Java script to for onclick() handler, I want to do it on code behind.
I have a user control that has several data components
What I want to do is populate the data components based on the parent's page title where the user control is called.
The parent page title is the most logical unique name to each page and so that would be the name that I want to import
as the default value for the data components select parameter. Each page name is stored in my sql data table [Towns] as TownsName.
The general idea is that the control will populate with the towns data based on the page title of the parent page.
<SelectParameters>
<asp:ControlParameter ControlID="DetailsView3" DefaultValue="PAGE TITLE NAME GOES HERE" Name="TownsName" PropertyName="SelectedValue" Type="String" />
</SelectParameters>
I am not sure how to code this correctly, but I am sure it would have to be called in the page load statement.
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
SetAttr(DetailsView3.DefaultValue = Parent.Page.Title())<-------THIS OFCOURSE DOES NOT WORK
End Sub
I have spent a couple of days trying to work this one out and have failed to find a workable solution..
I am trying to translate a chart from a classic asp componant to a 3.5 chart control. I have two problems so far:
1) (hopefully easy) For the XAxis and YAxis titles (not labels), how do you make these titles bold?
2) (seems impossible with .net) How can I break up the background color so that certain parts of the background are different colors? In the legacy control, the original programmer could drill down control to the y-axis lines for coloring the background.
Example in a Y-axis with lines from 0-100 with 10 intervals:
a) 0-50: the background color would be BLUE
b) 50-80: the background would be GRAY
c) 80-100: the backgound color would be RED
As far as I can see, with the .net chart control, you can only have a single color or a single gradient of two colors, but not striped as I am trying to describe above. It seems that if an old classic asp componant has this striping functionality, the .net control has got to have it somehow.
I'm wondering if this can be done. I have a SortedList which represents a shopping cart. The sorted list contains multiple instances of my CartItem class. The CartItem class contains all the fields (product id, price, quantity, etc.)
I'm wondering if there is a way to bind this to one of the data components (ie DataList, ListView, gridView, dropdownlist, etc.)
How do I add a web.config to a class library? I'm trying to build a data access component with two classes, one class that represents one thing and the other to perform data operations on that thing. However when I right click the project and click add item, I don't see information for adding a web.config, I just see information for adding an app.config. Maybe I'm doing this wrong? I'd like this component to be available to other asp.net apps that I will build in the future....
View 2 RepliesWe have the requirement to export the data from the grid excel. We can't install the Excel on the server. The excel generated need to be in the printable format. The excel generated needs to have custom headers, footers, repeatble rows, columns and landscape / portrait orientation style.
View 1 RepliesI am trying to pick data from the database through data access layer and use those values in different text boxes on the page.Basically on a click on the form, modal popup is planned to read the database and put the values into different text boxes which can be latter changed/ updated.
What I am unable to do is accessing those values on the form itself progamatically.
My data access component is as follows:
[Code]....
How do i read these values individually and put them in different boxes!? What I dont want to do is to access these from page's .cs file.
I want to get the component value inside the gridview row index. When the DropDownList SelectedIndexChange event is trigger.
Unable to get Selected Value of DropDownList inside GridView ItemTemplate in SelectedIndexChanged event...
Here the codes:
protected void Page_Load(object sender, EventArgs e) {
ArrayList Dummysource = new ArrayList() { "AA", "BB", "CC", "DD" };
if(!IsPostBack ) {
GridView1.DataSource = Dummysource;
GridView1.DataBind();
[Code]....
I want to Create Watcher Component how to create ?
ie: I created one Queue ( Private queue ) using MSMQ so the watcher Component will listen the Queue is there any msg if any message available on that Queue.
I have to do some process ie: pass that msg to Business Layer for further manipulation and keep on watch the queue for any other message.
May i know how to create Component class in asp.net.i was used the following code in VB.net but inASP.net there is no Componentclass file in
Add->Newitem
(how to create textbox with only your can enter numbers only)
My code to create text that only accept Number and also some color change.................
Public Class ZillisisNumberTextBox
Inherits TextBox
Private Sub ZillisisNumberTextBox_Enter(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Enter
Try
Me.BackColor = Color.LemonChiffon
Me.Font = New System.Drawing.Font("Verdana", 8.75!, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
Catch ex As Exception
MsgBox(ex.Message)
End Try
End Sub
Private Sub ZillisisNumberTextBox_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles Me.KeyPress
Try
If Not IsNumeric(e.KeyChar) And e.KeyChar <> System.Convert.ToChar(Keys.Back) And e.KeyChar <> System.Convert.ToChar(Keys.Delete) Then
e.Handled = True
End If
Catch ex As Exception
MsgBox(ex.Message)
End Try
End Sub
Private Sub ZillisisNumberTextBox_Leave(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Leave
Try
Me.BackColor = Color.White
Me.Font = New System.Drawing.Font("Verdana", 8.25!, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
Catch ex As Exception
MsgBox(ex.Message)
End Try
End Sub
End Class
I have succeeded in capturing image from webcam with window form.
There is a problem, i.e I'd like to apply this application on web page.
I try to convert winform component to webform component
(Winform Component (PictureBox) to Web User Control (asp:Image)), but it fails.
I am new to Visual Web Developer Express Edition 2008 as well as to asp.net. I think this is very simple question to be asked on this forum. But, i can't find a solution for this. I want to make TextBox Component as static through IDE. i don't want to do this manually. I have checked Textbox component's properties through Property Window. But, i haven't seen the property making a component as static.
View 4 RepliesI can't run Javascript from codebehind in my component.
My compenent simply listen a server from TCP/IP socket and create a nre thread for listening.
this.tcpClnt = new TcpClient();
this.tcpClnt.Connect(this.HostIP, Conversions.ToInteger(this.HostPort));
this.Stm = this.tcpClnt.GetStream();
new Thread(new ThreadStart(this.ReadSocket)).Start();
In my component ChangeState event, I'm trying to update a label.text.
[code]...
I tried with RegisterClientScriptBlock but it didn't change the label text.
i have a gridview binded with data when i hover mouse to row i want to display a image button to display date ,and when i click the button i want to display calender control for choose date, and next step after i choose date it will be must insert into database. and mean while a hidden label control will display and date shuld be display in it
View 2 RepliesI am using below code to find find no of slides in .ppt,.pptx and .pot file .
Microsoft.Office.Interop.PowerPoint.Application pptApplication = new Microsoft.Office.Interop.PowerPoint.Application();
Microsoft.Office.Interop.PowerPoint.Presentation pptPresentation = pptApplication.Presentations.Open(path, MsoTriState.msoFalse, MsoTriState.msoFalse, MsoTriState.msoFalse);
count=pptPresentation.Slides.Count;
It is working file in my system , but online it is showing error :
Retrieving the COM class factory for component with CLSID {91493441-5A91-11CF-8700-00AA0060263B} failed due to the following error: 80040154 Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)).
The coding is in ASP.NET 3.5.Here is the scenario.I am modifying a page that populates some data.In that page there is a table that displays pages. The pages have sub-pages and these sub-pages again have sub-pages.So thats three levels of hierarchal data presented.Right now its populated using asp:Treeview for easier display of the +(maximise) and -(minimise) images and all.Is that the best method?
What are the alternatives?
I have a custom component:
[Code]....
[Code]....
I try to create a new component instance like this:[Code]....
[Code]....