DBConnect

an open source library class to connect to MSSQL for select and execute scripts easily.

Very Simple Database Connection Class for C# Applications

Introduction

Using a database is essential for storing and retrieving data in applications, whether you're a beginner or a professional programmer. The DBConnect class is designed to simplify reading data from an MS SQL database using the DataTable object. You can execute a query by calling a single function.

DBConnect is compatible with C# applications and ASP.NET Framework websites.

Suggest you see our websites: Talashnet and Exir

Total Code

usingSystem;usingSystem.Collections.Generic;usingSystem.Data;usingSystem.Data.SqlClient;usingSystem.Linq;usingSystem.Text;namespaceEasyTeb{publicclassDBConnect{SqlConnectionconnection;SqlCommandcmd;SqlDataAdapteradapter;boolisset=false;publicDBConnect(){connection=newSqlConnection("Server=.\\SQLEXPRESS;Database=TalashNet;Integrated Security=True;");}publicstringScript(stringQuery){if(isset){try{cmd=newSqlCommand(CheckInject(Query),connection);objectresult=cmd.ExecuteScalar();if(result==null)return"1";elsereturnresult.ToString();}catch(Exceptionex){returnex.Message;}}return"0";}publicDataTableSelect(stringQuery){if(isset){DataTabledt=newDataTable();adapter=newSqlDataAdapter(CheckInject(Query),connection);adapter.Fill(dt);returndt;}returnnewDataTable();}publicvoidConnect(){if(!isset){connection.Open();isset=true;}}publicvoidDisConnect(){if(isset){connection.Close();//connection = null;adapter=null;cmd=null;isset=false;}}publicstringCheckInject(stringsql){sql=sql.Replace("--"," ");sql=sql.Replace("/*"," ");//sql = sql.Replace('%', ' ');//sql.Replace('*', ' ');returnsql;}publicstringCheckInjectText(stringsql){sql=sql.Replace(',',' ');sql.Replace('$',' ');sql.Replace('^',' ');sql.Replace('%',' ');returnsql;}}}

Using the Code

1. Create a .cs class file and add the above code to it.
2. In your form, use the following code to call a query from SQL Server.

Executing a SELECT Query

To perform a SELECT query and retrieve data into a DataTable:

stringquery="SELECT * FROM [MyTable]";DBConnectdb=newDBConnect();db.Connect();DataTabledt=db.Select(query);db.DisConnect();

Now, the DataTable contains the results of your query. You can display it in a DataGridView or use the data in your code.

Displaying DataTable in ASP.NET GridView

GridView1.DataSource=dt;GridView1.DataBind();

Displaying DataTable in C# Windows Application DataGridView

DataGridView1.DataSource=dt;

Executing DELETE, INSERT, or UPDATE Queries

To perform DELETE, INSERT, or UPDATE queries:

DBConnectdb=newDBConnect();db.Connect();db.Script(query);db.DisConnect();

Points of Interest

The DBConnect class simplifies interaction with SQL Server, enabling programmers to write database-driven applications more efficiently. It is designed to streamline database operations and improve development speed.

History

This class was first written in 2008 and is currently in its second version.