i have stored in the database as location India,Tamilnadu,Chennai,Annanagar while i bind in the grid view it ll be displaying as 'India,Tamilnadu,Chennai,Annanagar' this format.
but i need to be displayed as 'Annanagar,Chennai,Tamilnadu,India' in this format. how to perform this reverse order in query or in c#
note: this is stored under one column as 'India,Tamilnadu,Chennai,Annanagar' with comma separated.
I have a datalist that shows information from a SQL table perfectly. Is there a way to show the information in reverse order?
Example:
Person1
Person2
Person3
Instead I would like:;
Person3
Person2
Person1
I am created dynamic Usercontrol in the placeholder, it works fine(top to bottom) but i need to add controls in reverse order mean(bottom to top). I don know how to handle this one. how to display dynamic control in Bottom to top?
View 4 RepliesMy webGrid is working perfectly fine. However, I would like the default sort order to be in the opposite direction. If it were SQL, I'd be adding a DESC somewhere. Here's my working line of code:
[Code]....
It correctly sorts on the UWDate column, but I would like it to sort the opposite sort order. Of course, once it is displayed, you can click on the title and it will resort at that time.
I have list of words. I type in a word misspelled. Can I query the list using linq to get words that sounds like (soundex) the misspelled word?
View 2 RepliesI have a pretty basic search feature on a site that queries a sqldb with a sqldarasource, and then displays the results on a page, in a panel within a Repeater. I'd like to figure out if it's possible to somehow highlight the words the user searched on as they are displayed in the search results. The code below is my repeater. Do you know of any way to manipulate the Title or Description if the words in it's body match the words searched?
<asp:Panel
ID="pnlExperience"
runat="server"
Height="500px"
ScrollBars="Auto">
[code]...
I got a sql table and is trying to sort the data by the column that contains the data entered in a search form.
My code is below:
[Code]....
How can I use Order by on the result of a LinQ to SQL query ?
I have the following Situation:
Dim ret As New Object
ret = From status In tableStatus _
Select status.STATUS_ID, _
Text = Function_GetText(status.TEXT_ID)
Now I have to order this result on the field Text, has anyone an idea? (I can't use in my case Orde by Function_GetText(status.TEXT_ID))
i want to select three records order by Date .This is my News table.
NewID NewTitle NewContent NewDate
1 Example ExampleContent 01.12.2010
2 Example2 ExampleContent2 02.12.2010
3 Example3 ExampleContent3 03.12.2010
4 Example4 ExampleContent4 04.12.2010
So,query selects example4,example3 and example2.
Order Table
Order No Date Product Qty Customer
A101 10-Oct-2010 Mac Book 10 John
A102 10-Oct-2010 I-Phone 25 Smith
A103 10-Oct-2010 I-Pad 40 Kallis
Here Order No is primary key
Order Detail Table
Order No Date Product Qty Customer Batch No
A101 10-Oct-2010 Mac Book 03 John B01
A102 10-Oct-2010 I-Phone 05 Smith B02
A103 10-Oct-2010 I-Pad 10 Kallis B03
A101 10-Oct-2010 Mac Book 02 John B04
A102 10-Oct-2010 I-Phone 07 Smith B05
A103 10-Oct-2010 I-Pad 15 Kallis B06
Here Batch No is primary key
The above table is just a sample table.
I have more than 1000 Order in my table. And for each Order there are at least 12 Order Detail is available in my Order Detail Table. It uses to take long time on loading the report for the first time. So, I thought to select Top 20 records from Order table. I have used the below query in crystal report command
Select Top 20 O.OrderNo, O.Product, O.Date, O.Qty,OD.Unit,OD.Rate from Order O
inner join Order Detail OD on O.OrderNo = OD.OrderNo
1. After execution of above query, I would like to know whether all the records from Order Detail Table will be checked during execution (OR) only matching Top 20 records of Order Table will be checked in Order Detail Table and executed?
2. How to use stored procedure in Crystal Report command?
3. What are the steps I need to take, to load Crystal report fast during first time page load?
I am building an invoice system for a client and I am having trouble with the web forms related to the INSERT new order query.Basically I want to build up the order query from the selections made and then store it all in db at the end.
I don't want to use temporary db storage because it's a wasted trip to the server, I don't want to use session state because it's not data about the user I'm storing.... Unless I'm wrong, from what I've read I think query string is my best method since the data is not sensitive, it will just be primary keys and the like.
On the first form, the user will select the customer id from a datagrid displaying all customers. The next form allows them to choose the product from a datagrid showing all products and so on.... How do I pass this information across several pages?
My hope is at the end I will be able to take all the values and insert them into the corresponding tables to make up the customer order.
I have 5 hard corded texboxes in a page in a sequence with sequence Number . Now i want to add re-order /re-arraning functionaly .. but i can't use ajax reorder list because i have 5 hard corded texbox. how can i maintain the order in Insert/Update cases. And also suggest me control that i can use, another than ajax re-order list. coz i not using any list items i have hard corded items on the page.
View 1 RepliesThe AjaxToolkit has a ReorderList. I'm searching for a jQuery solution that does the same and found this page. I would like to change the order of divs (vertically) and upload the new order to the database (ajax).
View 2 RepliesI have two table Order and Order Detail.
What i need is i need to bind last 10 Order in Gridview/details view with paging, and the same order detail also fetch from database and shown in another gridview.. if user click any oderNo in first Gridview/DetailView then i need to show Respective order detail in anther gridview..
without postback coz we already fetch 10 order with orderdetails from the database..and if user click next 10 orderNo using paging then again we need to load 10 orderNo with respective orderdeatils from database like this going on....as well as let me know how to take print of particular oder and order detail....?
From my testing, it appears that the order of parameters for the UpdateParameters must match both the order of the bound fields on the form (asp:Formview), and the order of the parameters in the UpdateCommand. Is that correct? If so, why do the parameters have names if all that matters is the order? I tried both asp:ControlParameter and asp:Parameter. Maybe the more relevant question is why aren't the names used instead of the order, particularly for the form order?
So, given I display the Identity field (CID), and need that for the update, I cannot get the update to work without including it in the UpdateCommand. Of course, since it is an autonumber field in Access, I cannot actually set it. So, I had to add another field to the db (lngUpdateCID) that I could set. That can't be how it has to be done, but I could not figure out another way to do this.
The relevant code is below:
[Code]....
I have an asp.net web application. I don't have the source code. The bin contains 10 assemblies and a .compiled file. I used Reflector on the App_Code.dll and it shows me classes and namespaces and stuff, but its such a mess.Is there any way to reverse engineer this web app that won't take weeks/months to unfold? The application is pretty basic.
Note, the code is written by an engineer that left the company. We own the product.
(Not sure if I'm creating this post in the right place. Feel free to move if needed.)
I'm trying to enable full DNS lookup including hostname. Having trouble. I've followed the instructions here
(http://support.microsoft.com/kb/297795) with no luck. Request.ServerVariables("remote_host") still returns only an IP Address.
[Code]....
I've also tried using DNS.GetHostEntry(IPAddress) and the depricated DNS.GetHostByAddress(IPAddress). All I ever get back is the IP Address with no host name.
IIS 6.0, Windows Server 2007 Server Pack 2, .NET 2.0
We have nearly completed an ASP.NET MVC web application running with SSL in IIS and now find that we must integrate with a third-party product that is supplied as a PHP web app running under lightppd on an alternate port, but still on the same server.
We want to make the integration appear as seamless as possible, so our initial strategy is to do all of the authentication through our application, implement a reverse proxy to expose selected features from the third-party product, and then set-up the third-party product to only be accessible from localhost and (if we can manage it) only from the user our app pool runs as. As a second layer on top of this, we plan on running the third party active content in an IFRAME, so we can surround it with our menus and headers. With the right fonts and colors, hopefully, it won't look grossly out of place.
First question: Is this strategy totally naive? Given the hand we've been dealt, is there a better one?
Second question: What is the best way to implement the reverse proxy? I was thinking of using a routing rule with an Http Handler that invokes our usual authorization just as a controller would and makes the requests to the other site, streaming out the results it receives. Is there something that already does this generically, that I can just hook up and invoke? Maybe some way to specify a controller to handle everything I need to proxy and then use a ViewResult that represents a call to an external URL I construct from the URL I received?
If I can get a few pointers on what to look for, I can trot off to the docs for the details.
.Net's System.Web.HttpUtility class defines the following function to parse a query string into a NameValueCollection:
public static NameValueCollection ParseQueryString(string query);
Is there any function to do the reverse (i.e. to convert a NameValueCollection into a query string)?
How can I do the reverse of a regular PayPal transaction. The only information I found in their documents was for the customer to pay us for things. What if we want to pay out the customer?
Is there a way to give a transaction type to reverse and pay out to the customer instead of them paying us?
Update: Turns out you can use Mass Payments to pay out to customers... just needed to look on StackOverflow a bit more [URL]
Local machine visual studio day and month are normal in format dd/mm/yyyy. But after deployed to remote web site, saved Excel using C#, less than day 12, become mm/dd/yyyy.
Actually the code is to get data into Excel from stored procedure which do pivot table The way i save date to cell is oSheet.Cells[currentline, i + 1] = String.Format("{0:dd-MM-yyyy}", Convert.ToDateTime(reader[i].ToString()));
while (reader.Read())
{
for (int i = 0; i < reader.FieldCount; i++)
{
if (reader[i] != System.DBNull.Value)
{
if (i == 0)
{
oSheet.Cells[currentline, i + 1] = String.Format("{0:dd-MM-yyyy}", Convert.ToDateTime(reader[i].ToString()));
}
else
oSheet.Cells[currentline, i + 1] = reader[i].ToString();
}
}
currentline = currentline + 1;
}
reader.Close();
<runtime>
<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<dependentAssembly>
<assemblyIdentity name="System.Web.Extensions" publicKeyToken="31bf3856ad364e35"/>
<bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="3.5.0.0"/>
</dependentAssembly>
<dependentAssembly>
<assemblyIdentity name="System.Web.Extensions.Design" publicKeyToken="31bf3856ad364e35"/>
<bindingRedirect oldVersion="1.0.0.0-1.1.0.0" newVersion="3.5.0.0"/>
</dependentAssembly>
</assemblyBinding>
<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<dependentAssembly>
<assemblyIdentity name="Microsoft.Office.Interop.Excel"
publicKeyToken="71e9bce111e9429c"
culture="neutral" />
<publisherPolicy apply="yes" />
<bindingRedirect oldVersion="12.0.0.0"
newVersion="11.0.0.0"/>
</dependentAssembly>
</assemblyBinding>
</runtime>
I have a page that I want only anonymous users to see, and authenticated users to be redirected. So, like this:
<location path="Login_ForgotUserID.aspx">
<system.web>
<authorization>
<allow users="?" />
<deny users="*" />
[code]...
I am looking for ASP.Net MVC implementation for reverse ajax comet/polling. Can anyone provide some good link or tutorial
View 2 RepliesI have an embedded Google map with my web application in ASP.NET 3.5.I have implemented reverse geocoding (getting address from latitude and longitude) on Map click.Now, I need the same but on marker click.
View 2 RepliesAt the moment i,m working at a websit (ASP.net 3.5). I have build the project and till my surprise it is possible to reverse engineering the created dll's to the code (with Red Gate's .NET Reflector).
I have found several tools like Xheo and dotfuscator, but does there realy protected the created dll's ?? Does Microsoft have build a method to secure this ?? If this is not possible everybody can steal your code....
I have took a lot of time reading about this article, but is there a method or tool to make this secure?