KARTHICK's blog

KARTHICK NELLAI

ASP.NET WITH SQL CONNECTION C#

HEADER

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Data.SqlClient;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

CREATE

SqlConnection con1 = new SqlConnection("Data Source=MCANODE-102\\MCA;Initial Catalog=master;Integrated Security=True");

SqlDataReader rd1 = null;

con1.Open();

SqlCommand cmd = new SqlCommand("CREATE TABLE Persons (PersonID int, LastName varchar(255), FirstName varchar(255), Address varchar(255), City varchar(255) ); ", con1);

cmd.ExecuteNonQuery();

INSERT

SqlConnection con1 = new SqlConnection("Data Source=MCANODE-102\\MCA;Initial Catalog=master;Integrated Security=True");

SqlDataReader rd1 = null;

con1.Open();

SqlCommand cmd = new SqlCommand("INSERT INTO Table_1 (id, name)VALUES ('"+TextBox1.Text+"','"+TextBox2.Text +"') ; ", con1);

cmd.ExecuteNonQuery();

SELECT

SqlConnection con1 = new SqlConnection("Data Source=MCANODE-102\\MCA;Initial Catalog=master;Integrated Security=True");

SqlDataReader rd1 = null;

con1.Open();

SqlCommand cmd = new SqlCommand("select * from login ",con1 );

rd1=cmd.ExecuteReader();

while (rd1.Read())

{

TextBox1.Text= rd1.GetString(1).ToString();

}

DELETE

SqlConnection con1 = new SqlConnection("Data Source=MCANODE-102\\MCA;Initial Catalog=master;Integrated Security=True");

SqlDataReader rd1 = null;

con1.Open();

SqlCommand cmd = new SqlCommand("DELETE FROM Table_1 WHERE id='"+TextBox2.Text +"'; ", con1);

cmd.ExecuteNonQuery();

UPDATE

SqlConnection con1 = new SqlConnection("Data Source=MCANODE-102\\MCA;Initial Catalog=master;Integrated Security=True");

SqlDataReader rd1 = null;

con1.Open();

SqlCommand cmd = new SqlCommand("UPDATE Table_1 SET name='"+TextBox2.Text+"' WHERE id='"+TextBox1.Text+"'; ", con1);

cmd.ExecuteNonQuery();

ASP.NET WITH SQL CONNECTION C#

By karthick , in ASP.NET WITH SQL CONNECTION C# , c# , C# cooding for asp.net , sql connection in asp.net using c# , 2 Comments

HEADER

using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Data.SqlClient;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

CREATE

SqlConnection con1 = new SqlConnection("Data Source=MCANODE-102\\MCA;Initial Catalog=master;Integrated Security=True");

SqlDataReader rd1 = null;

con1.Open();

SqlCommand cmd = new SqlCommand("CREATE TABLE Persons (PersonID int, LastName varchar(255), FirstName varchar(255), Address varchar(255), City varchar(255) ); ", con1);

cmd.ExecuteNonQuery();

INSERT

SqlConnection con1 = new SqlConnection("Data Source=MCANODE-102\\MCA;Initial Catalog=master;Integrated Security=True");

SqlDataReader rd1 = null;

con1.Open();

SqlCommand cmd = new SqlCommand("INSERT INTO Table_1 (id, name)VALUES ('"+TextBox1.Text+"','"+TextBox2.Text +"') ; ", con1);

cmd.ExecuteNonQuery();

SELECT

SqlConnection con1 = new SqlConnection("Data Source=MCANODE-102\\MCA;Initial Catalog=master;Integrated Security=True");

SqlDataReader rd1 = null;

con1.Open();

SqlCommand cmd = new SqlCommand("select * from login ",con1 );

rd1=cmd.ExecuteReader();

while (rd1.Read())

{

TextBox1.Text= rd1.GetString(1).ToString();

}

DELETE

SqlConnection con1 = new SqlConnection("Data Source=MCANODE-102\\MCA;Initial Catalog=master;Integrated Security=True");

SqlDataReader rd1 = null;

con1.Open();

SqlCommand cmd = new SqlCommand("DELETE FROM Table_1 WHERE id='"+TextBox2.Text +"'; ", con1);

cmd.ExecuteNonQuery();

UPDATE

SqlConnection con1 = new SqlConnection("Data Source=MCANODE-102\\MCA;Initial Catalog=master;Integrated Security=True");

SqlDataReader rd1 = null;

con1.Open();

SqlCommand cmd = new SqlCommand("UPDATE Table_1 SET name='"+TextBox2.Text+"' WHERE id='"+TextBox1.Text+"'; ", con1);

cmd.ExecuteNonQuery();

Message box for asp.net c#

By karthick , in Message box for asp.net c# , 1 Comment

Alert for asp.net c#

Type cstype = this.GetType();

// Get a ClientScriptManager reference from the Page class.

ClientScriptManager cs = Page.ClientScript;

// Check to see if the startup script is already registered.

if (!cs.IsStartupScriptRegistered(cstype, "PopupScript"))

{

String cstext = "alert('karthi');";

cs.RegisterStartupScript(cstype, "PopupScript", cstext, true);

}

ASP.NET with SQL Server 2005 DataBase

By karthick , in ASP.NET with SQL Server 2005 DataBase , 1 Comment

CREATE DATABASE AND TABLE

ASP.NET with Database connection

VB.NET

Source code

Imports System

Imports System.Web.UI.WebControls

Imports System.Web.UI.HtmlControls

Imports System.Data

Imports System.Data.SqlClient

Partial Class _Default

Inherits System.Web.UI.Page

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click

Dim myConnection As System.Data.SqlClient.SqlConnection

Dim myCommand As System.Data.SqlClient.SqlCommand

Dim strSQL As String

myConnection = New SqlConnection("Data Source=USER-PC;Initial Catalog=master;User ID=sa;Password=system") 'master is database name,User is hostname

myConnection.Open() 'Open the connection

strSQL = "SELECT * FROM log where id=" + TextBox1.Text 'log is tablename,id is field

myCommand = New SqlCommand(strSQL, myConnection)

Dim re As SqlDataReader = myCommand.ExecuteReader()

While re.Read

TextBox2.Text = re.GetString(1).ToString’Read rows

End While

End Sub

End Class

Run the website

SQL Data Base Connection code

By karthick , 0 Comments

Imports System

Imports System.Web.UI.WebControls

Imports System.Web.UI.HtmlControls

Imports System.Data

Imports System.Data.SqlClient

Dim myConnection As System.Data.SqlClient.SqlConnection

Dim myCommand As System.Data.SqlClient.SqlCommand

Dim strSQL As String

myConnection = New SqlConnection("Data Source=MCANODE-102\MCA;Initial Catalog=master;Integrated Security=True")’master is database name,MCANODE_102\MCA hostname

myConnection.Open()’Open the connection

strSQL = "SELECT * FROM kar where id=12" ‘kar is tablename,id is field

myCommand = New SqlCommand(strSQL, myConnection)

Dim re As SqlDataReader = myCommand.ExecuteReader()

While re.Read

TextBox1.Text = re.GetString(2).ToString

End While

myConnection.Close()’Close the connection

RMI simple example

By karthick , in RMI simple example , 0 Comments

RMI simple example

Interface

import java.rmi.Remote;

import java.rmi.RemoteException;

public interface Calculator extends Remote

{

public long addition(long a,long b) throws RemoteException;

public long subtraction(long a,long b) throws RemoteException;

public long multiplication(long a,long b) throws RemoteException;

public long division(long a,long b) throws RemoteException;

}

Implementation

import java.rmi.RemoteException;

import java.rmi.server.UnicastRemoteObject;

public class CalculatorImpl extends UnicastRemoteObject implements Calculator

{

protected CalculatorImpl() throws RemoteException

{

super();

}

public long addition(long a, long b) throws RemoteException

{

return a+b;

}

public long subtraction(long a, long b) throws RemoteException

{

return a-b;

}

public long multiplication(long a, long b) throws RemoteException

{

return a*b;

}

public long division(long a, long b) throws RemoteException

{

return a/b;

}

import java.rmi.Remote;

import java.rmi.RemoteException;

public interface Calculator extends Remote

{

public long addition(long a,long b) throws RemoteException;

public long subtraction(long a,long b) throws RemoteException;

public long multiplication(long a,long b) throws RemoteException;

public long division(long a,long b) throws RemoteException;

}

Server

import java.rmi.Naming;

public class CalculatorServer

{

CalculatorServer()

{

try

{

Calculator c = new CalculatorImpl();

Naming.rebind("rmi://localhost:1099/CalculatorService", c);

}

catch (Exception e)

{

System.out.println("Exception is : "+e);

}

public static void main(String[] args)

{

new CalculatorServer();

}

Client

import java.rmi.Naming;

public class CalculatorClient

{

public static void main(String[] args)

{

try

{

Calculator c = (Calculator) Naming.lookup("//127.0.0.1:1099/CalculatorService");

System.out.println("Addition : "+c.addition(10,5));

System.out.println("Subtraction : "+c.subtraction(10,5));

System.out.println("Multiplication :"+c.multiplication(10,5));

System.out.println("Division : "+c. division(10,5));

}

catch (Exception e)

{

System.out.println("Exception is : "+e);

}

Compilation

javac Calculator.java

javac CalculatorImpl.java

javac CalculatorServer.java

javac CalculatorClient.java

rmic CalculatorImpl

start rmiregistry

java CalculatorServer

java CalculatorClient

output

Addition : 15

Subtraction : 5

Multiplication :50

Division : 2

KARTHICK's blog

KARTHICK NELLAI

Pages

ASP.NET WITH SQL CONNECTION C#

ASP.NET WITH SQL CONNECTION C#

Message box for asp.net c#

ASP.NET with SQL Server 2005 DataBase

SQL Data Base Connection code

RMI simple example

Search This Blog

About Me

Blog Archive

Labels