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
Ajay Kadian
NA
122
31.8k
Randomly access data from database
Mar 18 2014 11:40 AM
I want access data randomly and i have write the code when i click the button then data is displayed but i want when i again click the button then the next row data is displayed.
could you please tell i am stuck here past 15 days.please
And when click to a particular button which display the option match with database to a 6 column of a every row if its is correct then backcolor of button is green else red.
thank you in advance.
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.OleDb;
namespace WindowsFormsApplication3
{
public partial class Form1 : Form
{
public DataSet ds;
public OleDbDataAdapter adp;
OleDbConnection cn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=E:\\C#\\Database1.accdb");
public Form1()
{
InitializeComponent();
}
private void button5_Click(object sender, EventArgs e)
{
cn.Open();
OleDbDataReader odr;
OleDbCommand cmd = new OleDbCommand("select * from QUESTION where[Type]=@en", cn);
cmd.Parameters.AddWithValue("@en", textBox3.Text);
odr = cmd.ExecuteReader();
odr.Read();
if (odr.HasRows)
{
textBox2.Text = odr[0].ToString();
textBox1.Text = odr[1].ToString();
button1.Text = odr[2].ToString();
button2.Text = odr[3].ToString();
button3.Text = odr[4].ToString();
button4.Text = odr[5].ToString();
}
else
{
MessageBox.Show("HEhehehehehe");
}
cn.Close();
}
}
}
Reply
Answers (
29
)
App close
Use Array Unleash a Number