TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Disun Olowofoyeku
NA
1
1.9k
how to save the content (text and picture) of a richtextbox to a datatable and retrieve content from database?
Jul 11 2012 10:54 PM
Hello, I'm kinda new to C# and programming in general and this is the first database application that I'm working on. What I want to do is actually quite simple but I'm having a lot of trouble finding source code on it. I want to save the content (text and picture) of a rich text box to a datatable and I also want to be able to retrieve content I've saved into the database from it. These are two different codes that I tried (both for inserting) but there's no way I can be sure the first one worked and the second gives an exception...can someone help me out please? Your help would be greatly appreciated.
//Code to add from a textbox into a table. In this case, categories. Category spelt as Categorie intentional
public void AddCategorie()
{
//ConnectMe = new SqlConnection(connectionstring);
//ConnectMe.Open();
//CategorylistBox.BeginUpdate();
//string C = "INSERT INTO CategoryTable (Category) VALUES ('" + CategorytextBox.Text.Replace("'", "") + "')"; //The replace method will replace any single quotation (') the user types with nothing, so "doesn't" will be "doesnt" so it won't affect our INSERT statement
//MyCommand = new SqlCommand(C, ConnectMe);
//MyCommand.ExecuteNonQuery();
//this.categoryTableTableAdapter1.Fill(this.ktDatabaseDataSet1.CategoryTable);
//this.Refresh();
//CategorylistBox.SelectedIndex = CategorylistBox.Items.Count - 1;
//CategorylistBox.EndUpdate();
//ConnectMe.Close();
SqlConnection myConnection = new SqlConnection(connectionstring);
myConnection.Open();
CategorylistBox.BeginUpdate();
SqlCommand myCommand = myConnection.CreateCommand();
MyCommand.CommandText = "INSERT INTO CategoryTable (Category) VALUES ('" + CategorytextBox.Text.Replace("'", "") + "')";
MyCommand.CommandType = CommandType.Text;
SqlDataReader myDataReader;
myDataReader = myCommand.ExecuteReader();
while (myDataReader.Read())
{
NoterichTextBox.Text = (myDataReader[1].ToString());
}
CategorylistBox.EndUpdate();
myConnection.Close();
}
Reply
Answers (
0
)
PDF form fields
How to select only one radio button based on gridview row selection using c#.net