The following code illustrates on how to check if directory exists in specific path, if not then create directory. Here I show that how to create the directory with simple condition. private void TestDirectory() { string pathname = “C:\\Myfolder”; if(!Directory.Exists(pathname)) { Directory.CreateDirectory(pathname); } }
The SQL ALTER TABLE command is used to add, delete or modify columns in an existing table. You can also use the ALTER TABLE command to add and drop various constraints on an existing table. The basic syntax of an ALTER TABLE command to add a New Column in an existing table is as follows.… Read More »
If you need the similar structure of the table with different tablename, it’s better to duplicate r copy the table structure than creating a new table from scratch. It is easy to duplicate the table structure and rename it. Select any database table and right click and click on the option Duplicate Table Structure /Data… Read More »
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;