mandarapu:马库斯・克雷默:只​​需包括在SELECT语句中的列codeprelang="sql"spanclass="code-keyword"SELECT/spantasid,tasknamespanclass="code-keyword"FROM/span[YourTableName].../pre/code

如何从数据库中检索列:海

我在数据库tasid列，但我不使用编码，特别id.i我转换的ID编码任务名。

现在，我的问题是，当我被分配任务，将触发一个邮件，我需要显示任务名和taskid.how我可以检索该数据库列的前端。

请帮人

private void SendMail()

    {

        try

        {

            

            SmtpClient smtpClient = new SmtpClient();

            MailMessage message = new MailMessage();

            ArrayList empName = null;

            LoginBL loginBL = new LoginBL();

            StringBuilder sb = new StringBuilder();

            empName = loginBL.GetEmployeeName(ddlEmpName.SelectedValue);

            //message.Body = "Please Check Your Task in HRMS";

            message.From = new MailAddress(Session["EmailId"].ToString());

            sb.Append("Hi " + empName[5].ToString());

            sb.AppendLine();

            sb.AppendLine();

            if (hdnEdit.Value != string.Empty)

            {

                //sb.Append("HRMS : " +ddlTaskName.SelectedItem.Text + " is updated");

                message.Subject = "HRMS : " + ddlTaskName.SelectedItem.Text + " is updated";

            }

            else

            {

                //sb.Append("HRMS : " +ddlTaskName.SelectedItem.Text + " is Assigned to You");

                message.Subject = "HRMS : " + ddlTaskName.SelectedItem.Text + " is Assigned to You";

 

            }

            sb.Append("Please Check Your Task in HRMS");

            sb.AppendLine();

            sb.Append("\n");

            sb.Append("Task Name : " + ddlTaskName.SelectedItem.Text);

            sb.AppendLine();

            sb.Append("\n");

            //sb.Append("Task ID : " + 

            //sb.AppendLine();

            sb.Append("Thanks,");

            sb.AppendLine();

            sb.Append(Session["EmployeeName"].ToString());

            message.Body = sb.ToString();

            message.To.Add(empName[2].ToString());

            smtpClient.Send(message);

        }.