如何从数据库中检索列 [英] how to retrieve the column from database

问题描述

hai，

我在数据库中有tasid列，但未在编码该特定ID时使用过.我正在编码中将该ID转换为TaskName.

现在，我的问题是当我被分配一个任务时，将触发一封邮件，因为我需要显示taskname和taskid.如何检索该数据库列到前端.

请帮助任何人

hai,

i have a column tasid in database but i was not used in coding that particular id.i am converting that id to taskname in coding.

now,my problem is when i was assigned a task a mail will be triggered in that i need to display taskname and taskid.how i can retrieve that database column to frontend.

please help anyone

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);
        }.

推荐答案

只需在选择语句中包含该列.

Simply include the column in your select statement.

SELECT tasid, taskname FROM [YourTableName]...

尝试这些以学习ADO.net的概念:

使用C#读取，插入，更新和删除简单的ADO.NET数据库. [通过C#访问SQL Server的入门指南 [

Try these for learning concepts of ADO.net:

Simple ADO.NET Database Read, Insert, Update and Delete using C#.[^]

Beginners guide to accessing SQL Server through C#[^]

and after retrieving tasid you can pass it here in your code:

sb.Append("Task ID : " + tasidvalue);
sb.AppendLine();

希望对您有所帮助:)

hope it helps :)

这篇关于如何从数据库中检索列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！