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

King Umar

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

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Upendra Pratap Shahi11y ago
Accepted 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
+1
Upendra Pratap Shahi11y ago
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
+1
King Umar11y ago
do you have any other solution sir,because that code kinnda unfamiliar with me
0
Upendra Pratap Shahi11y ago
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");
+1
King Umar11y ago

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

0
Upendra Pratap Shahi11y ago
Thanks a ton for appreciation and very welcome dear.
0
King Umar11y ago
thank you sir it help me,you are really a good programmer :)
0