TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Kris Lemoine
1.7k
45
212
huge transfer with OleDbCommand
Oct 14 2004 2:55 AM
I have a strange problem. I have a .sql file that containts 3000 insert commands. I read every line and execute the command on the database. Till there there is no problem, it reads everything and executes everything. But if i watch to my datatransfer over the network, i have send and received 260Mb. That couldn't be normal. I work with OleDbCommand.ExecuteNonQuery, and maybe there will be the problem? this is my code: private OleDbConnection myConn; public create_database() { string connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=//cpc-srv/datanl/testmap-stage/bank_database.mdb"; myConn = new OleDbConnection(connStr); myConn.Open(); } protected override void Dispose( bool disposing ) { myConn.Close(); } public string doe(string commando) { OleDbCommand comm = new OleDbCommand(commando,myConn); comm.ExecuteNonQuery(); } private void start(object sender, System.EventArgs e) { StreamReader objReader = new StreamReader("c:\\datab.sql"); string sLine=""; while (sLine != null) { sLine = objReader.ReadLine(); if (sLine != null && sLine!="") doe(sLine); } objReader.Close(); }
Reply
Answers (
3
)
serial number for the setup
how can I define a HEX value in c#?