how can I update my database with dataset?
149620
This question seems to be incomplete. By this u want to add  or update a record to a table or add a table to a database. Dataset usually refers to a collection of data. Moreover, u haven't mentioned which database u r using(like mysql, msaccess) and how do u want to update( by using front end like java, vb.net or just directly by writing sql query).\n\nAny way, if it is a sql query here are some basic syntax,\n\n(Though these are MySQL Syntax, these are standard SQL Queries and can run very well in all databases...)\n\nFor Inserting a record into a table.\n  INSERT INTO table_name (column1, column2,...)\nVALUES (value1, value2,....);\n\nFor Updating a record into a table,\n\nUPDATE [LOW_PRIORITY] [IGNORE] tbl_name\n    SET col_name1=expr1 [, col_name2=expr2 ...]\n    [WHERE where_definition]\n    [ORDER BY ...]\n    [LIMIT row_count]\n\nFor creating table, \nCREATE TABLE table_name\n(\ncolumn_name1 data_type,\ncolumn_name2 data_type,\n.......\n)\n\nIf u have a table, but want to create a copy of the table,\n\nCREATE TABLE new_tbl LIKE orig_tbl;\n\nBasic SQL Tutorial and Mysql Manual can be accessed by the links given in sources.\n\n Moreover, if u want to do any access to database from a front end(like java or C#), then u need to know about JDBC,ODBC concepts and it is dependent on the language also. For that u need to refer the language references.\n\n The link given below is only for mysql, for other databases(like SQL Server, MSAccess, Postgresql, Oracle), u can refer the manual for the detailed explanation with syntax and explanations.\n\n  Sorry devvygirl, my knowledge in VB.NET is very limited.
214490
I am not sure I completely understand, but from the sounds of it you want to add records to a recordset? If you need to do lots of manipulation to get them try method 1, if it is simply data from two tables use method 2:\n\n1)I like to use a temporary table, insert all your records with an insert into, then do whatever you gotta do to create more records in the table, then select to get the full recordset. This is nice when the new records require a lot of manipulations to figure out.\n\n2)If you just need to add two selects together use a union statement\n\nSELECT * FROM Table1\nUNION\nSELECT * FROM Table2
946325
You will have to connect dynamically to a database and retrieve all this data first, and then build a variable based on these values.
479077
CREATE DATABASE [Database Name];\n\nWithout knowing the scope of your question, that is all there is to it.
64537
Here you go:\nhttp://sqlzoo.net/
209683
use the replace function in an update:\n\nupdate mytable set myrecord = replace(myrecord, 'jpg', 'gif') from mytable
987976
you must set the databasename property of your data control to your access database.
998353
1  Click "Start" > "Settings" > "Control Panel".  \n2  At the "Control Panel" window, open "Administrative Tools".  \n3  At the "Administrative Tools" window, open "Data Sources (ODBC)".  \n4  At the "ODBC Data Source Administration" window,\nselect the "System DSN" tab.\nClick the "Add..." button.  \n5  At the "Create New Data Source" window,\nhighlight "Microsoft Jet Engine 2.1 Data ".\nClick the "Finish" button. \nIn the next tab, select the file and change the file name like this \n\n&#92;&#92;10.32.168.24&#92;c$&#92;data&#92;test.mdb\n\nNow u can use the dsn in vb and it will work in any network system
94546
You may need to know VBA (Visual BASIC for Applications) in order to do this.  If you want to change the data of one field based on the input into another field, put the code into the field_AfterUpdate() event procedure of the field that will be manually updated.
1029483
Check out Microsoft\n\nOr just Google database design or database normalization.
857738
You need to learn some programming. You can do this from within access by using the built VBA (visual basic for applications) code editor by hitting alt-f11.\n\nYou can also use a full blown application development environment such visual studio .net which can then connect to your database and do what you want.\n\nBoth options require a fair bit of work on your part in learning to program if you don't already have such a background and my guess is if you are asking the question your programming experience is limited. You will also need a logical mind in order for programming to be a rewarding experience as programming hits disorganisation and you will wind yourself up in knots.
1153856
You can't, you can only build a spreadsheet, or a single table database.  You can use Access to build DB's.\n\nIf you need tuturiols on how to create/manage a Access Database.  See the links below.
377667
heres some code from a old ASP.NET application I found (the database connection string should be 1 line)\n\nDim Public DBS as String = "PROVIDER=Microsoft.Jet.OLEDB.\n4.0; DATA Source=c:&#92;DataBase.mdb"\n\n\n\nDim myconnection as oleDbConnection = new oleDbconnection(DBS)\nmyConnection.open()\nDim myCommand as oleDbCommand = New OleDbCommand("Select * from Threads", myConnection)\nDim myDataReader as oleDbDataReader = myCommand.ExecuteReader()
1029388
http://www.vbmysql.com/
462677
You can use Tables from MS Access or MS SQL Server Already loaded with Data
288421
Taht looks good, but I'd try this instead.\n\n&#92;&#92;code start\nDataColumn[] keys=new DataColumn[1];\ndataSet11.Tables["Orders"].Con... UniqueConstraint("ck_constrain...\nkeys[0]=dataSet11.Tables["Orde...\ndataSet11.Tables["Orders"].Pri...\nDataRow findrow = dataSet11.Tables"Orders"].Rows...\n&#92;&#92;code end
484774
Query the RDBMS's internal schema for that information. Also can check data types using regex on values, as well as defining meta-data for test you want to run, and a utility script to use it against defined tables.  (If the database is set up correctly, you shouldn't experience anomalies in the first place.)