Sorting changed it's order when click edit button and go to next page through paging ! - ASP.NET Discussion Boards

Hi all
iam developing a search page where the user can enter and select from different dropdownlists to construct the select statement. The user can add several rows(search criteria). I want to maintain the criteria the users chooses, lets say he selects first criteria and second or third. To save the criteria i have inserted a grid and what i want is to insert to this grid as rows. Each time the user chooses criteria he presses Add and this criteria is saved temporarly in the grid so i can upon pressing search to collect all criteria in one big select statement and do the search. How can i insert/delete to this grid?

You can save a DataTable in viewstate. Add a new row to your Datatable and then rebind the grid.

I didn't get any requirements for the signature

Hi
I would like to pass a variable from a gridview hyperlink to the next page
how woudl i do this
thanks

You can pass it in querystring.

please don't forget to vote on the post that helped you.

i have the following code
it displays the variable in the browser but no data is displaying

Page1:

asp:HyperLinkField DataNavigateUrlFields="Item_Ref" DataTextField="Item_Ref" HeaderText="Link" SortExpression="Item_Ref" DataNavigateUrlFormatString="~/Main/RoomCompdets.aspx?firstvar={0}" Target="_blank" />

Page 2

<asp:sqldatasource id="SqlDataSource1" runat="server" connectionstring="">]]>" SelectCommand="SELECT [ADB_Ref] FROM [item_descriptions] WHERE ([ADB_Ref] = @FirstVar)">
<selectparameters>
<asp:sessionparameter name="Firstvar" sessionfield="firstvar">

<asp:gridview id="GridView4" alternatingrowstyle-forecolor="black" rowstyle-forecolor="black" alternatingrowstyle-font-size="Large" runat="server" allowpaging="True" autogeneratecolumns="False" datasourceid="SqlDataSource1">
<columns> <asp:boundfield datafield="ADB_Ref" visible="true" headertext="ADB_Ref">

any help would be great

thanks

sorted it

Hello Genious..

I have some word files on server.. that i need to download all of them together..
So i have only one option that first i create a zip file from all these files and then then download this zip file..

So my functionality achived.

But when i extract these zip file and opens word any of word files within downloaded zip file, Opened Word file shows only byte data means some thing like lots of Sqaures which may be same as bytes of files..
and obeviously word file should display actual content in readable character..

Any Suggestons will appreciated...

If needed the please refer to my code..

For i As Integer = 0 To strFileToDownload.Count - 1

Dim strFileName As String = Path.GetFileName(strFileToDownload(i))
Dim MyFileStream As FileStream = File.OpenRead(strFileToDownload(i))
Dim buff() As Byte = New Byte((MyFileStream.Length)) {}
'Dim zipEntry As New ZipEntry(strFileToDownload(i))
Dim zipEntry As New ZipEntry(strFileName)
zipOS.PutNextEntry(zipEntry)
zipOS.Write(buff, 0, buff.Length)
zipOS.InitializeLifetimeService()
MyFileStream.Close()
Next
' Compress and close the zip file
zipOS.Finish()
zipOS.Close()

Response.ClearContent()
Response.ClearHeaders()
Response.ContentType = "application/zip"
Response.AddHeader("Content-Disposition", "attachment; filename=" + "CMM " + strProjectSize + " size Project Documents" + System.IO.Path.GetFileName(strNow))
Response.WriteFile(strNow)
Response.Flush()
Response.Clear()

I can sort a column on the first page,but when i go to second page through paging sorting changed it's order.
Another problem is When i click Edit button,sorting is changed as a result data are also changed for which i can't edit the actual row rather i see a different data on the same row to be updated.

Here is my code...

<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
OnPageIndexChanging="pagemethod" OnSorting="sortmethod" OnRowEditing="editmethod"
AutoGenerateColumns="False" PageSize="4" >

<Columns>
<asp:CommandField HeaderText="Edit" ShowEditButton="True" ButtonType="Button" />

<asp:TemplateField HeaderText="Name" SortExpression="Name">

<ItemTemplate><%#Eval("Name")%></ItemTemplate>

<EditItemTemplate>
<asp:TextBox ID="txtname" runat="server" Text='<%# Eval("Name") %>'></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>

protected void Page_Load(object sender, EventArgs e)

{
if (!IsPostBack)
{
BindGridView();
}

}

public void BindGridView()

{
DataSet ds = new DataSet();
ds=binddata();
GridView1.DataSource = ds;
GridView1.DataBind();
}

public DataSet binddata()

{
SqlConnection con = new SqlConnection("Server=.;database=emp;uid=sa;pwd=;");
SqlDataAdapter da = new SqlDataAdapter("select * from job", con);
con.Open();
DataSet ds = new DataSet();
da.Fill(ds, "emp");
return ds;
}

public void sortmethod(object sender, GridViewSortEventArgs e)

{
ViewState["sortcolumn"] = e.SortExpression;

if (ViewState["sortorder"] == null)
{
ViewState["sortorder"] = "asc";
}
ViewState["sortorder"]=ViewState["sortorder"].ToString() == "asc"?"desc":"asc";

DataView dv = new DataView(binddata().Tables[0]);
dv.Sort = ViewState["sortcolumn"] + " " + ViewState["sortorder"];
GridView1.DataSource = dv;
GridView1.DataBind();
}

public void pagemethod(object sender, GridViewPageEventArgs e)

{
GridView1.PageIndex = e.NewPageIndex;
GridView1.EditIndex = -1;
BindGridView();

}

public void editmethod(object sender, GridViewEditEventArgs e)

{
GridView1.EditIndex = e.NewEditIndex;
BindGridView();

}

try this code<br />
protected void Page_Load(object sender, EventArgs e)<br />
<br />
{<br />
if (!IsPostBack)<br />
{<br />
BindGridView();<br />
}<br />
<br />
}<br />
<br />
public void BindGridView()<br />
<br />
{<br />
DataSet ds = new DataSet();<br />
ds=binddata();<br />
DataView dv = new DataView(ds.Tables[0]);<br />
if(ViewState["sortcolumn"] != null &&  ViewState["sortorder"] !=null)<br />
{<br />
	dv.Sort = ViewState["sortcolumn"] + " " + ViewState["sortorder"];<br />
}<br />
GridView1.DataSource = dv;<br />
GridView1.DataBind();<br />
<br />
}<br />
<br />
public DataSet binddata()<br />
<br />
{<br />
SqlConnection con = new SqlConnection("Server=.;database=emp;uid=sa;pwd=;");<br />
SqlDataAdapter da = new SqlDataAdapter("select * from job", con);<br />
con.Open();<br />
DataSet ds = new DataSet();<br />
da.Fill(ds, "emp");<br />
return ds;<br />
}<br />
<br />
<br />
<br />
public void sortmethod(object sender, GridViewSortEventArgs e)<br />
<br />
{<br />
ViewState["sortcolumn"] = e.SortExpression;<br />
<br />
if (ViewState["sortorder"] == null)<br />
{<br />
ViewState["sortorder"] = "asc";<br />
}<br />
ViewState["sortorder"]=ViewState["sortorder"].ToString() == "asc"?"desc":"asc";<br />
BindGridView();<br />
}<br />
<br />
<br />
public void pagemethod(object sender, GridViewPageEventArgs e)<br />
<br />
{<br />
GridView1.PageIndex = e.NewPageIndex;<br />
GridView1.EditIndex = -1;<br />
BindGridView();<br />
<br />
}<br />
<br />
public void editmethod(object sender, GridViewEditEventArgs e)<br />
<br />
{<br />
GridView1.EditIndex = e.NewEditIndex;<br />
BindGridView();<br />
<br />
<br />
}

please don't forget to vote on the post that helped you.

Hello

Can anybody let me know how to do Edit,Update and Insert in DetailsView programatically.

Wafy

http://msdn2.microsoft.com/en-us/library/s3w1w7t4.aspx[^]

*jaans

Hi,

I am developing website that contains the flash file on home page.
And that flash file reads the images based on xml file.

In admin panel, administrator can select images that can be showed in flash file.

After changing xml file(server side), that is not reflected to the front end because xml file is cached.

To see the changed images, i must close the window and start new session.

Plz help me Confused | :confused:

Thanks in advance.

Hi,
I have a simple application which generates Excel reports. I use Response.BinaryWrite() to write whatever excel content i have to the client (client is prompted to save). I need to change some status message on my webpage after the excel generation process. However, this cannot be done since Response.Binary just flushes the excel file to the client and that's it.. Can someone plz suggest a way i could get the status changed prior the excel generation process plz?

Thank you

Carpe diem,
Krg

try write some client-side script in response to clientclick event

SkyWalker

Hi
I have created a sqldatasource with connection string details in and select statement
I want the select statement to work off two variables which would be declared like so

<selectparameters>
<asp:sessionparameter name="SSID" sessionfield="SSID" type="String">

How would i carry a session over from a previous page and put it in the code above?

thanks

hello
i am using asp.net 2.0 with c#.
in that i want to use treeview control.
i want to add nodes and when click on node that time navigate page will open.which is display beside of treeview.
pls help me
its really urgent
gayatri

string js = "<script language='javascript'>alert(ok);</script>";<br />
        Page.RegisterStartupScript("js", js);

The above code is not displaying any error.and not even displaying the messagebox.

Yesterday is a canceled check. Tomorrow is a promissory note. Today is the ready cash. USE IT.

Sonia Gupta wrote:
Page.RegisterStartupScript("js", js);

<br />
string js = "alert(ok);";<br />
Page.ClientScript.RegisterStartupScript(this.GetType(),"key",js,true);<br />
<br />
or<br />
<br />
string js = "<script language="javascript">alert(ok);</script>";<br />
Page.ClientScript.RegisterStartupScript(this.GetType(),"key",js);

please don't forget to vote on the post that helped you.

<br />
//TRY ?<br />
alert('ok');<br />

Hi friends.

I need to convert html string to image.

Can anybody help me regarding this?

Thanks in advance.

please don't forget to vote on the post that helped you.

Use Google

<asp:RadioButtonList ID="rdDateSelection" visible="true" AutoPostBack="true" runat="server" RepeatDirection="vertical" >
<asp:ListItem Value="Today">Today</asp:ListItem>
<asp:ListItem Value="FromToDate">From </asp:ListItem>
</asp:RadioButtonList>

through javascripting i want ot find out which radio the user has clicked .

var value=rdDateSelection.Options[rdDateSelection.selectedIndex].value;<br />
//Check value<br />
if(value=="Today")<br />
//do something here<br />
else <br />
//here

please don't forget to vote on the post that helped you.

Options is giving null some error

Get a idea from following script

SCRIPT LANGUAGE="JavaScript">
function testButton (form){
for (Count = 0; Count < 3; Count++) {
if (form.rad[Count].checked)
break;
}
alert ("Button " + Count + " is selected");
}

onClick="testButton(this.form)">

$Shucks | :-\$