1.Declaration MX.Application xl = null; MX.Workbook wb = null; MX.Worksheet wsheet = null; xl = new MX.Application(); wb = Microsoft.Office.Interop.Excel.Workbook)(xl.Workbooks.Add(Missing.Value)); wb.Sheets.Add(Missing.Value, Missing.Value, Missing.Value, Missing.Value); wsheet = (Microsoft.Office.Interop.Excel.Worksheet)(wb.Sheets[1]); wsheet.Cells.Font.Name = “VERDANA”; wsheet.Cells.Font.Size = 9; wsheet.Cells.HorizontalAlignment = MX.XlHAlign.xlHAlignCenter; wsheet.get_Range(“A1”, “A1”).ColumnWidth = 9; wsheet.get_Range(“B1”, “B1”).ColumnWidth = 13; wsheet.get_Range(“C1”, “C1”).ColumnWidth = 28; wsheet.get_Range(“D1”, “D1”).ColumnWidth = 12; wsheet.Cells[4, 1]… Read More »

Insert query is used to add/insert the data values into the database tables. By executing the query the data easily inserts into the database. The below statement is how we actually insert the data values into the database.   cmd.CommandText = “insert into `databasename.tablename (field1,field2) values (‘1′,’abc’); cmd.Connection = con; cmd.ExecuteNonQuery(); How to use alter… Read More »

In Datagridview it’s pretty easy to add columns, edit columns and it’s properties. With just a series of clicks and options you can just carry on it with ease. As Shown in the below snap, right click to view Datagridview Tasks, where you can add and edit columns You can give your desired column name… Read More »

BackgroundWorker in C# is used to simplify threading. This object is designed to simply run a function on a different thread and then call an event on your UI thread when it’s complete.   Illustration code: 1. backgroundWorker1.RunWorkerAsync() :  Used to kickoff the worker thread to begin it’s DoWork function.       private void button1_Click(object sender, EventArgs… Read More »

  In order to store the data safely, from the database there is a procedure to export all the sql statements.   Click on the database and right click, you can see the option Export database as Sql statements, click it.   After clicking Export database as Sql statements, a window  opens there you can… Read More »

Bool method in C# is used to check condition if true or false. Like as shown in the below code snippet. How to use BackgroundWorker in C#.Net How to export database as Sql statements

While selecting datagridviewcomboboxcolumn cell select, sometimes the cell backcolor or selection color turns black, follow the below source code to avoid it.     In the dataGridView1_EditingControlShowing event, you just write it as:   e.CellStyle.BackColor = Color.White;            

You can either use FolderBrowserDialog Tool from ToolBox like :     FolderBrowserDialog allows you to select the required folder:                               Else you can just write a source code for browsing a folder and return the selected path to textbox like:… Read More »

Yesterday I faced a serious issue called Just-In-Time Debugger error, while running Microsoft .Net Application. I was trying hard to fix the issue. But after a series of attempts I just fixed it  by repairing the Visual studio 2012 exe.   Steps:   Go to: Control Panel Programs -> Uninstall a Program Programs and Features… Read More »