|
Open two connections, one to the SQL Server and one to Access.
Create a SqlCommand to SELECT the data you want and extract it with a SqlDataReader. While you can read the rows from the SqlDataReader send OleDbCommands to Access to INSERT the data. Remember to Close all connections when done.
|
|
|
|
|
|
is this feasible for transfering all tables in database???
|
|
|
|
|
Yes. Just repeat the process for each table.
|
|
|
|
|
I have a field called occdate which I need to query. This code works fine and retreives the record
SELECT OccID<br />
FROM dbo.People_Occ<br />
WHERE (OccDate >= 01 / 08 / 2006)
However when i add a second parameter i get no results returned
SELECT OccID<br />
FROM dbo.People_Occ<br />
WHERE (OccDate >= 01 / 08 / 2006) AND (OccDate < 01 / 08 / 2007)
Can anyone tell me why?
|
|
|
|
|
The where clause will be something along the lines of:
WHERE OccDate BETWEEN StartDate AND EndDate
But it is impossible to give you the exact syntax without knowing what database you are using.
|
|
|
|
|
Keith Malwitz wrote: The where clause will be something along the lines of
Not necessarily. It is perfectly valid to say a is greater than x and a is less than y as the OP did. In fact, it gives more clarity because the BETWEEN clause doesn't intrinsically tell you if it is inclusive or exclusive of the values used. In the OP's case he's using a mix. The start date is inclusive and the end date is exclusive, so the BETWEEN clause is just not going to work for him.
-- modified at 18:57 Sunday 27th August, 2006
|
|
|
|
|
Without knowing which database you are using this is difficult to answer. I always put the date in ISO format (i.e. yyyy-mm-dd) to ensure that the parser doesn't swap the month and date around depending on the locale. Also, I typically use parameters:
SELECT OccID
FROM dbo.People_Occ
WHERE (OccDate >= @minDate) AND (OccDate < @maxDate)
|
|
|
|
|
Try this:
SELECT OccID
FROM dbo.People_Occ
WHERE (OccDate >= '01/08/2006') AND (OccDate < '01/08/2007')
--EricDV Sig---------
Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them.
- Laurence J. Peters
|
|
|
|
|
|
Hi all,first sorry if my english in bad
I'm working on a small project for university and I'm using C#.net with sql server 2005(I'm pretty new with both of them ) .creating database and adding data was ok, BUT I've got stuck in "finding and editing" section I'm using MSDN help and walkthroughs.
I used tabaleAdapter for adding rows and for locating and editing I tried to use FindBy method and as I mentioned its not working, heres the problem:
I used [this]tutorial (I'm having the first situation!) and tried to do like whats said in there! so heres my code:
0:
1:csmDataSet.T_MemberRow membersRow1 = csmDataSet1.T_Member.FindByID(1212);
2:membersRow1.F_Name = ("john");
the first error occured in the first line saying : " csmDataSet1 does not exist " I solved this problem with adding another line before the other two (line 0):
csmDataSet csmDataSet1 = new csmDataSet();
I'm not sure if it was a right descision to use this code.
second problem(the MAIN problem!) occured in line 2 after adding this line
it says:
Title:NullRefrenceException was Unhandled
->Object reference not set to an instance of an object.
I should mention that a record with ID=1212 exist in the table but in autos window the value for membersRow1 is Null, I tried some other methods like beginEdit(),IsNull and.. the all have the Error And Ive searched the net and some forums but I couldnt find a solution although I think it should be A basic problemm!!
the membersRow1 object is already created I have no idea whats the reason for this error!
I'm in a short of timee and it's driving me nutss , I'd really appreciate it if anyone could help me with this problem, Thankyou for Your Patience thanks in advance for ur replies.
|
|
|
|
|
Is it possible to do a distributed transaction across two processes where one process calls the other using .NET remoting? (I'm using .NET 2.0)
Specifically, I have a system that manages work orders, and sometimes the work order requires an adjustment to stock. The stock system uses a .NET service that runs on a server. I'd like to start the completion process of the work order in a distributed transaction, call the stock management service, enlisting it in the transaction, and then finally complete or rollback the transaction in the original work order process. I have access to the stock management source code, so modifying or adding a new method isn't a problem.
If anyone has done this or knows if it would work, where to find an example or if there are any "tricks" that must be done, I'd appreciate any feedback or thoughts on this. I've never done any practical work with distributed transactions, just read the theory from books and simple examples.
Thanks for the help,
Trevor B
|
|
|
|
|
I have the following code:
sqlDataAdapter2.SelectCommand.Parameters["@Id"].Value = intId;
sqlDataAdapter2.SelectCommand.Parameters["@Bdate"].Value = dtpFrom.Value;
sqlDataAdapter2.SelectCommand.Parameters["@Edate"].Value = dtpTo.Value;
int intRows = sqlDataAdapter2.Fill(dataTime1,"Timesheet");
dgTime.Update();
The fill method is returning the right amount of rows (double check wwith a query)
dgTime's datasource property is dataTime1.schema.
But the datagrid never get's populated?
Any ideas? Anymore info you may need to help me?
Thanx in advance!
Jude
|
|
|
|
|
Did you bind the datagrid. Update is, if I remember, to put changes made in the data grid back into the database.
|
|
|
|
|
Desktop App, not web...No databind() for this object
Jude
|
|
|
|
|
|
OK - check this out. I just ran a simple test to comfirm something. Here is what I did step by step.
1) Create new project(Windows Application).
2) Dragged a sqlDataAdapter onto the form.
3) Went through the wizard (create new connection, use sql statements, query builder, chose table, chose all columns.
4) Generate Dataset.
5) Dragged DataGrid onto form.
6) Set the Datasource property of the datagrid to the dataset.table
7) Added sqlDataAdapter.Fill to the load method of the form.
Worked fine.
I am doing the same with the project in question. The only difference is in the SELECT Statement. I am joining two tables into the data set and it is a stored procedure.
Jude
|
|
|
|
|
Hi,
We have implemented a Windows c# application using a typed dataset (ADO.NET)
I've modified the relation so the childs get deleted when the parent is deleted. Delete action: cascade.
In the function where I process all the changes in the dataset (Dataset.GetChanges()),
I create for every table 1 adapter & call the .Update() function.
When the first adapter (for parent) is created & called the .Update() function, the parent and all its childs are deleted due to the relationship (Delete action: cascade)
A few lines further on, the adapter of the childs are called and the .Update() function throws an exception because the child is already deleted on the DB! This is very ennoying and I really don't know how to solve this problem.
Any idea how to solve this? I tested it out with my own SqlCommand object and the deletion of the parent & childs did not cause any problems.
I'd really love to keep the relationship so the childs get deleted automatically. This allows me to write less code 
Best regards,
Jens
|
|
|
|
|
|
Hi,
Performing the updates in the correct order is not a good solution aswell.
I have put the table adapter update of parent at the end, but this comes with another problem.
Let's say you have to create the parent, the table adapter needs to first do the inserts of the parents, otherwise the children won't be added because of the relationship!
Any other solutions?
Best regards,
Jens
|
|
|
|
|
Perhaps I was not clear enough in my previous post. When updating a data source containing multiple related tables, you should update in this order:
1. ChildTable Deleted Records
2. New, Modified, and Deleted ParentTable Records
3. New ChildTable Records
4. Modified ChildTable Records
This order ensures that updates can be performed properly, taking into account the relationship between the tables.
The link in my previous post will walk you through how to update records based on their status (Added, Modified, Deleted).
Hope this helps.
|
|
|
|
|
i wnat to create a backup from a database in local my SQL Server(2000)
to the another computer on the network.
for this reason i define a backup device with Sp_addumpdevice stord procdure
and device create successfully but when execute the command
(Backup database GrantBooks to MyDeviceName )in the Query analyzer i give message that backup database perform successfully but the backup not exist
on the device path and backup not created.
what i do for this problem?
thanks a lot.
CuttingEdge
|
|
|
|
|
Friendz,
Is there any way where in I can delete a column(s) from DataTable programatically in .NET 2005.
Regards,
Vipul Mehta
Regards,
Vipul Mehta
Software Engineer
Chenoa Information & Software Services Pvt Ltd
|
|
|
|
|
DataTable.Columns.Remove("ColumnName") or DataTable.Columns.Remove(ColumnIndex) or
DataTable.Columns.RemoveAt(ColumnIndex)
|
|
|
|
|
Hi,
I have the following table:
Name Value
---- -----
Paul NULL
Mary NULL
Paul 0
What query can I use to detect Mary (the only one that has no values), but not Paul?
thanx
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
