get rid of the square brackets around the varchar(255) and it will work fine.

For that matter, why are you putting them around the datatypes anyway? I've never seen anyone do that.

select * from persons where (prefix like '%'+@input+'%'
or
firstname like '%'+@input+'%'
or
lastname like '%'+@input+'%')
and address like '%'+@addressinput+'%'

can you give us some sample data?

what's the error? is this from another thread? why didn't you post as followup in that thread instead of starting new thread?

int intTemp = Convert.ToInt32(Console.Readline())

?????
post your code

post your code that is giving this error

textBoxName.Text = DateTime.Now.Month.ToString()+"/1/"+ DateTime.Now.Year.ToString();

problem is not with the date function.

you are comparing the string "h" to the string "12"
"h" < "12" is always going to return false

you need to compare your variable h to the number 12

h...

it depends on how that column is setup in the database. Is it set up as an identity column?

i would run some tests on your email server and see. however I would have to guess that one message with lots of recipients would be much better

yeah, sorry you need using System.Text also

actually you don't want to be able to decrypt it.

what you do is encrypt the password and save that in the database

when the user logs in, encrypt the password the input on the login screen...

I see your problem, it's simply, oh wait I can't see anything because you didn't post any code, didn't say what you were using to send the email, no useful information whatsoever.

Might as well go...

i cannot even ping that address. You probably need to talk to your network administrator. This looks like a networking problem, not a ASP.Net problem

now for when you might want to do that.

Lets say you have started weekly and a monthly newsletter for this site, with the members having the option to sign up for either, neither or both.

Now...

left joins will return all rows in the initial table regardless of whether or not they have a corresponding entry in the joined table. for rows that do not have a corresponding entry, null will be...

call me crazy, but it appears that you are running a loop that only runs one time. Why?

to find the number of digits in int x

if (x < 0)
x = -x;
int count = 1;
x = x/10;
while( x > 0)
{
count++;
x = x/10;

I'm assuming you meant 22.00 OR Great and 16.50 OR Greater

double valueAfterDeduction(double oldValue){
if(oldValue >= 22.00) oldValue -= 3.3;
else if(oldValue >= 16.5) oldValue = (oldValue *...

or simply "select 50. / 100"

copy and paste the whole error message

Try this (http://www.microsoft.com/downloads/details.aspx?FamilyId=262D25E3-F589-4842-8157-034D1E7CF3A3&displaylang=en)

You have to have the .net framework installed. You can include that as part of your install progam.