Skip to main content

NuGet - Common Database Settings

NuGet Common Database Settings



Step 1:



Step 2:


  • Make a object for DataBase class. (you can see many Method )
  • Call the method named CheckDatabaseConnection.


Note : you can get the connection sting by calling DataBase.ConnectionString

That's all, select which type of database to be connected.

More over there are many methods in the BataBase class.



Function Description Return type
GetConnectionString(string) Set the database connection string void
CheckDatabaseConnection(string) Check the connection string existing or not bool
CheckDataExist(string) Check the data is present in the table bool
DropdownFill(string) Fill the a Dropdown DataTable
ExecuteDB(string) Can insert, update and delete data in the database void
GetData(string) Get a string from the database string
GetDataset(string) Get dataset from the database DataSet
GetSlno(string) Get the serial no from the table int



Happy Coding.

Comments

Popular posts from this blog

NuGet - Check Combo Box

Step 1:  Get the NuGet package https://www.nuget.org/packages/Common.CheckComboBox/ Step 2: Add the CheckComboBox Control in the toolbar. Click here Step 3: Drag the "CheckedComboBox" control from the toolbar to the form to the position where it should be placed   Step 4: Add items to the CheckedComboBox control by        for (int i = 0; i < 10; i++)             {                 checkedComboBox1.Items.Add(i);             }

NuGet - Common Security

Step 1: Get the NuGet package  https://www.nuget.org/packages/Common.Security/ Set the property with a string Security.CypherPassWord Security.CypherPassWord = "CypherPassWord"; Call the static method for  Security.Encrypt()  syntax :       Security.Encrypt(planeText,password) Call the static method for  Security.Decrypt()  syntax :       Security.Decrypt(planeText,password)
HOW TO RESOLVE REPORTING SERVICES CATALOG DATABASE FILE EXISTENCE FAILED OR TEMPORARY DATABASE FILE EXISTENCE FAILED Next to go to the Sql server root directory, by default C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA Files to be deleted ReportServer.mdf ReportServer_log.LDF ReportServerTempDB.mdf ReportServerTempDB_log.LDF .