Comments by Pravinjas (Top 35 by date)

give details about your database table column

give id to input control

<input type="text" id="text1" value="0" name="t1" önkeyup="nims();" />


then in cs file access that ID

like text1.text="whatever u want";

Hi..please explain more on this return (total != 0) && ((total & (total - 1)) == 0);

I cant understand above line

use following javascript code

var rdo1=document.getElementById('ID of your checkbox');
if(!rdo1.checked)
{
//user message
}

Thanks...

Thanks... Now it is working.

Thanks a lot. Its working. my 100+

please help me how to use temp table in 'IN clause'

16,9 is a dynamic string means there may be multiple number so how I store them in different variable
sometime there will be 16,9,2,5,7,3,0

Now it will give correct result...

Thanks. Can we stop execution of that stored procedure explicitly

I have checked this link and used that code it doesn't work.

Thanks Its working-pravin

It is not working.

I have to cancel search process if it take to long time.if i press escape then it is stop

above function giving error at INSERT @temp line

ALTER FUNCTION [dbo].[FNGetDataRowCount](@DatasetID AS INT)
RETURNS BIGINT
AS
BEGIN


DECLARE @retval AS BIGINT
DECLARE @temp TABLE (
--CREATE TABLE #temp (
table_name sysname ,
row_count INT ,
reserved_size VARCHAR(50),
data_size VARCHAR(50),
index_size VARCHAR(50),
unused_size VARCHAR(50)
)

DECLARE @datasetName varchar(100)
SET @datasetName = '['+Cast(@DatasetID AS varchar)+']'


INSERT @temp
EXEC sp_spaceused @datasetName
SELECT @retval=row_count from @temp WHERE table_name=@DatasetID



RETURN @retval

END

Can we create temp table in function.I have tried but it giving error -can not create temporary table from within function

is there any way to execute query in function?

I have to do this in SQL SERVER 2008(function)

Thanks.

I have to separate ID in SP and then have to select data through loop.plz tell me how use nested while loop in SP.becuase first while loop for table and in that loop I have to another while loop for text to be search

but there is multiple table.I have to select from multiple table

try to use emailfrom as a gmail

finally i got solution.instead of .aspx i used .ashx.
.aspx file was loading but problem is duplication of view-state because i was calling one page into another page. now i use .ashx file.now it is working.

Thanks for ur suggestion.

Im using jquery ajax for server side validation

$("#<%=txtProductCode.ClientID %>").keyup(function () {
var pcode = document.getElementById('<%=txtProductCode.ClientID %>').value;
$("#message").load('checkproductcode.aspx?str=' + pcode);


});

in my code instead of message1.innerhtml take alert message.
dont take alert message bellow ur file call.

Thanks.Its working.........I have done EnableViewState="false"