Storing dataset values in a database

Question

0.00/5 (No votes)

See more:

Hi i have split my dataset values and now i need to store that in database am nt geting idea do Me a favour pls and here is my coding for extracting the dataset

C#

public void spilt()
        {
            ///////// DATA SPILT IN TXT FILE ////////////
            try
            {
                String path = textBox1.Text;
                StreamReader file = new StreamReader(path);
                string myString = file.ReadToEnd();
                string[] words = myString.Split('\n');
                for (int x1 = 0; x1 < words.Length - 1; x1++)
                {
                                        data = words[x1].Split(' ', '\r');
                  
                }

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
              
            }
        }

Posted 9-Jul-13 18:44pm

usha C

Add a Solution

Comments

Sushil Mate 10-Jul-13 0:54am

What's data? string array? how about database, tell us the about table schema?

usha C 10-Jul-13 1:01am

the database table contain of 6 columns...i have splited those datas and now i need to store that in a database

Naz_Firdouse 10-Jul-13 1:06am

what does the data contains in your app???
YOu specified as "DATA SPILT IN TXT FILE " and also mentioned "I have split my dataset values " ...please elaborate your question...

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dheeraj_Gupta · Accepted Answer · 2013-07-09T19:13:00

Could you please explain your requirement? So that we can try to provide you the correct solution.

For while you can achieve your approach by creating a class for your table and store the dataset objects in this this list of this class. manipulate it and then you be able to perform the update command regarding each object in to the table.

Mark as answer if its solved your issue.

usha C · Accepted Answer · 2013-07-09T19:25:00

C#

try
            {
          
                String data1 = data[1];
                String data2 = data[2];
                String data3 = data[3];
                String data4=data[4];
                String data5 = data[5];
                String data6=data[6];
              cmd = new SqlCommand("Insert into Datasetextraction values('" + data1 + "','" + data2 + "','" + data3 + "','" + data4 + "','"+data5+"','"+data6+"')",cn.con);
                cmd.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }

Storing dataset values in a database

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0