如何将数据集转换为int [英] How to convert dataset to int

问题描述

i使用三层架构搜索数据并绑定到gridview，我的代码是



DAL：

i am using three tier architecture for search the data and bind to gridview, My code is

DAL:

public DataSet DSet(string Stxt)
   {
       try
       {
           con = new SqlConnection(connect);
           con.Open();
           cmd = new SqlCommand("Search_sp", con);
           cmd.CommandType = CommandType.StoredProcedure;
           cmd.Parameters.AddWithValue("@searchparameter", Stxt);
           da = new SqlDataAdapter(cmd);
           ds = new DataSet();
           da.Fill(ds);
           return ds;
       }
       catch
       {
           throw;
       }
       finally
       {
           con.Close();
       }
   }

BAL：

BAL:

public int txtsrch(string txtsrch)
    {
        try
        {
            return cfdal.DSet(txtsrch);
        }
        catch
        {
            throw;
        }
        finally
        {
            cfdal = null;
        }
    }

aspx页码：

aspx page code:

protected void Button2_Click(object sender, EventArgs e)
   {
       //connection();
       //query = "Search_sp";
       //cmd = new SqlCommand(query, con);
       //cmd.CommandType = CommandType.StoredProcedure;
       //cmd.Parameters.AddWithValue("@searchparameter", txtsearch.Text).ToString();
       //search_grid.DataSource = cmd.ExecuteReader();
       //search_grid.DataBind();

       string stxt = txtsearch.Text;
       search_grid.DataSource = cfbal.txtsrch(stxt);
       search_grid.DataBind();
   }

这里我的问题是显示错误（不能将数据集转换为int）但我不知道怎么做，即使我在google中引用仍然没有得到正确的输出，

感谢您的建议....

Here my Problem is it showing Error(can't convert dataset to int) but i don't know how to do it, even though i refer in google still i didn't get proper output,
Thanks for your advice ....

推荐答案

函数 DSet 返回数据集...

The function DSet returns a dataset...

public DataSet DSet(string Stxt)

所以当你在这里使用它时

so when you use it here

public int txtsrch(string txtsrch)
    {
        try
        {
            return cfdal.DSet(txtsrch);
        }

您收到错误是因为您希望txtsrch返回 int

鉴于你以后使用

you are getting the error because you want txtsrch to return an int
Given that you later use

search_grid.DataSource = cfbal.txtsrch(stxt);

我猜你真的不想要返回 int 来自txtsrch！



尝试

I'm guessing you really don't want to return an int from txtsrch!

Try

public DataSet txtsrch(string txtsrch)

而不是

这篇关于如何将数据集转换为int的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！