C#

string.Format("{0:0000-0000-0000}", 123456789012);

System.Console.WriteLine ( System.String.Format("{0:0000-0000-0000}",123456789012) ) ;
System.Console.WriteLine ( 123456789012.ToString("0000-0000-0000") ) ;

dgv.Columns[1].Width = 100;

public int Factorial(int n) {
    if (n<=1) return 1;
    return n*Factorial(n-1);
}

string MyFunction( string val )
{
  if ( val == "test" ) return val; // end of recursion

  // recursive case

  string xyz = ...

  return MyFunction( xyz );
}

----------------------------------
Be excellent to each other

private string MyFunction(string val)
{
//ToDo Calculate xyz

  if(xyz != "test") //<----This condition three times true.
  {
  val = MyFunction(xyz);
  }
  else
  {
  return val;
  }
}

teknolog123 wrote:

how can I reset the identity value when I deleted all the records?

DBCC CHECKIDENT (yourtable, reseed, 6798)

I are Troll

teknolog123 wrote:

thanks where and how can I put that code below?

const string myConnectionString = @"
	Data Source=SOUNDMAXP\SQLEXPRESS;
	Initial Catalog=Kafe;
	Integrated Security=SSPI;";
const string myCommandText = @"
	DBCC CHECKIDENT (yourtable, reseed, 6798)";

using(SqlConnection con = new System.Data.SqlClient.SqlConnection())
{
	con.Open();
	using(SqlCommand cmd = con.CreateCommand())
	{
		cmd.CommandText = myCommandText;
		cmd.ExecuteNonQuery();
	}
	con.Close();
}

I are Troll