Re: Inserting and retrieving values

Keon wrote:
I am trying to figure out the following information when storing some
info to the database, I don't know how to do this and therefore I am
stuck.

When you post this to the appropriate newsgroup (see below) you will
need to tell people what type and version of database you are using.
Your question cannot be answered without knowing this.


I am going to try and explain this to the best of my ability.

I have two tables in my db, my first table I am writing the following
information to it.

ex....
// table one
FieldID, fName, lName, Address, State, Zip;

// table two
ParentID, Data;

// FieldID is an auto generated int field
FieldID.Value = 0;
fName.Value = "Jim";
lName.Value = "Anderson";
Address.Value = "747 Quarry Rd";
State.Value = "GH";
Zip.Value = "83920";
cmd.ExecuteNonQuery();

There was no way for you to know it (except maybe by browsing through
some of the previous questions in this newsgroup before posting yours -
always a recommended practice) , but this is a classic ADO newsgroup.
ADO.Net bears very little resemblance to classic ADO so, while you may
be lucky enough to find a dotnet-knowledgeable person here who can
answer your question, you can eliminate the luck factor by posting your
question to a group where those dotnet-knowledgeable people hang out. I
suggest microsoft.public.dotnet.framework.adonet.




--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.


.

Relevant Pages

  • Re: MS Access - problem with Double type field
    ... This is a multipost, not a crosspost. ... > know what the form is posting, and subsequently what the database has ... Please reply to the newsgroup. ...
    (microsoft.public.inetserver.asp.db)
  • Re: datasets and table adapters dissapear from forms randomly!
    ... of the previous questions in this newsgroup before posting yours - always a ... but this is a classic ADO newsgroup. ... This email account is my spam trap so I ...
    (microsoft.public.data.ado)
  • Re: Typed DataSet
    ... some of the previous questions in this newsgroup before posting yours - ... but this is a classic ADO newsgroup. ... ADO.Net bears very little resemblance to classic ADO so, ... different from the dataset returned from the database? ...
    (microsoft.public.data.ado)
  • Re: Submit Button
    ... Bob, I basically have created a web form page that will be accessed via the ... It is a simple form with a SQL database that has related fields. ... the group you should be posting to is: ... >>> a quicker response by posting to the newsgroup. ...
    (microsoft.public.scripting.vbscript)
  • Re: msaccess and dataset problems
    ... i am trying to load a msaccess database into a dataset locally from ... Classic ADO does not have datasets, so you must be using ado.net. ... some of the previous questions in this newsgroup before posting yours - ... but this is a classic ADO newsgroup. ...
    (microsoft.public.data.ado)