|
hi
is there any function to convert mysql string datatype to int datatype.
I need to search data records from a table between certain price values.now this price values are stored in mysql as varchar type. And I need to compare it with certain price range which obviously is double or int type,
but how can i compare int and string . it gives error.
any help is appreciated,
thx,
max
|
|
|
|
|
How can i access starting index of selected text in label control using javascript.
kamalnath
|
|
|
|
|
Hope this is useful for you
var txt = '';
function getSelText()
{
var txt = '';
if (window.getSelection)
{
txt = window.getSelection();
}
else if (document.getSelection)
{
txt = document.getSelection();
}
else if (document.selection)
{
txt = document.selection.createRange().text;
}
else return;
}
alert(txt[0])//This line is to get starting index of selected text
|
|
|
|
|
Hi All
Can anyone guide me is the below approach is correct or not....
I am writing my max html code in my class file (Business layer) and return simple string to presentation layer. Normally i am doing this type of coding where i need my html to be build on the basis of return values from database.
E.g. I want to show hyperlink on a page if count(*) from table is greater than zero otherwise display “Not Available”. So my coding apprach is as below
strheader = "<br><br><font class=content> <STRONG>" + "More Images" + "</font> <br>"
sProdDescString3 = sProdDescString3 + strheader
If PrdMoreImageDataTable.Rows.Count = 0 Then
sProdDescString3 = sProdDescString3 + "Not Available"
Else
sProdDescString3 = sProdDescString3 + "<a href=# onclick=OpenWindow(a.htm);>Show Me</a>"
And in UI layer do simply as <%= sProdDescString3%> on appropriate location
Please guide me, is this approach is correct or some ……(
Amit
|
|
|
|
|
All HTML code should be in the presentation layer, not in the business layer.
---
b { font-weight: normal; }
|
|
|
|
|
Yes it makes sense.
One way to achieve is using span element in the presentation layer and then setting the InnerHtml property in class file according to the condition. e.g.
this.objSpan.InnerHtml = "";
Thanks,
Avanika
|
|
|
|
|
I'm just curious when I grab a connection string from my Web.config file using, say, WebConfigurationManager...
string connectionString = WebConfigurationManager.ConnectionStrings["myDatabase"];
...is the xml from the web.config file being read and parsed each and everytime this method is called? Or does is load the web.config and all it's settings into memory?
If it is reading the file each time, would it be faster to place the connection string into the Application Cache and read it from there?
Cheers!
Sunday Ironfoot
www.dominicpettifer.co.uk (work in progress)
|
|
|
|
|
Yes you are right,web.config is parsed each and everytime and your method will be called.This will show impact on performance so you can use cache memory to hold the connecton string.
Dont forget to set the expiry policy for that cache item,
i prefer file based expiry policy so that when web.config is changed then cache item get refreshed.
|
|
|
|
|
Interesting, if it is parsing the xml file each time it's doing it really quickly, far more efficiently than I thought. For instance if I do something like the follow code...
for (int i = 0; i < 1000; i++)
{
connectionString =
WebConfigurationManager.ConnectionStrings["default"].ConnectionString;
}
...it's going to parse the xml file 1000 times and cause the page execution to hang for a bit, except my page execution time is about 0.015 seconds. Also if I add a Thread.Sleep(1) inside the for loop the page execution jumps to about 2 seconds (1 second for Thread.Sleep(1) x 1000 plus any overhead from Thread.Sleep() method) meaning it's not my page timer thats not timing properly or anything.
Are you sure it's reading the web.config file each time and not just reading the settings from memory? Or have I way overestimated the overhead of parsing through xml?
Sunday Ironfoot
www.dominicpettifer.co.uk (work in progress)
|
|
|
|
|
So I have a very simple webpage (see below). When I click on the first button it posts back and updates the value with in the text box just fine, and same with the second one. But if I click on the first button then immediately click on the second one, so that they are both posting back at the same time, it will come back and fill in the data for the firs textbox, after the Thread.Sleep() has completed, then it will blow out the value in the first textbox, and set the value for the second value.
So it looks like it grabs the currect viewstate of all of the controls that have "AutoUpdateAfterCallBack" turned on, and there for when the callback is complete it will reset all of the fields, then update the value(s) that you wanted set.
Does anyone know how to get this example to work properly with the latest version of Anthem.Net? I only want it to update the fields that I actually modified with in the server side code.
[HTML Code]
<form id="form1" runat="server">
<div>
<anthem:TextBox ID="txt1" runat="server" EnableCallBack="true" AutoUpdateAfterCallBack="True"></anthem:TextBox>
<anthem:Button ID="btn1" runat="server" Text="Ajax w/Sleep" EnableCallBack="true" TextDuringCallBack="Processing..." EnabledDuringCallBack="false" />
</div>
<div>
<anthem:TextBox ID="txt2" runat="server" EnableCallBack="true" AutoUpdateAfterCallBack="True"></anthem:TextBox>
<anthem:Button ID="btn2" runat="server" Text="Ajax w/Sleep" EnableCallBack="true" TextDuringCallBack="Processing..." EnabledDuringCallBack="false" />
</div>
</form>
[Code Behind]
Partial Class Default
Inherits System.Web.UI.Page
Protected Sub btn1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btn1.Click
txt1.Text = "Hello World"
Threading.Thread.Sleep(1000)
End Sub
Protected Sub btn2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btn2.Click
txt2.Text = "Hello World"
Threading.Thread.Sleep(1000)
End Sub
End Class
-- modified at 18:43 Thursday 14th September, 2006
I'm using Anthem.Net v1.3.2 with VS.Net 2005 Pro.
|
|
|
|
|
For anyone that is interested, I found the solution to my problem.
Instead of setting the "AutoUpdateAfterCallBack" property in the HTML code, you would instead set it after you've updated the value for the text field, for example:
Partial Class Default
Inherits System.Web.UI.Page
Protected Sub btn1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btn1.Click
txt1.Text = "Hello World"
txt1.UpdateAfterCallBack = True
Threading.Thread.Sleep(1000)
End Sub
Protected Sub btn2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btn2.Click
txt2.Text = "Hello World"
txt2.UpdateAfterCallBack = True
Threading.Thread.Sleep(1000)
End Sub
End Class
That way the auto updating functionality of Anthem.Net will only update the specific field(s) that you set to update after the callback has occured.
|
|
|
|
|
I am using PUSH method to view data by crystal report. but i trying to export data in any format (i.e PDF) then i m getting error .. Logon fail
i dont know why this is happening ..
any suggestion please
thanks in advance
|
|
|
|
|
Imports System.Web.Services
<WebService("http://www.FL.com/SimpleHelloWorld/", "A simple web service which display message.")> _
Public Class HelloWorld
Code here
End Class
Getting error
c:\inetpub\wwwroot\WebService1\HelloWorld.asmx.vb(2): Attribute specifier is not a complete statement. Use a line continuation to apply the attribute to the following statement.
But i place underscore....
Amit
|
|
|
|
|
Maybe it's the line between the attribute and the class declaration.
Another thing I see, it's an illegal character that is not visible in the designer, try to delete and retype it to see if there is any change.
|
|
|
|
|
<WebService(Namespace="http://www.FL.com/SimpleHelloWorld/", Description="A simple web service which display message.")> _
.....
Hope this helps.
|
|
|
|
|
Kumar, removing the blank line after <webservice(namespace="http: www.fl.com="" simplehelloworld="" ",="" description="A simple web service which display message." )=""> _ will hopefully solve your problem.
|
|
|
|
|
Is Cache class available to App_Code folder too.
Because in my Global.cs which resides in App_code, If i use Cache["test" = "testvalue"; am getting a compiler error saying 'System.Web.Caching.Cache' is a 'type' but is used like a 'variable'
can anyone help
|
|
|
|
|
Context.Cache["test"] = "testvalue";
only two letters away from being an asset
|
|
|
|
|
Hey Guys
It is almost more than year I am working on dot.net, but unfortunately I never get the chance to work on hot technology like web service…
I am planning to learn myself so please suggest some good sites from where I can start. Specially with SOAP model…..I search some sites and maximum are for intermediate level…
Please suggest some good links from where I can get good exposure for web service with SOAP
Amit
|
|
|
|
|
|
|
hi guys i just wanna ask some question about the database my asp is connected to.
i now have a ms excel form whihc have over 900++ records !!!!
i am trying to find if there is a way to convert the excel database into my sql database.
pls suggest or tell me how i can do this.
i really dont want to type out 900++ records haha >.<
|
|
|
|
|
use DTS or BCP or import utility. All come with sql server....
Amit
|
|
|
|
|
Hi!
Does any one knows of any toolbar web part, this toolbar will contain a list of web sites and sub sites. I need to hook this sort of web part into my share point portal.
Your help is highly appreciated.
Thank you.
happy coding!
|
|
|
|
|
hi all
the question is more related to architecture and practices and I'll appreciate any opinion
i work with asp net 1/2 few years and with any project we developing we meet performance issues
maybe the problems is our methods or maybe we do not do the right things but it seems that view state and heavy page model really make performance bad
also, when you work with asp.net it very easy to start building your site component-oriented with many levels of nested controls that every one is data-driven and make a db call that altogether cause bad database performance
we recently did code review for other companies products and i see that every-one do that mistake with component-oriented design cause it so simple and fun to make smart controls with public properties and reuse them everywhere
also, i did a production application with MonoRail (MVS framework based on asp.net but using different light page-model and no viewstate) and it just lot faster
i will welcome any examples of how you guys build ASP.Net site that fast and easy to scale, also, any links to good resources are welcome
if you suggest to switch to PHP or Ruby on Rails i promise to consider that
Thanks much
EV
and may the source be with you
|
|
|
|