Re: Grid view Paging Issue - ASP.NET Discussion Boards

Rutvik Dave21-Jan-10 8:03

21-Jan-10 8:03

I know this is not the perfect solution, but you can apply this until you find another one.

Enable Sorting on the gridview and then handle the Sorting event.

inside that you will get a e.SortExpression. which is the Column name you clicked on.

Now call some method by passing it as parameter and return;.

I am not sure but most probably this will work.

Re: column selection of GridView

perreq21-Jan-10 8:19

perreq

21-Jan-10 8:19

thanks for the quick reply
that seems to be a good approach. I tried implement it but it doesn't invoke the action when i click on the grid.
have i forgot something? (I enabled sorting)

Re: column selection of GridView

Rutvik Dave21-Jan-10 9:45

Rutvik Dave

21-Jan-10 9:45

all you have to do is, AllowSorting = "true" and then handle the "Sorting" event (OnSorting="GridView1_Sorting"). and then click on the column names (it should be appeared as links) at the run time.

Re: column selection of GridView

kadaoui el mehdi21-Jan-10 8:14

kadaoui el mehdi

21-Jan-10 8:14

try this: http://quickstarts.asp.net/QuickStartv20/util/srcview.aspx?path=~/aspnet/samples/data/PagingSortingCallbacks.src[^]

HTML

<Columns>
<asp:HyperLinkColumn Text="View Member" DataNavigateUrlField="MemberID" DataNavigateUrlFormatString="/ViewMember.aspx?MemberID={0}"></asp:HyperLinkColumn>
</Columns>

protect excel sheet by password using OWC in C# - Exception from HRESULT: 0xE0040059 - Urgent

nishithrajn21-Jan-10 4:29

nishithrajn

21-Jan-10 4:29

I'm using OWC 11.0 in ASP.NET and C# to create excel file.

I need to protect/unprotect the sheet by a password. I tried to protect the sheet by following code.

string Password = "Password123";
object getPasswordFromUser =(object)Password;
xl.ActiveSheet.Protect(ref getPasswordFromUser, ref obj,
ref obj, ref obj, ref obj, ref obj, ref obj, ref obj, ref obj, ref obj,
ref obj, ref obj, ref obj, ref obj, ref objTrue, ref obj);

But it throws an exception "Exception from HRESULT: 0xE0040059"

Kindly help me to resolve this issue. Code works well if I miss the password.

Grid view Paging Issue

Amit Patel198521-Jan-10 3:26

Amit Patel1985

21-Jan-10 3:26

Hi All

I am using paging in grid view

<br />
    <asp:GridView ID="gridOrganizationDetails" runat="server" <br />
                    AutoGenerateColumns ="false" OnRowEditing ="gridOrganizationDetails_RowEditing"<br />
                OnRowDeleting ="gridOrganizationDetails_RowDeleting" CellPadding="7" <br />
                    onrowcreated="gridOrganizationDetails_RowCreated" AllowPaging="True" <br />
                    PageSize="1"><br />
                    <RowStyle ForeColor="#000066" /><br />
                    <FooterStyle BackColor="White" ForeColor="#000066" /><br />
                    <PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" /><br />
                    <PagerSettings Mode="NextPrevious" /><br />
                    <SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" /><br />
                    <HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" /><br />
                    <AlternatingRowStyle BackColor="#ffffff" /><br />
                    <AlternatingRowStyle BackColor="#ffffff" /><br />
                    <Columns><br />
                        <asp:BoundField HeaderText="Id" Visible ="true" DataField ="pk" /> <br />
                        <asp:BoundField HeaderText="Organization Name" Visible ="true" DataField ="name" />    <br />
                        <asp:BoundField HeaderText="Address 1" Visible ="true" DataField ="address1" />   <br />
                        <asp:TemplateField HeaderText="Active"><br />
                            <ItemTemplate><%# DisplayActive((Byte)Eval("is_Active"))%></ItemTemplate><br />
                        </asp:TemplateField>    <br />
                        <asp:CommandField ShowEditButton ="true" HeaderText ="Edit" <br />
                            HeaderStyle-HorizontalAlign ="Center" ItemStyle-HorizontalAlign ="Center" ><br />
                        <HeaderStyle HorizontalAlign="Center"></HeaderStyle><br />
<br />
                        <ItemStyle HorizontalAlign="Center"></ItemStyle><br />
                        </asp:CommandField><br />
                    </Columns><br />
                </asp:GridView><br />

in this i am following 3 tier architecture from Page i m calling business logic

from UI

<br />
 DataSet ds = myAction.GetOrganizationDetailsPaging(roleId, userId);<br />
        <br />
        //if (reader != null)<br />
        //{<br />
        gridOrganizationDetails.DataSource = ds;<br />
        gridOrganizationDetails.DataBind();<br />

in second layer

if (roleId == Convert.ToInt32(UserRole.Admin))
          {
              query = "Select * from organization";
          }
          else
          {
              query = "select * from organization orga , user us where (orga.pk =us.org_fk) and us.role_fk ='" + roleId + "'" + "and (us.pk ='" + userId + "')";

          }



          DbAction dbConnector = new DbAction();
          //MySqlDataReader reader = dbConnector.ExecuteReader(query);
          DataSet ds = new DataSet();
          ds = dbConnector.ExecuteDataSet(query);
          return ds;

from 3 layer i am returning the following thing

public DataSet ExecuteDataSet(String query)
       {
           DataSet ds = new DataSet();
           MySqlDataAdapter adapter = new MySqlDataAdapter(query, ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
           adapter.Fill(ds);

           return ds;
       }

if i m defiing page size 2 then only 2 record is coing and no paging option is coming
i am using My sql

thanks and regars
amit

Re: Grid view Paging Issue

Pranay Rana21-Jan-10 4:33

Pranay Rana

21-Jan-10 4:33

According to me if paging option is not coming than only 2 record is returned form the database try to run query in query analyzer and see the result

if not than plz try to provide more info

Re: Grid view Paging Issue

Rutvik Dave21-Jan-10 7:44

Rutvik Dave

21-Jan-10 7:44

Because you forgot to handle PageIndexChanging event of Grid View.

On that event you need to assign new page index to the gridview and then you need to bind the data set again.

i.e.

protected void gridOrganizationDetails_PageIndexChanging(object sender, GridViewPageEventArgs e)
{

gridOrganizationDetails.PageIndex = e.NewPageIndex;

//and then do databinding again.

ds = //set the ds here...;

gridOrganizationDetails.DataSource = ds;
gridOrganizationDetails.DataBind();
}

Re: Grid view Paging Issue

Amit Patel198521-Jan-10 18:58

Amit Patel1985

21-Jan-10 18:58

i checked from data base 10 record is coming.

and i also handle page index changing event

but still that footer is with record not coming.

Dynamically Changing EventHandlers in Web page

moon_stick21-Jan-10 3:13

moon_stick

21-Jan-10 3:13

I've already posted this on StackOverflow[^] but haven't seen much traffic yet...

I've got a web form (set in a master page) and want to check to see if the page has any changes before exiting (either by success or redirect). If any changes have been made, a dialog is displayed and the user can click ok or cancel.

I've created a panel to act as a dialog box (change z-layer, and apply shading and opacity to background) but my problem is in handling the click events from the buttons on the dialog. For a given exit scenario, I want to do something like:

protected void btnWelcomePage_Click(object sender, ImageClickEventArgs e)
{
    if (this.HasChanges())
    {
        lblDialogTitle.Text = "Confirm Exit";
        lblDialogMessage.Text = "Are you sure? Click OK to continue and lose any data entered";
        ClearEventHandlers(btnDialogOK);
        btnDialogOK_Click.Click += new EventHandler(btnDialogOK_Click);
        ClearEventHandlers(btDialogCancel);
        btnDialogCancel_Click += new EventHandler(btnDialogCancel_Click);
        pnlDialog.Visible = true;
    }
    else
    {
        Response.Redirect("~/WelcomePage.aspx");
    }
}

where the event handler for the buttons will do the appropriate work to hide the dialog and redirect if required.

My problem is that the EventHandler doesn't appear to bind between postbacks - setting a breakpoint in the Click event handler doesn't do anything; the page does an empty postback.

I assumed that the postback trashes the EventHandlers so I enabled ViewState on the buttons but to no avail. Can anyone suggest a model for handling this type of change? I've been searching through google but everything appears to relate to the dynamic creation of controls rather than the dynamic assignment of EventHandlers.

Thanks in advance

Dave

It definitely isn't definatley

Re: Dynamically Changing EventHandlers in Web page

Pranay Rana21-Jan-10 4:27

Pranay Rana

21-Jan-10 4:27

try to bind event with control when change are there in prerender event of the page

hope this will work because code did by you is right it should work

Re: Dynamically Changing EventHandlers in Web page

kadaoui el mehdi21-Jan-10 7:58

kadaoui el mehdi

21-Jan-10 7:58

to add controls (with eventhandlers) on pageweb you have to add it on page-init.

try this:

protected override void OnInit(EventArgs e)
    {
        base.OnInit(e);
        lblDialogTitle.Text = "Confirm Exit";
        lblDialogMessage.Text = "Are you sure? Click OK to continue and lose any data entered";
        ClearEventHandlers(btnDialogOK);
        btnDialogOK_Click.Click += new EventHandler(btnDialogOK_Click);
        ClearEventHandlers(btDialogCancel);
        btnDialogCancel_Click += new EventHandler(btnDialogCancel_Click);
    }

protected void btnWelcomePage_Click(object sender, ImageClickEventArgs e)
{
    if (this.HasChanges())
    {
    
        pnlDialog.Visible = true;
    }
    else
    {
        Response.Redirect("~/WelcomePage.aspx");
    }
}

good luck

Mehdi

Thread End

i gr821-Jan-10 3:02

i gr8

21-Jan-10 3:02

How to detect thread end,

Actually i want to give a message to the user after thread ends

Re: Thread End

J a a n s21-Jan-10 3:07

J a a n s

21-Jan-10 3:07

i gr8 wrote:
detect thread end

Which thread? Are you creating any new thread?
Can you please explain in detail?

"Never put off until run time what you can do at compile time."
- David Gries, in "Compiler Construction for Digital Computers", circa 1969.

Re: Thread End

Amit Patel198521-Jan-10 3:17

Amit Patel1985

21-Jan-10 3:17

if u creating Thread using Delegate then u child thread returns IAsyncResult which can we use to determinr whether thread is completed or not

Re: Thread End

i gr821-Jan-10 3:29

i gr8

21-Jan-10 3:29

only single thread

Alternate of File upload control

santosh_kum20-Jan-10 23:02

santosh_kum

20-Jan-10 23:02

Hi,

need a solution when i browse for 1 file in IE it returns the full path but in mozilla it returns only a file name

Thanks
www.myzonal.com

Re: Alternate of File upload control

nainakarri21-Jan-10 1:53

nainakarri

21-Jan-10 1:53

Hi

Not sure what code you are using, but you can try by using below tag

<input id="flExcel" runat="server" class="txt" style="width: 392px; height: 20px"<br />
                    type="file" unselectable="on" />

Regards
Naina

Naina

Web service call to get Yahoomail contacts

kokilaB20-Jan-10 21:27

kokilaB

20-Jan-10 21:27

How to Call webservice of Yahoo to get the Contact list..

I have created the Application ID and i am able to get the token value..

I need help to get the Webservice Session ID (wssid) to call webservice..

the code is as follows:

Dim auth As New Yahoo.Authentication("XXXXXXXXX-", "XXXXXXXXXX")
Session("Auth") = auth
Dim success As Boolean = False

If Not Session("Auth") Is Nothing Then
auth = DirectCast(Session("Auth"), Yahoo.Authentication)
End If

If (Not Request.QueryString("token") Is Nothing) _
AndAlso Request.QueryString("token").Length > 0 Then

' Make sure the call is valid
If auth.IsValidSignedUrl(Request.Url) = True Then

success = True

' Save the user token. It is valid for two weeks
auth.Token = Request.QueryString("token")

StackedBar100

yesu prakash20-Jan-10 20:35

yesu prakash

20-Jan-10 20:35

Hi,
How to create a StackedBar100 chart using microsoft chart control.

Thankyou
YPKI

XLS to XSL:FO

Venkat Eswaran20-Jan-10 20:07

Venkat Eswaran

20-Jan-10 20:07

Hi everyone,
How can i convert excel spreadsheet (xls file) to XSL:FO, in asp.net

Thanks,
Venkat

Venky

Problem triangular calling c#->javascript->c# on single click of search button [modified]

Vishnu Narayan Mishra20-Jan-10 19:43

Vishnu Narayan Mishra

20-Jan-10 19:43

Hi To all forum members,

I have a search button which search records in the form, then I have to call a java script which return some values, on the base of these values I have I Have to populate Grid View.
Actually
when I clicked on search button
I) It hits to database and takes records and
II) These records are passed to java script
III) Then java script returns a value location.

On the base of java script values and code behind search criteria values i Have to populate grid view.
I am using asp.net and c# technology.
How can achieve all three steps by single click of search button.

Even i am unable to populate grid on form refresh from that java script code.

All three steps I have to perform in Single click on Search button.
~~I achieved this but I have to click search button twice.~~

Vishnu Narayan Mishra
Software Engineer

modified on Thursday, January 21, 2010 1:53 AM

Re: Problem triangular calling c#->javascript->c# on single click of search button

Brij20-Jan-10 20:10

Brij

20-Jan-10 20:10

Why do you want to roundtrip?Why dont you try to simulate the javascript thing in c# itself?it'll also improve the performance.

Cheers!!
Brij

Re: Problem triangular calling c#->javascript->c# on single click of search button

Pranay Rana20-Jan-10 20:49

Pranay Rana

20-Jan-10 20:49

if you want to do this thing in one go than only one solution is there

use ajax mecanism for that or use jquery ajax which work for you easily in javasript.

gridView

jojoba201020-Jan-10 19:35

jojoba2010

20-Jan-10 19:35

how to shape a gridview in ASP.net (C# Coding ) same as Forum.
I wanna to have forum with GridView.(but with all other Forum Shape)

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.