SQL关联表操作 添加用户再添加产品.docVIP

SQL关联表操作 添加用户再添加产品 using System; using System.Data; using System.Data.SqlClient; namespace EricAssignment { class Program { public static string InputUsername; static void Main(string[] args) { Program p = new Program(); p.StartupMenu(); Console.ReadLine(); } public void StartupMenu() { Program p = new Program(); Console.WriteLine(\t\t******************** Startup Menu *********************); Console.WriteLine(\t\t* 1.Login *); Console.WriteLine(\t\t* 2.Exit Application *); Console.WriteLine(\t\t*******************************************************); Console.Write(Enter your choice:); try { int choice = Convert.ToInt32(Console.ReadLine()); switch (choice) { case 1: p.Login(); break; case 2: Environment.Exit(0); break; default: Console.WriteLine(There have no this choice,please check!); p.StartupMenu(); break; } } catch (Exception e) { Console.WriteLine(There have no this choice,please check!); p.StartupMenu(); } } public void Login() { Console.Write(Enter your username:); string Username = Console.ReadLine(); Console.Write(Enter your password:); string Password = Console.ReadLine(); Program p = new Program(); string sql = select * from Login where Username= + Username + and Password= + Password + ; DataTable dt = p.executequery(sql);