|
MS has biased .NET to work well with SQL Server. If you want to go really fast don't use fill. Instead create type objects and use the datareader as well as appropriate Where clauses. In my experience, Oracle (when done correctly) will vastly outperform SQL Server.
Need a C# Consultant? I'm available.
Happiness in intelligent people is the rarest thing I know. -- Ernest Hemingway
|
|
|
|
|
Thank.
Ennis Ray Lynch, Jr. wrote: In my experience, Oracle (when done correctly) will vastly outperform SQL Server.
You mean what Oracle data reading is done correctly only through DataReader????
I just wander what internaly Fill method implemented throught DataReader isn't it????
|
|
|
|
|
El'Cachubrey wrote: You mean what Oracle data reading is done correctly only through DataReader????
Of course not. A data reader is slightly faster as there is less overhead, but the difference is far from what you describe.
El'Cachubrey wrote: I just wander what internaly Fill method implemented throught DataReader isn't it????
Yes. The difference is the overhead that is added by the DataTable.
Experience is the sum of all the mistakes you have done.
|
|
|
|
|
Hi all.
I need help converting an html file to pdf in code.
I've had a look at some trial code (Sautinsoft and ExpertPdf), it works, but it places a watermark on the generated pdf saying I should purchase the entire component. Is there a free way to do this? I'm looking at Itext# and i do not think it will cut it.
Any help would be much appreciated.
Thanks
M
|
|
|
|
|
Try SharpPDF
http://sharppdf.sourceforge.net/
|
|
|
|
|
Hi.
Im writing a program that uploads a file to a FTP server, after it has done that i want it to compare the uploaded file with the one on the harddrive.
Anyone know how to check for uploaded files and check that the files are identical in size ?
//Regards M
|
|
|
|
|
FileInfo info = new FileInfo(file_to_check)
if(info.Exists)
long len = info.Length
only two letters away from being an asset
|
|
|
|
|
i use a method that looks like this
public bool upload(string fileName)
{
FileInfo fileInf = new FileInfo(fileName);
string uri = "ftp://" + FtpServerIP + "/" + fileInf.Name;
FtpWebRequest reqFTP;
reqFTP = (FtpWebRequest)FtpWebRequest.Create(new Uri("ftp://" + FtpServerIP + "/" + fileInf.Name));
reqFTP.Credentials = new NetworkCredential(FtpUserID, FtpPassword);
reqFTP.KeepAlive = false;
reqFTP.Method = WebRequestMethods.Ftp.UploadFile;
reqFTP.UseBinary = true;
reqFTP.ContentLength = fileInf.Length;
if (fileInf.Exists)
{
return false;
}
else
{
int buffLenght = 20482;
byte[] buff = new byte[buffLenght];
int contentLen;
FileStream fs = fileInf.OpenRead();
try
{
Stream strm = reqFTP.GetRequestStream();
contentLen = fs.Read(buff, 0, buffLenght);
while (contentLen != 0)
{
strm.Write(buff, 0, contentLen);
contentLen = fs.Read(buff, 0, buffLenght);
}
strm.Close();
fs.Close();
return true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Upload Error");
}
}
return true;
}
how do i implement what u suggested correcly ?
|
|
|
|
|
Perhaps I'm misunderstanding. You have the file you are uploading, FileInfo fileInf = new FileInfo(fileName); What is the point it comparing the uploaded version of the same file?
only two letters away from being an asset
|
|
|
|
|
Well i want to be sure that the upload was completed succesfully, later i am deleting the file from the harddrive, thats why I need to do the check.
|
|
|
|
|
Generally, I'd say if you got no exceptions, then it succeeded. Usually the simple solution is the one that works best.
only two letters away from being an asset
|
|
|
|
|
hi my aim is to close a open socket ....that too perfectly
socket.close() is raising exceptions ..any methods to close it forcefully
its me sid
|
|
|
|
|
This is just a quess, but maybe try doing a socket.Disconnect() first?
I'm going to become rich when I create a device that allows me to punch people in the face over the internet.
"If an Indian asked a programming question in the forest, would it still be urgent?" - John Simmons / outlaw programmer
|
|
|
|
|
I have some questions as below :
1.I want to connect to my application which is intalled in another country,
and the clients who work with this app have low speed internet and they are very beginner
now i have this problem that how i can use some apps for connecting to them or how i can
embed such API in my app when user clicks on that it automatically send the its desktop for me
|
|
|
|
|
Google came up with this[^] among others
|
|
|
|
|
|
Are you sure that you wrote that code? It looks like you copied and pasted it from somewhere, without even looking at it. What's the give-away, you may ask?
clife537 wrote: mail.From = "mail@mymail.com";
clife537 wrote: mail.To = "mail@mymail.com";
clife537 wrote: mail.Fields["http://schemas.microsoft.com/cdo/configuration/sendusername"] = "mail@mymail.com";
clife537 wrote: mail.Fields["http://schemas.microsoft.com/cdo/configuration/sendpassword"] = "xxxxxxx";
clife537 wrote: SmtpMail.SmtpServer = "smtp.domain.com";
You are supposed to replace all those with actual E-Mail addresses, and your working SMTP server.
I'm going to become rich when I create a device that allows me to punch people in the face over the internet.
"If an Indian asked a programming question in the forest, would it still be urgent?" - John Simmons / outlaw programmer
|
|
|
|
|
Isn't the MailMessage.To property, read-only? I don't think you can write
clife537 wrote: mail.To = "mail@mymail.com";
It would generate an error.
To add an email address to the MailMessage.To property, you'd have to write something like:
mail.To.Add("someone@somewhere.world");
Ashish
|
|
|
|
|
Hi,
Does anyone know how the get/Pass the DBnull Value of an integer field from a typed dataset without getting an error?
Propertie Allow DBnull is true for my integer field.
Thx
Kurt
|
|
|
|
|
I'm not quite sure I understand your question, but if I understand correctly, DBNull.Value, will give you a null value you can pass.
I'm going to become rich when I create a device that allows me to punch people in the face over the internet.
"If an Indian asked a programming question in the forest, would it still be urgent?" - John Simmons / outlaw programmer
|
|
|
|
|
hi,
thx for u'r response. (i rather be polite thinking you're invention maybe exists.  )
Its a column from a typed dataset, which has no value entered by the user. so the value is DBnull. When getting my value to pass to a stored proc it results in an error.
Typed dataset DataSet1 with Table1 has 3 columns all integers with property allow DBnull
Gives a row Table1Row with fields Table1Row.ID1, Table1Row.ID2, Table1Row.ID3
when calling for example Table1Row.ID2 it gives an error.
In designtime the property Nullvalue also remains (throw exception) and cannot be modified. For string fields it's no problem.
Thx again.
Kurt
|
|
|
|
|
topcatalpha wrote: thx for u'r response. (i rather be polite thinking you're invention maybe exists. )
topcatalpha wrote: When getting my value to pass to a stored proc it results in an error.
What is the error message you are recieving?
I'm going to become rich when I create a device that allows me to punch people in the face over the internet.
"If an Indian asked a programming question in the forest, would it still be urgent?" - John Simmons / outlaw programmer
|
|
|
|
|
The error message is :
The value for column 'ID2' in table 'Table1' is DBNull
|
|
|
|
|
Double check that the field ID2 does allow null values, that make sure that there isn't a exception thrown if there is a null value. Additionally, in your code, you can check the value before passing it, and if it is equal to DBNull then set the value to 0 instead of null.
I'm going to become rich when I create a device that allows me to punch people in the face over the internet.
"If an Indian asked a programming question in the forest, would it still be urgent?" - John Simmons / outlaw programmer
|
|
|
|
|
Found something :
[^]
i need to check each field for null and pass null value myself. Seems very unlogic to me knowning that SQL servers allow DBnull values in tables.
Ex :
<br />
if(Table1Row.IsID2Null())<br />
ATDatabase.AddInParameter(updateCommand, "ID2", DbType.Int32, null);<br />
else<br />
ATDatabase.AddInParameter(updateCommand, "ID2", DbType.Int32, Table1Row.ID2);
Checking the auto generated code from the typed dataset:
[System.Diagnostics.DebuggerNonUserCodeAttribute()]<br />
public long ID2 {<br />
get {<br />
try {<br />
return ((long)(this[this.Table1.ID2Column]));<br />
}<br />
catch (System.InvalidCastException e) {<br />
throw new System.Data.StrongTypingException("The value for column \'ID2\' in table \'Table1\' is DBNull.", e);<br />
}<br />
}<br />
set {<br />
this[this.Table1.ID2Column] = value;<br />
}<br />
}
Cannot pass null value here...
greetz
Kurt
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
