Order by - ASP.NET Discussion Boards

You're welcome

My postings are a natural product. The slight variations in spelling and grammar enhance their individual character and beauty and are in no way to be considered flaws or defects.

Hi everyone,

I have the following web method as shown below. Can anyone tell me how can i call this web method in an asp.net webpage? The result that i want to obtain from calling this web method would redirect me to another web page. thanks in advance.

[WebMethod]
public int DoIT()
{

// Get the hostname
string myHost = System.Net.Dns.GetHostName();

string connect = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=C:\\inetpub\\wwwroot\\Request\\App_Data\\TV.mdb";
string query = "SELECT COUNT(IPAddress) FROM Request WHERE IPAddress = ?";
int result = 0;

using (OleDbConnection conn = new OleDbConnection(connect))
{
using (OleDbCommand cmd = new OleDbCommand(query, conn))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("IPAddress", myHost);

conn.Open();
result = (int)cmd.ExecuteScalar();
}
}

return result;

}

If you want to call the WebService from the client then you can use ASP.NET AJAX for this, check this links:

http://www.asp.net/ajax/
http://www.asp.net/ajax/documentation/live/
http://www.asp.net/AJAX/Documentation/Live/tutorials/ASPNETAJAXWebServicesTutorials.aspx

Use AJAX PageMethods to access them.

Hi, I have an web application. I am lossing sessions and static variables become null if i use the following code in my application.

public string _xmlfilepath = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "App_Code\\Culture.xml");
public string _userfilepath = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "Users");

Even when i am using this code...the sessions are lost

_userfilepath = Request.PhysicalApplicationPath + "Users\\";
_xmlfilepath = Request.PhysicalApplicationPath + "App_Code\\Culture.xml";

If i use this code then its working fine.
Adding paths in web.config

<add key="UserPath" value="F:\MyFolder\Users\" />
<add key="CultureXML" value="F:\MyFolder\Admin\Culture.xml" />

Later i am retirving those paths in application

public string _userfilepath = ConfigurationManager.AppSettings["UserPath"];
public string _xmlfilepath = ConfigurationManager.AppSettings["CultureXML"];

But I dont know the drive names etc at client location to place my application. If i use the appdomain code then where ever this code placed the files will create in that directory itself. But the problem is i am loosing sessions and static variables becoming null. Due to this exceptions are arising.

How can i overcome this issue?

G. Satish

Did you try Server.MapPath() function?

http://msdn.microsoft.com/en-us/library/ms524632.aspx[^]

Parwej Ahamad
ahamad.parwej@gmail.com

Yes. I tried now by using Server.MapPath(). But still same problem loosing sessions and static variables becoming null.

G. Satish

Dear Experts

I have gridview with bound with objectDatasource. I want to order by all the results with date. I can not see the property of objectdatasource that can order the result by date. I am waiting for your help please

My code is give as

<asp:ObjectDataSource id="odsCaseMovement" runat="server" OldValuesParameterFormatString="original_{0}"
               TypeName="Atlas.Core.ObjectDataSource.odsV_CaseEnquiry" SelectMethod="odsLoadCaseByBarCode" OnSelected="odsCaseMovement_Selected">
               <SelectParameters>
                   <asp:ControlParameter ControlID="txtCaseBarcode" Name="par_caseBarcode" PropertyName="Text"
                       Type="String" />
               </SelectParameters>
           </asp:ObjectDataSource>

The gridview is

<acc:AtlasGrid id="grvCaseMovement" runat="server" Width="98%" CssClass="GridTable" DataSourceID="odsCaseMovement" PageSize="20"
                AllowSorting="True" AllowPaging="True" AutoGenerateColumns="False" OnRowDataBound="grvCaseMovement_RowDataBound">
               <RowStyle CssClass="list_row" />
               <PagerTemplate>
                   <div style="width: 100%; text-align: center;">
                       <asp:LinkButton CommandName="Page" CommandArgument="First" ID="LinkButton1" runat="server"
                           Style="color: black">&lt;&lt; First</asp:LinkButton>
                       <asp:LinkButton CommandName="Page" CommandArgument="Prev" ID="LinkButton2" runat="server"
                           Style="color: black">&lt; Prev</asp:LinkButton>
                       [Records
                       <%= grvCaseMovement.PageIndex * grvCaseMovement.PageSize + 1%>
                       -
                       <%= grvCaseMovement.PageIndex * grvCaseMovement.PageSize + grvCaseMovement.Rows.Count%>
                       Of
                       <%= Atlas.Core.ObjectDataSource.odsV_CaseEnquiry.rowCount%>
                       ]
                       <asp:LinkButton CommandName="Page" CommandArgument="Next" ID="LinkButton3" runat="server"
                           Style="color: black">Next &gt;</asp:LinkButton>
                       <asp:LinkButton CommandName="Page" CommandArgument="Last" ID="LinkButton4" runat="server"
                           Style="color: black">Last &gt;&gt;</asp:LinkButton>
                   </div>
               </PagerTemplate>
               <Columns>
                   <asp:BoundField DataField="ID" HeaderText="Case ID" Visible="False" />
                   <asp:BoundField DataField="Barcode" HeaderText="Case Barcode" SortExpression="Barcode" />
                   <asp:BoundField DataField="OriginalDate"  HeaderText="Date Generated" SortExpression="OriginalDate" DataFormatString="{0:dd/MM/yyyy}"  />
                    <asp:BoundField DataField="Date" HeaderText="Delivery Date" DataFormatString="{0:dd/MM/yyyy}" />
                   <asp:BoundField DataField="AccountName" HeaderText="Account Name" />
                   <asp:BoundField DataField="AccountNumber" HeaderText="Account Number" />
                   <asp:BoundField DataField="Loaded" HeaderText="Date &amp; Time Loaded" DataFormatString="{0:dd/MM/yyyy HH:mm:ss}" />
                   <asp:BoundField DataField="POD" HeaderText="Date &amp; Time Delivered" SortExpression="POD" DataFormatString="{0:dd/MM/yyyy HH:mm:ss}" />
                   <asp:BoundField DataField="State" HeaderText="Status" SortExpression="State" />
                   <asp:BoundField DataField="Name" HeaderText="Drop Point" SortExpression="Name" />
                   <asp:BoundField DataField="RouteNumber" HeaderText="Route Number" SortExpression="RouteNumber" />
                   <%--<asp:BoundField DataField="Returning" HeaderText="Job Type" SortExpression="Returning" /> --%>

                    <asp:TemplateField HeaderText="Job Type">
                       <ItemTemplate>
                           <asp:Label ID="lblJobType" runat="server" Text='<%# Eval("Returning")%>' ></asp:Label>
                       </ItemTemplate>
                   </asp:TemplateField>

                   <asp:TemplateField HeaderText="Asset">
                   <ItemTemplate>
                       <asp:Label id="LabAsset" runat="server" Text='<%# Eval("AssetID") %>' ></asp:Label>
                   </ItemTemplate>
                   </asp:TemplateField>

                   <asp:TemplateField HeaderText="AssetType">
                   <ItemTemplate>
                       <asp:Label id="LabAssetType" runat="server" Text='<%# Eval("AssetTypeID") %>' ></asp:Label>
                   </ItemTemplate>
                   </asp:TemplateField>

                   <asp:TemplateField HeaderText="Warehouse Poistion" ItemStyle-Wrap="false" SortExpression="WarehousePosID">
                     <ItemTemplate>
                        <asp:Label ID="lblWarePos" runat="server" Text ='<%# Eval("WarehousePosID") %>'></asp:Label>
                     </ItemTemplate>
                   </asp:TemplateField>

               </Columns>
               <PagerStyle CssClass="GridTablePagging" />
               <HeaderStyle CssClass="GridTableHeader" />
           </acc:AtlasGrid>

Is this what you mean: ObjectDataSource..::.SortParameterName Property[^]

Tychotics: take us back to the moon

"Life, for ever dying to be born afresh, for ever young and eager, will presently stand upon this earth as upon a footstool, and stretch out its realm amidst the stars."
H. G. Wells

It is most like the code you refer.
But in my case sorting is working fine, As you have already noticed I am using AtlasGrid.
I want to load data sorted by DeliveryDate on PageLoad.

Thanks for you intrest in my problem

So why not just sort as: select [Column1], [Column2],... from [Table} order by [Column] in the underlying sql?

Tychotics: take us back to the moon

"Life, for ever dying to be born afresh, for ever young and eager, will presently stand upon this earth as upon a footstool, and stretch out its realm amidst the stars."
H. G. Wells

Actually I am using EasyObject and I do not have access to EasyObject Code and Database server. I have to order it by date in HTML code or code behind

dhdh

So what's your question?

Tychotics: take us back to the moon

"Life, for ever dying to be born afresh, for ever young and eager, will presently stand upon this earth as upon a footstool, and stretch out its realm amidst the stars."
H. G. Wells

I am running .net 3.5 sp1
Where do I get the appropriate aspnet_regsql.exe please?
I ran the one in C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727 but it says it is not compatible.
This file does not exist in C:\WINDOWS\Microsoft.NET\Framework\v3.5
Any thoughts please?

arkiboys wrote:
says it is not compatible.

What says it is not compatible? It doesn't matter what framework you are using aspnet_regsql.exe only creates the database for asp.net forms auth.

I know the language. I've read a book. - _Madmatt

It gives that error When I try to login to the site.
Thanks

Then it isn't with the aspnet_regsql. Check your connection string.

I know the language. I've read a book. - _Madmatt

Hi I am using a multiline textbox in asp.net.
I want if a url is entered in textbox then it should be clickable.
I have goggled but found no answer.
Please help me.

Thanks in advance

Off the top of my head I think you'd need to use a Rich Text Control of some description or, perhaps, FCK Editor (I would link it for you but I'm being blocked form Source Forge for an unkinown reason (me not them)). Anyway, look at those unless anyone has a better solution.

Tychotics: take us back to the moon

"Life, for ever dying to be born afresh, for ever young and eager, will presently stand upon this earth as upon a footstool, and stretch out its realm amidst the stars."
H. G. Wells

ASP.net doesn't have rich textbox control. It is in windows form.

hence 'of some description'. Try the FCK Editor or similar.

Tychotics: take us back to the moon

"Life, for ever dying to be born afresh, for ever young and eager, will presently stand upon this earth as upon a footstool, and stretch out its realm amidst the stars."
H. G. Wells

I'll bet there's a jQuery extension for that.

how could i change dynamically the hyperlink look & behavior using css. suppose for few users i will show hyperlink and for few users i will show label. i think hyperlink can behave like label if proper css can be use. so if possible please someone give me a snippet of css which will make a hyperlink a just label.

thanks in advance

tbhattacharjee

Why dont you use label and link and Show/Hide them according your requirement.

Cheers!!
Brij