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();
Tuesday, 14 August 2012
AUTO NUMBER GENERATION
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]);
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 ;
}
}
}
{
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";
}
{
int click = 1;
if(ViewState["clickcount"] == nul)
{
click = 1;
}
else
{
click = (int)ViewState["clickcount"] + 1;
}
ViewState["clickcount] = click;
Label1.Text = "Buttonclick" + click + "times";
}
Subscribe to:
Posts (Atom)