如何将列表值存储到数据库（SqlServer） [英] How to Store List values into databse(SqlServer)

问题描述

在CustomerDto我写了这些代码

  public  CustomerDTO（）
 {} 
 
  public   string 名称
 {
  get ; 
  set ; 
} 
  public   string 性别
 {
 < span class =code-keyword> get ; 
  set ; 
} 
  public   string 年龄
 {
 < span class =code-keyword> get ; 
  set ;按钮点击活动
} 
} 

列表<   CustomerDTO  >  GetCustomerInfo =新列表<   CustomerDTO  > （）; 
 GetCustomerInfo = GetCustomerDetail（2）; 
 CustomerOrder customerOrder = new CustomerOrder（）; 
 customerOrder.From =; 
 customerOrder.To =; 
 SaveCustomerDetails（GetCustomerInfo，txtEmail.Text，txtMobile.Text，customerOrder）; 
} 

GetcustomerDetails（）方法中的
我是这样写的

 私人列表< CustomerDTO> GetCustomerDetail（ int  SeatCount）
 {
 List< CustomerDTO> GetCustomers =  new 列表< CustomerDTO>（）; 
  for （ int  i =  1 ; i <  = SeatCount; i ++）
 {
 CustomerDTO EachCustomerDTO =  new  CustomerDTO（）; 
  if （i ==  1 ）
 {
 EachCustomerDTO。 Name = txtName1.Text; 
  if （rblGender1.SelectedIndex ==  0 ）
 EachCustomerDTO.Gender = < span class =code-string> 男性; 
  else  
 EachCustomerDTO.Gender =  女性; 
 EachCustomerDTO.Age = txtAge1.Text; 
} 
  else   if （i ==  2 ）
 {
 EachCustomerDTO.Name = txtName2.Text; 
  if （rblGender2.SelectedIndex ==  0 ）
 EachCustomerDTO.Gender = < span class =code-string> 男性; 
  else  
 EachCustomerDTO.Gender =  女性; 
 EachCustomerDTO.Age = txtAge2.Text; 
} 
  else   if （i ==  3 ）
 {
 EachCustomerDTO.Name = txtName3.Text; 
  if （rblGender3.SelectedIndex ==  0 ）
 EachCustomerDTO.Gender = < span class =code-string> 男性; 
  else  
 EachCustomerDTO.Gender =  女性; 
 EachCustomerDTO.Age = txtAge3.Text; 
} 
  else   if （i ==  4 ）
 {
 EachCustomerDTO.Name = txtName4.Text; 
  if （rblGender4.SelectedIndex ==  0 ）
 EachCustomerDTO.Gender = < span class =code-string> 男性; 
  else  
 EachCustomerDTO.Gender =  女性; 
 EachCustomerDTO.Age = txtAge4.Text; 
} 
  else   if （i ==  5 ）
 {
 EachCustomerDTO.Name = txtName5.Text; 
  if （rblGender5.SelectedIndex ==  0 ）
 EachCustomerDTO.Gender = < span class =code-string> 男性; 
  else  
 EachCustomerDTO.Gender =  女性; 
 EachCustomerDTO.Age = txtAge5.Text; 
} 
  else   if （i ==  6 ）
 {
 EachCustomerDTO.Name = txtName6.Text; 
  if （rblGender6.SelectedIndex ==  0 ）
 EachCustomerDTO.Gender = < span class =code-string> 男性; 
  else  
 EachCustomerDTO.Gender =  女性; 
 EachCustomerDTO.Age = txtAge6.Text; 
} 
 GetCustomers.Add（EachCustomerDTO）; 
} 
  return  GetCustomers; 
} 

我在这样写的SaveCustomerDetails方法中的

  private   void  SaveCustomerDetails（List< CustomerDTO> CoustomerDetails， string  EmailId， string  Mobile，CustomerOrder CustomerOrderDetail）
 {
  try  
 {
 
 
  string  connStr = System.Configuration.ConfigurationManager.ConnectionStrings [ < span class =code-string> myConnectionString]。ConnectionString; 
 SqlConnection con =  new  SqlConnection（connStr）; 
 con.Open（）; 
 SqlCommand cmd =  new  SqlCommand（）; 
 cmd.Connection = con; 
 cmd.CommandType = CommandType.StoredProcedure; 
 cmd.CommandText =   SaveCustomerRegistration; 
 cmd.Parameters.Add（  @ Email，EmailId）; 
 cmd.Parameters.Add（  @ Mobile，Mobile）; 
  object  objTab = cmd.ExecuteScalar（）; 
  for （ int  i =  0 ; i < ; i ++）
 {
 
} 
 
 
 con 。关（）; 
} 
  catch （例外情况）
 {
 
} 
 最后 
 {
 
} 
 

你可以建议我如何编写保存数据库的代码



提前感谢

解决方案

< blockquote>

 List< String> list =  new  List< String>（）{  A ，  B，  C}; 
 使用（ var  con =  new  SqlConnection（connectionString））
 {
 con.Open（）; 
 使用（ var  cmd =  new  SqlCommand（  INSERT INTO TABLE（Column）VALUES（@Column），con））
 {
 cmd.Parameters.Add（  @ Column，SqlDbType.VarChar ）; 
  foreach （ var   value  在列表中）
 {
 cmd.Parameters [  @ Column]。值=  value ; 
  int  rowsAffected = cmd.ExecuteNonQuery（）; 
} 
} 
} 

in CustomerDto i have written these code

public CustomerDTO()
        {}

        public string Name
        {
            get;
            set;
        }
        public string Gender
        {
            get;
            set;
        }
        public string Age
        {
            get;
            set;
        }
    }

in button click event

List<CustomerDTO> GetCustomerInfo = new List<CustomerDTO>();
            GetCustomerInfo = GetCustomerDetail(2);
 CustomerOrder customerOrder = new CustomerOrder();
            customerOrder.From = "";
            customerOrder.To = "";
SaveCustomerDetails(GetCustomerInfo, txtEmail.Text, txtMobile.Text, customerOrder);
        }

in GetcustomerDetails() method i written like this

private List<CustomerDTO> GetCustomerDetail(int SeatCount)
        {
            List<CustomerDTO> GetCustomers = new List<CustomerDTO>();
            for (int i = 1; i <= SeatCount; i++)
            {
                CustomerDTO EachCustomerDTO = new CustomerDTO();
                if (i == 1)
                {
                    EachCustomerDTO.Name = txtName1.Text;
                    if (rblGender1.SelectedIndex == 0)
                        EachCustomerDTO.Gender = "Male";
                    else
                        EachCustomerDTO.Gender = "FeMale";
                    EachCustomerDTO.Age = txtAge1.Text;
                }
                else if (i == 2)
                {
                    EachCustomerDTO.Name = txtName2.Text;
                    if (rblGender2.SelectedIndex == 0)
                        EachCustomerDTO.Gender = "Male";
                    else
                        EachCustomerDTO.Gender = "FeMale";
                    EachCustomerDTO.Age = txtAge2.Text;
                }
                else if (i == 3)
                {
                    EachCustomerDTO.Name = txtName3.Text;
                    if (rblGender3.SelectedIndex == 0)
                        EachCustomerDTO.Gender = "Male";
                    else
                        EachCustomerDTO.Gender = "FeMale";
                    EachCustomerDTO.Age = txtAge3.Text;
                }
                else if (i == 4)
                {
                    EachCustomerDTO.Name = txtName4.Text;
                    if (rblGender4.SelectedIndex == 0)
                        EachCustomerDTO.Gender = "Male";
                    else
                        EachCustomerDTO.Gender = "FeMale";
                    EachCustomerDTO.Age = txtAge4.Text;
                }
                else if (i == 5)
                {
                    EachCustomerDTO.Name = txtName5.Text;
                    if (rblGender5.SelectedIndex == 0)
                        EachCustomerDTO.Gender = "Male";
                    else
                        EachCustomerDTO.Gender = "FeMale";
                    EachCustomerDTO.Age = txtAge5.Text;
                }
                else if (i == 6)
                {
                    EachCustomerDTO.Name = txtName6.Text;
                    if (rblGender6.SelectedIndex == 0)
                        EachCustomerDTO.Gender = "Male";
                    else
                        EachCustomerDTO.Gender = "FeMale";
                    EachCustomerDTO.Age = txtAge6.Text;
                }
                GetCustomers.Add(EachCustomerDTO);
            }
            return GetCustomers;
        }  

in SaveCustomerDetails method i written like this

private void SaveCustomerDetails(List<CustomerDTO> CoustomerDetails, string EmailId, string Mobile, CustomerOrder CustomerOrderDetail)
       {
           try
           {


               string connStr = System.Configuration.ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString;
               SqlConnection con = new SqlConnection(connStr);
               con.Open();
               SqlCommand cmd = new SqlCommand();
               cmd.Connection = con;
               cmd.CommandType = CommandType.StoredProcedure;
               cmd.CommandText = "SaveCustomerRegistration";
               cmd.Parameters.Add("@Email", EmailId);
               cmd.Parameters.Add("@Mobile", Mobile);
               object objTab =  cmd.ExecuteScalar();
               for (int i = 0; i < ; i++)
               {

               }


               con.Close();
           }
           catch (Exception ex)
           {

           }
           finally
           {

           }

can u suggest me how can i write the code for saving the database

thanks in advance

解决方案

List<String> list = new List<String>() { "A", "B", "C" };
using (var con = new SqlConnection(connectionString))
{
    con.Open();
    using (var cmd = new SqlCommand("INSERT INTO TABLE(Column)VALUES(@Column)", con))
    {
        cmd.Parameters.Add("@Column", SqlDbType.VarChar);
        foreach (var value in list)
        {
            cmd.Parameters["@Column"].Value = value;
            int rowsAffected = cmd.ExecuteNonQuery();
        }
    }
}

这篇关于如何将列表值存储到数据库（SqlServer）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！