protected void btnDelete_Click(object sender, EventArgs e)
{
MikesServiceRef.TestService objTest = new MikesServiceRef.TestService();
int ret = objTest.DeleteRecord(Convert.ToInt32(txtID.Text));
if (ret > 0)
{
lblMessage.Text = "Record delete Successfully";
txtID.Text = "";
txtName.Text = "";
txtCity.Text = "";
}
else
{
lblMessage.Text = "Error while deleting record";
}
}
protected void btnInsert_Click(object sender, EventArgs e)
{
MikesServiceRef.TestService objTest = new MikesServiceRef.TestService();
int ret = objTest.InsertDetail(txtName.Text, txtCity.Text);
if (ret > 0)
{
lblMessage.Text = "Record Inserted Successfully";
txtID.Text = "";
txtName.Text = "";
txtCity.Text = "";
}
else
{
lblMessage.Text = "Error while inserting record";
}
}
protected void btnSelect_Click(object sender, EventArgs e)
{
MikesServiceRef.TestService objTest = new MikesServiceRef.TestService();
DataSet ret = objTest.GetDetialByID(Convert.ToInt32(txtID.Text));
if (ret.Tables.Count > 0)
{
if (ret.Tables[0].Rows.Count > 0)
{
//add the rows to the tables using the column names below.
txtName.Text = ret.Tables[0].Rows[0]["PersonName"].ToString();
txtCity.Text = ret.Tables[0].Rows[0]["PersonCity"].ToString();
}
else
{
lblMessage.Text = "Record not found";
}
}
}