|
Hello,
I am facing a problem in updation of data to dBaseIII database.
I have to append two dBaseIII databases and insert to third database(which all the table structures are same).
I have merged two datasets and tried to update the third database by using ODBCDataAdapter, I was able to see that the two datasets are merged in debugging, but when it was updated by the command ODBCDataAdapter.Update(dsDataset); the new records are not reflecting the physical dBaseIII database.
I was able to select the data from the database, but not able to insert new data through C# program.
The following is the code I have tried! Can any one help me to resolve this problem.
adSTOERUNG = new System.Data.Odbc.OdbcDataAdapter("SELECT * FROM xyzTable",cnnST );
System.Data.Odbc.OdbcCommandBuilder builder = new System.Data.Odbc.OdbcCommandBuilder(adSTOERUNG);
adSTOERUNG.Fill(DSMain,"xyzTable");
DSMain.Merge(DS2Insert.Tables[0]);
adSTOERUNG.Update(DSMain.Tables[0]);
The following ODBC driver I have used for connection.
CollatingSequence=ASCII;SafeTransactions=0;Threads=3;Statistics=0;MaxScanRows=8;DefaultDir=c:\xyz;FILEDSN=c:\xyz\xyztable.dbf.dsn;index=code; DriverId=21; UserCommitSync=Yes;FIL=dBase III;PageTimeout=0;Driver={Microsoft dBase Driver (*.dbf)};MaxBufferSize=10000;UID=admin"
Regards,
Kishore.
|
|
|
|
|
can anybody give me a tutorial on using the progress control bar.
thnaks very much
|
|
|
|
|
The following code can help
drag and drop on form, adjust the size as per your requirements.
private System.Windows.Forms.ProgressBar progressBar1;
this.progressBar1 = new System.Windows.Forms.ProgressBar();
progressBar1.Maximum = 100;
progressBar1.Minimum = 0;
progressBar1.Step = 100 /10;
|
|
|
|
|
I want it to be like a profit bar that tells me if the stock is winning or loosing according to a database that gives the prices of the stock.
how do i set the progress bar to do so.
and how do i make it give more than one color.
for example if it is loosing it gives red and if it is winning it gives green
thanks
|
|
|
|
|
You might consider creating a custom control, to graph your needs, not a progressbar control
------------------------------ "The Soapbox has been so ..."
|
|
|
|
|
Here u have very clear information about the Progress control bar
http://msdn2.microsoft.com/en-gb/library/ms670342.aspx. if u have any doubts after this please reply i can explain u clearly
bye.......
|
|
|
|
|
Hi
I would like to list all the available servers from tnsnames.ora file.
DBNAME =
(DESCRIPTIOMN= (ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=113.114.2.145)(PORT=1521))
(CONNECT_DATA=SERVICE_NAME=dbname))
In this file i want to read exactly service_name. How to do it in C#. Any one could you help me please?
kesavan
|
|
|
|
|
Regular expression to find the service name, then check matches collection.
|
|
|
|
|
HI
well here is another question
how do we provide help facility with in a windows application. what are the strategies/ methodologies for it.
thanks in advance
Rocky
|
|
|
|
|
This article should help. http://www.helpscribble.com/dotnet.html[^]
the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
yea that looks helpful Pete' and I'll read it out now and see what happens
thanks
|
|
|
|
|
i use AxShockwaveFlashObjects in VS.net 2003 , but when i run the exe of this project , on framework 2 , this object cause error!!!!!!!!
why?
how could i solve this problem!!!
|
|
|
|
|
Hi
well I just wanted to know how can we back up a database from a windows application at lets say a specifin instance of time. Wel I'm using Sql server 2000 and C# 2.0. I have made a stored procedure that can backup the database too but I was wondering that the stoored procedure is also in that database too. so what happens if the databse gets curropted and how would my application know if it's curropted or not.
thanks in advance
Rocky
|
|
|
|
|
Open an ADO connection and run excute nonquery with a backup script such as....
<br />
<br />
BACKUP DATABASE [Northwind] TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\Northwind.bak' WITH NOFORMAT, NOINIT, NAME = N'Northwind-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10<br />
GO
Handy hint, Use the SQL2005 management console (even for 2000 dbs) design you backup then hit the script buttton. Wosh.... you have your script or if you feeling professional RTFM.
Blog Have I http:\\www.frankkerrigan.com
|
|
|
|
|
|
i have a toolstrip container which contains some toolstrips. I want toolstrips's order to be reverse displayed at runtime.Means the order i added the controls to be reversed. how can i make it?
|
|
|
|
|
|
can u please tell it with an example prgm
|
|
|
|
|
Hi all, I just listen a socket for permanent data and want to save it in a file. Can anybody help me?
//Socket socket = ...
NetworkStream ns = new NetworkStream(socket);
Int32 i = ns.Read(bytes, 0, bytes.Length);
while (i != 0)
{
//Code here
}
|
|
|
|
|
You can save the data like this
using System.IO;
...
NetworkStream ns = new NetworkStream( socket );
byte[] bytes = null;
Int32 reveivedDataLenght = ns.Read( bytes, 0, bytes.Length );
FileInfo receivedDataFile = new FileInfo( @"C:\receivedDataFile.bin" );
FileStream fs = receivedDataFile.Open( FileMode.Append, FileAccess.Write, FileShare.Read );
fs.Write( bytes, 0, reveivedDataLenght );
|
|
|
|
|
|
Hello everyone,
How can I check if the mouse is inside or outside the client area.. To be more specific I have tried to make a calculation for inner controls but this do not work for the Form.
I am doing a drag-drop operation and I need to know when the user tries to drag something outside the main form. Is there a way to achieve ?
Thanks in advance and best regards !
.:: Something is Wrong ::.
|
|
|
|
|
Hello,
You could set a flag at the MouseLeave event of the Form.
Hope that helps!
All the best,
Martin
|
|
|
|
|
Thanks for your reply but it doesn't work.. I add a MouseLeave event which set the mouseInside booleand to false and a MouseEnter event which set the same boolean to true..
But interestingly when my mouse is over a control inside the Form the MouseLeave event is fired..
.:: Something is Wrong ::.
|
|
|
|
|
for which controls are you useing MouseLeave and MouseEnter events?
I think you should specify those two events for every control in you form.
Hope it helps
|
|
|
|