ASP.NET

s=(string)command.executescaler();

bigint

string Code = "select Code from ds1 " ;
int s;
using (SqlCommand command = new SqlCommand(Code, conn))
{
  s = (int)command.ExecuteScalar();
}

string update = " update ds1 set name='asd' where Code='" + s + "'";

public int GetData()
  {
     int Code;

     String strCon = "blablablablablablabla";

     SqlConnection con = new SqlConnection(strCon);

     SqlCommand cmdselect = new SqlCommand();

     cmdselect.CommandText = "select Code from ds1";

     cmdselect.Connection = con;

     try
     {
         con.Open();

         Code = (int)cmdselect.ExecuteNonQuery();

     }
      catch(SqlException)
     {
          throw;
     }
      finally
     {
         con.Close();
     }

     return Code;

  }

string code = "select * from path";
        string s;
        using (SqlCommand command = new SqlCommand(code, conn))
        {
            conn.Open();
            SqlDataReader dr;
            dr = command.ExecuteReader();
            dr.Read();         
           string s1 = dr.GetValues(0);
           s=s1
            conn.Close();
        }
        string filename = Path.GetFileNameWithoutExtension(s);
        SqlDataAdapter da = new SqlDataAdapter(filename, conn);
        da.Fill(ds, "a");
        DataList1.DataSource = ds.Tables["a"];
        DataList1.DataBind();
    }

ahmad25 wrote:

SqlDataAdapter da = new SqlDataAdapter(filename, conn);