Sending mail form a table instead from a form - new to C# aspnet

Question

1.00/5 (1 vote)

See more:

SQL-Server-2008R2

Have the undernoted code segment which is working ok from a form.

Need to apply it from a table with the undernoted fields in sql server

Table: Mail.dbo

name        email               memo
----------------------------------------
eva         aaa@gmail.com     trialeva
sam         bbb@gmail.com     trialsam
jon         ccc@gmail.com     trialjon
amy         ddd@gmail.com     trialamy

C#

EmailSubj = "Trial Message";
EmailMsg = Convert.ToString(txt_Trial_memo.Text);

string[] emails = new string[] { txt_Email.Text, txt_Zemail.Text, txt_Bemail.Text };
foreach (var email in emails)
{
    if (!string.IsNullOrWhiteSpace(email))
        SendEmail(email, EmailSubj, EmailMsg);
}

Please assist in building the loop

or offer any web refereneces to assist.

Thanks

What I have tried:

Reviewed codes on the internet and earlier codes in another language

Posted 2-Oct-16 18:49pm

Member 12770648

Updated 3-Oct-16 4:34am

David_Wimbley

v2

Add a Solution

Comments

Sinisa Hajnal 3-Oct-16 7:01am

SO, you need to get the data (emails) from the database and use that? In C#? And you cannot be bothered to find decent example of data retrieval of which there are thousands? 1 vote.

Member 12770648 3-Oct-16 12:36pm

please its not about the connection. I am new to c# asp.net I just moved from another language.

Its about the looping to send the message

Member 12770648 3-Oct-16 12:46pm

You have misled the request.

All, I wanted was how to get the filtered records mailed and not about the connection please.

I have searched for such an example but to no avail.

ZurdoDev 3-Oct-16 10:25am

I agree with Sinisa. It sounds like you are asking how to get data from a database. That is standard and simple but depends on your data structure so we can't tell you how to to it anyway. It would help if you could clarify what you are asking.

[no name] 3-Oct-16 10:26am

"Reviewed codes on the internet", yeah sure. I find it very hard to believe, no impossible to believe, that you searched the internet for how to connect to and query a SQL Server database and found absolutely nothing?

Member 12770648 3-Oct-16 12:32pm

Its not about the connection please .

Its about setting the loop thereafer afer the data has been retrieved,

Member 12770648 3-Oct-16 12:37pm

Please its not about the connection.

Its about how to loop to send the mails in c# asp.net

[no name] 3-Oct-16 13:01pm

What about the loop? A loop is a loop is a loop. for each row in your table, get the information from the table, send the email using the information you got from the table. What exactly is the problem?

Member 12770648 3-Oct-16 16:57pm

I have just read about datasets and I need to incorporate the operation in a while loop.

Remember this is a feature I have working in another language and Iam switching over to c# asp.net, There is a learning curve.

You guys are not patient with new users.

[no name] 3-Oct-16 18:53pm

We are plenty patient with new users. We expect people to actually try to do their work themselves. If you have to use a while loop, then why is there no while loop in the code that you have shown us? Why didn't you mention this before? If you are learning then go learn. We can't teach you programming in a forum posting like you are expecting us to do.

F-ES Sitecore 3-Oct-16 10:28am

To get data from your database you can use ado.net. Google "ado.net tutorial" or "ado.net getting started" and you'll find examples of how you read data from a table.

Member 12770648 3-Oct-16 12:34pm

I dont have problem with data retrival please.

Its the looping please.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

David_Wimbley · Answer 1 · 2016-10-03T04:31:00

So what you are asking is really how to connect to sql server using c# and access the data. I know nothing about your project/how you intend to access the data. There are many different ways to access sql server (normal ado.net, entity framework, nhibernate...etc.) so I'm going to assume you are using entity framework as that is the easiest way to answer this question.

What you need to do is first, research what it is you are trying to do as this is an extremely basic thing to do in C#. Accessing data, to me, is one step above Hello World and is something you should be familiar with already.

So to get the data you would do something like.

C#

// I added IsSent to your Mail table as a way to filter out mail already sent. You could also just delete these items from your table after mail has been sent.
var mailToSend = context.Mail.Where(m=> !m.IsSent);

foreach(var mail in mailToSend)
{
     SendEmail(mail.email, "You don't have a subject column, static text/passed in variable here", mail.memo);
}

the mailToSend variable is a collection of items from your database. You need to decide how you intend on accessing your data. For more information on using entity framework (and general C# to sql connections) see below links:

connect to sql server c - Google Search[^]

use entity framework C# - Google Search[^]

Getting Started (Entity Framework)[^]

Getting Started with Entity Framework 6 Code First using MVC 5 | The ASP.NET Site[^]

An Introduction to Entity Framework for Absolute Beginners[^]

Entity Framework Tutorial[^]

UPDATE:

In the off change you want to use Sql Server DB Mail...here are some links. You need to evaluate what it is you are trying to do and see which option best fits your needs.

sp_send_dbmail (Transact-SQL)[^]

Configure Database Mail[^]

SQL Database Mail – Send Emails from SQL Server – Microsoft SQL Server on Windows Azure Virtual Machines[^]