473,320 Members | 1,978 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

A list of field type names

Where can I find a reference guide that lists the different field types, and
the names (ex: NVarchar)? What if I want to make Date field? How do I
know how to programmatically create a Date field? is it NVardate?

See what I mean? Heres an example:

Dim cmd As New OleDb.OleDbCommand("CREATE TABLE People ( " & _
"AutoId int identity ," & _
"Id int NOT NULL," & _
"Name NVarchar(50)," & _
"Address NVarchar(50)," & _
"Phone NVarchar(25)," & _
"CONSTRAINT [pk_AutoId] PRIMARY KEY (AutoId)) ", conn)

But I don't know how to create different field types...

Thank you
Nov 21 '05 #1
5 2133
Daniel Kaseman wrote:
Where can I find a reference guide that lists the different field
types, and the names (ex: NVarchar)?


Look in the documentation for your Database engine.

If you're using SQL Server, look in the Contents of SQL Server Books Online
for Transact-SQL Reference / Data Types.

--

(O)enone
Nov 21 '05 #2
Where do I find that documentation in Visual Studio .Net?

"Oenone" <oe****@nowhere.com> wrote in message
news:eB**************@TK2MSFTNGP10.phx.gbl...
Daniel Kaseman wrote:
Where can I find a reference guide that lists the different field
types, and the names (ex: NVarchar)?
Look in the documentation for your Database engine.

If you're using SQL Server, look in the Contents of SQL Server Books

Online for Transact-SQL Reference / Data Types.

--

(O)enone

Nov 21 '05 #3
"Daniel Kaseman" <da*@cfaith.com> schrieb:
Where do I find that documentation in Visual Studio .Net?


.... typically by pressing the F1 key.

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://classicvb.org/petition/>
Nov 21 '05 #4
Daniel Kaseman wrote:
Where do I find that documentation in Visual Studio .Net?


As it's not part of Visual Studio, it's possible (though I'm not sure) that
it isn't present in the VS.NET documentation.

You wouldn't expect it to document ALL the database engines (MS SQL Server,
MS Access, MySQL, Oracle, PostgreSQL, Firebird, etc.etc.) would you?

--

(O)enone
Nov 21 '05 #5
Daniel,

Have a look at this page.
http://msdn.microsoft.com/library/de...l/acintsql.asp

I hope this helps,

Cor
Nov 21 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

15
by: C White | last post by:
I've got another drop list problem I am using the following code where users select a name, but it should pass a name and email into the table <select name="user"> <option value="<%...
7
by: dixie | last post by:
I have a text box on a form. In that text box is a list of people separated by a comma. Like A.Smith, L.Jones, P.Somebody, H. Somebodyelse Note, there is no full stop at the end of the list...
6
by: dam_fool_2003 | last post by:
Hai, I thank those who helped me to create a single linked list with int type. Now I wanted to try out for a void* type. Below is the code: #include<stdlib.h> #include<stdio.h>...
2
by: dhnriverside | last post by:
Hi guys Ok, here's the situation. I'm building a reporting system for my application, that basically creates a CSV file based on a load of data in my database. I'm trying to make the...
0
by: Mythran | last post by:
I wrote some code that is supposed to enumerate through the specified file's win32 resources and return a string-array of all icon names. When it runs, it returns a string-array with a bunch of...
7
by: Tizzah | last post by:
What is wrong with that? regex = /^(http|https):\/\/+({1}+)*\.{2,5}(({1,5})?\/.*)?$/ if(field.hpage.value != regex.test(field.hpage.value)){ alert("Bad Homepage") field.hpage.focus()...
11
by: eureka | last post by:
Hi All, I'm training in Servlets, JSP and JavaScript, I have a web page in which there's a "StudentName" textbox and below it is a "Names" Dropdown list. Initially the Textbox is empty and...
2
by: G Gerard | last post by:
Hello I am trying to connect to a msaccess database and then create a list of the objects in that database (more specifically the tables) and then create a list of the fields (including the...
2
by: Fred Mellender | last post by:
I am trying to use reflection to output the fields (names and values) of an arbitrary object -- an object dump to a TreeView. It works pretty well, but I am having trouble with generic lists,...
4
by: justice750 | last post by:
Hi All, I am using a FormView control. The allows me to update records in the database. However, when a database field is null I can not update the field on the form. It works fine when the field...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.