protected void dataList1_UpdateCommand(object source, DataListCommandEventArgs e)
{
String custId = dataList1.DataKeys[e.Item.ItemIndex].ToString();
string company = ((TextBox)e.Item.FindControl("txtCompany")).Text;
string contact = ((TextBox)e.Item.FindControl("txtContact")).Text;
string city = ((TextBox)e.Item.FindControl("txtCity")).Text;
string country = ((TextBox)e.Item.FindControl("txtCountry")).Text;
//Create the Customer object
Customer obj = new Customer
{
CustomerId = custId,
CompanyName = company,
ContactName = contact,
City = city,
Country = country
};
try
{
CustomerDataAcess dataAcess = new CustomerDataAcess();
dataAcess.UpdateCustomer(obj);
}
catch (Exception ex)
{
throw ex;
}
//Deselect the edititemtemplate by resetting the EditItemIndex to -1
dataList1.EditItemIndex = -1;
PopulateData();
}
public CustomerModel Get(int id)
{
CustomerDataAcess customer = new CustomerDataAcess();
CustomerModel result = customer.GetCustomer(id);
return(result);
//return "value";
}
public List <CustomerModel> Get()
{
CustomerDataAcess customer = new CustomerDataAcess();
List <CustomerModel> data = customer.GetCustomers();
return(data);
//return new string[] { "value1", "value2" };
}
private void PopulateData()
{
CustomerDataAcess dataAcess = new CustomerDataAcess();
var list = dataAcess.GetCustomers();
dataList1.DataSource = list;
dataList1.DataBind();
}
private void PopulateData()
{
//if (adapter == null)
// adapter = new SqlDataAdapter(sql, ConnectionString);
//if (ds == null) ds = new DataSet();
//adapter.Fill(ds, tablename);
//this.repeater1.DataSource = ds;
//repeater1.DataMember = tablename;
//repeater1.DataBind();
CustomerDataAcess dataAcess = new CustomerDataAcess();
var list = dataAcess.GetCustomers();
repeater1.DataSource = list;
repeater1.DataBind();
}
