ALTER procedure [dbo].[sp_insert_update_request]
if(@type = 'Insert')
insert into Request(UserTypeId,Document1location,Document2location,Document3location,descr,StatusId,ApplicationId )
i am getting the following error....
Procedure or function 'sp_insert_update_request' expects parameter '@doc1location', which was not supplied.
pls suggest me ....how to solve this issue...i am struggling for the past 4 days....
We are all here pure volunteers. We do not have time or motivation to do Google queries for you.
In case you do not know how you can search the web for any infos you might need you maybe want to read this article[^].
Neither we are machines or heartless geeks. Anyone understands when your first question is not too good and some info went missing while asking. But for the future: Consider these guidelines[^] when asking a question.
And the most important thing: Be polite and use punctation marks.
Nutshell: ASP.NET does NOT have any inbuilt API support to send out an SMS. You need to go for a third party solution or use something that is found on the Internet. Articles and discussions above should help you out.
AFAIK, Marathi uses same script as Hindi. In that you can't easily tell which language is used.
Easier way to detect language if your text is written using Unicode is by checking the character range. If the character range is in between the range for Hindi, you can assume it is Hindi. But you need to scan till the end and if all the characters are in Hindi, the word is written in Hindi. Your algorithm should also consider zero-width joiner and non joiners (ZWJ & ZWNJ) while scanning the input. I have done an implementation of language detection. You can find code here[^]. It is written in C but the concepts are same for any language.
If i select 2 schools per region i should get error message.
Sounds like straight forward implementation. On page submit, check for the number of regions selected - if more then one, check number of schools for a region - if more then one, throw an error message.