|
|
Hi All
I have a datagrid & I want it to be sorted when the user clicks on the column header..How can I do that??
Thanks a lot in advance 
Happy
|
|
|
|
|
it's very simple
use this function in your class file or at code behind
public void BindGrid(DataTable dt, DataGrid dg, string sortexpression, string order)
{
try
{
if (dt.Rows.Count > 0)
{
DataView dv;
dv = dt.DefaultView;
if (sortexpression != "")
{
if (order == "desc")
dv.Sort = sortexpression + " DESC";
else
dv.Sort = sortexpression;
}
dg.DataSource = dv;
dg.DataBind();
}
}
catch (Exception ex)
{
clsLog.WriteLog(ex.Message);
throw ex;
}
}
where, argument1=datatable object where you hv stored the data which you would like to display
2.argument2=your datagrid id
3.argument3=variable(here u cn take sortexpression which you will declare at the beginning like this private string sortexpression = "";)
4.argument4= Convert.ToString(ViewState["order"])
now on click of column_header event write the code
LinkButton lnkbtn;
lnkbtn = (LinkButton)sender;
if (Convert.ToString(ViewState["order"]) == "Asc")
{
ViewState["order"] = "desc";
}
else
{
ViewState["order"] = "Asc";
}
if (lnkbtn.Text == "1st column headername")
{
sortexpression = "1st column headername";
}
if (lnkbtn.Text == "2ndcolumn headername")
{
sortexpression = "2ndcolumn headername";
}
fillgrid();
(i think u know what to write in this function here just bind ur grid and one more thing in this function call the sort function with required paramts mentioned above)
deepti
|
|
|
|
|
|
Change the allowSorting datagrid property to true
go to Columns property, select the field what you want to sort, write onto the SortExpression the same column datafield.
On datagrid sorting function
<br />
protected void Grid_Sorting(object sender, GridViewSortEventArgs e)<br />
{<br />
string sql = "SELECT * FROM table WHERE conditions ORDER BY " + e.SortExpression;<br />
SqlDataAdapter data_Adapter = new SqlDataAdapter(sql, conexxxion);<br />
DataSet dataSet = new DataSet();<br />
data_Adapter.Fill(dataSet);<br />
Grid.DataSource = dataSet.Tables[0].DefaultView;<br />
Grid.DataBind();<br />
}<br />
you can do it with all datagrid columns
![Rose | [Rose]](https://www.codeproject.com/script/Forums/Images/rose.gif)
keep Learning and you never will be out of date...
|
|
|
|
|
hai friends
im doing asp web application project using c#.net.first step in that is registration form.it will contain username,emailid and country. u fill that form and click submit button.the output is automatically generate the password and pass the your username and password through entered emilid of user.this and all i done.if the user not use the password and username within 24 hours, that record should be detele automatically, how can i do that, can anyone help me
thanks
Dhatchinamoorthy.R
9894824838
|
|
|
|
|
There needs to be some scheduler service that runs in the webserver, which needs to do these maintenance jobs.
|
|
|
|
|
I want to upload image file(only .jpg, .gif, .png) on server.
But according to requirement I've to use image button to browse file.
After selecting file, on "Save Changes" button i've to upload image to server
I'm not able to display File dialog on click event of ImageButton.
Please Help..! I'm new in the .Net.
Thanks In Advance...!
|
|
|
|
|
The simple answer is 'You can not'. The only FileOpen dialog you get is 'Browse' using , which creates a textbox and a button. Anything else might need ActiveX.
|
|
|
|
|
Hi
i want to Extract the zip File. For this i m using Csharb Ziplib Library. i tried with that it extract it but its not extracting the whole zip into folder..Pls Tell me how i can achieve this..
Thanks and Regards
Aavesh
|
|
|
|
|
Any specific errors being encountered?
|
|
|
|
|
NO,i didn't get any error while proces...But its not working properly..pls Tell me what shuld i do
Suggest me..its urgent..
Thanks & Regards
Aavesh Agarwal
|
|
|
|
|
Hi All,
Iam having aproblem with export to Excel. What i want to do is that, I want to export the contents of a datagrid to excel-The features should be
1. Open,Save and Cancel Buttons
2. The Excel spreadsheet should be formatted to the best fit width for all
cols with header in a font Arial, SIze 10, Bold, White text color,and
Blue backcolor for the heading
3. The Excel File need only to contain only one sheet with name say 'AAA'.
Kidly put in ur suggestions and Plz help to solve this out.
Thank u.
Regards,
jeeva
|
|
|
|
|
I met this problem several weeks before. i recommend u to use xsl, this article [^] does help me a lot!
wish u could succeed!;P
Regards,
Steven
|
|
|
|
|
Hi Steven,
Thanks for the link.
I did try it out as per ur link but its for VS.NET-2005 but i need it for 2003. Some functions are not compatible in this version.
Plz Help.
Regards,
Jeeva
-- modified at 2:59 Saturday 14th October, 2006
|
|
|
|
|
I see,it is XslCompiledTransform, in vs2003 we use XslTransform instead of it. In the FAQ of that article there is some detailed info about it(its name is "Net 1.1 version").;P
Regards
Steven
|
|
|
|
|
Thanks Steven.
I got the program working but i wasn't used to the XSL. After go'g thru the necessary docs i became somewhat familiar with that too.
Still the data from the dataset is not getting populated in the Excel sheet. As I went thru the XSl doc i came to know that
"<xsl:for-each select="NewDataSet/Table">"
The select keyword will select data from each inner node as per the depth specified. But here instead of XML file we are using dataset.
"<xsl:value-of select="ProductID"/>"
The select in here ---say "ProductID" IS it the field names that should be given as per our select commnd.
Is my problem something to do with the above.
Can u Plz suggest a possible solution for the same.
Thanks & Regards,
Jeeva
|
|
|
|
|
dataset is ok, i am just using dataset, u could use:
strExcelFile= objExport.TransformDataTableToExcel(ds.datatable(i),True)
objExport.SendExcelToClient(strExcelFile)
Also u have to have some polishment of ExcelExport.vb so as to run it in vs2003.
If u have any more question, u could sent email to me.
wish u could succeed!;P
Regards,
Steven
|
|
|
|
|
hi!
can some one guide me how to get value from the column of a dataset as we get from datareader(i-e dr["String column name"])
thanks in advance
regards
shezi
|
|
|
|
|
You can get that like this:
dataset.Tables[0].Rows[0][0].ToString();
This will give you the value of the first column of the first row of the dateset.
Best Regards,
Apurva Kaushal
|
|
|
|
|
u can use
dataset.table["table name"].Rows[row number]["column name"];
rahul
|
|
|
|
|
private string GetWebContent()
{
string fullpath = @"http://www.google.com";
HttpWebRequest webreq = (HttpWebRequest)System.Net.WebRequest.Create(fullpath);
HttpWebResponse webresp = (HttpWebResponse)webreq.GetResponse();
StreamReader strm = new StreamReader(webresp.GetResponseStream(), Encoding.ASCII);
String text = strm.ReadToEnd();
strm.Close();
return text;
}
This is my code. it works well on my own computer, but when i put in my office computer, there is a WebException:
"The underlying connection was closed: Unable to connect to the remote server."
why? is it because the setting of firewall in the office server or something.
Thanks very much
|
|
|
|
|
It uses system IE settings. Are you able to use google.com in your office computer.
And IE profiles might interfere too.
|
|
|
|
|
Thanks.
i can use www.google.com in my office computer through IE.
and i do not understand "And IE profiles might interfere too"
could you explain it for me, and how to fix it then?
|
|
|
|
|
hello,
while converting a vb.net application to c#, one pagechangedeventhandler event in vb.net application gives error in C# . Also overridden finally method also gives error in C# and suggest to provide destructor. But also not allow to declare destructor in an abstract class.
I have converted vb code to C# . but not able to run the application due to above errors.
plz help
regards,
max
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
