How to add a text file into dtatatable column as first column

Question

0.00/5 (No votes)

See more:

Hi,

I have a data table having multiple column which is coming from DB.Now I need to add one column from a text file as the first column.Below format is my text file

ID		
----  
val1      
val3      
val5

below is my table creation code and i am getting data table with DB values .How i can add my txt file as first column

What I have tried:

C#

private static DataTable LoadTable(string connectionString, string query, string tableName)
        {
            using (var connection = new OdbcConnection(connectionString))
            using (var command = new OdbcCommand(query, connection))
            using (var adapter = new OdbcDataAdapter(command))
            {
                command.CommandTimeout = 0;
                var table = new DataTable(tableName);
                adapter.Fill(table);
                return table;
            }
        }

Posted 8-Dec-21 3:14am

Manidas Payyoli

Updated 8-Dec-21 4:11am

PIEBALDconsult

v2

Add a Solution

1 solution

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)

OriginalGriff · Answer 1 · 2021-12-08T04:10:00

Solution 1

Try this:

string strConnect = SMDBSupport.SMInstanceStorage.GetInstanceConnectionString("MyDatabase");
using (SqlConnection con = new SqlConnection(strConnect))
    {
    try
        {
        con.Open();
        using (SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM MyTable", con))
            {
            DataTable dt = new DataTable();
            da.Fill(dt);
            dt.Columns.Add("My New Column", typeof(string)).SetOrdinal(0);
            myDataGridView.DataSource = dt;
            }
        }
    catch (Exception ex)
        {
        Debug.WriteLine(ex.ToString());
        }
    }

You can then set the values of your DT to the text file lines.

Posted 8-Dec-21 4:10am

OriginalGriff

Updated 8-Dec-21 4:11am

v2

Comments

[no name] 8-Dec-21 10:24am

I dont have any data grid view.I am using OLEDB connection.This is not working for me.I have text file out there I need to use that to get the data and to add in to existing DT

OriginalGriff 8-Dec-21 10:53am

So don't use the DGV ... That's just there to show you how I do it ...

[no name] 8-Dec-21 11:38am

how do i access my outside .txt file here?

OriginalGriff 8-Dec-21 11:53am

You are kidding, right?
You are playing with DB's and DT's and you have no idea how to read a *text file*?

[no name] 8-Dec-21 12:55pm

if (tableName == "TestData")
{

var pathC = @"H:\Oneroof\SyntheticData\Claims.txt";

var fileContents = File.ReadAllLines(pathC);

var splitFileContents = (from f in fileContents select f.Split(':')).ToArray();

int maxLength = (from s in splitFileContents select s.Count()).Max();

for (int i = 0; i < maxLength; i++)
{
table.Columns.Add();
}

foreach (var line in splitFileContents)
{
DataRow row = table.NewRow();
row.ItemArray = (object[])line;
table.Rows.Add(row);
}

}

return table;

[no name] 8-Dec-21 12:56pm

honestly i have no idea sir..i am just learning the things now only..i tried above code but not giving result as expected.an extra clmn is adding though