no overload for method takes '1' arguments

Question

Hi all! I have a problem I am using this code in a software and I am getting a error in GetData(cmd). I have done it another way but I want to know what's really problem can anybody help me? string dbconnection = ConfigurationManager.ConnectionStrings[ConString].ConnectionString; private void BindData() { SqlConnection con = new SqlConnection(dbconnection); string strQuery = select CustomerIDContactNameCompanyName  +  from customers; SqlCommand cmd = new SqlCommand(strQuery); GridView1.DataSource = GetData(cmd); // => getting eror (no overload for method 'GetData' takes '1' arguments) GridView1.DataBind(); } private void GetData() { GridView1.DataBind(); } Thanks

Vulpes · Answer

Well the GetData method doesn't take any arguments and you'll also get another error because it's not returning anything either. However I'd just scrap that method and do it like this: private void BindData() { using (SqlConnection con = new SqlConnection(dbconnection)) { string strQuery = select CustomerIDContactNameCompanyName  +  from customers; SqlCommand cmd = new SqlCommand(strQuery con); SqlDataAdapter adapter = new SqlDataAdapter(); DataSet ds = new DataSet(); adapter.Fill(ds); GridView1.DataSource = ds.Tables[0]; GridView1.DataBind(); } }

Jignesh Trivedi · Answer

hi here the defination Getdata method does not takes any parameter.... also there is no need to pass any parameter..... also i think you will not work.. try Vulpes code