<%@ Application Language="C#" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Net" %>
<%@ Import Namespace="System.Net.Mail" %>
<script runat="server">
void Application_Start(object sender, EventArgs e)
{ SqlConnection sql = new SqlConnection();
sql.ConnectionString =ConfigurationManager.ConnectionStrings["ConnectionString2"].ConnectionString;
SqlCommand cm = new SqlCommand("SELECT Members.Email, Members.Member_Name,Reminder.Reminder_Text FROM Members INNER JOIN Reminder ON Members.Member_Id = Reminder.Member_Id where Reminder_Date=" + DateTime.Now.Date, sql);
cm.Parameters.AddWithValue("@re",DateTime.Now.Date);
SqlDataAdapter myAdapter = new SqlDataAdapter();
myAdapter.SelectCommand = cm;
sql.Open();
DataSet reminder = new DataSet();
myAdapter.Fill(reminder);
sql.Close();
foreach (DataRow row in reminder.Tables[0].Rows)
{
MailMessage msg = new MailMessage("a7lyareej@gmail.com",row[1].ToString(),row[0].ToString(),row[2].ToString());
msg.IsBodyHtml = true;
NetworkCredential mailAuth = new NetworkCredential("a7lyareej@gmail.com", "555555555555");
SmtpClient mailClieant = new SmtpClient("smtp.gmail.com", 587);
mailClieant.EnableSsl = true;
mailClieant.UseDefaultCredentials = false;
mailClieant.Credentials = mailAuth;
mailClieant.Send(msg);
}}يظهر هذا الخطأ
Incorrect syntax near '12'.
السطر 24: myAdapter.Fill(reminder);
جربت إنه اعطي الداتا ست اسم...نفس المشكلة تظهر مع العلم جربت هذا الكود في صفحة عادية ضبط...لكن في الجلوبل مايضبط ايش المشكلة؟؟