What is perfect way to declare variable data type in asp.net to match SQL data type?

Question

Post reply

What is perfect way to declare variable data type in asp.net to match SQL data type?

adonetok

SSCrazy Eights

Points: 8395
More actions
February 11, 2017 at 7:50 am

#327101

From asp.net project I need to insert data into one table in SQL server which has a lot of data type as below.
What is perfect way to declare variable data type in asp.net to match SQL data type?
(I only use string, integer before)
[AUTHNO] [dbo].[vcType] NOT NULL,[SEQUENCE] [dbo].[sNumber] NOT NULL,
[NOTES] [varchar](max) NULL,
[SUBJECT] [dbo].[vcAddress] NULL,
[SECURED_YN] [dbo].[sNumber] NULL,
[CREATEBY] [dbo].[iNumber] NULL,
[CREATEDATE] [datetime] NOT NULL

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004432 More actions · Answer 1

IMHO, call a stored procedure.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

adonetok SSCrazy Eights Points: 8395 More actions · Answer 2

Yes, I'll call store procedure.
But, first I need declare variable in asp.net, assign value to variable from various controls, such as text boxes, drop down lists.
After that, will pass values to store procedure.

Jeff Moden SSC Guru Points: 1004432 More actions · Answer 3

I don't know enough about asp.net to tell you off the top of my head but the following search seems useful.
https://www.google.com/?gws_rd=ssl#q=match+asp.net+variables+to+sql+server+data+types

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Ed Wagner SSC Guru Points: 287026 More actions · Answer 4

Jeff Moden - Saturday, February 11, 2017 5:11 PM
I don't know enough about asp.net to tell you off the top of my head but the following search seems useful.
https://www.google.com/?gws_rd=ssl#q=match+asp.net+variables+to+sql+server+data+types

You build your SQL EXECUTE statement from the values in your controls, being sure to do your client-side validation first. Then you fire the statement. No matter how you declared your .NET variables, the procedure will receive the values in the data types it expects. For example, if you have a string variable in .NET that you pass as a datetime parameter, SQL will receive it as a datetime. If the string passed isn't a valid datetime value, the call to the procedure will fail on the .NET side.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Jeff Moden SSC Guru Points: 1004432 More actions · Answer 5

Understood but if you don't know that you shouldn't pass a "DOUBLE Word" to a "TinyInt", you're in deep Kimchi. 😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Ed Wagner SSC Guru Points: 287026 More actions · Answer 6

Jeff Moden - Sunday, February 12, 2017 10:33 AM
Understood but if you don't know that you shouldn't pass a "DOUBLE Word" to a "TinyInt", you're in deep Kimchi. 😉

Touche, sir. In that case, the page at https://msdn.microsoft.com/en-us/library/cc716729(v=vs.110).aspx in MSDN for .NET ought to work.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

adonetok SSCrazy Eights Points: 8395 More actions · Answer 7

Thank you, Ed Wagner,
This is what I am looking for.

Ed Wagner SSC Guru Points: 287026 More actions · Answer 8

adonetok - Monday, February 13, 2017 5:56 AM
Thank you, Ed Wagner,
This is what I am looking for.

Glad to help. Thanks for the feedback.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions