Manage the large STRING in CRYSTAL REPORT without new line (REMOVE ENTER)

local StringVar myvar;

myvar := replace ({ member.address},chr(13)+ chr(10)," ");

myvar
description :
this code was write in Formula Field of Crystal report
local StringVar myvar it was a local variable declare
StringVar is a DataType in Crytal report
{ member.address} was a database column
chr(13) + chr(10) was a Enter Key
replace ( [original source ] , [find string ] , [replace string ] )
myvar was return



Add an item to combobox before bind data from data base


Combobox in windows form which retrieve data from data base  but you want to add first item  like ---Select --- before the data from data base then this article is helpful to you.


code:

   
        private void Form1_Load(object sender, EventArgs e)
        {
            // Variable Delaration
            SqlConnection cnn = new SqlConnection();
            SqlCommand cmd = new SqlCommand();
            SqlDataAdapter da = new SqlDataAdapter();
            DataSet ds = new DataSet();
            DataTable dt = new DataTable();

            // connection open
            cnn.ConnectionString=@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True";
            cnn.Open();

            // get data in datatable
            cmd.Connection = cnn;
            cmd.CommandText = "Select * from Tbl_Department";
            da.SelectCommand = cmd;
            da.Fill(ds, "Tbl_Department");
            dt = ds.Tables["Tbl_Department"];


            // assign dumy data
            DataRow dr = dt.NewRow();
            dr["Dept_Id"] = -1;
            dr["Dept_Name"] = "---Select Department---";
            dt.Rows.InsertAt(dr, 0);

            // fill data in combobox
            comboBox1.DataSource = dt;
            comboBox1.DisplayMember = "Dept_Name";
            comboBox1.ValueMember = "Dept_Id";
        }


Character in UPPERCASE or LOWERCASE in TEXTBOX

Textbox has a property for input in a particular case is CharacterCasing  

It has a three value
    1. Normal
      All types input.
    2. Upper
      Only input in UPPERCASE
    3. Lower   
      Only input in LOWERCASE