|
I am writing a program that updates a access database. I am filling a dataset with data from a comma delimited text file. Then I insert the dataset into the database with this piece of code.
OleDbAdapter.Update(dataSet1, "Table1");
This works great, but I also need to insert records to the database using a SQL insert statement. I am using the code below to insert a single record to the database.
"insert into Table1(col1, col2, col3)"
+ " values ('" + textBox1.Text + "', '"
+ textBox2.Text + "', '"
+ textBox3.Text + "')";
This works great. The problem comes in when I try to insert another dataset. The correct number of records are added but every row is the same as the row from the SQL statement. I bound the dataset to a datagrid but the datagrid shows the correct data in each row. Please help me before I get fired. Thanks
|
|
|
|
|
Hello Everyone, not sure if this is the correct forum for my question but im sure someone will tell me if it isnt, here goes with a little intro at my place of work we use a vb based app built on both sql 6.5 and 2k. i am currently a lowly helpdesk jockey but want more ( a la matrix !) im quite happy to dive straight in the deep end so i have this question which will i believe set me on the road to all things great, we use reusable scripts from within sqlew but i want to have a .exe from my desktop that i double click, select my script from a listbox enter the required values and then execute the script ( this script would have to execute across several networked workstations) i am familiar enough with terminology of both sql and vb i would greatly appreciate somebodies words of wisdom can this be done ?
regards
MM
|
|
|
|
|
I want to create a table from existing tables in SQL sever.
I have tried CREATE TABLE TBL_NAME AS SELECT * FROM EXISTNG_TBL_NAME.
But this command is not working in SQL Server.
Please Help me out in this situation.
Bawa
|
|
|
|
|
Hi there im new these forums but couldnt help notice your question, if i read your post correctly then cant you just dump or bulk copy out your table drop table then create new bulk copy in ? sorry if that doesnt help
MM
|
|
|
|
|
SELECT * INTO NEW_tblName FROM EXISTING_tblName WHERE 0 = 1
--SQLServer Books Online--
INTO Clause
Creates a new table and inserts the resulting rows from the query into it.
The user executing a SELECT statement with the INTO clause must have CREATE TABLE permission in the destination database. SELECT...INTO cannot be used with the COMPUTE. For more information, see Transactions and Explicit Transactions.
You can use SELECT...INTO to create an identical table definition (different table name) with no data by having a FALSE condition in the WHERE clause.
----------
There go my people. I must find out where they are going so I can lead them.
- Alexander Ledru-Rollin
|
|
|
|
|
Thanks dear.. your querry realy works.... again thanks dear.....
Bawa
|
|
|
|
|
I have successfully retrieved data with an adapter to create my required dataset. But now I want to know how many rows are in my dataset? I am using SQL 2003 and .NET1. I see that many people use the Tables.Rows.Count, but mine isn't working when I do that.
How do I retrieve the number of rows of the table in the dataset?
Thanks.
|
|
|
|
|
please try the following code
dim ds as new dataset<br />
dim da as new sqldataadapter(strQuery,conn)<br />
da.fill(ds,"test")<br />
response.write(ds.tables("test").rows.count)
strQuery is the select command, conn is the connection
|
|
|
|
|
I don't know VB
I'm using C#. Are you still able to help me in finding out how many records are in a table in a dataset.
|
|
|
|
|
cybersurferdev wrote: I'm using C#.
Your question should post in C# Forum.[^] But anyway, i still help you with this issue. Try to check this website[^] in order to convert the code from the previous post in order to answer your question.
|
|
|
|
|
//this should answer your question
string connStr = "Fill in your connection string here";
string sqlStr = "SELECT * FROM someTable";
System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection(connStr);
System.Data.OleDb.OleDbDataAdapter da = new System.Data.OleDb.OleDbDataAdapter(sqlStr, conn);
System.Data.DataSet ds1 = new DataSet("test");
System.Data.DataTable dt1 = ds1.Tables["someTable"];
int rowCount = dt1.Rows.Count;
//or a good use is
for(int i=0; i< dt1.Rows.Count; i++)
{
//do something
}
//or another
foreach (System.Data.DataRow dr1 in dt1.Rows)
{
//Do something else
}
|
|
|
|
|
|
Hey,
Anyone knows where the databases/tables, created on SQL Server2000, are located.I mean the actual path to which I can navigate to from windows browser.
Thanx & Regards.
Success is not a Destination,
... But a Journey !!
|
|
|
|
|
In Query Analyzer type the following in, while connected to the master database:
select name, filename FROM sysdatabases This will give you the operating-system path and name for the database's primary file.
Alternatively, you can connect to a specific database and perform
SELECT * FROM sysfiles This will get the details of the files for the current database.
ColinMackay.net
Scottish Developers are looking for speakers for user group sessions over the next few months. Do you want to know more?
|
|
|
|
|
Hi Colin,
Thanx 4 ur qik response.
I'll definetely try and let u know.
Thanx & Regards.
Success is not a Destination,
... But a Journey !!
|
|
|
|
|
Go to Enterprise Manager and navigate to database folder. Right click on any database that you want to know its path and choose Properties command from the context menu. The database property dialog box appear and navigate to the Data Files tab and you will see the Location property and you will see the full path of the database file.
|
|
|
|
|
Hi,
Working with OleDB (MS Access db).
I need to round the result of a SELECT SUM(this * that).
I've tried SELECT SUM(ROUND(this * that)) and ROUND(SUM(this * that))
but it doesn't seem to work. I've been able to use FORMAT though...
Is it possible to use ROUND with a SUM?
If all I can use is FORMAT, can someone point me to the list of options I can use with FORMAT... all I know is 'Standard'.
thanks for your help,
Ron
|
|
|
|
|
HI,
Well as for a change and problem reduction solving i will use the following:
SELECT SUM(this)
//and store it in
Decimal first_result;
//then
SELECT SUM(that)
//and store it in
Decimal Second_result;
//then the result
Decimal result = Decimal.Multiply(first_result,Second_result);
I hope this can be of use...
|
|
|
|
|
Can any one plz tell me why we do not use new keyword in oracledataReader
that is why this gives error
OracleDataReader objectDR=new OracleDataReader();
Thanks In advance
|
|
|
|
|
Hi,
if you want to use the datereader then usually you use to get all the results of the query so basically it's read the result of a query from the DB.
Below you can find a sample code that will use a query text to put it in the Oracle Command and then Retrive the results with the use of Datareaer Where a DataReader Return the resulted rows one by one each time it Uses .Read() Method wich return a bool with false if all the rows are all ready readed.
//code sample to use DataReader class
oracleConnection1.Open();<br />
<br />
string query_txt = "Select * from any_table";<br />
<br />
OracleDataReader ordr1 = new OracleCommand(query_txt,oracleConnection1).ExecuteReader();<br />
<br />
while( ordr1.Read())<br />
{<br />
MessageBox.Show(ordr1[0].ToString();<br />
}<br />
<br />
oracleConnection1.Close();
//where ordr1[0].ToString() 0 is the first column in the select statement
|
|
|
|
|
Thanx for your interest in my query but what i want to know is
why have u done
OracleDataReader ordr1 = new OracleCommand(query_txt,oracleConnection1).ExecuteReader();
instead why u did not do this
OracleDataReader ordr1 = new OracleDataReader();
// that is why we do not use new keyword with darareader
Thanxs in Advance
|
|
|
|
|
okay, usually if you use the new command it will give u an Error ("No Constructors Defined") right and cuz it was ment basically for reading the date from a Command (at least this is what i Know!)so if you just want to initilaize it then make it
OracleDataReader ordr1 = null;
//or with out Intilaizing it
OracleDataReader ordr1;
thnx.
|
|
|
|
|
HOW TO PLACE CHECK BOX IN GRID AND HOW TO DISPLAY RESPECTIVE VALUES IN ANOTHER GRID IF I SELECTED AN ITEM FROM CHECKBOX
HAI THIS IS HARI PLZ HELP ME IF I GET ANY PROBLEM WHILE PROGRAMMING.
|
|
|
|
|
Please don't write in all caps; it is irritating.
ADO.NET knows nothing about checkboxes. ADO.NET is a mechanism for transferring information in and out of databases. There are no user interface components.
If you are developing a web application you may like to try the ASP.NET forum, if you are developing a Windows Forms application you may like to try the C# or VB.NET forum.
ColinMackay.net
Scottish Developers are looking for speakers for user group sessions over the next few months. Do you want to know more?
|
|
|
|
|
I have just put together a Windows 2003 x64 Server for a client. Our intent is to move an application that is currently on a Windows 2000 server. It uses an Access 2003 front end and connects via ODBC to a mysql database. When we go to the 64 bit server everything is screwed up.
mysql finally released mysql 5.0 binaries for Windows x64. However, after creating an ODBC datasource we get "Access encountered an unexpected error and shutdown...." this happens if both Access and mysql are on the 64 bit machine or if only mysql is on 64 bit and Access and ODBC datasource is on 32 bit Win 2000.
I also tried using Maxdb. I got that installed and it works from the command line. However none of the GUI tools work on 64 bit Windows. Furthermore, I can put a few records into a table to test. Opening the table via Access and ODBC is ok but if you try to delete a record Access just hangs. When you force a shutdown of Access and reopen the desired record has been deleted. Again this happens if everything is on 64 bit machine or 64 bit for backend and 32 bit for front end.
Help! and Thanks!
Scott
|
|
|
|