Solved

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

Posted on 2004-09-21
4
676 Views
Last Modified: 2011-10-03
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
0
Comment
Question by:kvnsdr
  • 2
  • 2
4 Comments
 
LVL 11

Expert Comment

by:Agarici
ID: 12120479
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
 
LVL 1

Author Comment

by:kvnsdr
ID: 12123769
I receive the following compile error: cannot convert type string to char

The following code is underlined.....

{Environment.NewLine} );
               
0
 
LVL 1

Author Comment

by:kvnsdr
ID: 12123877
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
 
LVL 11

Accepted Solution

by:
Agarici earned 250 total points
ID: 12130765
then use
string[] lines = yourTextBox.Text.split( new char[]{'\n'} );


hth.A.
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Article by: Najam
Having new technologies does not mean they will completely replace old components.  Recently I had to create WCF that will be called by VB6 component.  Here I will describe what steps one should follow while doing so, please feel free to post any qu…
Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question