|
Convert your price field to integer in the query...
SELECT Your_Fields FROM Your_Table WHERE Your_Condition ORDER BY CAST(Your_Field AS INT)
EVEN THE WORD IMPOSSIBLE SAYS I M POSSIBLE.
|
|
|
|
|
The problem is that I'm using the SortExpression property of the gridview's databound item. The sortExpression property only takes that column name to be sorted so how can I add this Cast(field As Int)??
|
|
|
|
|
Try casting in your select
select column1, column2,CAST(columnn3 AS INT) as column3 from table
This will return an int column to your grid, problem solved.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
EVEN THE WORD IMPOSSIBLE SAYS I M POSSIBLE.
|
|
|
|
|
Got It
CAST In Your Select Sql Query
Select field1,CAST(Price AS INT) As Price,.......
EVEN THE WORD IMPOSSIBLE SAYS I M POSSIBLE.
|
|
|
|
|
Thanks a lot, I think this is gonna work.
|
|
|
|
|
Thats what I said - do the cast in the query, it then returns the correct datatype.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Your design is broken. Why you need to keep prices in NVarchar field ? How are you binding this grid view ? Using a DataTable ? If yes, after filling the data table, change the column type to integer or double. So gridview can sort it correctly.
|
|
|
|
|
I need to know how can I bind my gridview from a pop up window?
I have a gridview on a parent page and then a user can open a pop up window to perform some changes on the gridview in the parent page after that he closes the window. Right then I need to bind the gridview on the parent page to view the changes that the user did from the pop up window.
How can I do that?
|
|
|
|
|
OK so you want the following to happen:
User views gridview in mainpage
user edit gridview in new window
user views gridview in mainpage with updated values.
The thing is when the new window closes its not very easy to navigate a user back to the mainpage and then refresh that page to reflect the new changes.
Instead of opening a new window(which may be blocked by pop-up blocker) keep them in the same window and user query string to transfer the values.
|
|
|
|
|
thanks for the repy, but there is no way I can do all the editing on the same page. The only way is to use a pop up window.
Is there any other solution for this?
|
|
|
|
|
No, because as soon as you open a pop-up window your application is split in two and they can now continue navigating around the mainpage even with the pop-up open.
best to keep it all in the same window anyway
|
|
|
|
|
public partial class Default2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string s17 = Request.Form["scheck"].ToString();
scheck.Value = s17;
Response.Write(s17);
string s18 = Request.Form["sacc1"].ToString();
sacc1.Value = s18;
Response.Write(s18);
string s19 = Request.Form["schild"].ToString();
schild.Value = s19;
Response.Write(s19);
string s = Session["child"].ToString();
//Response.Write(s);
//Response.Write(s19);int.Parse(Request.Form["schild"])==1
if (int.Parse(s19)== 1)
{
Session["a"] = ctcchild1.name;
Session["b"] = ctcchild1.age;
Session["c"] = ctcchild1.college;
}
else if (int.Parse(s19)==2)
{
Session["d"] = ctcchild2.name;
Session["e"] = ctcchild2.age;
Session["f"] = ctcchild2.college;
}
//else
//{
else if (2<int.parse(s19)><= 3)
{
Session["g"] = ctcchild3.name;
Session["h"] = ctcchild3.age;
Session["i"] = ctcchild3.college;
}
else if(int.Parse(s19) == 4)
{
Session["j"] = ctcchild4.name;
Session["k"] = ctcchild4.age;
Session["l"] = ctcchild4.college;
}
how to apply condition at this place
plz tell me
thanks
|
|
|
|
|
what do you mean by
gaurav mangal wrote: how to apply condition at this place
|
|
|
|
|
gaurav mangal wrote: if (int.Parse(s19)== 1)
{
Session["a"] = ctcchild1.name;
Session["b"] = ctcchild1.age;
Session["c"] = ctcchild1.college;
}
else if (int.Parse(s19)==2)
{
Session["d"] = ctcchild2.name;
Session["e"] = ctcchild2.age;
Session["f"] = ctcchild2.college;
}
//else
//{
else if (2<int.parse(s19)><= 3)
{
Session["g"] = ctcchild3.name;
Session["h"] = ctcchild3.age;
Session["i"] = ctcchild3.college;
}
else if(int.Parse(s19) == 4)
{
Session["j"] = ctcchild4.name;
Session["k"] = ctcchild4.age;
Session["l"] = ctcchild4.college;
}
if you have conditions like this, how would u retrieve correct data back from Session ???
apr ~ asp
|
|
|
|
|
then plz tell me what should i do.
|
|
|
|
|
actually i am taking value from one page to other page using sessions .
but i want at secont page that if the value of session["s1"] ==2 to webcontrol should be generate two times.and it ==3 then usercontrols should be generate 3 times .so i have to apply condition :
if(session["s1"]==1)
{
}
if(1<session["s1"]><=2)(error)
{
}
now i get error:
Operator '|' cannot be applied to operands of type 'bool' and 'int'
what should i do.
thanks
|
|
|
|
|
gaurav mangal wrote: if(1<session["s1"]><=2)
That if condition is totally wrong!
I'm not able to understand what you are trying to do here.
Can you please explain?
EVEN THE WORD IMPOSSIBLE SAYS I M POSSIBLE.
|
|
|
|
|
thanks for the response.
actually i want that if a user select 2 from dropdownlist or 3 or 4 .
then at second page 2 or 3 or 4 usercontrol will create .so i have
tha value of dropdownlist in sessions .
and want to apply condition on that .
this is the code .
or you suggest what should do.
public partial class Default2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string s17 = Request.Form["scheck"].ToString();
scheck.Value = s17;
Response.Write(s17);
string s18 = Request.Form["sacc1"].ToString();
sacc1.Value = s18;
Response.Write(s18);
string s = Session["child"].ToString();
//Response.Write(s);
//Response.Write(s19);int.Parse(Request.Form["schild"])==1
if (int.Parse(s)== 1)
{
Session["a"] = ctcchild1.name;
Session["b"] = ctcchild1.age;
Session["c"] = ctcchild1.college;
}
else if (1<int.parse(s)><=2)(error)
{
Session["d"] = ctcchild2.name;
Session["e"] = ctcchild2.age;
Session["f"] = ctcchild2.college;
}
//else
//{
else if (2<int.parse(s)><=3)(error)
{
Session["g"] = ctcchild3.name;
Session["h"] = ctcchild3.age;
Session["i"] = ctcchild3.college;
}
else if(int.Parse(s19) == 4)
{
Session["j"] = ctcchild4.name;
Session["k"] = ctcchild4.age;
Session["l"] = ctcchild4.college;
}
|
|
|
|
|
I'm not able to understand why you are doing in this way.
How do you know that total number of user controls you are creating.
Because, if you are using if there always will be a limit.
Why cant you do something like below
<br />
int totalControl=0;<br />
if(Session["child"]!=null)<br />
{<br />
totalControl=int.Parse(Session["child"].ToString());
for(int curControl=0;curControl<totalcontrol;curcontrol++)><br />
{<br />
}<br />
}<br />
EVEN THE WORD IMPOSSIBLE SAYS I M POSSIBLE.
|
|
|
|
|
Sherin Iranimose wrote: totalControl=int.Parse(Session["child"].ToString());//Should be always contain numbers in session.
If you aren't sure about the session content, the above method is not secure as it may throw "FormatException" if session has an invalid value. Here is a safe method
if(int.TryParse(Session["child"].ToString(),out totalControl))
{
}
|
|
|
|
|
Thanks Sherin
its working .ya you are right .plz tell now how i can take the values from user controls .and how i can retrive the values at next page .
but the condition is same .if 2 is selected then only two user control should be appear and values of these user control go to the next page.
plz send me the code
Thanks .....Again
gaurav
|
|
|
|
|
at next page i want tha values of user control should be appear in a table .i have set property in usercontrol .aspx.cs page .
|
|
|
|
|
Hi
I have some video file located on server.I want to show thumbnail of these wmv file in my web application.Now my problem is that i don't know how to create thumbnail from wmv file.
If anybody know Please reply me at ankit_jain26@rediffmail.com
Thanks
|
|
|
|
|
Hi All
I have some problem,i am working on chat application,and want to create
Push server ,can any one give me some idea or link ,how to create push server in dot net (For pooling data from client to server) ,i hope u guys understand the problem.
Thanks
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
