How Can I Get The Serial Number From Sql And Store In My C# Code

SqlConnection xconn=new SqlConnection(ConfigurationManager.ConnectionStrings["DbConnect"].ToString());

SqlCommand xcmd=new SqlCommand("select max(serialNum) from dbo.YourTable",xconn);
int num=0;
try
{
xconn.Open();
num=xcmd.ExecuteScalar();
Console.WriteLine("Max serial number is {0}",num);
}
catch(Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
xconn.Close();
}