Convert varchar value to tinyint?

Question

Navigation

#1 by (1 votes)

0

I have a value in a textbox (varchar) in a webform of asp .net and I need to compare it with a tinyint type value of sql.

What would be the way?

Thanks

Greetings

sql c# .net

asked by sunflower 08.03.2018 в 17:29

source

1 answer

score 1 · Accepted Answer

I recommend you read this article.

There you can see the data relationship between the different SQL and C # data types

In your case, to be able to insert tinyint you must use Byte

string a = "1";
Byte b;

b = Convert.ToByte(a);

Byte c = 0;

if(b>c){
.......
}

I hope it serves you .. Greetings