Category: MYSQL

  • Replace Blank CELLs with NULL Value

    SELECT ‘UPDATE table SET [‘ + name + ‘] = NULL WHERE [‘ + name + ‘] = ””;’ FROM syscolumns WHERE id = object_id(‘table’) AND isnullable = 1;

  • How to read DBF to Datatable

    [csharp] OleDbConnection oConn = new OleDbConnection(@”Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\Temp;Extended Properties=dBase III”); OleDbCommand command = new OleDbCommand(“SELECT * FROM Test.DBF”, oConn); oConn.Open(); DataTable dt = new DataTable(); dt.Load(command.ExecuteReader()); oConn.Close(); [/csharp]

  • How to Backup MYSQL Databases

    REM Export all databases names to file mysql -h your-server-ip -u user-name -ppassword information_schema –skip-column-names –execute=”SHOW DATABASES;” > databases.tmp echo “Start!” REM Look over database names REM Outter loop to get table names for /F %%A in (databases.tmp) do ( echo “Exporting table Names for %%A” mysql -h your-server-ip -u user-name -ppassword %%A –skip-column-names –execute=”SHOW…

  • Only Office – Multifunctional service for business with low cost

    Only Office is a great tool which can use by any small scale organization for Project management, online editors, documents management, emails and few more things. Like all the features are available in other products too like Google, Microsoft Office Online, Microsoft SharePoint. All these products stores data to their own cloud servers, they are…

  • How to export schema of MYSQL Database?

    If you need schema of your MYSQL database for backup or any copy database to another server, then you must need schema with or without data. GUI tools like SQLYog, WebYog or PHPmyAdmin will best example for that. But if you need any command or utility then MYSQLDUMP has most important role. For using mysqldump…

  • Basic Authentication in ASP.Net MVC Web API

    ASP.NET Web API is a great tool to create lightweight, HTTP services that reach a broad range of clients, including all browsers and mobile platforms. In most of scenarios we need authentication to restrict services . There are two ways to restrict it – Forms authentication – Windows authentication Forms authentication is a mechanism that…

  • How to: Manage Transactions in the Entity Framework

    How to: Manage Transactions in the Entity Framework Managing Connections and Transactions

  • How to cast MSSQL Datetime in MYSQL

    If any one mograte MSSQl data to MYSQl then there will be issue related to datetime column. SQL management studio generate script export the datetime value to hex value and MYSQL doesn’t recognized it. To solve this issue just create a function and called it where required. create function sp_ConvertSQLServerDate(dttm binary(16)) returns datetime return CAST(…

  • How to use MYSQL for ASP.Net Membership and Role provider