|
I am doing a windows based project in which i come across a situation where i need to update the values in the database with the values edited in the datagridview control. I need the code for doing this.
|
|
|
|
|
praveenkumar_vittaboina wrote: I need the code for doing this.
Well, this is no code shop where you get the ready code. 
What have done so far?
Break down your problem into small units, try to look in Google for the examples and still if you have difficult than pin point your problem so that some one can help you.
This will eventually make you a better developer too. 
Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
|
Hello,
I have a problem with the accuracy of double.
If i have a lot of formula that look somthing like this :
double a = Somthing1();
double b = Something2();
double c = something3();
double Ans = a+b-c
And in one of the calc the answer for :
a = 2e-35
b=1
c=1
then the formula need to be :
Ans =2e-35+1-1=2e-35+0=2e-35
but becaue a will be very small number and c and b will be big number (1)
then Ans will be 0 because it will do this:
(2e-35)+1-1 = ~0+1-1=1-1=0
so if
ans = a+b-c != b-c+a
What can i do to solve this problem ?
|
|
|
|
|
Use a float.
On a more serious note, all programmers should know that:
double a = 1.5;
double b = 1.5;
bool result = a == b
When doing double math determine the acceptable margin of error and use that in your calculations to evaluate equality. Usually margin of error is one order of magnitude below significant results. The other option is to magnify your numbers by a factor before performing your results and then divide when finished. Double will eventually run out of precision.
|
|
|
|
|
Multiply c by -1 and then apply Kahan summation. You can't really do anything better than that unless you know something about a b and c in advance.
|
|
|
|
|
Hi,
when you are accumulating numeric values, you have to take care of the order you apply; the right order could be:
- small to large if you don't expect values to cancel out (say you have to add a million times 1 and one billion; doing the ones first will yield one million, which is visible when added to one billion. The other way around each individual one would be lost against the billion.
- large to small if you have large values that cancel each other out.
As you can see, it isn't straightforward. There is a difference between computer hardware+software and algebraic equations.
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
|
|
|
|
|
Excel.Application ExcelApp = new Excel.ApplicationClass();
ExcelApp.Visible = false;
String WorkbookPath = filename;
Excel.Workbook ExcelWorkbook = ExcelApp.Workbooks.Open(WorkbookPath, 0, false, 5, "", "", false, Excel.XlPlatform.xlWindows, "", true, false, 0, true, false, false);
Excel.Worksheet Sheet = (Excel.Worksheet)ExcelWorkbook.Sheets[1];
DataTable newTable = new DataTable();
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filename + ";Extended Properties= Excel 8.0";
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
OleDbCommand cmd = new OleDbCommand("SELECT * FROM [" + Sheet + "$]", conn);
cmd.CommandType = CommandType.Text;
OleDbDataAdapter da = new OleDbDataAdapter(cmd);
da.Fill(newTable);
dataGridView1.DataSource = newTable;
I am using this code to read an excel file and save the data in a datatable ....
I am getting this error "System.__ComObject$' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long." and the error pointer comes on the second last line of the code ... can neone help
|
|
|
|
|
You are building your SQL string by concatenating the object Sheet. This object is of type Excel.Worksheet - which is not a string. Thus, as with all objects, it is calling it's ToString() method to obtain a string value it can concatenate with the rest of the SQL string. Since Excel.Worksheet is a COM Object, it's ToString is returning "System.__ComObject". You'll need to obtain the actual text name of the worksheet and use that to build the SQL string.
|
|
|
|
|
Thankyou very much ... the answer was not only precise but was very well explained
|
|
|
|
|
You may also want to take a look at OleDbConnection.GetSchema (Google it to find the MSDN documentation link). This will allow you to directly obtain schema information for the Excel file. The schema is returned as a DataSet containing DataTables for a variety of entities. One of these DataTables will contain a list of table names (which are the Excel worksheet names you'll use in your queries). This will allow you to avoid using COM automation entirely (ie. Excel Object library) to obtain the list of Worksheets. The benefit: no dependency on Excel object library DLLs, registration, versioning, etc... all the headaches that come with COM automation.
|
|
|
|
|
Hi all,
if someone forgets there password for login to a website, i would like to send them an email with there username and password by quering the database.
Can any one advice me on the C# code that is used for sending email to a user?
Thank you in advance.
|
|
|
|
|
If you search this site for an article called 'how to use google', you'll find that I both answer your question, and the underlying question that caused you to need to ask this.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Hi Christain,
Thank you for your response.
Can you at least learn to be polite?
Any ways I have the Answer :
System.Net.NetworkCredential SMTPUserInfo = new System.Net.NetworkCredential(sSMTPUser, sSMTPPass);
SmtpClient emailClient = new SmtpClient("smtp.gmail.com",587);
The 587 works with some mail Client but not with others like Gmail, etc...
|
|
|
|
|
He is being polite, and you're being lazy. You can find out what port Google expects by Googling for "SMTP port gmail".
Good luck
I are troll
|
|
|
|
|
kibromg wrote: Can you at least learn to be polite?
Watch your tone there, Christian Graus has been a member at codeproject for years, with over 50,000 posts and 30 articles, his Fixture/Legend status has been earned.
You are a firstly and obviously a beginner and new to programming, you're putting in NO effort to make your system functional other then expecting your work handed to you.
I'll be less polite then others, get the f*** off your ass and go learn to use Google, and if you can't find your answer there then guess what, it's time to find a different f***ing profession, one that is more suited to your (lack of) intelligence.
How's that for polite, buddy?
|
|
|
|
|
EliottA wrote: How's that for polite, buddy?
Not much, I'm afraid.
However it is pretty clear, except for some asterisks.
Do you really need 27 letters in your alphabet?
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
|
|
|
|
|
I could have circumvented then filter, but I didn't feel it appropriate.
Those responses truly get to me, especially when geared towards people with high post/article counts who have contributed more then enough for others. I knew zilch about programming before I stumbled my butt onto this site, and learned from various tutorials and posts before I began to post myself.
So retorts like that, insulting from people from whom I've directly (or indirectly) learned off of comes as a direct insult to me.
|
|
|
|
|
Yes, you and I both don't like what was said.
However, if I would want to call someone impolite, I would still try and do so in a polite way if such is possible at all.
![Rose | [Rose]](https://www.codeproject.com/script/Forums/Images/rose.gif)
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
|
|
|
|
|
|
I have a class called "Card" (as in a deck of cards), which extends the PictureBox class. Now the picturebox is the size of the image (150X215). When you mouse over the card it "hovers" (its Y location decreases 20 pixels) and is supposed to show part of the card underneath it. However this does not happen. See this picture: http://img199.imageshack.us/i/cardsj.jpg/[^]
I've done this in the OnLoad event of the Card class:
this.SetStyle(ControlStyles.SupportsTransparentBackColor, true);
this.BackColor = Color.Transparent;
But it doesn't work (as you can see in the picture). I found this article: http://www.codeproject.com/combobox/TransListBox.asp[^]
But how do I do this in C#?
BTW the images are transparent png's.
|
|
|
|
|
Using pictureboxes for this, is a little insane. Just draw your cards onto your form in your paint event.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
I've changed it from PictureBox to Panel and added this:
protected override void OnPaint(PaintEventArgs pe)
{
base.OnPaint(pe);
pe.Graphics.DrawImage(this.card_image, new Point(0, 0));
}
But it's still not transparent. Do you want to look at my code?
|
|
|
|
|
No, I want you to do what I suggested. DON'T put the images inside a control, draw them on your form directly, in your paint event.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Christian Graus wrote: Using pictureboxes for this, is a little insane
ftfy
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
