This tutorial will teach you how to Populate DataGridView based on Combobox selected using C#.net and Microsoft SqlServer. Import the Namespace using System.Data.SqlClient; Establish the database Connection SqlConnection con = new SqlConnection("server=.;database=ads;user id=sa;password=123;"); SqlCommand cmd; SqlDataAdapter dr; DataSet ds; ComboBox Selected Event if (comboBox1.SelectedItem.ToString() == "Students") { try { dataGridView1.Refresh(); con.Open(); DataTable dt = new DataTable(); dr = new SqlDataAdapter("select …

This tutorial will teach you how to do the login from validation using C#.net and Sqlserver. Import the Namespaces using System.Data.SqlClient; Establish the Database Connection SqlConnection con = new SqlConnection(“server=.;database=StarAirways;user id=sa;password=123;”); Add Button SqlCommand cmd = new SqlCommand("select username,password,role from users where username='" + txtUserName.Text + "' and password='" + txtPassword.Text + "'and role='" + CRole.Text + "'", con); SqlParameter …

The Fried Rice shop Inventory Management System is developed using C#.NET and SQL SERVER. The project is built to manage sales and transactions. To make a new transaction, fields such as: Fried Rice type, qty,price and payment needs to be selected. If you like to learn point of sales systems step by step, this is the right place to learn …

The Coffee Shop Pos System using C#.NET. The project is built to manage sales and transactions. To make a new transaction, fields such as: Rice Type and Drink type, qty needs to be selected. If you like to learn point of sales systems step by step, this is the right place to learn from the beginning. In this tutorial useful …

The Icecream shop pos system is developed using C#.NET. The project is built to manage sales and transactions. To make a new transaction, fields such as: Ice cream type and Drink type, qty needs to be selected. If you like to learn point of sales systems step by step, this is the right place to learn from the beginning. In …

This Elapsed Time Calculation System is useful for check the employees working time. This system start to work when employee log in to the office until log off from office. Import the Following Namespace Dim date1 As String Dim i, flg As Integer Dim th, ot As Decimal Public st As String Public wh As Decimal Create the Function Private …

This C#.net Crud will teach you how to do basic database functions that are CREATE RETIEVE UPDATE and DELETE using Microsoft Server 2012 Database. The INSERT, SELECT, UPDATE and DELETE statements can be used in any database system, because this is support by all relational database systems. We will learn how to INSERT, SELECT, UPDATE and DELETE in database by …

This tutorial will teach you Profit and Commission Calculation using C#.net.while calculating the commission from the profit include 1% commission. Paste the code inside the ok button private void button1_Click(object sender, EventArgs e) { double buyprice = double.Parse(txtBprice.Text); double sellprice = double.Parse(txtSprice.Text); //Profit double tot = sellprice - buyprice; txtProfit.Text = tot.ToString(); //Commission double comm = tot * 1/100; txtComm.Text …

This tutorial will teach you how make a Autocomplete Textbox using C#.net Sqlserver Database. First Step you have to make the GUI Design after that select the textbox and go to the Properties  do the couple of option i attached the screenshot image below.do the same what i attached below. Write the code inside the Form_Load Event  using System.Data.SqlClient; namespace …

This tutorial will teach you inheritance in C#.net Core step by step. First step  i have created the class Address. class has the properties HouseNo,Street,City. after that i have created the HouseAddress class which has a the properties HouseName after that i have created ShopAddress  class which has a the properties ShopName. inside the main method of the programme you …