Posts

Showing posts from September, 2023

Asp curd

 Imports System.Data.SqlClient Public Class data_base_2     Dim conn As New SqlConnection     Dim cmd As New SqlCommand     Dim da As SqlDataAdapter     'Dim dt As New SqlDataReader     Dim ds As New DataSet     Private Sub data_base_2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load         'TODO: This line of code loads data into the 'Ucc_databaseDataSet.ucc_student' table. You can move, or remove it, as needed.         Me.Ucc_studentTableAdapter.Fill(Me.Ucc_databaseDataSet.ucc_student)         conn.ConnectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ucc_database.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"         conn.Open()         MsgBox("database conected..!")         MsgBox(conn.State())     End Sub ...
Post a Comment
Read more

PHP WITH SESSION

 // login.php page <?php // Start a session or resume the existing session session_start(); // Check if the user is already logged in, redirect to landing page if logged in if (isset($_SESSION['user_id'])) {     header("Location: landing.php");     exit; } // Check if the login form is submitted if (isset($_POST['login'])) {     // Validate user credentials (you should hash and securely store passwords)     $username = $_POST['username'];     $password = $_POST['password'];     // Replace with your database connection code     $db_connection = mysqli_connect("localhost", "username", "password", "database_name");     if (!$db_connection) {         die("Connection failed: " . mysqli_connect_error());     }     $sql = "SELECT * FROM users WHERE username = '$username' AND password = '$password'";     $result = mysqli_query($db_connection, $sql);   ...
Post a Comment
Read more

unix

 1.Arithmatic opration using swith case in UNIX #!/bin/bash echo "Enter first number: " read num1 echo "Enter second number: " read num2 echo "Enter the operation (+, -, '*', '/'): "  # Enclose '*' and '/' in single quotes read operation case $operation in     +) result=$((num1 + num2));;     -) result=$((num1 - num2));;     '*') result=$((num1 * num2));;   # Use single quotes to specify '*'     '/') result=$((num1 / num2));;   # Use single quotes to specify '/'     *) echo "Invalid operation"; exit 1;; esac echo "Result: $result" 2.print Febonacci series or prime number #!/bin/bash echo "Enter 'F' for Fibonacci series or 'P' for prime numbers: " read choice if [ "$choice" = "F" ]; then     echo "Enter the number of terms in Fibonacci series: "     read n     a=0     b=1     echo "Fibonacci Series: "     for ...
Post a Comment
Read more

CRUD OPRATION ASP.NET

Image
       CRUD Operation in ASP.NET using VB ·       Program Definition: The below given program perform CRUD operation in ASP.NET using VB.   ·       Designing Page: database.aspx   ·       Scripting page: database.aspx.vb   Imports System.Data.SqlClient   ·        To insert the data into database double click on “insert” button and write the following code into that part   Protected Sub btninsert_Click(ByVal sender As Object, ByVal e As EventArgs) Handles btninsert.Click   Dim connect As New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\GJ_SO_SMM\Documents\Vis ual Studio 2010\Projects\demo\demo\App_Data\Database1.mdf;Integrated Security=True;User Instance=True")   Dim productId As Integer = txtproductid.Text Dim name As ...
Post a Comment
Read more

ASP-WEB-APP

Image
Imports System.Data Imports System.Data.OleDb Public Class viewitem Inherits System.Web.UI. Page Dim strcon As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\Admin\Documents\shopingcart.mdb" Protected Sub Page_Load( ByVal sender As Object , ByVal e As System. EventArgs ) Handles Me .Load Dim con As New OleDbConnection Dim com As New OleDbCommand Dim da As New OleDbDataAdapter Dim ds As New DataSet con.ConnectionString = strcon con.Open() com.Connection = con com.CommandText = "Select * From item" da.SelectCommand = com da.Fill(ds) con.Close() GridView1.DataSource = ds.Tables(0) GridView1.DataBind() End Sub   Protected Sub Button1_Click( ByVal sender As Object , ByVal e As EventArgs ) Handles Button1.Click Dim con As New OleDbConnection Dim com As New OleDbCommand Dim da As New OleDbDataAdapter Dim ds As New DataSet con.ConnectionString = strcon con.Open() com.Connection = con ...
Post a Comment
Read more