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
kevin
NA
1
3.3k
Display database mysql with DataSet to Datagridview C#
Jan 5 2014 8:30 AM
I have a database access class which is contain INSERT,UPDATE,DELETE and READ. My INSERT,UPDATE, and DELETE is success full. Now i am stuck how to read the database item that i have inserted into database table. Here is what i do :
DBConnect.cs (A database class that created in a separated project but in a same solution)
public void Select()
{
#region fields
string sqlQuery;
#endregion
#region SQL Queries
sqlQuery = "SELECT NoNota, Nama, Tanggal, Tipe, Keterangan FROM master";
#endregion
#region execute
if (this.OpenConnection() == true)
{
cmd = new MySqlCommand(sqlQuery, connect);
cmd.ExecuteNonQuery();
CloseConnection();
}
#endregion
}
Here is my form that will consume that Select() function to display a database item. It's a winform named Report.cs (a WinForm that located in another project which is in a same solution)
Report.cs
private void btn_Tampil_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
ds = clsDBConnect.Select();
dgv_report.DataSource = ds;
}
What i got is i can't "convert Type 'void' to dataset". How to do the right way? what i missed here?
Reply
Answers (
1
)
TableLayoutManager
How to create Multi Location Software in c# win application