code to fetch data from database and display all records

vikas m

hi,

i have written a code to fetch data from database and display it in a textbox

but the problem is that it displays only the last value

what modification should i do to display all values in the textbox one by one

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

using System.Data.SqlClient;

namespace sample2

{

public partial class Form1 : Form

{

public Form1()

{

InitializeComponent();

db();

}

private void Form1_Load(object sender, EventArgs e)

{

}

public void db()

{

SqlConnection con = new SqlConnection("Data Source=xxxx;Initial Catalog=temp1;Integrated Security=True");

con.Open();

SqlCommand cmd = new SqlCommand("Select * from t1",con);

SqlDataReader reader = cmd.ExecuteReader();

while(reader.Read())

{

textBox1.Text = reader.GetValue(0).ToString();

}

con.Close();

}

private void textBox1_TextChanged(object sender, EventArgs e)

{

}

3 Replies

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

Vulpes12y ago
Accepted answer
Sure, try this (WF assumed);

// add these fields
private List list = new List();
private int index = 0;

public void db()
{
SqlConnection con = new SqlConnection("Data Source=xxxx;Initial Catalog=temp1;Integrated Security=True");
con.Open();
SqlCommand cmd = new SqlCommand("Select * from t1",con);
SqlDataReader reader = cmd.ExecuteReader();

while(reader.Read())
{
list.Add(reader.GetValue(0).ToString()); // now using list field
}

reader.Close();
textBox1.Text = list[0]; // display first one
index = 1;
con.Close();
}

private void button1_Click(object sender, EventArgs e)
{
if (index == list.Count) index = 0; // start again from beginning
textBox1.Text = list[index];
index++;
}
vikas m12y ago
thank you for the help. is it possible for you to give me a code to display each record fetched from database in a textbox upon a button click??? thank you in advance
Vulpes12y ago
Try:

public void db()
{
SqlConnection con = new SqlConnection("Data Source=xxxx;Initial Catalog=temp1;Integrated Security=True");
con.Open();
SqlCommand cmd = new SqlCommand("Select * from t1",con);
SqlDataReader reader = cmd.ExecuteReader();
var list = new List();

while(reader.Read())
{
list.Add(reader.GetValue(0).ToString());
}

reader.Close();
textBox1.Text = String.Join("\r\n", list.ToArray());
con.Close();
}

The textbox's Multiline property also needs to be set to true.