Mobile Shop Project Report 4t1w2a

  • ed by: Vishnu Chariyathra A
  • 0
  • 0
  • December 2019
  • PDF

This document was ed by and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this report form. Report 3b7i

Overview 3e4r5l

& View Mobile Shop Project Report as PDF for free.

More details w3441

  • Words: 8,027
  • Pages: 74


Product using System; using System.Collections.Generic; using System.Linq;

E-Mobi using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data.SqlClient; using System.Data; using System.Data.Sql; public partial class product : System.Web.UI.Page { SqlConnection con = new SqlConnection("Data Source=hppc;Initial Catalog=mobile;Integrated Security=True"); string br = ""; protected void Page_Load(object sender, EventArgs e) { 2.Visible = false; if (!IsPostBack) { DropDownList1.Items.Insert(0, new ListItem("Add New", "")); } commen.Visible = false; } protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) { DropDownList2.Items.Clear(); Label1.Text = DropDownList1.SelectedItem.Text.ToString(); con.Open(); String getState = "Select model from Tb_pro where brand_name='" + DropDownList1.SelectedItem.Text.ToString() + "'"; DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(getState, con); da.Fill(dt); DropDownList2.DataSource = dt; DropDownList2.DataTextField = "model"; DropDownList2.DataValueField = "model"; DropDownList2.DataBind(); DropDownList2.Items.Insert(0, new ListItem("Select model..", ""));

E-Mobi con.Close(); /* Label1.Text = DropDownList1.Text.ToString(); Label1.Text += " "; Label1.Text+=DropDownList2.Text.ToString(); 2.Visible = true;*/ } protected void DropDownList2_SelectedIndexChanged(object sender, EventArgs e) { string fr1 = ""; try { //SqlConnection con = new SqlConnection("Data Source=ups5d40;Initial Catalog=mobile;Integrated Security=True"); con.Open(); String getState = "Select * from Tb_pro where brand_name='" + DropDownList1.SelectedItem.Text.ToString() + "'AND model='"+DropDownList2.SelectedItem.Text.ToString() +"'"; DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(getState, con); da.Fill(dt); if(dt.Rows.Count>0) { //Label2.Text = dt.Rows[0][0].ToString(); Label2.Text = dt.Rows[0][1].ToString(); Label3.Text = dt.Rows[0][2].ToString(); Label4.Text = dt.Rows[0][3].ToString(); Label5.Text = dt.Rows[0][4].ToString(); Label6.Text = dt.Rows[0][5].ToString(); Label7.Text = dt.Rows[0][6].ToString(); Label8.Text = dt.Rows[0][7].ToString(); Label9.Text = dt.Rows[0][8].ToString(); Label10.Text = dt.Rows[0][9].ToString(); Label11.Text=dt.Rows[0][10].ToString(); Label12.Text = dt.Rows[0][11].ToString(); Label13.Text = dt.Rows[0][12].ToString(); Label14.Text = dt.Rows[0][13].ToString(); Label15.Text = dt.Rows[0][14].ToString(); Label16.Text = dt.Rows[0][15].ToString();

E-Mobi Label17.Text = dt.Rows[0][16].ToString(); Label18.Text = dt.Rows[0][18].ToString(); Label19.Text = dt.Rows[0][19].ToString(); Label20.Text = dt.Rows[0][20].ToString(); Label21.Text = dt.Rows[0][21].ToString(); Label22.Text = dt.Rows[0][22].ToString(); Label23.Text = dt.Rows[0][23].ToString(); Label24.Text = dt.Rows[0][24].ToString(); Label25.Text = dt.Rows[0][25].ToString(); Label26.Text = dt.Rows[0][26].ToString(); Label27.Text = dt.Rows[0][27].ToString(); Label28.Text = dt.Rows[0][28].ToString(); Label29.Text = dt.Rows[0][29].ToString(); Label30.Text = dt.Rows[0][30].ToString(); Label31.Text = dt.Rows[0][31].ToString(); Label32.Text = dt.Rows[0][32].ToString(); Label33.Text = dt.Rows[0][33].ToString(); Label34.Text = dt.Rows[0][17].ToString(); string fr = "~//product//"; fr = dt.Rows[0][34].ToString(); Image1.Width = 120; Image1.Height = 200; Image1.ImageUrl = fr; br = dt.Rows[0][0].ToString(); fr1 = br; } } catch(Exception dr2) { Response.Write(dr2.Message); } try { string sl = "select * from Tb_Review where product_id='" + br + "'"; SqlDataAdapter sqdt1 = new SqlDataAdapter(sl, con); DataTable dt1 = new DataTable(); sqdt1.Fill(dt1); if (dt1.Rows.Count > 0)

E-Mobi { commen.DataSource = dt1; commen.DataBind(); commen.Visible = true; } } catch(Exception j) { Response.Write(j.Message); } Label1.Text = DropDownList1.Text.ToString(); Label1.Text += " "; Label1.Text += DropDownList2.Text.ToString(); 2.Visible = true; } protected void Button1_Click(object sender, EventArgs e) { try { String getState = "Select product_id from Tb_pro where brand_name='" + DropDownList1.SelectedItem.Text.ToString() + "'AND model='"+DropDownList2.SelectedItem.Text.ToString() +"'"; DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(getState, con); da.Fill(dt); SqlCommand cmd = new SqlCommand(); con.Open(); cmd.Connection = con; cmd.CommandText = "insert into Tb_Review values('" +dt.Rows[0][0].ToString()+ "','" + txtname.Text.ToString() + "','" + TextBox1.Text.ToString() + "','" + TextBox2.Text.ToString() + "','" + System.DateTime.Now.ToString() + "','" +RadioButtonList1.SelectedItem.Text.ToString()+ "')"; cmd.ExecuteNonQuery(); con.Close(); } catch (Exception jk) { Response.Write(jk.Message); }

E-Mobi } }

Search Product using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data.SqlClient; using System.Data; public partial class search : System.Web.UI.Page { SqlConnection con = new SqlConnection("Data Source=hppc;Initial Catalog=mobile;Integrated Security=True"); protected void Page_Load(object sender, EventArgs e) { 1.Visible = false; 2.Visible = false; 3.Visible = false; 4.Visible = false; con.Open(); String getState1 = "Select DISTINCT brand_name from Tb_pro"; DataTable dt1 = new DataTable(); SqlDataAdapter da1 = new SqlDataAdapter(getState1, con); da1.Fill(dt1); if (dt1.Rows.Count > 0) { DropDownList1.DataSource = dt1; DropDownList1.DataTextField = "brand_name"; DropDownList1.DataValueField = "brand_name"; DropDownList1.DataBind(); } con.Close();

E-Mobi } protected void Button1_Click(object sender, EventArgs e) { 3.Visible = false; 4.Visible = false; GridView1.Visible = false; if (TextBox1.Text.ToString()!="") { con.Open(); String getState2 = "Select * from Tb_pro where model LIKE '%" + TextBox1.Text.ToString() + "%'"; DataTable dt2 = new DataTable(); SqlDataAdapter da2 = new SqlDataAdapter(getState2, con); da2.Fill(dt2); if (dt2.Rows.Count > 0) { GridView1.Visible = true; GridView1.DataSource = dt2; GridView1.DataBind(); } else { 4.Visible = true; 3.Visible = true; } con.Close(); } } protected void CheckBox1_CheckedChanged(object sender, EventArgs e) { } protected void Button2_Click(object sender, EventArgs e) { 1.Visible = true; GridView1.Visible = false; } protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)

E-Mobi { if (e.CommandName == "view") { con.Open(); string frh = e.CommandArgument.ToString(); String getState = "Select * from Tb_pro where product_id='" +frh+ "'"; DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(getState, con); da.Fill(dt); if (dt.Rows.Count > 0) { //Label2.Text = dt.Rows[0][0].ToString(); Label2.Text = dt.Rows[0][1].ToString(); Label3.Text = dt.Rows[0][2].ToString(); Label4.Text = dt.Rows[0][3].ToString(); Label5.Text = dt.Rows[0][4].ToString(); Label6.Text = dt.Rows[0][5].ToString(); Label7.Text = dt.Rows[0][6].ToString(); Label8.Text = dt.Rows[0][7].ToString(); Label9.Text = dt.Rows[0][8].ToString(); Label10.Text = dt.Rows[0][9].ToString(); Label11.Text = dt.Rows[0][10].ToString(); Label12.Text = dt.Rows[0][11].ToString(); Label13.Text = dt.Rows[0][12].ToString(); Label14.Text = dt.Rows[0][13].ToString(); Label15.Text = dt.Rows[0][14].ToString(); Label16.Text = dt.Rows[0][15].ToString(); Label17.Text = dt.Rows[0][16].ToString(); Label18.Text = dt.Rows[0][18].ToString(); Label19.Text = dt.Rows[0][19].ToString(); Label20.Text = dt.Rows[0][20].ToString(); Label21.Text = dt.Rows[0][21].ToString(); Label22.Text = dt.Rows[0][22].ToString(); Label23.Text = dt.Rows[0][23].ToString(); Label24.Text = dt.Rows[0][24].ToString(); Label25.Text = dt.Rows[0][25].ToString(); Label26.Text = dt.Rows[0][26].ToString(); Label27.Text = dt.Rows[0][27].ToString();

E-Mobi Label28.Text = dt.Rows[0][28].ToString(); Label29.Text = dt.Rows[0][29].ToString(); Label30.Text = dt.Rows[0][30].ToString(); Label31.Text = dt.Rows[0][31].ToString(); Label32.Text = dt.Rows[0][32].ToString(); Label33.Text = dt.Rows[0][33].ToString(); Label34.Text = dt.Rows[0][17].ToString(); string fr = "~//product//"; fr = dt.Rows[0][34].ToString(); Image1.Width = 120; Image1.Height = 200; Image1.ImageUrl = fr; Label1.Text = dt.Rows[0][2].ToString(); Label1.Text += " "; Label1.Text += dt.Rows[0][3].ToString(); 2.Visible = true; } else { 3.Visible = true; 4.Visible = true; } con.Close(); } } protected void Button3_Click(object sender, EventArgs e) { 3.Visible = false; 4.Visible = false; GridView1.Visible = false; con.Open(); String getState2 = "Select * from Tb_pro where brand_name='" + DropDownList1.SelectedItem.Text.ToString() + "'and price < 5000"; if (DropDownList2.SelectedItem.Text.ToString()=="BETWEEN 5000 AND 10000") { getState2 = "Select * from Tb_pro where brand_name='" + DropDownList1.SelectedItem.Text.ToString() + "'and price BETWEEN 5000 AND 10000";

E-Mobi } else if (DropDownList2.SelectedItem.Text.ToString() == "BETWEEN 10000 AND 20000") { getState2 = "Select * from Tb_pro where brand_name='" + DropDownList1.SelectedItem.Text.ToString() + "'and price BETWEEN 10000 AND 20000"; } else if (DropDownList2.SelectedItem.Text.ToString() == "ABOVE 20000") { getState2 = "Select * from Tb_pro where brand_name='" + DropDownList1.SelectedItem.Text.ToString() + "'and price > 20000"; } DataTable dt2 = new DataTable(); SqlDataAdapter da2 = new SqlDataAdapter(getState2, con); da2.Fill(dt2); if (dt2.Rows.Count > 0) { GridView1.Visible = true; GridView1.DataSource = dt2; GridView1.DataBind(); } else { 3.Visible = true; 4.Visible = true; } con.Close(); } }

Compare Products using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI;

E-Mobi using System.Web.UI.WebControls; using System.Data; using System.Data.SqlClient; public partial class compare : System.Web.UI.Page { SqlConnection con = new SqlConnection("Data Source=hppc;Initial Catalog=mobile;Integrated Security=True"); protected void Page_Load(object sender, EventArgs e) { 2.Visible = false; DropDownList2.Enabled = false; DropDownList3.Enabled = false; DropDownList4.Enabled = false; } protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) { DropDownList2.Items.Clear(); Label1.Text = DropDownList1.SelectedItem.Text.ToString(); con.Open(); String getState = "Select model from Tb_pro where brand_name='" + DropDownList1.SelectedItem.Text.ToString() + "'"; DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(getState, con); da.Fill(dt); DropDownList2.DataSource = dt; DropDownList2.DataTextField = "model"; DropDownList2.DataValueField = "model"; DropDownList2.DataBind(); DropDownList2.Items.Insert(0, new ListItem("Select model..", "")); con.Close(); DropDownList2.Enabled = true; } protected void DropDownList2_SelectedIndexChanged(object sender, EventArgs e) { try

E-Mobi { // SqlConnection con = new SqlConnection("Data Source=ups5d40;Initial Catalog=mobile;Integrated Security=True"); con.Open(); String getState = "Select * from Tb_pro where brand_name='" + DropDownList1.SelectedItem.Text.ToString() + "'AND model='" + DropDownList2.SelectedItem.Text.ToString() + "'"; DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(getState, con); da.Fill(dt); if (dt.Rows.Count > 0) { //Label2.Text = dt.Rows[0][0].ToString(); Label2.Text = dt.Rows[0][1].ToString(); Label3.Text = dt.Rows[0][2].ToString(); Label4.Text = dt.Rows[0][3].ToString(); Label5.Text = dt.Rows[0][4].ToString(); Label6.Text = dt.Rows[0][5].ToString(); Label7.Text = dt.Rows[0][6].ToString(); Label8.Text = dt.Rows[0][7].ToString(); Label9.Text = dt.Rows[0][8].ToString(); Label10.Text = dt.Rows[0][9].ToString(); Label11.Text = dt.Rows[0][10].ToString(); Label12.Text = dt.Rows[0][11].ToString(); Label13.Text = dt.Rows[0][12].ToString(); Label14.Text = dt.Rows[0][13].ToString(); Label15.Text = dt.Rows[0][14].ToString(); Label16.Text = dt.Rows[0][15].ToString(); Label17.Text = dt.Rows[0][16].ToString(); Label18.Text = dt.Rows[0][18].ToString(); Label19.Text = dt.Rows[0][19].ToString(); Label20.Text = dt.Rows[0][20].ToString(); Label21.Text = dt.Rows[0][21].ToString(); Label22.Text = dt.Rows[0][22].ToString(); Label23.Text = dt.Rows[0][23].ToString(); Label24.Text = dt.Rows[0][24].ToString(); Label25.Text = dt.Rows[0][25].ToString(); Label26.Text = dt.Rows[0][26].ToString(); Label27.Text = dt.Rows[0][27].ToString();

E-Mobi Label28.Text = dt.Rows[0][28].ToString(); Label29.Text = dt.Rows[0][29].ToString(); Label30.Text = dt.Rows[0][30].ToString(); Label31.Text = dt.Rows[0][31].ToString(); Label32.Text = dt.Rows[0][32].ToString(); Label33.Text = dt.Rows[0][33].ToString(); Label34.Text = dt.Rows[0][17].ToString(); Image1.ImageUrl = dt.Rows[0][34].ToString(); con.Close(); DropDownList3.Enabled = true; /* 2*//* Label35.Visible = false; Label1.Visible = false; Label36.Visible = false; Label37.Visible = false; Label38.Visible = false; Label39.Visible = false; Label40.Visible = false; Label41.Visible = false; Label42.Visible = false; Label43.Visible = false; Label44.Visible = false; Label45.Visible = false; Label46.Visible = false; Label47.Visible = false; Label48.Visible = false; Label49.Visible = false; Label50.Visible = false; Label51.Visible = false; Label52.Visible = false; Label53.Visible = false; Label54.Visible = false; Label55.Visible = false; Label56.Visible = false; Label57.Visible = false; Label58.Visible = false; Label59.Visible = false; Label60.Visible = false;

E-Mobi Label61.Visible = false; Label62.Visible = false; Label63.Visible = false; Label64.Visible = false; Label65.Visible = false; Label66.Visible = false; Image2.Visible = false; 2.Visible = true;*/ /*ENDING*/ } } catch (Exception dr2) { Response.Write(dr2.Message); } } protected void DropDownList3_SelectedIndexChanged(object sender, EventArgs e) { DropDownList4.Items.Clear(); Label1.Text = DropDownList3.SelectedItem.Text.ToString(); // SqlConnection con = new SqlConnection("Data Source=ups5d40;Initial Catalog=mobile;Integrated Security=True"); con.Open(); String getState = "Select model from Tb_pro where brand_name='" + DropDownList3.SelectedItem.Text.ToString() + "'"; DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(getState, con); da.Fill(dt); DropDownList4.DataSource = dt; DropDownList4.DataTextField = "model"; DropDownList4.DataValueField = "model"; DropDownList4.DataBind(); DropDownList4.Items.Insert(0, new ListItem("Select model..", "")); DropDownList4.Enabled = true; con.Close(); }

E-Mobi protected void DropDownList4_SelectedIndexChanged(object sender, EventArgs e) { try { SqlConnection con1 = new SqlConnection("Data Source=hppc;Initial Catalog=mobile;Integrated Security=True"); con1.Open(); String getState = "Select * from Tb_pro where brand_name='" + DropDownList3.SelectedItem.Text.ToString() + "'AND model='" + DropDownList4.SelectedItem.Text.ToString() + "'"; DataTable dt1 = new DataTable(); SqlDataAdapter da1 = new SqlDataAdapter(getState, con1); da1.Fill(dt1); if(dt1.Rows.Count>0) { Label35.Text = dt1.Rows[0][1].ToString(); Label1.Text = dt1.Rows[0][2].ToString(); Label36.Text = dt1.Rows[0][3].ToString(); Label37.Text = dt1.Rows[0][4].ToString(); Label38.Text = dt1.Rows[0][5].ToString(); Label39.Text = dt1.Rows[0][6].ToString(); Label40.Text = dt1.Rows[0][7].ToString(); Label41.Text = dt1.Rows[0][8].ToString(); Label42.Text = dt1.Rows[0][9].ToString(); Label43.Text = dt1.Rows[0][10].ToString(); Label44.Text = dt1.Rows[0][11].ToString(); Label45.Text = dt1.Rows[0][12].ToString(); Label46.Text = dt1.Rows[0][13].ToString(); Label47.Text = dt1.Rows[0][14].ToString(); Label48.Text = dt1.Rows[0][15].ToString(); Label49.Text = dt1.Rows[0][16].ToString(); Label50.Text = dt1.Rows[0][17].ToString(); Label51.Text = dt1.Rows[0][18].ToString(); Label52.Text = dt1.Rows[0][19].ToString(); Label53.Text = dt1.Rows[0][20].ToString(); Label54.Text = dt1.Rows[0][21].ToString(); Label55.Text = dt1.Rows[0][22].ToString(); Label56.Text = dt1.Rows[0][23].ToString();

E-Mobi Label57.Text = dt1.Rows[0][24].ToString(); Label58.Text = dt1.Rows[0][25].ToString(); Label59.Text = dt1.Rows[0][26].ToString(); Label60.Text = dt1.Rows[0][27].ToString(); Label61.Text = dt1.Rows[0][28].ToString(); Label62.Text = dt1.Rows[0][29].ToString(); Label63.Text = dt1.Rows[0][30].ToString(); Label64.Text = dt1.Rows[0][31].ToString(); Label65.Text = dt1.Rows[0][32].ToString(); Label66.Text = dt1.Rows[0][33].ToString(); Image2.ImageUrl = dt1.Rows[0][34].ToString(); 2.Visible = true; /* 1*//* try { SqlConnection con = new SqlConnection("Data Source=ups5d40;Initial Catalog=mobile;Integrated Security=True"); con.Open(); String getState1 = "Select * from Tb_pro where brand_name='" + DropDownList1.SelectedItem.Text.ToString() + "'AND model='" + DropDownList2.SelectedItem.Text.ToString() + "'"; DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(getState1, con); da.Fill(dt); if (dt.Rows.Count > 0) { //Label2.Text = dt.Rows[0][0].ToString(); Label2.Text = dt.Rows[0][1].ToString(); Label3.Text = dt.Rows[0][2].ToString(); Label4.Text = dt.Rows[0][3].ToString(); Label5.Text = dt.Rows[0][4].ToString(); Label6.Text = dt.Rows[0][5].ToString(); Label7.Text = dt.Rows[0][6].ToString(); Label8.Text = dt.Rows[0][7].ToString(); Label9.Text = dt.Rows[0][8].ToString(); Label10.Text = dt.Rows[0][9].ToString(); Label11.Text = dt.Rows[0][10].ToString(); Label12.Text = dt.Rows[0][11].ToString(); Label13.Text = dt.Rows[0][12].ToString();

E-Mobi Label14.Text = dt.Rows[0][13].ToString(); Label15.Text = dt.Rows[0][14].ToString(); Label16.Text = dt.Rows[0][15].ToString(); Label17.Text = dt.Rows[0][16].ToString(); Label18.Text = dt.Rows[0][18].ToString(); Label19.Text = dt.Rows[0][19].ToString(); Label20.Text = dt.Rows[0][20].ToString(); Label21.Text = dt.Rows[0][21].ToString(); Label22.Text = dt.Rows[0][22].ToString(); Label23.Text = dt.Rows[0][23].ToString(); Label24.Text = dt.Rows[0][24].ToString(); Label25.Text = dt.Rows[0][25].ToString(); Label26.Text = dt.Rows[0][26].ToString(); Label27.Text = dt.Rows[0][27].ToString(); Label28.Text = dt.Rows[0][28].ToString(); Label29.Text = dt.Rows[0][29].ToString(); Label30.Text = dt.Rows[0][30].ToString(); Label31.Text = dt.Rows[0][31].ToString(); Label32.Text = dt.Rows[0][32].ToString(); Label33.Text = dt.Rows[0][33].ToString(); Label34.Text = dt.Rows[0][17].ToString(); Image1.ImageUrl = dt.Rows[0][34].ToString(); con.Close(); } } catch(Exception g) { Response.Write(g.Message); } /*end*/ } con1.Close(); } catch (Exception dr2) { Response.Write(dr2.Message); }

E-Mobi } }

using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data.SqlClient; using System.Data.Sql; using System.Data; public partial class : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void Button1_Click(object sender, EventArgs e) { try { SqlConnection con = new SqlConnection("Data Source=hppc;Initial Catalog=mobile;Integrated Security=True"); string ins = "select * from Tb_ where _uname='" + TextBox1.Text.ToString() + "' and _pwd='" + TextBox2.Text.ToString() + "'"; SqlDataAdapter sqdt = new SqlDataAdapter(ins, con); DataTable dt = new DataTable(); sqdt.Fill(dt); if (dt.Rows.Count > 0) { Response.Redirect("//HOME.aspx"); }

E-Mobi } catch(Exception ex) { Response.Write(ex.Message); } } }

Home <%@ Page Language="C#" AutoEventWireup="true" CodeFile="HOME.aspx.cs" Inherits="_HOME" %> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> MOBILE ADVISOR 1p5u32 <style type="text/css"> .style1 { width: 100%; } .style2 { width: 409px; text-align: center; } .style3 { width: 266px;

E-Mobi } .style4 { width: 588px; text-align: right; }
sdfa


E-Mobi
HOME
     
   
   


E-Mobi  		  

©business events. All right reserved.

css


E-Mobi

Change name & using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data.SqlClient; public partial class _PWDRES : System.Web.UI.Page { SqlConnection con = new SqlConnection("Data Source=hppc;Initial Catalog=mobile;Integrated Security=True"); protected void Page_Load(object sender, EventArgs e) { } protected void Button2_Click(object sender, EventArgs e) { try { // SqlConnection con = new SqlConnection("Data Source=ups5d40;Initial Catalog=mobile;Integrated Security=True"); SqlCommand cmd = new SqlCommand(); con.Open(); cmd.Connection = con; cmd.CommandText = "update Tb_ set _pwd='"+TextBox7.Text.ToString()+"'where _pwd='"+TextBox3.Text.ToString()+"'"; //cmd.CommandText = "insert into Tb_ values('" + TextBox1.Text.ToString() + "','" + TextBox5.Text.ToString() + "')"; cmd.ExecuteNonQuery(); con.Close(); cmd.Connection = con; Response.Redirect("HOME.aspx"); }

E-Mobi catch(Exception ex) { Response.Write(ex.Message); } } protected void Button1_Click(object sender, EventArgs e) { try { //SqlConnection con = new SqlConnection("Data Source=ups5d40;Initial Catalog=mobile;Integrated Security=True"); SqlCommand cmd = new SqlCommand(); con.Open(); cmd.Connection = con; cmd.CommandText = "update Tb_ set _uname='" + TextBox4.Text.ToString() + "'where _pwd='" + TextBox6.Text.ToString() + "'"; cmd.ExecuteNonQuery(); con.Close(); cmd.Connection = con; Response.Redirect("HOME.aspx"); } catch (Exception ex) { Response.Write(ex.Message); } Response.Redirect("HOME.aspx"); } }

Add New Products using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data;

E-Mobi using System.Data.Sql; using System.Data.SqlClient; public partial class _newpro : System.Web.UI.Page { SqlConnection con = new SqlConnection("Data Source=hppc;Initial Catalog=mobile;Integrated Security=True"); SqlConnection con1 = new SqlConnection("Data Source=hppc;Initial Catalog=mobile;Integrated Security=True"); protected void Page_Load(object sender, EventArgs e) { } protected void TextBox1_TextChanged(object sender, EventArgs e) { } protected void Button1_Click(object sender, EventArgs e) { if(File1.HasFile) { try { /*DataBase connection part start*/ SqlCommand cmd = new SqlCommand(); con.Open(); cmd.Connection = con; /*Database connection */ //sql query string filename = "~//product//"; filename += TextBox30.Text.ToString(); filename += DropDownList1.Text.ToString(); filename += ".jpg"; File1.SaveAs(Server.MapPath(filename)); //executed cmd.CommandText = "insert into Tb_pro values('"+TextBox30.Text.ToString() +"','"+TextBox1.Text.ToString()+"','"+DropDownList1.SelectedItem.Text.ToString() +"','"+TextBox2.Text.ToString()+"','"+TextBox3.Text.ToString()+"','"+TextBox4.Text.ToString()

E-Mobi +"','"+RadioButtonList1.SelectedItem.Text.ToString()+"','"+TextBox5.Text.ToString() +"','"+TextBox6.Text.ToString()+"','"+TextBox7.Text.ToString()+"','"+TextBox8.Text.ToString() +"','"+TextBox9.Text.ToString()+"','"+TextBox10.Text.ToString()+"','"+TextBox11.Text.ToString() +"','"+TextBox12.Text.ToString()+"','"+TextBox13.Text.ToString()+"','"+TextBox14.Text.ToString() +"','"+RadioButtonList2.SelectedItem.Text.ToString()+"','"+TextBox15.Text.ToString() +"','"+TextBox16.Text.ToString()+"','"+TextBox17.Text.ToString()+"','"+TextBox18.Text.ToString() +"','"+TextBox19.Text.ToString()+"','"+TextBox20.Text.ToString()+"','"+TextBox21.Text.ToString() +"','"+TextBox22.Text.ToString()+"','"+TextBox23.Text.ToString()+"','"+TextBox24.Text.ToString() +"','"+TextBox25.Text.ToString()+"','"+TextBox26.Text.ToString() +"','"+RadioButtonList3.SelectedItem.Text.ToString()+"','"+TextBox27.Text.ToString() +"','"+TextBox28.Text.ToString()+"','"+Label1.Text.ToString()+"',@fil,'"+TextBox31.Text.ToString()+"')"; cmd.Parameters.AddWithValue("@fil", filename); //sql query execution cmd.ExecuteNonQuery(); /*DataBase connectio close*/ con.Close(); /*------------------*/ Response.Redirect("HOME.ASPX"); } catch(Exception ex) { Response.Write(ex.Message); } } } protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) { con1.Open(); String getState = "Select brand_web from Tb_brand where brand_name='" + DropDownList1.SelectedItem.Text.ToString() + "'"; DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(getState, con1); da.Fill(dt); if (dt.Rows.Count > 0) { Label1.Text = dt.Rows[0][0].ToString(); } } }

E-Mobi

Add New Brands <%@ Page Language="C#" AutoEventWireup="true" CodeFile="ADDbrand.aspx.cs" Inherits="_ADDbrand" %> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> MOBILE ADVISOR 1p5u32 <style type="text/css"> .style1 { font-family: "Times New Roman", Times, serif; } .style2 { height: 22px; } .style3 { height: 29px; }


E-Mobi sdfa
BRAND NAME
OFFICIAL WEBSITE

©business events. All right reserved.

css


Delete Products & Comments using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data; using System.Data.SqlClient; public partial class _delete : System.Web.UI.Page { SqlConnection con = new SqlConnection("Data Source=hppc;Initial Catalog=mobile;Integrated Security=True"); protected void Page_Load(object sender, EventArgs e) { 1.Visible = false;

E-Mobi 2.Visible = false; } protected void Button1_Click(object sender, EventArgs e) { 1.Visible = true; 2.Visible = false; string g = "select * from Tb_Pro"; SqlDataAdapter sqdt = new SqlDataAdapter(g, con); DataTable dt = new DataTable(); sqdt.Fill(dt); if (dt.Rows.Count > 0) { GridView1.DataSource = dt; GridView1.DataBind(); } } protected void Button2_Click(object sender, EventArgs e) { 1.Visible = false; 2.Visible = true; string g = "select * from Tb_Review"; SqlDataAdapter sqdt = new SqlDataAdapter(g, con); DataTable dt = new DataTable(); sqdt.Fill(dt); if (dt.Rows.Count > 0) { GridView2.DataSource = dt; GridView2.DataBind(); } } protected void GridView1_SelectedIndexChanged(object sender, EventArgs e) { } protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName =="view")

E-Mobi { try { string g = e.CommandArgument.ToString(); con.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandText = "delete Tb_Pro where date='" + g + "'"; cmd.ExecuteNonQuery(); con.Close(); } catch (Exception l) { Response.Write(l.Message); } } } protected void GridView2_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "view") { try { string g = e.CommandArgument.ToString(); con.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandText = "delete Tb_Review where date='" + g + "'"; cmd.ExecuteNonQuery(); con.Close(); } catch (Exception l) { Response.Write(l.Message); } }

E-Mobi } }

Cha p t e r 5

SC R E E N SH O T S

Home Page

E-Mobi

Product Display Page

E-Mobi

Product Comparison Page

E-Mobi

Product Search Page

E-Mobi

Us Page

E-Mobi

PAGE

E-Mobi

Home Page

E-Mobi

name & Reset Page

E-Mobi

Add New Product Page

E-Mobi

Delete Product Page

E-Mobi

Add Brand Page

E-Mobi

Cha p t e r 6

CONC L U SI O N

E-Mobi

The project was successfully completed within the time span allotted. All the modules are tested separately and put together to form the main system. Finally the system is tested with real data and it worked successfully. Thus the system has fulfilled the entire objective defined. The system has been developed in an interactive manner; the reports generated by the system are clear and legible. The system is flexible, friendly and has its own full data security and all the data recovery facility. The system is flexible and changes can be made without any difficulty. Every Step has been taken to make the working of the project comfortable as possible for the s. To conclude easily, we thank all the people who help us to complete this project successfully.

Cha p t e r 7

BI B L I O G R A P H Y

•

Elias M.Awad , " SYSTEM ANALYSIS & DESIGN", Galgotia Publications-Second Edition2005

•

Henry Korth , "DATABASE DESIGN CONCEPT", MCGRAW-HILL-Fifth Edition,2005

•

Roger. S. Pressman , "SOFTWARE ENGINEERING",MCGRAW-HILL-Sixth Edition,2005

CRM

Related Documents 3m3m1z

Mobile Shop Project Report 4t1w2a
December 2019 69
Electronic Shop Project Report 5k3q4q
October 2019 45
Project Report On Mobile Banking 71k26
April 2020 22
Project Report On Mobile Banking 71k26
November 2021 0
Online Mobile Phone Shop A Asp.net Project 5f3a1b
December 2021 0
Mobile Shop Management System 704u6y
November 2019 85

More Documents from "Vishnu Chariyathra A" y3an

Mobile Shop Project Report 4t1w2a
December 2019 69
Frictionless Compressor Technology Presentation 2k413
October 2019 83
Ansys Geotechnical Geology - Finite Element Modeling 562q2u
April 2022 0
Robotics By Ganesh Hegde d5r69
March 2023 0
Dictionary Of All Scriptures And Myths.pdf 34844
October 2022 0
Frictionless Compressor Technology Seminar Report 73qx
December 2019 64

Copyright © 2025 IDOUB.