|
I m using a Pivot table and a chart in my asp.net 2.0(C#) application. I want to edit data in Pivot table and save in the sql database.
Is there any way of doing it?
|
|
|
|
|
What data do you want to save? Surely the data displayed in a pivot table is aggregated...
If you change the underlying data, I'm sure you can save it, but the answer to your question depends very much on how you are supplying the data to your pivot table - it's really just a matter of creating an update sql statement for anything that changes...
|
|
|
|
|
I saw one example of how to display Pivot Table
protected PivotTableClass pt;
pt = new PivotTableClass();
pt.ConnectionString ="Provider=SQLOLEDB.1;Data Source=AHD-2003;database=northwind;user id=sa;password=;";
pt.DataMember ="select * from suppliers";
pt.ShowDetails();
I m using OWC10. But there is no method named ShowDetails(). How can it be?
Do u have any example of how to display Pivot table programmatically.
|
|
|
|
|
I am developing a site in which I need to show images as thumbnails and on bringing mouse over them I want to show them as big like the images shown in below link
http://www.pensacolamls.com/(0v3xqr45qcmocsnrmh3nhmyo)/propertyDetails.aspx?mls=301025
Please tell me how can i make my .jpg files as thumbnails and on bringing mouse over them to show details as in above site.
Thanks,
Sandy
|
|
|
|
|
If you have 2 images (a thumbnail and a large image) you can just put the thumbnails on the page and render the inline popups on mouseovers (i suggest doing this with javascript cause otherwise you'll have troubles with postbacks).
If you do not have 2 images you will have to render your own thumbnails (on pageload for example) with System.Drawing libary. Then you can save your thumbnails just like you should have 2 images.
For an inline popup you can put a div with style "display:none" wherin you put your image. And onmouseover (from your thumbnail) you change the style of the div to display:div. With css you can place the div where you want on the screen.
|
|
|
|
|
I have a asp.net 2.0 web application that needs to open a word template from server, user change something, and then save back to server. Is it possible? Any help is appreciated.
|
|
|
|
|
It is possible using Office Interop, but before you do I'd suggest you look at what Microsof themselves have to say on the subject:
1) licensing: Microsoft require Office licenses for any server wanting to do this:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q243006#kb2[^]
2) (more importantly) there are technical limitations to running this kind of thing on the web:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q257757#kb2[^]
If you scroll down to where it says "Problems using Automation of Office server-side" in para 2 it says (in bold!):
"This fact alone makes running Office Applications from a server-side environment risky and unsupported."
So all in all, not a good idea....
There are 3-rd party components you can buy which will do the job - do a Google search.
cheers
Phil
|
|
|
|
|
Thanks for the reply.
What I understand is that if using Office Interop Office needs to be installed on web server. Even so it still can not save changed word document back to server.
Do you have any suggestion for the 3rd party component.
|
|
|
|
|
|
I have this in my html
<asp:DataList runat="server" ID="dlEntry" >
<ItemTemplate>
<AddOn:PostItem runat="server" UserRegisterDate="8/9/1972" UserTitle="Testing" TotalPosts="15" UserLoginName="NickTurner"/>
</ItemTemplate>
</asp:DataList>
my class file looks like so:
private DateTime _dtUserRegisteredDate = DateTime.Now;
private string _sTitle = "";
private int _iTotalPosts = 0;
private string _sUserName = "";
protected void Page_Load(object sender, EventArgs e)
{
}
public DateTime UserRegistedDate
{
get { return _dtUserRegisteredDate; }
set { _dtUserRegisteredDate = value; }
}
public string UserTitle
{
get { return _sTitle; }
set { _sTitle = value; }
}
public int TotalPosts
{
get { return _iTotalPosts; }
set { _iTotalPosts = value; }
}
public string UserLoginName
{
get { return _sUserName; }
set { _sUserName = value; }
}
In the WUC control is looks like
<asp:Label ID="Label1" runat="server" CssClass="PostNormal" Text='<%=UserLoginName%>'></asp:Label>
The value is being set. I saw this from stepping through the code. But when it prints on the browser its blank. All of the properties.
This is VS2005
What am I forgetting?
Thanks
1 line of code equals many bugs. So don't write any!!
-- modified at 9:21 Thursday 27th April, 2006
|
|
|
|
|
Hi Nick,
You cannot use the inline render code expression <%= ...%> to assign a value to the property of a server control. In this case, you either set the property in code or use the data binding expression:
<asp:Label ID="Label1" runat="server" CssClass="PostNormal" Text='<%# UserLoginName%>'/> And in the Page_Load you call the DataBind method of the label to bind the value UserLoginName to the Text property.
|
|
|
|
|
actually the problem was this
and yeah the equals was wrong
But if I have inline, I can not include text i.e...
Text='<%# UserLoginName%>' will work
but
Text='LoginName: <%# UserLoginName%>'
will not.
if I take out "LoginName:" and move that too another label it works. very odd
1 line of code equals many bugs. So don't write any!!
|
|
|
|
|
The sample code simply looks like this:
Text='<%# "LoginName: " + UserLoginName %>'
|
|
|
|
|
LOL.
I didn't think of that.
1 line of code equals many bugs. So don't write any!!
|
|
|
|
|
Right I have a flash interface, and I need to pass a variable from flash to asp.net in order to set a variable that is important to the running of my web page.
here is my action script
******************************************
btn_1.onRelease = function(){
PosId = "First";
getURL("WebForm2.aspx", "_self", "POST");
};
******************************************
Now I need to know how to retieve that vaiable in asp.net.
I have tried using,
Dim Pos As String
Pos = Request.QueryString("PosId")
But this doesn't work, any help would be appreciated.
|
|
|
|
|
Well you specify the POST protocol in the GetURL, so it would be
Request.Form["PosId"]
or specify GET in the getURL line and your code should work.
Current blacklist
svmilky - Extremely rude | FeRtoll - Rude personal emails | ironstrike1 - Rude & Obnoxious behaviour
|
|
|
|
|
I am facing a big problem in using datagrid.. while designing datagrid i dont know no of columns and no of rows.. So I am creating datacolums on the basis of a the resultset returned by the query at runtme. My problem is I am populating resultset into DATA Table then binding it to datagrid, Now I want the last column to be of type Combo Box, which is extra column and is not returned by the query.
Kindly let me know whther i can create addtional column in such a way at runtime
|
|
|
|
|
Basically, you can dynamically create the last column containing the DropDownList/ListBox control, then add it to the Columns collection of the datagrid control. To create the custom column, you have two options:
+ You can create a custom template column which implements the ITemplate interface, you can see more info from the article[^]. The downside of this way is that you cannot handle the postback event of the dropdownlis/listbox control if you want to do that.
+ Another option is that your custom control can inherit from the DataGridColumn class, and override the InitializeCell method to add the dropdownlist/listbox control to the table cell.
|
|
|
|
|
when i try to upload the file it gives error "Access denied".
then it gives me solution to change the rights of folder going into the security tab.
when i goto the property of project it shows me only four tab.....
General -- Sharing --WebSharing---Customize.
no security Tab.
what should i do to resolve this Error.
|
|
|
|
|
The error is suggesting that your ASP.NET application does not have priveledges to write to the upload folder - you indicate that you were looking at the "property of project" - did you mean the properties of the upload folder?
What operating system are you running? Are you using NTFS for the file system?
|
|
|
|
|
|
Vasudevan Deepak Kumar wrote: For your problem, you can open inetmgr. Navigate to the virtual directory, RightClick properties and give 'Write' Access from there. That alone should work.
Ouch. You just gave the entire world write permission to the folder.
If the file system is not NTFS, it is not a permission problem. A FAT disk has no permission system at all.
---
b { font-weight: normal; }
|
|
|
|
|
Also, you might want to check this condition: if your machine (XP) is not joined to a domain, then you don't see the Security tab by default. If this is the case, you can display this tab as below:
+ Go to the Folder Options dialog (you can see this in Control Panel, or in the Tools menu of the Window Explorer).
+ In the View tab, under the Advanced Settings, uncheck the "Use simple file sharing (Recommended)" option.
|
|
|
|
|
hai every one
i m ajay
facing a problem related to modal dialog boxes
i have one page on which i have taken two list boxes.i m populating the first list box frm database.ther r 2 buttons add and remove.u can add items in the second list box and vice versa.
working fine for me
problem arises when i m opening this page as a modal dialog box frm anothr page.
when i m selecting a value frm first list box and click on the add button in dialog box it opens a new instance of the same page and allow me to add.
i did not want this behaviour.i just want to do all operations in the same dialog box .
plz help
any suggetion will be highly appriciated.
ajay
coding of the page frm where i m opening dialog box(containing list boxes)---
Public Class WebForm1
Inherits System.Web.UI.Page
#Region " Web Form Designer Generated Code "
'This call is required by the Web Form Designer.
<system.diagnostics.debuggerstepthrough()> Private Sub InitializeComponent()
End Sub
Protected WithEvents Label1 As System.Web.UI.WebControls.Label
Protected WithEvents TextBox1 As System.Web.UI.WebControls.TextBox
Protected WithEvents Button1 As System.Web.UI.WebControls.Button
Protected WithEvents Label2 As System.Web.UI.WebControls.Label
'NOTE: The following placeholder declaration is required by the Web Form Designer.
'Do not delete or move it.
Private designerPlaceholderDeclaration As System.Object
Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
'CODEGEN: This method call is required by the Web Form Designer
'Do not modify it using the code editor.
InitializeComponent()
End Sub
#End Region
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
If Not Page.IsPostBack Then
Dim listitems As String
listitems = Session("listitems")
'Response.Write(listitems)
Label2.Text = listitems
End If
End Sub
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Session("temp") = TextBox1.Text
'Response.Redirect("webform2.aspx")
Button1.Attributes.Add("onclick", "window.showModalDialog('webform2.aspx', null,'status:no;dialogWidth:370px;dialogHeight:220px;dialogHide:true;help:no;scroll:no');")
End Sub
End Class
coding of webform2------
Imports System.Data.SqlClient
Public Class WebForm2
Inherits System.Web.UI.Page
Dim str1 As String
#Region " Web Form Designer Generated Code "
'This call is required by the Web Form Designer.
<system.diagnostics.debuggerstepthrough()> Private Sub InitializeComponent()
End Sub
Protected WithEvents lstbox1 As System.Web.UI.WebControls.ListBox
Protected WithEvents lstbox2 As System.Web.UI.WebControls.ListBox
Protected WithEvents btnsubmit As System.Web.UI.WebControls.Button
Protected WithEvents btnremove As System.Web.UI.WebControls.Button
Protected WithEvents BtnBack As System.Web.UI.WebControls.Button
Protected WithEvents hdFieldNames As System.Web.UI.HtmlControls.HtmlInputHidden
'NOTE: The following placeholder declaration is required by the Web Form Designer.
'Do not delete or move it.
Private designerPlaceholderDeclaration As System.Object
Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
'CODEGEN: This method call is required by the Web Form Designer
'Do not modify it using the code editor.
InitializeComponent()
End Sub
#End Region
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'Put user code to initialize the page here
If Not Page.IsPostBack Then
'Dim sql_conn As New SqlConnection("server=mms-server2;uid=sa;pwd=miqaat098;database=bank_1.1")
Dim sql_conn As New SqlConnection("server=mms-server2;uid=sa;pwd=miqaat098;database=safe")
Dim str As String
Dim zRow As DataRow
sql_conn.Open()
Dim dset As New DataSet
Dim temp As String
temp = Session("temp")
Dim sql_cmd As New SqlCommand("select * from mms_dataitem_master", sql_conn)
' Dim sql_cmd As New SqlCommand("getfieldvalues", sql_conn)
' sql_cmd.CommandType = CommandType.StoredProcedure
'sql_cmd.Parameters.Add("@DataItemName", temp)
Dim sadapter As New SqlDataAdapter(sql_cmd)
' Dim sadapter As New SqlDataAdapter
' sadapter.SelectCommand = sql_cmd
sadapter.Fill(dset)
lstbox1.Items.Clear()
lstbox1.DataSource = dset
'For i = 0 To dset.Tables(0).Rows.Count
If lstbox1.Items.Count < 1 Then
For Each zRow In dset.Tables(0).Rows
'ListBox1.Items.Add(dset.Tables(0).DefaultView(0).Row.Item("name"))
lstbox1.Items.Add(zRow.Item(temp))
Next
End If
sql_conn.Close()
End If
End Sub
Private Sub btnsubmit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnsubmit.Click
If lstbox1.SelectedIndex < 0 Then
Me.btnsubmit.Attributes.Add("onclick", "return confirm('Are you sure you want to delete?');")
Else
Dim Item As ListItem = New ListItem
If lstbox1.SelectedIndex > -1 Then
Item.Text = lstbox1.SelectedItem.Value
Item.Value = lstbox1.SelectedItem.Text
lstbox1.Items.Remove(lstbox1.SelectedItem)
lstbox2.Items.Add(Item)
'concatinates the second list box values in a hidden texbox hdFieldNames
hdFieldNames.Value = hdFieldNames.Value & Item.Text & ","
End If
End If
End Sub
Private Sub btnremove_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnremove.Click
If lstbox2.SelectedIndex < 0 Then
Me.btnremove.Attributes.Add("onclick", "return confirm('Second ListBox Is Empty.Click On The Add Button To Insert an Item In The List');")
Else
Dim Item1 As ListItem = New ListItem
If lstbox2.SelectedIndex > -1 Then
Item1.Text = lstbox2.SelectedItem.Value
Item1.Value = lstbox2.SelectedItem.Text
lstbox2.Items.Remove(lstbox2.SelectedItem)
lstbox1.Items.Add(Item1)
End If
End If
End Sub
Private Sub BtnBack_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnBack.Click
Session("listitems") = hdFieldNames.Value
Response.Redirect("webform1.aspx")
End Sub
End Class
|
|
|
|
|
Hello,
I have a big problem.I have a page which has html and asp controls on it.COmplete validation is done using javascript.Now I have 2 dropdownlists one for countries and other for states.I should get the states based on the countries.So I have to set the autopostback of countries dropdownlist to true.The button that I have is submit button of html.the problem is how to write the code to update the data on the page.Right now I have the code in page load event.But as autopostback of countries dropdownlsit is true the page gets posted in between.So I cannot have the update code in the pageload.As the controls are html cotrols how do i write events for html.I cannot write javascript to update the database.It is very very urgent for my project.I need it badly.KIndly some one give me a solution for the problem.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
Oh well.. I have used some of the Aspose products and found them very good: