怎么得到SQL查出来的值(多行)并放入DataGrid控件里面。

protected void btnSubmit_Click(object sender, EventArgs e)
{
this.notxt.Text = "";
string sql = "select allotTaskPid,SUBSTRING(allotTaskName,0,8)as allotTaskName ,allotTaskBeTime,allotTaskEndTime,dbo.GetDeptName(allotTaskDept) allotTaskDept,dbo.GetempName(allotTaskEmpId) allotTaskEmpId,allotTaskParent,allotTaskCaption,allotTaskTarget,allotTaskStopEmp,allotTaskStopTime,taskStopReason,cycleSum,currentCycle,dbo.GetCycle(allotTaskCycle)allotTaskCycle ,dbo.GetAllotState(allotTaskState) allotTaskState,allotTaskResult from dbo.AllotTask where 1=1";
if (this.txtName.Text.Trim() != "")
{
sql = sql + "and allotTaskName like '%" + txtName.Text.Trim() + "%'";
}
if (this.txtEmp.Text.Trim() != "")
{
sql = sql + "and dbo.GetempName(allotTaskEmpId )= '" + txtEmp.Text.Trim() + "'";
}
if (this.BbeginTime.Text.Trim() != "")
{
sql = sql + "and CONVERT(char(10),allotTaskBeTime,120)>= '" + BbeginTime.Text + "'";
}
if (this.BendTime.Text.Trim() != "")
{
sql = sql + "and CONVERT(char(10),allotTaskBeTime,120)<= '" + BendTime.Text + "'";
}

if (this.Ebegintime.Text.Trim() != "")
{
sql = sql + "and CONVERT(char(10),allotTaskEndTime ,120)>= '" + Ebegintime.Text + "'";
}
if (this.Eendtime.Text.Trim() != "")
{
sql = sql + "and CONVERT(char(10),allotTaskEndTime ,120)<= '" + Eendtime.Text + "'";
}
if (this.DropDownList1.SelectedIndex != 0)
{
sql = sql + "and allotTaskDept= '" + this.DropDownList1.SelectedIndex + "'";
}
if (this.DropDownList2.SelectedIndex != 0)
{
sql = sql + "and allotTaskState= '" + this.DropDownList2.SelectedValue + "'";
}
SqlDataAdapter da = new SqlDataAdapter(sql, DbHelperSQL.connectionString);
DataSet ds = new DataSet();
da.Fill(ds);

string newdb = "123";
Session.Add("newdb", newdb);
this.GvExamin.DataSource = ds;
this.GvExamin.DataKeyNames = new string[] { "allotTaskPid" };
this.GvExamin.DataBind();
this.ddlCurrentPage.Items.Clear();
for (int i = 1; i <= this.GvExamin.PageCount; i++)
{
this.ddlCurrentPage.Items.Add(i.ToString());
}

if (this.GvExamin.Rows.Count != 0)
{
this.ddlCurrentPage.SelectedIndex = this.GvExamin.PageIndex;
}
else
{
this.notxt.Text = "没有相关数据！";
}
}

一看 你就明白

SqlConnection conn = new SqlConnection("链接字符串");
conn.Open();
SqlDataAdapter sda = new SqlDataAdapter(sql, conn);
DataTable dt = new DataTable();
sda.Fill(dt);
conn.Close();
GrdDevSSluCorpOra.DataSource = dt;

strCorpName = txtCorpName.Text;
strOrganizeCode = txtOrganize_Code.Text;
string sql = "select Full_CorpCode,CORP_NAME,Organize_Code,OrganizeCode ";
sql+="from TB_CORP_BASIC_INFO left join TBSYSUSERINFO ";
sql+="on TB_CORP_BASIC_INFO.Full_CorpCode=TBSYSUSERINFO.FullCorpCode ";
sql+= "where TB_CORP_BASIC_INFO.CORP_NAME like'%" + strCorpName + "%' and TB_CORP_BASIC_INFO.Organize_Code='" + strOrganizeCode + "'";
using (OleDbConnection connection = new OleDbConnection(sql ))
{
DataSet ds = new DataSet();
try
{
connection.Open();
OleDbDataAdapter command = new OleDbDataAdapter(sql , connection);
command.Fill(ds);
}
catch (System.Data.OleDb.OleDbException Exp)
{
Log.LogError.AddLogError("错误信息", Exp, _Path);
}
finally
{
connection.Close();
}
return ds;
}
返回一个DS，接收一下，绑定到DataGrid就OK了

本文如未解决您的问题请添加抖音号：51dongshi（抖音搜索懂视），直接咨询即可。