Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2004-09-21
4
Medium Priority
?
687 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 750 total points
ID: 12130765
then use
string[] lines = yourTextBox.Text.split( new char[]{'\n'} );


hth.A.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

This article is for Object-Oriented Programming (OOP) beginners. An Interface contains declarations of events, indexers, methods and/or properties. Any class which implements the Interface should provide the concrete implementation for each Inter…
This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

972 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