|
I am just giving a direct query like "DELETE FROM [T_BL_CHARGE_SELLING] WHERE [CHARGEID] = @original_CHARGEID" in the sqldatasource's delete query property...
Ranjith
|
|
|
|
|
Hi,
I have this Data Grid which I drag and drop from the Database Explorer. It works well and I did some editing to it. And the problem is some of my fields are storing id which point to another table that store the description of the id.
Let say titleId in my 'staff' table is '1', so it point to 'title' table where '1' is 'Manager'. When the Grid show on the web page, I don't want it to show the id '1' when I select from 'staff' table, I want it to show 'Manager'.
How can I add another sql query in this Grid to make it select the name of the title and show it in the Grid?
Thanks
J Liang
|
|
|
|
|
J Liang wrote: How can I add another sql query in this Grid to make it select the name of the title and show it in the Grid?
I think no need of adding one more SQL query for solving this problem.
J Liang wrote: I don't want it to show the id '1' when I select from 'staff' table, I want it to show 'Manager'
What you can do is fetch the type from your second table for that id and show it. Use single query. That could be something like
SELECT
T.YourColumnName,
S.OtherColumn
FROM
Staff S,
Title T
WHERE
T.titleId = S.titleId
|
|
|
|
|
Hi,
Thanks for the suggestion, it works just fine and the data grid is showing the description instead of the id.
J Liang
|
|
|
|
|
Hi all , Just wanted to know if there is a color picker control available in ASP.Net..
I want to use it in one of my projects...
I want to know if there are some add-ons available so that the color picker control can be directly accessed from the toolbox in Visual Studio 2005
Thanks in advace
|
|
|
|
|
you can surely get it from Here[^]
Best Regards,
Apurva Kaushal
|
|
|
|
|
Thanks Apurva...The code link provided by u is known to me ...I just wanted to know , isn't there some build in control in asp.net to provide the color picker control.
Like in VC++ , there is a build in control control , SO how can .NET miss such a useful control
|
|
|
|
|
Hi,
I have page where an excel file would be imported, while importing there are certain validations would be done, once through insertion operation would be performed in the database.
This whole process works fine and takes little time, now the requirement is that while we click the button 'Start Processing' a taskbar sort of thing should be displayed.
Like loading... 1% 2% etc etc.
Once the operation is done this should not be visible
Typical website stuff which shows the loading msg when being loaded.
How to implement this???
Gautham
|
|
|
|
|
when i tried to get the address in asp.net it is displayed the address "fe80::5efe:192..... like this.
How to get IPv4 Address in VISTA?
PLZ solve this Prob
Thanks in advance
|
|
|
|
|
http://aspnet.4guysfromrolla.com/demos/IsPrime.aspx[^]
the code link above does it looks wrong as i tryed testing it however does not work it keep telling me :
Page.IsValid cannot be called before validation has taken place. It should be queried in the event handler for a control that has CausesValidation=True and initiated the postback, or after a call to Page.Validate.
p.s: i am using asp.net2
|
|
|
|
|
Not sure...but you may try setting CausesValidation=False for other controls
<< >>
|
|
|
|
|
i want to add a mouseout event to a hyperlink.how can i do that
|
|
|
|
|
Use the Attributes collection of the control.
---
single minded; short sighted; long gone;
|
|
|
|
|
YourControl.Attributes.Add("onmouseout", "myJSFunction()")
Mubashir
Every job is a self portrait of the person who did it.
|
|
|
|
|
hi ...
in browsers (such as IE) how can emulate a button click event ?
for example
suppose a dictionary webpage :
i want to make an application that automatically textBox control and the click the "translate" button.
tanks a lot
|
|
|
|
|
seems obvious, but have you tried document.getElementById ('myButton').click() (client side) or btnClickHandler (null, null) on the server?
"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox
|
|
|
|
|
i have one login form that is designed using photoshop and flash. i want include that web pages in my asp.net web application.i have done that .but problem is after adding to asp.net application some of the html codings is not working like mouseout event for hyperlink and all.what i can do for that.
anyone please help me...
|
|
|
|
|
Hi all,
Can any one help me in retreiving outlook in aspx page. I need to check my inbox and other tabs in a web page.
Thanks
|
|
|
|
|
Hi,
U can get the code in www.outlookcode.com. U will find nice articles on reading inbox or reading unread mails or any specific folder and many more...
hope this helps u...
|
|
|
|
|
The simplest method is to get the admin to enable Outlook Web access, then just slap it in an IFrame
"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox
|
|
|
|
|
Hi i have two html pages...,
In first html page i have some two links like(link1, link2)...,
In another html page i have 8 links like (link1 to link8)...,
If i click in first html page that "Link1", then its want to go second html page and show first 4 links(link1 to link4)...,
in that time that link5 to link8 want to be hide(visible=false)...
Similarly,if i click "Link2" then its want to go second html page and show last 4 links(link5 to link8)...,
in that time that link1 to link4 want to be hide(visible=false)...
How to do this one...,
Plz help me......
Magi
|
|
|
|
|
hi there:
You can pass thru query string to the second page to indicate which link is clicked in the first page...then you can do your business in the second page (visible/invisible arcordingly)
<< >>
|
|
|
|
|
Whenever you click the links in the first html page pass a quey string too!
Like if link1 in page1 is clicked then your target url should be appended with something like url?page1.
The same with link2, when clicked the url should be appended with link2.
Now you can write a function using javascript in the form load event for the html2 page to check whether link1 is clicked or link2 is clicked!
then accordingly you enable/disable links in your html2 page.
the javascript function to capture the passed query string is as follows:
function getQueryVariable(variable)
{
var query = window.location.search.substring(1);
var vars = query.split("&");
for (var i=0;i<vars.length;i++)
{
="" var="" pair="vars[i].split("=");
" if="" (pair[0]="=" variable)="" return="" pair[1];
="" }
="" }=""
that="" is="" my="" thought="" process,="" hope="" it="" works!!=""
<div="" class="ForumSig">Gautham
|
|
|
|
|
<a href="#" onclick="javascript:popWin = window.open('page2.htm')">Open Window</a>
<a href="#" onclick="javascript:ShowDiv('First')">link1</a>
<a href="#" onclick="javascript:ShowDiv('Second')">link2</a>
<a href="#" onclick="javascript:if(popWin != null)if(!popWin.closed)popWin.close();">Close PopUp</a>
<script>
var popWin;
function ShowDiv(objId)
{
if(popWin == null)
{
alert('Please Open Your PopUp Firstly');
return;
}
popWinObject = popWin.document.getElementById(objId);
if(popWinObject == null)
{
alert('Object Dos Not Exist In PopUp.');
return;
}
if(popWinObject.style.display == "none")
popWinObject.style.display = "";
else
popWinObject.style.display = "none";
return;
}
</script>
and in page2.htm write:
<div id="First"> First Panel </div>
<div id="Second"> Second Panel </div>
We Can Do Anything, If We Want It
|
|
|
|
|
Hi i dont want any popup window on here...,
first,just link1 and link2 button want to display...,
if i click that "link1" then in another html page want to show link1 to link4 else if i click "link2" then link5 to link8 want to display how to do that?????,
Plz explain with codes..........
Plz hlp me..............
Magi
|
|
|
|