protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.Cookies["Username"] != null)
Txtusername.Text = Response.Cookies["Username"].Value;
Txtusername.Attributes.Add("value", Request.Cookies["Username"].Value);
if (Request.Cookies["password"] != null)
Txtpassword.Attributes.Add("value", Request.Cookies["password"].Value);
if ((Request.Cookies["username"] != null) && (Request.Cookies["password"] != null))
Chkrember.Checked = true;
}
}
protected void Btnsubmit_Click(object sender, EventArgs e)
{
if ((this.Chkrember.Checked))
{
if ((Request.Browser.Cookies))
{
Response.Cookies["username"].Value = Txtusername.Text;
Response.Cookies["username"].Expires = DateTime.Now.AddYears(20);
Response.Cookies["password"].Value = Txtpassword.Text;
Response.Cookies["password"].Expires = DateTime.Now.AddYears(20);
}
else
{
Response.Cookies["username"].Expires = DateTime.Now.AddYears(-20);
Response.Cookies["password"].Expires = DateTime.Now.AddYears(-20);
} }
}
How can I bind to a
DataSet?
DataSet ds =
GetDataSet();
DataView view = ds.Tables[0].DefaultView;
SmoothLineChart chart = new
SmoothLineChart();
chart.Legend = "Value 1";
chart.
DataSource = view;
chart.
DataXValueField = "Description";
chart.
DataYValueField = "Value1";
chart.
DataBind();
ChartControl1.Charts.Add(chart);
ChartControl1.
RedrawChart();
protected void Page_Load(object sender,
EventArgs e)
{
if (!Page.
IsPostBack)
{
LoadChartData();
}
}
private void
LoadChartData()
{
string
constr = @"Server=
TestServer; Database=
SampleDatabase;
uid=
sa;
pwd=123;";
string query = "SELECT c.
CategoryID, c.
CategoryName, " +
" Count(p.
UnitPrice) AS '
TotalProducts' " +
" FROM Categories c " +
" INNER JOIN Products p ON c.
CategoryID = p.
CategoryID " +
" GROUP BY c.
CategoryID, c.
CategoryName";
SqlDataAdapter da = new
SqlDataAdapter(query,
constr);
DataTable table = new
DataTable();
da.Fill(table);
DataView dv = table.
DefaultView;
Chart1.Series["Series1"].Points.DataBindXY(dv, "
CategoryName",
dv, "
TotalProducts");
Chart2.Series["Series1"].Points.DataBindXY(dv, "
CategoryName",
dv, "
TotalProducts");
}
Drop Down List in Multiple Selected Items
For example if u select in country and it will come state and city
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;
using System.Configuration;
public partial class _Default : System.Web.UI.Page
{
//Class1 obj = new Class1();
private string
strconnection = "Data Source=
NCORE-8;Initial Catalog=
dropdown;Trusted_Connection=true;Integrated Security=True ";
protected void Page_Load(object sender,
EventArgs e)
{
if (!
IsPostBack)
{
BindCountryDropdown();
}
}
protected void
BindCountryDropdown()
{
SqlConnection con = new
SqlConnection(
strconnection);
con.Open();
SqlCommand cmd = new
SqlCommand("select * from Country", con);
SqlDataAdapter da = new
SqlDataAdapter(
cmd);
DataSet ds = new
DataSet();
da.Fill(
ds);
con.Close();
ddlCountry.
DataSource =
ds;
ddlCountry.
DataTextField = "
CountryName";
ddlCountry.
DataValueField = "
CountryID";
ddlCountry.
DataBind();
ddlCountry.Items.Insert(0, new
ListItem("--Select--", "0"));
ddlState.Items.Insert(0, new
ListItem("--Select--", "0"));
ddlCity.Items.Insert(0, new
ListItem("--Select--", "0"));
}
protected void
ddlCountry_
SelectedIndexChanged(object sender,
EventArgs e)
{
int
CountryID = Convert.ToInt32(ddlCountry.SelectedValue);
SqlConnection con = new
SqlConnection(
strconnection);
con.Open();
SqlCommand cmd = new
SqlCommand("select * from State where
CountryID=" +
CountryID, con);
SqlDataAdapter da = new
SqlDataAdapter(
cmd);
DataSet ds = new
DataSet();
da.Fill(
ds);
con.Close();
ddlState.
DataSource =
ds;
ddlState.
DataTextField = "
StateName";
ddlState.
DataValueField = "
StateID";
ddlState.
DataBind();
ddlState.Items.Insert(0, new
ListItem("--Select--", "0"));
if (
ddlState.
SelectedValue == "0")
{
ddlCity.Items.Clear();
ddlCity.Items.Insert(0, new
ListItem("--Select--", "0"));
}
}
protected void
ddlState_
SelectedIndexChanged(object sender,
EventArgs e)
{
int
StateID = Convert.ToInt32(ddlState.SelectedValue);
SqlConnection con = new
SqlConnection(
strconnection);
con.Open();
SqlCommand cmd = new
SqlCommand("select * from City where
StateID=" +
StateID, con);
SqlDataAdapter da = new
SqlDataAdapter(
cmd);
DataSet ds = new
DataSet();
da.Fill(
ds);
con.Close();
ddlCity.
DataSource =
ds;
ddlCity.
DataTextField = "
CityName";
ddlCity.
DataValueField = "
CityID";
ddlCity.
DataBind();
ddlCity.Items.Insert(0, new
ListItem("--Select--", "0"));
}
}
Webconfig
App code
using System;
using System.Collections.Generic;
using System.
Linq;
using System.Web;
using System.
Configuration;
///
/// Summary description for Class1
/// public class Class1
{
public string
CountryName,
StateName,
CityName , cs;
public int
CountryId,
StateID,
CityID;
public Class1()
{
cs = System.Configuration.ConfigurationManager.AppSettings["Connection"].
ToString();
}
}
