Comments by .net333 (Top 71 by date)

I solved this by using
COALESCE([Useremail],'')=coalesce(@Email,[UserEmail],'') and
COALESCE([PhoneNo],'')=coalesce(@PhoneNumber,[PhoneNo],'').

It handles the null values with coalesce function

Thanks an0ther1. i will refer the documents

Thanks Maciej Los. I need to get the User Details with Email or Phone Number. That's why i used coalesce function.

Thank you Richard. i will follow the ANSI-92 Join

Thank you mika

Hi Mika,
Thanks for your reply. yes vwOrdersforManageUsers is a view. I posted view

this is my Response:
[Fiddler] Read Response() failed: The server did not return a complete response for this request. Server returned 0 bytes.
working fine for Xml but for Json Getting this error

Yes john. Enabled for all my services

<getmanageresponse>
<managelist>

<availability>
<availabletimings>11:00 AM-2:00 PM
<dayavailable>Monday


<availability>
<availabletimings>2:00 PM-5:00 PM
<dayavailable>Monday


<availability>
<availabletimings>11:00 AM-2:00 PM
<dayavailable>Tuesday

Hi John. I changed web.config Service model settings same as above. but getting results in xml only

I'll make changes my query..Thank you Chill

getting error at Picture pict = sheet.Pictures(Pic) as Picture;

Hi digimanus..getting error at Picture pict = sheet.Pictures(Pic) as Picture;

hi Mika
i used above code to read images from excel..
but i got one error while reading image

Error Code : Exception from HRESULT: 0x800A03EC

Here is my code


if (dtItem.Rows[i]["PicName"].ToString() != "")
{
Worksheet sheet = worksheetItemOption;
if (sheet != null)
{
string Pic = dtItem.Rows[i]["PicName"].ToString();
Picture pict = sheet.Pictures(Pic) as Picture;
pict.CopyPicture(XlPictureAppearance.xlScreen, XlCopyPictureFormat.xlBitmap);
System.Drawing.Image img = Clipboard.GetImage();
MemoryStream ms = new MemoryStream();
img.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);
byte[] bytes = ms.ToArray();
postImportRequest.CommonMenu.Image = bytes;
}


}

Thank you

i am inserting ExcelSheet Data ItemName, Description and Images to sql server db using c#

excel sheet data is reading and inserting but images are not reading from excel

Hi Mika
thanks for your reply..can u send me a sample solution to upload excel sheet Data(ItemName, Description and Image) to sql server db using c#.net

thank you Gihan

thank you abhi..i'll go through with the above link

thanx Damith...may be my query optimized..

here is my query and executing fast in my sql server

select distinct(Name) as CategoryName from Lookup l,RestaurantAppInfo R,RestaurantMenu M where
R.CuisineTypeId=@Cuisinetype and R.CuisineTypeId=L.Id and R.AppId=M.AppId
and M.EntityType='Category' and M.Active=1

thanks Griff...i'll contact paypal about this information...

Thank you gagan..but it's not worked for me

Thank you so much Griff..I'll ask these doubts in PayPal site only

how to write wcf service for validating facebook credentials

i disposed the object also
Code:
FileUpload1.Dispose();

but i am getting same error

we Used this one but no use using(File.Delete(Server.MapPath(Request.ApplicationPath + "/ProviderImages/" + HiddenField1.Value)));

here Admin data is in two tables

1) Users 2) Employees Tables

first query is for fetching the UsersAppointments

second Query is for fetching the Employees Appointments..So here Same Data is Repeating for Admins

thank you so much Marcus

finally i solved this problem.

i have one webpage like http://localhost:3596/some.Web.Provider/Provider/TaskEdit.aspx?TaskId=155...i don't want user to type this url...

WebPages...aspx pages....I want to restrict some urls

thank you..here i am not passing the AdminId..and i got the solution
SELECT e.AdminId , s.CompanyName,s.CompanyId
FROM Employee e
INNER JOIN Company s
ON e.AdminId = s.AdminId
WHERE e.EmployeeId=@EmpId

Thank you so much vivek...It's working..i tried many ways..but i didn't get the output....Once again Thank you

thank you..but here i want to execute two queries...only i am passing EmployeeId from UI...by using EmployeeId i will get AdminId..By Using AdminId i will get CompanyName...

Thank you sandeep

Wcf Service Library..and I didn't find Global.asax File in Asp.net Also

i deleted automatically generated Global.asax file and I try to add file but i didn't find Global.asax file

i tried but i didn't find Global.asax file

thank you..but it's not working..it's working only for if i Select State i got Cities..but i am not getting all cities

thank you and i'll try

Thank you...

hi,
Click on Microsoft SQL Server 2008 R2 November CTP--->Configuration Tools-->Sql server configuration Manager....If u click on Sql server Configuration Manager you will get a sql server configuration manager window..in that double click on sql server agent...then click on start button...After that follow the below steps in sql server

MsSQL -> ObjExplorer -> SqlServerAgent ->New (if not accessible then start sql agent service)-> Job ->

in this new window,
general tab -> Name=test
Desc=trial...
check 'Enable' option
Steps tab -> New -> StepName=one type=trans-SqlScr(TSQL)
Database=Your_DB
cmd= Copy paste all your delete queries here.

Advance tab -> On success action=Quit the job

Schedule tab -> New -> Name=From Morning daily
Schedule type= Reccuring
check 'Enable' option
Daily Frequency => check 'Occure once' at = 10 AM
check 'No End date'

Thank you...i already checked these sites...i don't want to call wcf service in Iphone....first I want to change the existing wcf service for IPhone....

Thank you aarti..This problem is network related problem....but u r code is working.........once again thank you

ok thank you

If i connect with the local server credentials i am getting Sql server Agent...if i give remote server credentials i am not getting the Sql Server Agent...

i get the Sql server agent in local sql server..but i didn't get it in Remote sql server..my database is in Remote Server..not in local server...

i get the sql server agent in local server..but i didn't get it in sql remote server..my database is in remote server

it's working...thanks you so much aarti....

Thank you

Thank you..but i didn't understood sql server Agent..how can we create A Job...I referred all the sites but i didn't understood

ya...every 24 hours

thank you

thank you...i don't want to backup this data..i wanna to completely remove data from tables...This is the demo data

I solved this problem using contextKey

yes..if i select state and Typed like 'a' in textbox so i'll get particular EmployeeNames for that state

It's working..Thank you so much Prasad

thank you

i will use just message security...thank u mr Tim Corey

Shall we buy any certificate for this or not?

Thank u mr Corey