AWP SQL

A) Create a web application bind data in a multiline textbox by querying in another textbox.

protected void Button1_Click(object sender, EventArgs e)

{

SqlConnection conn=new SqlConnection();

conn.ConnectionString="Data Source=COMP254;Initial Catalog=TYIT;Integrated

Security=True";

//stringconnStr = ConfigurationManager.ConnectionStrings["connStr"].ConnectionString;

//SqlCommand cmd = new SqlCommand("Select Id,Name,Password from Login", conn);

SqlCommand cmd = new SqlCommand(TextBox1.Text, conn);

conn.Open();

SqlDataReader reader = cmd.ExecuteReader();

while (reader.Read())

{

TextBox2.Text += reader["Id"].ToString() + " " + reader["Name"].ToString() + " "

+ reader["Password"].ToString() +

"\n";

}

reader.Close();

conn.Close();

}

 B) Create a web application to display records by using database.


protected void Button1_Click(object sender, EventArgs e)

{

SqlConnection conn = new SqlConnection();

conn.ConnectionString = "Data Source=COMP254;Initial Catalog=TYIT;Integrated

Security=True";

//stringconnStr = ConfigurationManager.ConnectionStrings["connStr"].ConnectionString;

//SqlCommand cmd = new SqlCommand("Select * from City", conn);

SqlCommand cmd = new SqlCommand(TextBox1.Text, conn);

conn.Open();

SqlDataReader reader = cmd.ExecuteReader();

while (reader.Read())

{

//To add new blank line in the text area

for (int i = 0; i < reader.FieldCount - 1; i++)

{

Listbox1.Items.Add(reader[i+1].ToString());

}

}

reader.Close();

conn.Close();

}

Practical No. 7 Working with Database

A) Create a web application to display Databinding using dropdownlist control.

Create a web page with DropDownList control, one Button and one Label

control.

protected void Page_Load(object sender, EventArgs e)

{

if (IsPostBack == false)

{

SqlConnection conn=new SqlConnection();

conn.ConnectionString="Data Source=COMP254;Initial Catalog=TYIT;Integrated

Security=True";

//stringconnStr = ConfigurationManager.ConnectionStrings["connStr"].ConnectionString;

//SqlCommand cmd = new SqlCommand("Select Id,city from City", conn);

SqlCommand cmd = new SqlCommand(“select Id,city from City”, conn);

conn.Open();

SqlDataReader reader = cmd.ExecuteReader();

DropDownList1.DataSource = reader;

DropDownList1.DataTextField = "City";

DropDownList1.DataBind();

reader.Close();

conn.Close();

}

}

protected void Button1_Click(object sender, EventArgs e)

{

Label1.Text = "You Have Selected : " + DropDownList1.SelectedValue;

} }


B) Create a web application for to display the phone no of an author using database

protected void Page_Load(object sender, EventArgs e)

{

if (IsPostBack == false)

{

SqlConnection conn=new SqlConnection();

conn.ConnectionString="Data Source=COMP254;Initial Catalog=TYIT;Integrated

Security=True";

//stringconnStr =

ConfigurationManager.ConnectionStrings["connStr"].ConnectionString;

//SqlCommand cmd = new SqlCommand("Select Id,city from City", conn);

SqlCommand cmd = new SqlCommand("select * from Book", conn);

conn.Open();

SqlDataReader reader = cmd.ExecuteReader();

DropDownList1.DataSource = reader;


DropDownList1.DataTextField = "book";

DropDownList1.DataBind();

reader.Close();

conn.Close();

}

}

protected void Button1_Click(object sender, EventArgs e)

{

SqlConnection conn=new SqlConnection();

conn.ConnectionString="Data Source=COMP254;Initial Catalog=TYIT;Integrated

Security=True";

string selectSQL;

selectSQL = "select author from Book ";

selectSQL += "WHERE id=" + DropDownList1.SelectedItem.Value + "";

SqlCommand cmd = new SqlCommand(selectSQL, conn);

cmd.Connection = conn;

conn.Open();

SqlDataReader reader = cmd.ExecuteReader();

while (reader.Read())

{

Label1.Text = reader["author"].ToString();

}

reader.Close();

conn.Close();

}


C) Create a web application for inserting and deleting record from a database. (Using Execute-

Non Query).


4 Lables , 3 Textboxes and 1 Button

protected void Button1_Click(object sender, EventArgs e)

{

SqlConnection conn=new SqlConnection();

conn.ConnectionString="Data Source=COMP254;Initial Catalog=TYIT;Integrated

Security=True";

string InsertQuery = "insert into Book values(@id, @book,

@author)";

SqlCommand cmd = new SqlCommand(InsertQuery, conn);

cmd.Parameters.AddWithValue("@id", TextBox1.Text);

cmd.Parameters.AddWithValue("@book", TextBox2.Text);

cmd.Parameters.AddWithValue("@author", TextBox3.Text);

conn.Open();

cmd.ExecuteNonQuery();

Label4.Text = "Record Inserted Successfuly.";

conn.Close();

}


stringInsertQuery = "delete from branch where NAME=@NAME";

SqlCommandcmd = new SqlCommand(InsertQuery, con);

cmd.Parameters.AddWithValue("@NAME", TextBox1.Text);

con.Open( );


cmd.ExecuteNonQuery( );



Comments

Post a Comment

Popular posts from this blog

python(BI)

PRACTICAL NO.1 AIM: Perform the data classification using classification algorithm.  1A. Perform the data classification using Naïve Baye’s Algorithm. from sklearn.datasets import load_iris iris = load_iris() X = iris.data y = iris.target from sklearn.model_selection import train_test_split X_train,X_test,y_train,y_test=train_test_split(X,y,test_size=0.4,random_state=1) from sklearn.naive_bayes import GaussianNB gnb=GaussianNB() gnb.fit(X_train,y_train) y_pred=gnb.predict(X_test) from sklearn import metrics print("Gaussian Naive Bayes model accuracy(in%):",metrics.accuracy_score(y_test,y_pred)*100) EXAMPLE-span.csv import numpy as np import pandas as pd from sklearn.feature_extraction.text import CountVectorizer from sklearn.naive_bayes import MultinomialNB df=pd.read_csv('/content/spam1.csv',encoding='latin-1') df=df[['Message','Category']] df.columns=['SMS','Type'] countvec=CountVectorizer(ngram_range=(1,4),stop_words='eng...
Read more

Prac_8(AMP)

PRACTICAL 8  Activity.xml <? xml version ="1.0" encoding ="utf-8" ?> <androidx.constraintlayout.widget.ConstraintLayout xmlns: android ="http://schemas.android.com/apk/res/android"     xmlns: app ="http://schemas.android.com/apk/res-auto"     xmlns: tools ="http://schemas.android.com/tools"     android :layout_width ="match_parent"     android :layout_height ="match_parent"     tools :context =".MainActivity" >    <Button         android :id ="@+id/btnstart"         android :layout_width ="wrap_content"         android :layout_height ="wrap_content"         android :text ="Start"         app :layout_constraintBottom_toBottomOf ="parent"         app :layout_constraintEnd_to...
Read more

LSA10

i) Program that demonstrates the use of if..else with test Create a vi editor to write the script: vi Prog1.sh Code: echo Enter any number read n if test $n -gt 0 then              echo $n is positive else              echo $n is negative fi steps forward chmod +X Prog1.sh bash Prog1.sh ii) Program to check existing file Create a vi editor to write the script: code: echo Enter the file name: read fname if [ -f $fname ] then           echo the File Exists. else             echo the File with name $fname does not exists fi iii) Program for string comparison Create a vi editor to write the script: code: echo Enter two Strings read str1 read str2 if [ $str1 = $str2 ] then             echo The strings are identical else             echo The Strings are not id...
Read more