Tuesday, 14 August 2012

AUTO NUMBER GENERATION

OleDbConnection cn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..\..\..\database.mdb");

cn.open();

DataSet ds = new DataSet();

OleDbDataAdapter da = new OleDbDataAdapter("SELECT iif(max(fieldname)=Null,1,max(field name) +1) as [Number] from Tablename", cn);

da.Fill(ds);

if (ds.Tables[0].Rows.Count > 0)
{

textBox1.Text= ds.Tables[0].Rows[0]["Number"].ToString();

}

cn.close();

Wednesday, 8 August 2012

RUNTIME ERROR : "object does not contain a definition for get_Range" in MS Excel

 Microsoft.Office.Interop.Excel.Range myrange = excelsheet.get_Range(excelsheet.Cells[1, 1], excelsheet.Cells[this.dataGridView1.RowCount + 1, this.dataGridView1.Columns.Count]);


 Solution:

Include (object) as shown in the below line....................



 Microsoft.Office.Interop.Excel.Range myrange = excelsheet.get_Range((object)excelsheet.Cells[1, 1], (object)excelsheet.Cells[this.dataGridView1.RowCount + 1, this.dataGridView1.Columns.Count]);


Wednesday, 6 June 2012

FLASH SIMPLE TIP

Press F6 to set timeline after each action or move....

Monday, 14 May 2012

KEYPRESS EVENT IN C#

private void txt1_KeyPress(object sender, KeyPressEventArgs e)
{

if (e.KeyChar == (char)Keys.Enter)

{

//do something

}
}

Thursday, 10 May 2012

CALCULATION IN TEXTBOX USING Convert.ToInt32 and int.parse

                                USING Convert.ToInt32

private void button1_Click(object sender, EventArgs e)
{
int value1 = Convert.ToInt32(this.textBox1.Text);

int value2 = Convert.ToInt32(this.textBox2.Text);

int value3 = Convert.ToInt32(this.textBox3.Text);

int value4 = (value2-value1) * value3;

 this.textBox4.Text = value4.ToString();

 }

USING  int.Parse
private void button1_Click(object sender, EventArgs e)
{

int value1 =(textBox1.Text);

int value2 = int.Parse(textBox2.Text);

int value3 = int.Parse(label1.Text);

intvalue4 = (value2-value1) * value3;

textBox4.Text = value4.ToString();
}

Sunday, 6 May 2012

COOKIES IN ASP.NET

protected void Page_Load(object sender, EventArgs e)
{

TextBox1.Text = "Ajith";
TextBox2.Text = "bmw";
HttpCookie usercars = Request.HttpCookie["favouritecar"];
if(usecookie == null)
{

HttpCookie usecar = new HttpCookie("favouritecar");
 usecar["name"] = TextBox1.Text.ToString();
 usecar["car"] = TextBox2.Text.ToString();
 usecar.Expires.DateTime.Now.AddDays(1);
Response.Cookie.Add(usecar);

}
else
{

String name =usercars["name"];
String car = usercars["car"];
Label1.Text =  "hi" + name + "is using" +car ;

}
}
}

COUNTING CLICK USING VIEWSTATE

protected void Button1_Click(object sender, EventArgs e)
    {
int click = 1;
if(ViewState["clickcount"] == nul)
{
 click = 1;
}
else
{
click = (int)ViewState["clickcount"] + 1;
}
ViewState["clickcount] = click;
Label1.Text = "Buttonclick" + click + "times";
}
back to top