What is perfect way to declare variable data type in asp.net to match SQL data type?
-
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 -
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) -
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. -
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) - Jeff Moden - Saturday, February 11, 2017 5:11 PM
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.
-
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) - Jeff Moden - Sunday, February 12, 2017 10:33 AMUnderstood 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.
-
Thank you, Ed Wagner,
This is what I am looking for. - adonetok - Monday, February 13, 2017 5:56 AM
Glad to help. Thanks for the feedback.
Viewing 9 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply