how display all data from a sql command in a textbox/richtex

Question

i have problem in displaying the result from a sql command in my textbox,it only display just a word,but i want to display all of it just like in this picture

Upendra Pratap Shahi · Answer

Put your datatable or dataset value in desired textbox for showing the result in textboxes. Use like this.. SqlConnection Conn = new SqlConnection(Connection_String); SqlCommand Comm1 = new SqlCommand(Command, Conn); Conn.Open(); SqlDataReader DR1 = Comm1.ExecuteReader(); if (DR1.Read()) { textBox.Text = DR1.GetValue( 0 ).ToString(); } Conn.Close(); http://www.codeproject.com/Questions/155444/how-to-display-data-from-sql-database-to-textbox-u http://stackoverflow.com/questions/18454164/how-to-retrieve-date-value-from-database-to-textbox-in-asp-net https://www.daniweb.com/web-development/aspnet/threads/31919/retrieve-information-from-database-display-into-asp-net-web-controls-textbox if this helped kindly accept the answer

Upendra Pratap Shahi · Answer

http://www.dotnetperls.com/richtextbox http://www.codeproject.com/Questions/688524/Displaying-Data-in-Rich-Textbox-Using-Csharp http://sqlmag.com/database-development/store-rtf-data-sql-server-database

Upendra Pratap Shahi · Answer

Use like this-- The String class doesn't implement INotifyPropertyChanged, so there are no events for the binding source to tell the RichTextBox that something changed. Try updating your class with the INotifyPropertyChanged : Code: public class Test : INotifyPropertyChanged { public event PropertyChangedEventHandler PropertyChanged; private string _PropertyText = string.Empty; public string PropertyText { get { return _PropertyText; } set { _PropertyText = value; OnPropertyChanged("PropertyText"); } } private void OnPropertyChanged(string propertyName) { if (PropertyChanged != null) PropertyChanged(this, new PropertyChangedEventArgs(propertyName)); } } Also, it looks like DataBinding doesn't like the name "Property" for a property name. Try changing it to something else other than "Property". rtxt_chatLog.DataBindings.Add("Text", t, "PropertyText");

King Umar · Answer

do you have any other solution sir,because that code kinnda unfamiliar with me

King Umar · Answer

Dim cmd As SqlCommand Dim sSQL As String Dim ds As DataSet 'dataset Dim conn As New SqlConnection conn.ConnectionString = "Data Source=USER-PC;Initial Catalog=MiSInventory;Integrated Security=True" Dim adapter As New SqlDataAdapter Try conn.Open() sSQL = " SELECT Category,COUNT(*) AS NumberOfItem FROM [MiSInventory].[dbo].[AddItem] GROUP BY Category" cmd = New SqlCommand(sSQL, conn) adapter.SelectCommand = cmd ds = New DataSet() ''fill data into dataset adapter.Fill(ds, "AddItem") RichTextBox1.DataBindings.Add("text", ds.Tables("AddItem"), "Category") Catch ex As Exception MessageBox.Show("Could not connect database: " & ex.Message, "Database Connection Error", MessageBoxButtons.OK, MessageBoxIcon.Error) End Try conn.Close() need help,still just a word not all of it

Upendra Pratap Shahi · Answer

Thanks a ton for appreciation and very welcome dear.

King Umar · Answer

thank you sir it help me,you are really a good programmer :)

how display all data from a sql command in a textbox/richtex

Answers (7)