Comments by balongi (Top 119 by date)

no thanks

this is function made in visual basic, so please convert into sql function

bind with null as datasource

i am testing the web service .. and it say method not found

at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at _Default.Button2_Click(Object sender, EventArgs e) in d:\project\Arrear\WebSite9\Default.aspx.cs:line 63

that the stack trace
how i overcome this

if i execute procedure in sql than it take 3 minute to get the record

Thanks............

Hi can you make a custome code for that because i am not aware with syntax please help me on this

but if start date is equal to end then i want to change the color for employeename
if i use avobe statement it change the color of startdate

problem is solved.. actual i need to convert the value .. now its done

I need indian currency fromat

I cant change constraint,, can you give me sub query

row is visible with data, i want to show only data not row with data. means when i print the report row is also visible

Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AI" in the equal to operation. error come

Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AI" in the equal to operation. error come

which type of join is best

i have to pass one parameter from code behind, how it check that it is serial number or name

it say ; missing before statment

Date someDate = new Date("1/1/2011");
.......; missing

how it achieve in javascript ?

if user add number with space than also it acceptable. can you modify according to that. means four number and many space will acceptable

i am try to ask you that:
if (double.TryParse(s, out d))
{
...
} what code come in this block

use entering only the numeric value not a string. user can enter 23, or 23.5

but then it giving same error. i want if user enter 23, it automatically add 23.0 to in it. if enter decimal value value need as it.

what should statement come in first if block. and what is the purpose of out?

so what the alternative. i have to do it with static

Please help me on this

there is + near line 2, i have added select * from in first line and in line 2 i added FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=E:\backup\' + @DataFeed + '', 'select * from [Sheet1$] where area is not null') . but it give Msg 102, Level 15, State 1, Line 2 Incorrect syntax near '+'. error

there is + near line 2, i have added select * from in first line
and in line 2 i added FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 8.0;Database=E:\backup\' + @DataFeed + '', 'select * from [Sheet1$] where area is not null') . but it give Msg 102, Level 15, State 1, Line 2 Incorrect syntax near '+'. error

it still giving error :

Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '+'.

Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '+'.

thanks :D

Thanks for post

thanks for post.. but the session is server site state management. we cannot store data in session in offline Mode.

ok thanks

Ok.. i'll try again thanx for your time

now! it come to first problem state

button need two click event for this!..

the databinding code already in ispostback condition.. but alert run when i click autopostback true of textbox. first time alert show the value for database but when you change the text of textbox then the variable in alert go blank

can u suggest me javascript function for that!

Let me check this!!

By using as your suggestion now, no marker is displayed on map

ancbusinessurl is anchor tag id

ancbusinessurl is anchor tag id. when i run my code it display hello i want hello come in underline

What is cdata here

i use group by businessid but the duplicate businessid come again

But it will display duplicate businessid and userid

i have another quey in case of
select Distinct Businessid, UserId from tblBusinessRatingandReviews
than duplicate businessid also come

agian same error come

if i select one by one item from first dropdowlist then the second dropdownlist become empty.. this is the problme

That is for the facebook like button and this post is for facebook comment button

here lnkprev.commandargument, give value that i reterive in container.data item.. now how i reterive it in eval. please tell

In code behind the value is come from this code:
if ((LinkButton)sender == lnkNext)
{
lnkPrev.CommandArgument = (PageIndex + 1).ToString();
lnkNext.CommandArgument = ((PageIndex + 1) + DisplayPage).ToString();
}

after your suggestion i added code, now my textbox is accepting all kind of text where it string or digit. Now Error messeage is not displayng

If i add function as check(sender,args) , the syntex error is come

after make change, the eror messege is not displyed:
here is changed code:
function check(sender, args)
{

var pattern=/^[A-Za-z0-9]{10}$/;

var regexp = new RegExp(pattern);
//alert(document.getElementById("ctl00_ContentPlaceHolder1_txtPhoneNumber").value);
if(regexp.test(document.getElementById("ctl00_ctl00_ContentPlaceHolder1_ContentProfile_txtMobileNumber").value))
{
return true;
}
else
{

args.IsValid = false;


}
}

ok , now how it prevent to enter string.

i want to show error message when it not match with regular expression. where i make change please tell

yes, i replace it but same error is display this is my latest procedure:
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go


ALTER procedure [dbo].[recursive]
(
@id int =null,
@studentname varchar(20) =null
)
As
BEGIN
with ProductSearch
As
(
select * from student
)

select * from ProductSearch


if(@studentname is not null and @id is null)
Begin
select * from ProductSearch where studentname =@studentname
end
else if(@studentname is null and @id is not null)
Begin
select * from ProductSearch where id =@id
end
end

this is my latest procedure
ALTER procedure [dbo].[recursive]
(
@id int =null,
@studentname varchar(20) =null
)
As
BEGIN
with ProductSearch
As
(
select * from student
)

select * from ProductSearch


if(@studentname is not null and @id is null)
Begin
select * from ProductSearch where studentname =@studentname
end
else if(@studentname is null and @id is not null)
Begin
select * from ProductSearch where id =@id
end
end

it compile successfully but giving error after execution. Yes i replaced it .

Giving same error.

i am storing the result of student table in productsearch. the productsearch is not a table

But if both parameter are not null then it never reach to second parameter because of ('or') condition. it accept first and give result basis of business name , however i put wrong description

because setlocation function is called on button click which i wriiten on updatepanel

I dont want 'ispostback' property, is their any alternative

i beginner for this can you suggest how i use trim function under string class

Sir i am using this query in asp.net. The result is displayed in datalist if i search for ('manoj admin'), but if user added two spaces between them then datalist dosen't so the record. i need user can supply as manay spaces but the result of query should be generated.

Please suggest me idea!

i dont use split, because i have to work with requirement

SO what is the query, for that user can type as many spaces he want.

i am reterving it in asp.net using query suggested by you. user can type as many spaces between them.

it give result if their is on space between ('avinash Admin') if i write ('avinash Adnub') it not work

Ok i am using these field in search button. if i search for manoj Admin it give result in datalist. the result shown manoj Admin. but if i added two spaces between them it dosent display the record pleze help

what is the use o ISNULL here ?

i am using these filed in search button. if i search record for avinash Admin it give avinash admin as result but if i added two spaces between them it dosen't give the output.

i am using asp.net... but the button control is come through database which is html control

my dropdownlist contain langauge like choose--langauge, hindi,punjabi,english
i want if user select chooselangauge item than the validation will come with message that you cannot select choose-langague but if user select hindi, punjabi than it will ok

thanx it work by your suggestion .. it work now by adding these

if (ds.Tables[0].Rows.Count > 0)
{

return result = Convert.ToString(ds.Tables[0].Rows[0]["password"]);

}
else
{
return result;
}

how i would check plz suggest i am beginer for asp.net

i am showing it on label if email does not exist but it not work .. here is code

protected void BtnSubmit_Click(object sender, EventArgs e)
{






if (TextBox1.Text == "")
{
Lblpwd.Text = "wrong mail id";


}
else
{
mydatalayer.DataLayer d1 = new mydatalayer.DataLayer();
d1.forgotpassword(TextBox1.Text);
Lblpwd.Text = "your password is: " + d1.forgotpassword(TextBox1.Text);
}





}

Yes but i didnt get any help

Latest :

Create procedure GetFillDropDownList
(
@strFldName varchar(100)
@fldId varchar(100)
@strTableName varchar(100)




)



as
Select " + (IsDistinct == true ? " distinct ": "") @strFldName + ", " + @fldId + " from " + @strTableName + " order by + @strFldName;



Incorrect syntax near '@fldId' eror is come

if you will make this for me .. then i think i can understand it

create procedure GetFillDropDownList
(

@strTableName varchar(100),
@strFldName varchar(100),
@fldId varchar(100)

)

as

Select (IsDistinct == true ? distinct : "") + @strFldName + "," + @fldId from @strTableName + order by @strFldName;


i am doing this way

i'll tryed but procedure have some error when i translate above query into storeprocedure

can you translate the avobe query into procedure that written in my question

It start working thanx ..
the thing is that iam not putting adp.fill(ds); thax very much.. Sir

string s = Lblpwd.Text;
but problem is not solved

after debugging i found index is out of range error

But i am giving matching value to it

But this is not big issue.. plz observe my issue is related to big problem

Cannot find table 0. this error come

i give 1. if it found email in database otherwise it return zero but i want password 123

this error is come after i replaced my coding to your suggestion

Error 1 Cannot apply indexing with [] to an expression of type 'System.Data.DataTable'

this is not right because it return o or 1 .. if written email is in database it give 1 otherwise zero.. but i want the password.. that is 123 in my database

i want to make procedure for only qeuery. mehtod is working fine

ok the loginControls is ok for me but anyhow i want to acoomplish this task through manually .. plz observe my coding and tell that where i am worng for finding password only if email is valid.

but the issue is not solve.. it return 0 or one insted of the password that was reterive from database..
in database the password is 123..

ok thanx..

just i want to know how i get inner content of status to label.

i am doing this:-
label1.text= status.innerhtml

thanx....

Thanx for being kind... ;)

this.address is undefined

error is come after debugg...

how'll i sort this problem

can usercontrol.ascs have features of breakpint

me running it on firefox...the map is not displayed after made changes by me



after clicking go button doesn't happen anything... onclick="showaddress(this.address.value)",returnfalse;"/>

i'll tryed but its not working............

:) thanks

thanks....

ok thax..... Its work!

i get this error--Unable to cast object of type 'System.Data.DataRowView' to type 'PropertyLayer.cls_student'.

why writing --
if (e.Row.RowType == DataControlRowType.DataRow)
{

LinkButton link = e.Row.FindControl("View") as LinkButton;
link.Attributes["onclick"] = "return popwin(" + ((cls_student)e.Row.DataItem).id + ")";


}