public void setCustomerDetails()
{
Console.Write("Hello! Please your Details");
Console.Write("\nEnter your name : ");
Name = Console.ReadLine();
Console.Write("Account Number : ");
AccountNumber = Convert.ToInt64(Console.ReadLine());
Console.Write("Pin : ");
Pin = Convert.ToInt16(Console.ReadLine());
CustomerDetailsList.Add(new CustomerDetails(AccountNumber, Pin, Name));
Console.WriteLine("Your Details Succesfully added ");
}
protected void Page_Load(object sender, EventArgs e)
{
{
//string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
// string constr = "Data Source=omisbi3.niunt.niu.edu;Initial Catalog=Z1781921;Initial Catalog=Z1781921;User ID=z1781921;Password=Bw1243$h11";
string constr = "Data Source=omisbi3.niunt.niu.edu;Initial Catalog=Z1781921;Initial Catalog=Z1781921;User ID=z1781921;Password=Bw1243$h11";
using (SqlConnection con = new SqlConnection(constr))
{
try
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandText = "SELECT Name,Phone,email,PickUpDate,DropDate,CarModel,NoOfDays,Rent FROM CustInfo ";
con.Open();
cmd.Connection = con;
//cmd.Parameters.AddWithValue("@Search", TextBox1.Text);
cmd.ExecuteNonQuery();
DataTable dt = new DataTable();
using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
{
sda.Fill(dt);
CustomerDetailsList.DataSource = dt;
CustomerDetailsList.DataBind();
}
}
}
catch (Exception E)
{
String s = E.Message;
}
finally
{
if (con != null)
{
con.Close();
}
}
}
}
}
