Now, create a new page "Views\HomePage.xaml" file and replace the following code in it. This "SaveInfo(.)" method will perform SQL Server database insertion query and store the target data from the user into SQL Server table as targeted. In the above code, I have created a simple wrapper method that will communicate with SQL Server using my previously created "executeQuery(.)" method from DAL(Data Access Layer) class. public static void SaveInfo( string fullname).
namespace Data_Storage_using_SQL_Code.Common.using Data_Storage_using_SQL_server.Helper_Code.Common.For this method to work, you need to replace the SQL Server database connection string with your own credentials and settings.Ĭreate "Model\BusinessLogic\HomeBusinessLogic.cs" file and replace the code with the following. The above piece of code will allow us to communicate with SQL Server in order to perform related queries. rowCount = sqlCommand.ExecuteNonQuery().sqlCommand.CommandType = CommandType.Text.SqlCommand sqlCommand = new SqlCommand().SqlConnection sqlConnection = new SqlConnection(strConn).string strConn = "Data Source=SQL Server Name(e.g. localhost) Database=SQL Database Name User Id=SQL User Name Password=SQL Password ".public static int executeQuery( string query).namespace Data_Storage_using_SQL_server.Helper_Code.Common.Now, create "Helper_Code\Common\DAL.cs" file and replace the code with the following code in it.
Now, create a new WPF application project and name it "Data Storage using SQL server". In the above script, I have simply created my main database for this tutorial and I have created a simple table for storing the information.
0 kommentar(er)
