我想从我的文本字段中取值到select查询请帮忙

问题描述

String s11 =选择student.sname，admission.sroll，admission.scourse，admission.semester from admission，student where entry.asid =（从文本框中获取值）和admission.asid = student.sid;

String s11="Select student.sname,admission.sroll,admission.scourse,admission.semester from admission,student where admission.asid=(get value from the textbox) and admission.asid=student.sid";

推荐答案

using (SqlCommand command = new SqlCommand("Select student.sname,admission.sroll,admission.scourse,admission.semester from admission,student where admission.asid=@Variable and admission.asid=student.sid", connection))
{
	command.Parameters.Add(new SqlParameter("Variable", txtVariable.Text.Trim()));
	SqlDataReader reader = command.ExecuteReader();
	DataTable dataTable = new DataTable();
	dataTable.Load(reader); 
}

这篇关于我想从我的文本字段中取值到select查询请帮忙的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！