using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.Configuration;
using System.Data.SqlClient;
using System.Data;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
string name = txtName.Text;
int age = Convert.ToInt32(txtage.Text);
double number = Convert.ToDouble(txtNumber.Text);
string sex = Convert.ToString(ddlSex.SelectedItem);
string a = System.Configuration.ConfigurationManager.ConnectionStrings["myconnection"].ToString();
//string connectionstring = WebConfigurationManager.ConnectionStrings["myconnection"].ConnectionString;
SqlConnection con = new SqlConnection(a);
if (con.State != ConnectionState.Open)
con.Open();
string query = "insert into tblPersonalDetails(name,age,sex,number) values('" + name + "','" + age + "','" + sex + "','" + number + "');";
SqlCommand cmd = new SqlCommand(query, con);
int i = cmd.ExecuteNonQuery();
con.Close();
if (i > 0)
{
lblmessage.Text = "success";
}
else
{
lblmessage.Text = "failed";
}
}
protected void btnView_Click(object sender, EventArgs e)
{
string CommandString = "select * from tblPersonalDetails where name = '"+txtName.Text + "';";
string connectionstring = System.Configuration.ConfigurationManager.ConnectionStrings["myconnection"].ToString();
SqlConnection con = new SqlConnection(connectionstring);
if (con.State != ConnectionState.Open)
con.Open();
SqlCommand cmd = new SqlCommand(CommandString, con);
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
DataSet ds = new DataSet();
da.Fill(ds);
grdview.DataSource = ds;
grdview.DataBind();
}
protected bool GetLoginInfo(string Username, string password)
{
bool result = false;
try
{
string CommandString = "SELECT COUNT(id) as total from tblLoginInfo where username = '" + Username + "' and password = '" + password + "';";
string connectionstring = System.Configuration.ConfigurationManager.ConnectionStrings["myconnection"].ToString();
SqlConnection con = new SqlConnection(connectionstring);
if (con.State != ConnectionState.Open)
con.Open();
SqlCommand cmd = new SqlCommand(CommandString, con);
SqlDataReader sdr = cmd.ExecuteReader();
int Total = 0;
while (sdr.Read())
{
Total = Convert.ToInt32(sdr["total"].ToString());
}
con.Close();
if (Total > 0)
result = true;
}
catch { }
return result;
}
}
