How to Create Login Form in ASP.NET using SQL Server Database[With Source Code]

See the Designing part in Video:

<connectionStrings>
    <add name="dbconnection" connectionString="Data Source=RAN-PC;Initial Catalog=aspnew;Integrated Security=True"/>
  </connectionStrings>

Watch The Database Connection Part in Video.

Code inside the Login Button:

       
     string constr = WebConfigurationManager.ConnectionStrings["dbconnection"].ConnectionString;
        SqlConnection con = new SqlConnection(constr);
        try
        {
            con.Open();
            SqlCommand cmd = new SqlCommand("select count(*) from aspnew where username='" + txtuser.Text + "' and password ='" + txtpass.Text + "' ", con);
            SqlDataAdapter sda = new SqlDataAdapter(cmd);
            DataTable dt = new DataTable();
            sda.Fill(dt);
            cmd.ExecuteNonQuery();
            if(dt.Rows[0][0].ToString()=="1")
            {
                Response.Write("alert('successful in login')"); //write Script tag before writing alert and close script tag as shown in below
                Response.Redirect("~/Default2.aspx");
            }
            else
            {
                Response.Write("alert('error in login')"); //write Script tag before writing alert and close script tag
            }
        }catch(Exception ex)
        {
            Response.Write(ex.Message);
        }

    }
       
 

Write the Script tag as:

Response.Write("<script>alert('successful in login')</script");

Watch The Video:

Insert Update Delete and View Data From SQL Server Database in C#.NET[With Source Code]

Watch the designing part in video!
 Connection Class Code:

       
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;
using System.Data;

namespace projectincsharp
{
    class Connection
    {
        SqlConnection con = new SqlConnection("Data Source=RAN-PC;Initial Catalog=projectincsharp;User ID=sa;Password=interrupt");
        public SqlConnection active()
        {
            if(con.State==ConnectionState.Closed)
            {
                con.Open();
            }
            return con;
        }
       
    }
}



       

Source Code of the program!

       

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace projectincsharp
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
            fillListBox();
        }

        private void btnInsert_Click(object sender, EventArgs e)
        {
            if (validate())
            {
                Connection con = new Connection();
                SqlCommand cmd = new SqlCommand(@"INSERT INTO [dbo].[project]
           ([Name]
           ,[Address]
           ,[Email])
     VALUES
           ('" + txtName.Text + "', '" + txtAdd.Text + "', '" + txtEmail.Text + "')", con.active());
                cmd.ExecuteNonQuery();
                //cmd.EndExecuteNonQuery();
                MessageBox.Show("successfully", "insert", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            else
            {
                MessageBox.Show("error", "insert", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
        }
        bool validate()
        {
            bool returnval = true;
            if(txtName.Text.Length==0)
            {
                returnval = false;
            }
            if(txtAdd.Text.Length==0)
                {
                returnval = false;
                 }
            if(txtEmail.Text.Length==0)
            {
                returnval = false;
            }
            return returnval;

        }
        private void btnDelete_Click(object sender, EventArgs e)
        {
            Connection con = new Connection();
            SqlCommand cmd = new SqlCommand(@"DELETE FROM [dbo].[project] WHERE [Roll No] = '" + txtRoll.Text + "'",con.active());
            cmd.ExecuteNonQuery();
            MessageBox.Show("successfull", "delete", MessageBoxButtons.OK, MessageBoxIcon.Information);
            txtRoll.Clear();
            txtName.Clear();
            txtAdd.Clear();
            txtEmail.Clear();

               
        }

        private void btnUpdate_Click(object sender, EventArgs e)
        {
            Connection con = new Connection();
            SqlCommand cmd = new SqlCommand(@"UPDATE [dbo].[project]
   SET [Name] = '" + txtName.Text + "',[Address] = '" + txtAdd.Text + "',[Email] = '" +txtEmail.Text+"' WHERE [Roll No] ='" + txtRoll.Text + "'", con.active());
            cmd.ExecuteNonQuery();
            MessageBox.Show("successful", "update", MessageBoxButtons.OK, MessageBoxIcon.Information);


        }

        private void btnNew_Click(object sender, EventArgs e)
        {
            txtAdd.Clear();
            txtEmail.Clear();
            txtRoll.Clear();
            txtName.Clear();
            txtName.Focus();

        }
        void GridView()
        {
            Connection con = new Connection();
            SqlDataAdapter sda = new SqlDataAdapter("select * from project", con.active());
            DataTable dt = new DataTable();
            sda.Fill(dt);
            dataGridView1.Rows.Clear();
            foreach(DataRow item in dt.Rows)
            {
                int n = dataGridView1.Rows.Add();
                dataGridView1.Rows[n].Cells[0].Value = item["Roll No"].ToString();
                dataGridView1.Rows[n].Cells[1].Value = item["Name"].ToString();
                dataGridView1.Rows[n].Cells[2].Value = item["Address"].ToString();
                dataGridView1.Rows[n].Cells[3].Value = item["Email"].ToString();
            }
            

        }

        private void Form1_Load(object sender, EventArgs e)
        {
            GridView();
        }

        private void dataGridView1_MouseDoubleClick(object sender, MouseEventArgs e)
        {
            int n = dataGridView1.SelectedRows[0].Index;
            txtRoll.Text = dataGridView1.Rows[n].Cells[0].Value.ToString();
            txtName.Text = dataGridView1.Rows[n].Cells[1].Value.ToString();
            txtAdd.Text = dataGridView1.Rows[n].Cells[2].Value.ToString();
            txtEmail.Text = dataGridView1.Rows[n].Cells[3].Value.ToString();

        }
        void fillListBox()
        {
            string query = "select * from project";
            Connection con = new Connection();
            SqlCommand cmd = new SqlCommand(query, con.active());
            SqlDataReader myreader;
            try
            {
                con.active();
                myreader = cmd.ExecuteReader();
                while(myreader.Read())
                {
                    string sname = myreader.GetString(1);
                    listBox1.Items.Add(sname);
                }
            } catch(Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        private void listBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
            Connection con = new Connection();
            string sql = "select * from project where name ='" + listBox1.Text + "';";
            SqlCommand cmd = new SqlCommand(sql, con.active());
            SqlDataReader myreader;
                try
            {
                con.active();
                myreader = cmd.ExecuteReader();
                while(myreader.Read())
                {
                    string rollno = myreader.GetInt32(0).ToString();
                    string name = myreader.GetString(1);
                    string address= myreader.GetString(2);
                    string email = myreader.GetString(3);
                    txtRoll.Text = rollno;
                    txtName.Text = name;
                    txtAdd.Text = address;
                    txtEmail.Text = email;
                }
                
            }catch(Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
    }
}



       
 

Watch the video:

How To Insert Update Delete and Search Data In MySQL Database Using PHP[With Source Code]

Download the code from here: CLICK HERE

Watch The Video:

How to Send Free SMS Using SMS API in PHP?[With Source Code]

watch the video for all the technical parts:

Download Source Code: CLICK HERE

Watch the video

How to Send Free SMS in C#.NET using SMS API?With Source Code]

watch the designing part in video:

Code:

       

               String result;
                string apiKey = txtapi.Text;
                string numbers = txtnum.Text; // in a comma seperated list
                string message = txtmess.Text;
                string send = txtseder.Text;

                String url = "https://api.txtlocal.com/send/?apikey=" + apiKey + "&numbers=" + numbers + "&message=" + message + "&sender=" + send;
                //refer to parameters to complete correct url string

                StreamWriter myWriter = null;
                HttpWebRequest objRequest = (HttpWebRequest)WebRequest.Create(url);

                objRequest.Method = "POST";
                objRequest.ContentLength = Encoding.UTF8.GetByteCount(url);
                objRequest.ContentType = "application/x-www-form-urlencoded";
                try
                {
                    myWriter = new StreamWriter(objRequest.GetRequestStream());
                    myWriter.Write(url);
                }
                catch (Exception ex)
                {
                    //return e.Message;
                    MessageBox.Show(null, "the error is" + ex, MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
                finally
                {
                    myWriter.Close();
                }

                HttpWebResponse objResponse = (HttpWebResponse)objRequest.GetResponse();
                using (StreamReader sr = new StreamReader(objResponse.GetResponseStream()))
                {
                    result = sr.ReadToEnd();
                    // Close and clean up the StreamReader
                    sr.Close();
                }
                //return result;
                MessageBox.Show(result);
            }



       
 

Import following library file:
using System;
using System.Collections.Generic;
using System.Net;
using System.Collections.Specialized;
using System.IO;

Watch the video:

How to Send Free SMS in java using SMS API? [With Source Code]

Watch the Designing part in Video:

       
  // import package
  import java.io.BufferedReader;
  import java.io.InputStreamReader;
  import java.io.OutputStreamWriter;
  import java.net.URL;
  import java.net.URLConnection;
  import java.net.URLEncoder;
  import java.net.HttpURLConnection;
  import javax.swing.JOptionPane;

               try {
   // Construct data
   String apiKey = "apikey=" + txtapi.getText();
   String message = "&message=" + txtmess.getText();
   String sender = "&sender=" + txtsender.getText();
   String numbers = "&numbers=" + txtnumber.getText();
   
   // Send data
   HttpURLConnection conn = (HttpURLConnection) new URL("https://api.txtlocal.com/send/?").openConnection();
   String data = apiKey + numbers + message + sender;
   conn.setDoOutput(true);
   conn.setRequestMethod("POST");
   conn.setRequestProperty("Content-Length", Integer.toString(data.length()));
   conn.getOutputStream().write(data.getBytes("UTF-8"));
   final BufferedReader rd = new BufferedReader(new InputStreamReader(conn.getInputStream()));
   final StringBuffer stringBuffer = new StringBuffer();
   String line;
   while ((line = rd.readLine()) != null) {
    //stringBuffer.append(line);
                                JOptionPane.showMessageDialog(null, "message"+line);
   }
   rd.close();
   
   //return stringBuffer.toString();
  } catch (Exception e) {
   //System.out.println("Error SMS "+e);
                        JOptionPane.showMessageDialog(null, e);
   //return "Error "+e;

       
 

Video:

How to Send Free SMS using Android?[With Source Code]

Steps:

1. Watch the video for the designing part:


2. Declare the EditText and Button on MainActivity.java file as:

EditText _txtapi, _txtmess, _txtsender, _txtnum;
Button _btnsend; 

3. Initialize  button and textfield inside the onCreate method as:

_txtapi = (EditText)findViewById(R.id.txtapi);
_txtmess=(EditText)findViewById(R.id.txtmess);
_txtsender=(EditText)findViewById(R.id.txtsender);
_txtnum=(EditText)findViewById(R.id.txtphone);
_btnsend=(Button)findViewById(R.id.btnsend);

4. Create the listening event of button and write the following code inside that listening event as:

       

 _btnsend.setOnClickListener(new View.OnClickListener() {
    @Override    public void onClick(View v) {
        try {
            // Construct data            String apiKey = "apikey=" + _txtapi.getText().toString();
            String message = "&message=" + _txtmess.getText().toString();
            String sender = "&sender=" + _txtsender.getText().toString();
            String numbers = "&numbers=" + _txtnum.getText().toString();

            // Send data            HttpURLConnection conn = (HttpURLConnection) new URL("https://api.txtlocal.com/send/?").openConnection();
            String data = apiKey + numbers + message + sender;
            conn.setDoOutput(true);
            conn.setRequestMethod("POST");
            conn.setRequestProperty("Content-Length", Integer.toString(data.length()));
            conn.getOutputStream().write(data.getBytes("UTF-8"));
            final BufferedReader rd = new BufferedReader(new InputStreamReader(conn.getInputStream()));
            final StringBuffer stringBuffer = new StringBuffer();
            String line;
            while ((line = rd.readLine()) != null) {
                //stringBuffer.append(line);                Toast.makeText(getApplicationContext(), "the message is "+line, Toast.LENGTH_LONG).show();
            }
            rd.close();

            //return stringBuffer.toString();        } catch (Exception e) {
            //System.out.println("Error SMS "+e);            Toast.makeText(getApplicationContext(), "the error message is"+e, Toast.LENGTH_LONG).show();
            //return "Error "+e;        }
    }
});



       
 

5. Create the thread and write the above code inside that thread or strict the thread and write the following code inside the onCreate method but outsize the listening event of button.

StrictMode.ThreadPolicy policy = new StrictMode.ThreadPolicy.Builder().permitAll().build();
StrictMode.setThreadPolicy(policy);

Video:

How to Create Notification in Android using Android Studio?[With Source Code]

see the designing part in video:

after watching the designing part
1. declare the button as: Button _btnnotify
2. initialize the button as: _btnnotify=(Buttion)findViewByID(R.id.btnnotify).
3. Create the listening event of button and write the following code inside the listening event of button as:

       

               _btnnotify.setOnClickListener(new View.OnClickListener() {
    @Override       public void onClick(View v) {

NotificationCompat.Builder builer = new NotificationCompat.Builder(MainActivity.this);
        Intent intent = new Intent(Intent.ACTION_VIEW, Uri.parse("http://techsupportnep.blogspot.com"));
        PendingIntent pendingIntent = PendingIntent.getActivity(MainActivity.this, 01, intent,0);
        builer.setContentIntent(pendingIntent);
        builer.setDefaults(Notification.DEFAULT_ALL);
        builer.setContentTitle("NOTIFICATION TILE HERE");
        builer.setSmallIcon(R.mipmap.ic_launcher);
        builer.setContentText("this is notification example");
        NotificationManager notificationManager = (NotificationManager)getSystemService(NOTIFICATION_SERVICE);
        notificationManager.notify(001, builer.build());

    }
}); 

       
 

Video:

how to show alert dialog box in android?

A dialog is a small windows that prompts the user to make a decision or enter additional information. A dialog does not fill the screen and is used to take an action before they can proceed.example:

Alert Dialog in Android

The Dialog class is the base class for dialog, but we should avoid instantiating Dialog directly instead use one of the following subclasses.
AlertDialog: a dialog that can show a title, up to three buttons, a list of selected items, or a custom layout.
DatePickerDialog or TimePickerDialog: A dialog with a predefined UI that allows user to select a date or time.
Creating AlertDialog: create as:
        AlertDialog.Builder builder= new AlertDialog.Builder(MainActivity.this)


it has has three regions:
1. Title
2. Content area
3. Action button

Alert Dialog in Android

Three different action button:
1. positive: we should use this to accept and continue with the action (the “ok” action).
2. Negative: we should use this to cancel the action
3. Neutral: we should use this when the user may not want to proceed with the action but does not necessarily want to cancel.










Dismissing the dialog:

When the user touches any of the action buttons created with an AlertDiaog.Builder the system dismisses the dialog for us otherwise we can manually dismiss the dialog by calling dismiss().

See the design part in video:

Code:

Declare the button and textfield inside the main activity class as:

       

            Button _btnlogin;
    EditText _txtuser, _txtpass;
       
 

Initialize the button and text field inside the onCreate method as:

       

             _btnlogin=(Button)findViewById(R.id.btnlogin);
        _txtuser=(EditText)findViewById(R.id.txtuser);
        _txtpass=(EditText)findViewById(R.id.txtpass);
       
 

Create the listning event of the button and write the following code:

       

             _btnlogin.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                String user = _txtuser.getText().toString();
                String pass = _txtpass.getText().toString();
                if(user.equals("admin")&& pass.equals("admin")){
                    final AlertDialog.Builder builder= new AlertDialog.Builder(MainActivity.this);
                    builder.setTitle("informaiton");
                    builder.setMessage("username and password matched!");
                    builder.setPositiveButton("ok", new DialogInterface.OnClickListener() {
                        @Override
                        public void onClick(DialogInterface dialog, int which) {
                            dialog.dismiss();
                        }
                    });
                    AlertDialog dialog = builder.create();
                    dialog.show();

                }
            }
        });
       
 

Watch the video: