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 textboxit only display just a wordbut 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 sirbecause 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 CategoryCOUNT(*) 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 helpstill 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 meyou are really a good programmer :)