|
I am using C# with WPF. Database will be in server system. Client System will have only Sofware. I am new to Client and server. Server and client connected through LAN. Server windows 7 os
|
|
|
|
|
|
This is done by using a "provider" that is able to talk to the database (making connections, sending SQL queries and retrieving data, errors, ...).
There are several different providers for Oracle. probably the best is ODP.Net, but you also have OleDb or ODBC providers. I'd recommend wrapping the provider classes with a DAL (Data Access Layers) component.
Feel free to read this[^] article to get an idea.
To connect to the correct database you need a connectionstring. Look here[^] for more info.
Do a prototype first before directly changing your good application .
hope this helps.
|
|
|
|
|
hello
i'm using c# to create an application to send email to multiple email address that stored in datagridview column
this is the code for sending to single email
try
{
SmtpClient client=new SmtpClient("smtp.gmail.com",587);
MailMessage message = new MailMessage();
message.From = new MailAddress(txtemail.Text);
message.To.Add(txtreciever.Text);
message.Body = txtbody.Text;
message.Subject = txtsubject.Text;
client.UseDefaultCredentials = false;
client.EnableSsl = true;
if (txtattachment.Text != "")
{
message.Attachments.Add(new Attachment(txtattachment.Text));
}
client.Credentials = new System.Net.NetworkCredential(txtemail.Text, txtpassword.Text);
client.Send(message);
message = null;
MessageBox.Show("Message Sent");
}
catch(Exception ex)
{
MessageBox.Show( "Failed to Send Message");
}
|
|
|
|
|
And?
What's the problem you are having with multiple sends?
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
it sends only to one email >> message.To.Add(txtreciever.Text);
i have datagridview i need get emails from email column and send my email to all
|
|
|
|
|
Well, you know how to get the contents of a DGV column, I assume?
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
yes i can get it and send to richtextbox
but i dont know how to get it from richtext and separate each email and send email one by one
|
|
|
|
|
Why send multiple emails? Send a single email to multiple recipients.
Set the To address to your own, and add the emails to the BCC , separated by semi-colons.
Each recipient will get a copy of the email, and will not see the other addresses.
=========================================================
I'm an optoholic - my glass is always half full of vodka.
=========================================================
|
|
|
|
|
thats exactly what i want sorry for my bad english
can just correct it by code
|
|
|
|
|
You need to loop through the rows in the dataset.
Create the email object, set the text, attachments etc as you do now, then loop through the dataset, adding the email address, followed by a semicolon, to the BCC address, so at the end of the loop it will look something like:
joe.bloggs@email.co.uk;jane.do@hotmail.com;member.11579870@codeproject.com;
After populating the address field, send the email.
=========================================================
I'm an optoholic - my glass is always half full of vodka.
=========================================================
|
|
|
|
|
Why send it to an RTB? If you can get the data on a row by row basis, then you already have hem separated...
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
how to bind sql data in kendo ui grid in webpage not in mvc
|
|
|
|
|
|
I have a followin problem. My task is to create a simple chart drawing library(like Windows Charts for example). I have already tried tu use Graphics class but there are few problems with this approach. When using Graphics i have no control over stuff that I already drawn. I need a way to interact with drawn objects - to erase a specific point or line from the view, or to make a mouse hover events. I simply ask for some guidance how to even start.
|
|
|
|
|
If it's alright for you to borrow some ideas from other projects then you will find a lot of articles when you google for "codeproject chart designer" or "codeproject report designer".
Otherwise my suggestion would be: Have an anchor point for each graphical element and, depending on the shape of the element, zero to many track-points. Keep these points in some collection: Maybe a simple List<T> to start off with but probably there's room for optimization. Subscribe to mouse-move-events and calculate the distance of the mouse pointer to these points to determine the closest point (there's the optimization potential: if it's not a simple List but a structure that lets you sort the points by their x- any y-coordinates then you could find the closest point faster). If the distance is below a chosen threshold, change the mouse pointer to indicate the possibility of some action - like dragging the shape. If the user clicks and holds the mouse button, change the shapes coordinates (or dimensions) according to the mouse movement until he releases the mouse button while repainting the graphics area.
Would this be the sort of guidance you were asking for?
If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson
|
|
|
|
|
Yes, it was helpful. Thank You.
|
|
|
|
|
You're welcome!
If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson
|
|
|
|
|
GENARATE AUTO SERIAL NUMBER
kumarmayank354@yahoo.com
|
|
|
|
|
I have no idea what your question is. Please read: How-to-get-an-answer-to-your-question[^]
I suggest you remove your email address from your message if you want to avoid being spammed.
If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson
|
|
|
|
|
I also have no idea what help you need, and would agree: Never post your email address in any forum, unless you really like spam! If anyone replies to you, you will receive an email to let you know.
And DON'T SHOUT. Using all capitals is considered shouting on the internet, and rude (using all lower case is considered childish). Use proper capitalization if you want to be taken seriously.
You want an answer? Describe your problem, remembering that we can't see your screen, access your HDD, or read your mind. Tell us what you have tried, what problems you met, and what help you need. And don't shout at us...it may work with your mother but in the real world it is unlikely to help you with anything...
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
You have posted a similar question in Q& A section:
"auto generate serial number in c# "
Please don't Spam... Have some patience to get you answer. Also, Explain the problem you are facing. We have not developed telepathic abilities till date. Until then, you need to explain stuff..
|
|
|
|
|
Here you go: 19386461206399246257047 .
/ravi
|
|
|
|
|
I hope that's guaranteed to be random[^]!
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Ask me again, and I'll guarantee I'll give you a different one. You have my guid on that.
/ravi
|
|
|
|