将字符串拆分并存储到SQL中的数据库中，C#lang [英] split string and store into database in SQL ,c# lang

问题描述

private void button1_Click(object sender, EventArgs e)
        {
		// read listview and write into text file
            StreamWriter sw = new StreamWriter("c:\\temp.txt");
            sw.Flush();
            sw.BaseStream.Seek(0, SeekOrigin.Begin);
            for (int i = 0; i < this.lvwMessages.Items.Count; i++)
            {
                for (int j = 0; j < this.lvwMessages.Items[i].SubItems.Count; j++)
                {
                    string tab = (j == 0) ? string.Empty : ",";
                    sw.Write(tab + lvwMessages.Items[i].SubItems[j].Text);
                }
                sw.WriteLine();
            }
            sw.Flush();
            sw.Close();
            
            //split string
                split();
          
       
        }
        private void split()
        {
           
           StreamReader rd1 = new StreamReader("c:\\temp1.txt");//string is suhas,kumar,8888888888,male.
            string str12 = rd1.ReadLine();
            string[] str1 = str12.Split(',');
           // splitmsg(str1);
            foreach (string part in str1)
          {
               //display array string
                MessageBox.Show(part.ToString());
            
           }
      
        }

--------------------------------------------- ---------------------------
我需要将数组值存储在参数中，以便在SQL查询中访问这些参数.
或任何其他可以在其中插入字符串并插入DB的方法.
我的数据库名称是Auto-> Fname Lname手机性别
====== ===== ===== ======
suhas kumar 888888男性
ravi kumar 555555男性
请帮助我的银子.............

------------------------------------------------------------------------
i need to store array values in parameters so that accessing those parameter in SQL query..

or any other method where i can slip string and insert into DB.
my DB name is Auto--> Fname Lname phone gender
====== ===== ===== ======
suhas kumar 888888 male
ravi kumar 555555 male
plz help me its argent ..........

推荐答案

请帮助我的银子"

我不在乎它是什么银色，这不会使我们想要帮助您.

对于您的问题，您可以将已解析的字符串作为XML数据发送到存储过程，并让sql server处理它.

"plz help me its argent"

I don''t care what shade of silver it is, that''s not going to make us want to help you.

As to your question, you could send the parsed string as XML data to a stored procedure and let sql server handle it.

这篇关于将字符串拆分并存储到SQL中的数据库中，C#lang的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！