string fpath=null;
private void button2_Click(object sender, EventArgs e)
{
fpath="D:\\xyz.mdb";
if (System.IO.File.Exists(fpath))
fpath = "D:\\xyz-" + DateTime.Now.ToString("dd-mm-yy") + ".mdb";
CreateDatabase(fpath); //CreateDataBase method Call
System.Diagnostics.Process.Start(fpath); //Opens the Created File
}
public static bool CreateDatabase(string fullFilename)
{
bool succeeded = false;
try
{
string newDB = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fullFilename;
Type objClassType = Type.GetTypeFromProgID("ADOX.Catalog");
if (objClassType != null)
{
object obj = Activator.CreateInstance(objClassType);
// Create MDB file
obj.GetType().InvokeMember("Create", System.Reflection.BindingFlags.InvokeMethod, null, obj,
new object[] { "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + newDB + ";" });
succeeded = true;
// Clean up
System.Runtime.InteropServices.Marshal.ReleaseComObject(obj);
obj = null;
}
}
catch (Exception ex)
{
//Tools.ShowMessage("Could not create database file: " + fullFilename + "\n\n" + ex.Message, "Database Creation Error");
MessageBox.Show(ex.ToString());
}
return succeeded;
}
Blog Archive
-
▼
2009
(48)
-
▼
September
(29)
- Measuring Execution Time in C#
- C# Snippets: Directory Listing in C#
- C# Snippets: Saving User Preferences and Settings
- C# Snippets: To Obtain Current Application Directory
- C# Snippets: Beeping the PC Speaker in C#
- C# Snippets: Lorem Ipsum Generator
- C# Snippets: Foreach Loop Over Hashtable
- C# - Data Types and Ranges
- C# Snippets: String to byte[ ] and byte[ ] to String
- C# Snippets: List Box Data Binding
- C# Snippets: Limit Text Box Entry to Numeric Only
- Q) My LoginPage needs validate the UserId & Passwo...
- Trick: Clearing data from all TextBox Fast
- How to Create a MS-Access DataBase file by Clickin...
- Supporting Different Versions of MS-Access's Using...
- Q) What's Wrong in this? Getting "NullReferenceObj...
- How do i make MDI Parent & Child Forms in C#.NET a...
- How to write code : for every button click, should...
- How to insert a Line of data in the middle of the ...
- Visual C# Samples, Specifications, Quick Reference...
- Number to Text in console Program
- Number to Text1
- Generate Random Number22
- Generate Random Number2
- Generate Random Number1
- Named and optional parameters in C# 4.0
- Tip : Flush the KeyBoard buffer in C#
- How to make the numeric values as left alignment i...
- How to compute the numeric values of DataGridView'...
-
▼
September
(29)
My Links
- C# Snippets: 1
- C# Snippets: 2
- XMLFOX - CSHARP SAMPLES
- Q: Export your Crystal Report data to PDF
- Q: To create a Excel report wihtout using Excel object model Ex
- Q: Using C#, How to Save,Update Data to and from XML with out using the sql server database
- Q: upload excel to SQL using C#.net,VS2005
- Q: Export DataTable to Excel using c# with Formatting Styles
- Q: Crystal report in c# .Net
- Q: Import excel into Sql server 2005 Table
- Q: READ, UPDATE & DELETE XML FILE USING X-PATH
- Q: Export Data from Listview to Excel
- Q: About GridView Data To Excel C#
- Q: Simple way to convert excel sheet to sql table
- Q: How to send data from c# file(.cs) to xslt file
- Q: How to Export and import data from sqlserver to excel sheet in vb.net
- Q: Migration of data from access to excel and vice versa
- Q: How to insert the data from excel to Database in .Net?
- Q: How can we create excel sheet in c# using data grid
- Q: DateTime Value Manipulation
- Q: create an array from a txt file
- Q: HowtoOepnandReadanExcelSpreadsheetinaListViewin.NET
- Q: How to fill data to excel
- Q: Reading Image from Excel file using C# .Net
- C# / CSharp Tutorial
- stackoverflow.com/questions
- General .NET Projects
- Sample .NET Projects with source code
- CSharpArticles
- PHPManual
- phpmanual/en/install.windows
- ProtoPage
Friday, September 18, 2009
How to Create a MS-Access DataBase file by Clicking a button in C#.Net?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment