|
Search on Micrsoft.com, I got a free copy from them on using Asp.Net 3.5 and AJAX, but I think I had to sign in with my Windows Live ID 
Lloyd J. Atkinson
"Logic will get you from A to B, but imagination will take you everywhere" - ALbert Einstein
I look at Microsoft, and turn to my poster on the wall saying: "Bang head here in case of stress".
|
|
|
|
|
Hi friends, I create a table with 3 columns in MS SQL2005:
Time1 float
Time2 float
Socre float
Then I would like to run command to show 4 columns:
Time1
Time2
Score
TotalScore=Time1*Score+Time2*0.5*Score
by using
Select Time1, Time2, Score, Time1*Score+Time2*0.5*Score As Total Score from test
But I find that if the time is NULL the score would be NULL as well.
How can I convert the NULL value to float 0.0 and get the TotalScore correctly?
|
|
|
|
|
This is not an ASP.NET question, but if you select COALESCE(Score, 0) will return 0 if Score is null.
Christian Graus
Driven to the arms of OSX by Vista.
"Iam doing the browsing center project in vb.net using c# coding" - this is why I don't answer questions much anymore. Oh, and Microsoft doesn't want me to.
|
|
|
|
|
You need to use ISNULL function as follows:
ISNULL(Time1, 0) * ISNULL(Score, 0) + ISNULL(Time2, 0) * 0.5 * ISNULL(Score, 0) AS TotalScore
|
|
|
|
|
Thanks a lot for your help John and Christian, I got it. Sorry and I would ask for help in "SQL discussion" part.
|
|
|
|
|
Can someone point me to a good resource or article as to how implement or build a wysiwyg editor into a .net website? I am looking for something similar what is used on this site to post message. Thanks in advance to all that reply.
|
|
|
|
|
While I don't know the answer,m I'll be watching the responses you get to see how it's done.
One very, very tedious way I can think of, though, would be to click View->Source on the menu bar and see how it's implemented here. Another approach might be as simple as searching the articles here for an ASP.Net Text editor.
"A Journey of a Thousand Rest Stops Begins with a Single Movement"
|
|
|
|
|
|
Thanks i'll take a look at these references
|
|
|
|
|
|
Hello,
I am working with visual studio 2005.
i used update panel, my problem is how to focusing the control after asynchronous postback. please give a small code..
Thanks in advance...
Pinna
|
|
|
|
|
Hello,
I am working with visual studio 2005.
I have one gridview with template field textboxes.
for every row i have 3 textboxes, when i enter value in second textbox, i need to show the multiplication of two textbox value in third textbox.
i write code using onblur event, but it is working for single row.
Please suggest me how find the event of textbox using javascript.(I mean how to find in which textbox(which row) i entered the value)
Please help me...
Thanks in advance..
Pinna
|
|
|
|
|
Use datagrid's RowDataBound event to write the javascript. Your JavaScript will be bounded to all rows.
Errors are like Mini Skirts, shorter they get, more revealing they become.
|
|
|
|
|
How we can call javascript funtion in row databound event of gridview.
Looking forward for your reply...
Thanks in Advance...
Pinna
|
|
|
|
|
e.Row.Attributes.Add(event,javascript)
ex: e.Row.Attributes.Add("onmouseover", "this.style.backgroundColor='blue'");
Errors are like Mini Skirts, shorter they get, more revealing they become.
|
|
|
|
|
Hi Friends,
In select html control,how to clear optgroup values(option group values)? Kindly help me.....
Thanks & Regards
Senthil Kumar.T.S
|
|
|
|
|
Perhaps you need to iterate the all option value and deselect it. I think is not possible in single shot.
Parwej Ahamad
g.parwez@gmail.com
|
|
|
|
|
hi
is it possible to get an ASP element with javascript?
I'm trying to get the text of an asp textbox (or the value of input type text) that is nested within an ASP TemplateField .
thanks in advance
j
|
|
|
|
|
Yes , First find the control bby control id like :
var obj=document.getElementById('Controlid').vlaue;
Parwej Ahamad
g.parwez@gmail.com
|
|
|
|
|
but how can i predict the control id as ASP elements don't have a predetermined id? (i can't use the 'ID' attribute as opposed to the HTML id attribute)
|
|
|
|
|
You can use document.getElementById(fieldID).
Errors are like Mini Skirts, shorter they get, more revealing they become.
|
|
|
|
|
thanks but please see my reply to Parwej above..
j
|
|
|
|
|
hi dude,
suppose the textbox id is txtname
give like this
var name = document.getelementbyid(txtname).value;
here txtname-->controlid as mentioned by parwej
u got it now
T.Balaji
|
|
|
|
|
sorry if i'm missing something or wasn't clear enough : I need the id for an ASP control that within a GridView (as mentioned - nested within asp:TemplateField)
so for example if my code is:
<asp:TextBox runat="server" ID="txtName">>
after rendering the TextBox id will be something like:
"ctl00_ContentPlaceHolder1_gridView_ctl12_txtName"
thanks
|
|
|
|
|
We are using crystal report and asp.net.
We have used a hyperlink in a crystal report field to open an aspx page for which values are passed in query string(URL) "/test/default.aspx?Parameter="+{value1}
But the link opens in the same window.
how to open the link in a new window? can it be achieved using <a> tag?
Thanks in advance
Jey
modified on Tuesday, October 28, 2008 11:05 AM
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
