Hi, I have one table as, id Items 1 col1 2 col2 3 col3 another table as Sid col1 col2 col3 col4 1 A B NULL NULL 2 D E NULL F now i have to compare Items of tbl1 with columns of tbl2. here i need the output as true or false from select query. for ex. col1 of tbl1 is compared with col1 of tbl2.if the col1 has value then it should return false. if all values are null then it should return as true. here im expecting col1-false,col2-false,col3-true

Nothing is Impossible. Keep always Smiling... :)

modified on Wednesday, May 5, 2010 5:39 AM

Hi everyone, I have one textbox which needs to allows only values with >0. if it is 0 then, it should be return error msg. Pls anyone help!!!

Nothing is Impossible. Keep always Smiling... :)

Thanks for ur timely help...

Nothing is Impossible. Keep always Smiling... :)

that is all child records should be displayed next to parent.

Nothing is Impossible. Keep always Smiling... :)

Hi everyone, my table is 6219 HBO 02 0 6220 HBO1 0201 6219 6221 HEAO 0202 6219 6222 HTS 0203 6219 6231 MEAO 0403 6228 6232 MTS 0404 6228 6234 Midde 05 0 6235 Overi 06 0 6228 MBO 04 0 6236 WO 10 0 6237 Post 07 0 6239 Basi NULL NULL 6448 Athe 05001 6234 but i need like this, 6219 HBO 02 0 6220 HBO1 0201 6219 6221 HEAO 0202 6219 6222 HTS 0203 6219 6228 MBO 04 0 6231 MEAO 0403 6228 6232 MTS 0404 6228 6234 Midde 05 0 6448 Athe 05001 6234 6235 Overi 06 0 6236 WO 10 0 6237 Post 07 0 6239 Basi NULL NULL

Nothing is Impossible. Keep always Smiling... :)

Thank you very much....Thanks for your timely help... :)

Nothing is Impossible. Keep always Smiling... :)

modified on Wednesday, July 1, 2009 3:30 AM

Thanks for reply.... but i need a same result in select query without using Cursor,temptable,looping etc., because superior says it is a time consuming process.

Nothing is Impossible. Keep always Smiling... :)

hi, Please help me.. i ve a table like this, Sentby SentOn AcceptBy AcceptOn 1 2009-06-15 19:40:36.000 1 2009-06-15 19:40:36.753 32 2009-06-29 13:36:59.450 1 2009-06-30 12:25:45.303 1 2009-06-15 19:40:36.000 1 2009-06-15 19:40:36.000 1 2009-06-16 13:19:34.693 1 2009-06-16 13:19:34.693 1 2009-06-15 19:40:36.000 1 2009-06-15 19:40:36.000 2 2009-06-15 19:40:36.000 1 2009-06-16 19:40:36.000 and i need like this Sentby SentOn 1 2009-06-15 19:40:36.000 32 2009-06-29 13:36:59.450 1 2009-06-30 12:25:45.303 1 2009-06-15 19:40:36.000 1 2009-06-16 13:19:34.693 1 2009-06-15 19:40:36.000 2 2009-06-15 19:40:36.000 1 2009-06-16 19:40:36.000 here in 2nd & 6th row ,Sentby and Accept by Columns are different so i need that in next row.

Nothing is Impossible. Keep always Smiling... :)

hi, i want to get a string from 0th position to current cursor position in HTML Textbox using javascipt. anybody know pls reply me....

Nothing is Impossible. Keep always Smiling... :)

ok please tell me how to zip and download a content.....

Nothing is Impossible. Keep always Smiling... :)

Hi anybody know about downloading folder?? i have a code for downloading file.but i need code for downloading folder. im using asp.net2.0 with c#

Nothing is Impossible. Keep always Smiling... :)

can u expand ur question

Nothing is Impossible. Keep always Smiling... :)

u use VB as a code behind language. in Inline code U can use Javascript. for ex. Inline code ---------- script> function check() { if(confirm("Do u want to delete")) return true; else return false; } /script> asp:button text="delete" id="b1" onclick="b1_click" onclientclick="return check()" /

Nothing is Impossible. Keep always Smiling... :)

use this http://172.16.216.187/test/Default.aspx in both system windows firewall should be in off. also test folder should be in web sharing.

Nothing is Impossible. Keep always Smiling... :)

In ASP.Net u can use Javascript confirm for this purpose. based on return value of confirm u can delete the record.

Nothing is Impossible. Keep always Smiling... :)

Hai i have the following HTML, if i set this code to the innerHtml property of div tag, the image did not show. anybody know why???

Nothing is Impossible. Keep always Smiling... :)

very very thanks its works fine.......

Nothing is Impossible. Keep always Smiling... :)

Hi, is there any way to bind the value to header text of gridview control??? i have the value in dataset.but i could not bind into grid...

Nothing is Impossible. Keep always Smiling... :)

hi, i have one html file.i want to split it up into 2 parts then these parts should display in datagrid paging. is it possible.pls anybody let me know

Nothing is Impossible. Keep always Smiling... :)

you can use simple javascript or builtin AJAX control for this purpose...

Nothing is Impossible. Keep always Smiling... :)