How to make Crystal Report for this ....
try
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
conn.Open();
SqlCommand cmd = new SqlCommand("insetclientinfo", conn);
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@clientId", txtid.Text);
cmd.Parameters.AddWithValue("@name", txtname.Text);
cmd.Parameters.AddWithValue("@mobile", txtmobile.Text);
cmd.Parameters.AddWithValue("@address", txtaddress.Text);
cmd.Parameters.AddWithValue("@cnic", txtcnic.Text);
cmd.Parameters.AddWithValue("@city", txtcity.Text);
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.InsertCommand = cmd;
adapter.InsertCommand.ExecuteNonQuery();
cmd.Connection.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
this.conn.Close();
}