如何从数据库中检索列

本文介绍了如何从数据库中检索列的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

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的概念: 使用C#读取，插入，更新和删除简单的ADO.NET数据库. [ ^ ] 通过C#访问SQL Server的入门指南 [ ^ ] 检索tasid之后，您可以在代码中将其传递到这里: Try these for learning concepts of ADO: 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 :)