如何从数据库中检索列 [英] 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屋!
查看全文