|
|
We have an application that uses a Radiobuttonlist of 36 items for the user to identify a Reason for a visit. This application has been in use for over 3 years and has created over 40,000 records in a MS-SQL Table. The users of this application would like to recude the number of Reasons in the Radiobuttonlist down to 11. Besides online access, they are able to generate various stat reports using this data.
How can I do this and still bring up records that contain Reasons that are no longer on the Radiobuttonlist without generating an SQL exception?
I don't think it can easily be done. If I could hide the no longer in use reasons, I could use code behind to show these reasons in a separate field on the screen rather than in the Radiobuttonlist as a selected item. Same thing for the reports.
I hope this makes sense. Any advise will be much appreciated.
|
|
|
|
|
Best thing to do is have your user do a mapping from Old reason to new reason, then clean the data and enable the new 11 radio buttons.
For example:
Old reason = A, New reason=B
Old reason = B, New Reason=B
Old reason = C, New Reason=X
you get the idea.
Good luck 
|
|
|
|
|
I understand what you are saying. Can't see a magic way to handle this. Thank you for the prompt reply. 
|
|
|
|
|
Dears
Any body help me about master page.
i build 2 pages with command master page.
and master page have 2 links for 2 pages.
Normaly when i click on master page first link then open first page and when i click on master page second link then open second page.
In this process whole page refress.
I need when i click on master page link then refress only contact page not a master page.
|
|
|
|
|
well...
the page inherits the masterpage so when you click the link the page reloads the masterpage also.
Maybe if all of the page is in an updatepanel you do not see it flicker.
In Word you can only store 2 bytes. That is why I use Writer.
|
|
|
|
|
I think you need further reading on Master Pages and Content Pages.
A content page inherits from its master page but both are rendered as one
page before it's sent to the client. The client browser (e.g. FireFox, IE)
does not differentiate between a master and content page as everything is sent as one
page e.g. Default.aspx.
There are methods such as:
- AJAX,
- Scripting (Script Manager/Update panel)
- IFrames
which can help u with partial page rendering.
Good Luck!
|
|
|
|
|
Since upgrading I'm seeing some strange results when querying against my web.sitemap file. Since most of my navigation is based on my web.sitemap file, this means many of my pages aren't loading.
When I query against the web.sitemap file, I'm getting back incorrect values for the url property. So if I run the following code
SiteMapNode rootNode = SiteMap.Provider.RootNode;
labTest.Text = rootNode.Url;
I would expect to read back "~/default.aspx", but instead I get back:
/(A(RAVFN-5DzAEkAAAANzE4MWZlMmUtYWI5OC00Nzg5LTk5YmMtNmEwNWRl NjAxYjU4KwIMaNwwBgRI9_M39CTz q6EZY7U1))/default.aspx
This means when I try to build my website navigation dynamically it fails because I cannot find sitemap nodes by url:
SiteMapNode footballNode = SiteMap.Provider.FindSiteMapNode("~/default.aspx");
The above statement fails because it reads back a url with the crazy string in front. What makes matters worse it that the problem is sporatic. It usually fails for awhile, then once it starts working it works for awhile, then I check back and it's broke again (all without changing any code).
|
|
|
|
|
Hi,
In my application i have a search criteria field in which one document name field is there.
I have a document in my database with name $#%#$. Now, I want to search for document by entering only %.
How i do that?
I tried differnt things but its not working. If i entered % in the document name field it gives me all the document.But, I want only that document.
Thanks,
Umesh Tayade
|
|
|
|
|
I can see you use the LIKE in your query.
If you only enter % you do get all. If you enter #%# I guess your result will be better.
(BTW I have never seen a filename with a % in it, maybe de-abstract you question)
In Word you can only store 2 bytes. That is why I use Writer.
|
|
|
|
|
Escape it with a backslash (\), like this '\%'
|
|
|
|
|
You can use either
SELECT columns FROM table WHERE
column LIKE '%[%]%'
-- or
SELECT columns FROM table WHERE
column LIKE '%\%%' ESCAPE '\'
|
|
|
|
|
Good Dal All
i have this aspx page
<%@ Page Language="C#" Async="true" Trace="true" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form runat="server" method="post" action="https://www.vcs.co.za/vvonline/ccform.asp" >
<asp:HiddenField ID="p1" Value="4635" runat="server" />
<asp:HiddenField ID="p2" Value="2" runat="server" />
<asp:HiddenField ID="p3" Value="Some Goods" runat="server" />
<asp:HiddenField ID="p4" Value="5.00" runat="server" />
<asp:Button ID="btnSubmit" runat="server" Text="Pay by Credit Card"
/>
</form>
</body>
</html>
what happens here is that on the Client side when someone clicks the Button it will do the payment and redirect to the page, i want to do this one the server side. i tried this
protected void btnSubmit_Click1(object sender, EventArgs e)
{
string P1 = p1.Value;
string P2 = p2.Value;
string P3 = p3.Value;
String URl = "https://www.vcs.co.za/vvonline/ccform.asp?p1=" + P1 + "&p2=" + P2 + "&p3=" + P3;
WebClient svc = new WebClient();
svc.UploadStringAsync(new Uri(""), "Post", "AT");
svc.UploadStringCompleted += new UploadStringCompletedEventHandler(svc_UploadStringCompleted);
}
and
void svc_UploadStringCompleted(object sender, UploadStringCompletedEventArgs e)
{
String estr = e.Result;
}
You can test using that URL
Thanks
Vuyiswa Maseko,
Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code.
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
The testURL says:
cs Terminal Id missing No Vcs Terminal Id presented 17/05/2011 04:19:38 PM
So what is your question really?
Why don't you do a response.redirect (why asynchronous?)
Don't you need an update anel in which the data is updated after pressing the button. You do now a repost with variables while you have the values when you hit the button.
In Word you can only store 2 bytes. That is why I use Writer.
|
|
|
|
|
what I at least miss is a page_load event where the values from the querystring are placed in the hidden fields
In Word you can only store 2 bytes. That is why I use Writer.
|
|
|
|
|
Good Day digimanus
I am using Asyc because i want to use this in Silverlight.
Vuyiswa Maseko,
Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code.
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
Good Day All
i have the Following URL
https://www.vcs.co.za/vvonline/ccpay.asp?p1=FP99&p3=Test%20ccPay[^]
use can use it to test. I want to Post it with after that you will see the page that request for Refnumber and i want to pay that ref number and post it again
and receive the last page and after the Credit card has been entered i want to receive the URL Response. This is what i have so far
WebClient svc = new WebClient();
svc.UploadStringCompleted += new UploadStringCompletedEventHandler(svc_UploadStringCompleted);
svc.UploadStringAsync(new Uri("https://www.vcs.co.za/vvonline/ccpay.asp?p1=FP99&p3=Test%20ccPay"), "Post", "AT");
void svc_UploadStringCompleted(object sender, UploadStringCompletedEventArgs e)
{
String Response = e.Result;
}
This "Response" URl gives me html of the page that is returned.
use the Async because i will be hosting this in Silvelight, i just want to grap the idea.
Thanks
Vuyiswa Maseko,
Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code.
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
this message is the same as the previous
In Word you can only store 2 bytes. That is why I use Writer.
|
|
|
|
|
guys;
i am wondering if i can make two asynchronous post-backs in the same time;
Help people,so poeple can help you.
|
|
|
|
|
|
Thank you, sir;
I saw this article but i want some real-time scheduling system (you know FIFO is not real-time);)
Thanks again;
Help people,so poeple can help you.
|
|
|
|
|
use the updatePanel with UpdateMode="Conditional"
In the event source that handles the request for the updatePanel set updatePanel.Update()
In Word you can only store 2 bytes. That is why I use Writer.
|
|
|
|
|
Hi guys,
I'm wondering if there is a way i can connect to MySql database using Linq?
I tried using the ODBC connector and visual cries it's not a supported
data provider.
Google is not being a good buddy here, any help please?
I looked at LinqConnect, they want alot of money 
Will appreciate your help.
Morgs
|
|
|
|
|
|
Thanks Ahamad,
did step on that one through THE GOOGLE. most forums insist that this project is still under
development/construction. No one gives asurance about it for some reason.
will keep searching maybe there could be something hidden out there.
thanks for your feed mate.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
