C#: Parse textBox1.text into SQL datatable then reverse the procedure later......????

I need to parse the contents of a textbox into a SQL datatable then at a later time parse the SQL table back into the textbox. The textbox contents look like the following. It is very similar to a hosts file in content and structure. The data contents are seperated by a 'tab' and lines seperated by 'newline' or linefeed.....

127.0.0.1        MyComputer
129.0.1.8        Server
LVL 1
kvnsdrAsked:
Who is Participating?
 
AgariciConnect With a Mentor Commented:
then use
string[] lines = yourTextBox.Text.split( new char[]{'\n'} );


hth.A.
0
 
AgariciCommented:
sqlconnection c = new sqlconnection(...);
sqlcommand cmd = new sqlcommand();
c.Open();
cmd.Connection = c;

string[] lines = yourTextBox.Text.split( new char[]{Environement.NewLine} );
foreach( string line in lines )
{
 string[] lineParts = line.split(new char[]{'\t'} );
 // now use lineParts[0] - ip addr and lineParts[1] - computer name to insert/update the sql datatable
 cmd.CommandText = string.Format("Insert into computers( IP, NAME ) values ( '{0}', '{1}' ) ", lineparts[0],lineparts[1);
 cmd.executenonquery()
}



A.
0
 
kvnsdrAuthor Commented:
I receive the following compile error: cannot convert type string to char

The following code is underlined.....

{Environment.NewLine} );
               
0
 
kvnsdrAuthor Commented:
I also use the following 'hand-coded' SQL connection syntax:

string SQL = " SELECT * FROM tbl_Ports ";
SqlConnection cn = new SqlConnection("integrated security=SSPI;data source=office; persist security info=False;initial catalog=master ");
SqlDataAdapter da = new SqlDataAdapter(SQL,cn);
da.SelectCommand.ExecuteNonQuery();
cn.Close();
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.