How to display database table ?

Question

0.00/5 (No votes)

See more:

I have created table, but How can i display database table in Windows Form ?

C#

SqlConnection sqlconn = new SqlConnection("Data Source=AAN-PC;Initial Catalog=friday;Integrated Security=True");
                        SqlDataAdapter sa = new SqlDataAdapter();

                        string query = "insert into Table_1(SensorID,SensorValue,Time) values(@AB, @SV, @TM)";
                        sa.InsertCommand = new SqlCommand(query, sqlconn);

                        sa.InsertCommand.Parameters.AddWithValue("@AB", id);
                        sa.InsertCommand.Parameters.AddWithValue("@SV", hexValue);
                        sa.InsertCommand.Parameters.AddWithValue("@TM", DateTime.Now.ToString("HH:mm:ss"));

Posted 17-Jan-13 18:53pm

ontheline89

Updated 17-Jan-13 19:13pm

sisir patro

v2

Add a Solution

Comments

Sumit_Kumar_Sinha 18-Jan-13 0:57am

Hey...........You want to fetch the data from database and Display in Winform........or You want to insert winform data in database..............because above code you wrote for data insertation...

ontheline89 18-Jan-13 0:59am

i need to fetch data and display it in winforms. But i am getting how to display it. Display need to be updated automatically.

Sumit_Kumar_Sinha 18-Jan-13 1:02am

actually i am not working on winform...............if u need code for web form then i will provide you................you can make changes according to your requirement

ontheline89 18-Jan-13 1:03am

thank you , i will try to make changes in your web form code.

Jephunneh Malazarte 18-Jan-13 1:03am

so your saying you want to fetch all database table and you don't know how? if that is yes then try:

select * from information_schema.tables

Sumit_Kumar_Sinha 18-Jan-13 1:07am

public void LoadGridData() // Bind GridView Data
{
SqlCommand cmd = new SqlCommand("select * from Emp_tabl1 ", con);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();

}

ontheline89 18-Jan-13 1:08am

Thank you so much.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

sisir patro · Accepted Answer · 2013-01-17T19:20:00

Solution 1

HI,

Check out the following link to display the table in windows form:
Adding Tables and Columns to the Windows Forms DataGrid Control
Table in c# windows form app
http://bytes.com/topic/c-sharp/answers/940680-display-google-map-windows-form[^]

How to refresh the datagrid:
Refreshing the grid for updated data

Thanks

Posted 17-Jan-13 19:20pm

sisir patro

Updated 17-Jan-13 19:34pm

v2

Comments

ontheline89 18-Jan-13 1:25am

Data grid is displaying data from database but how can i automatically update a datagrid as new data goes to database.

[no name] 18-Jan-13 1:32am

Use the following code to refresh your grid.

Add public Refresh method in FormA.

public void RefreshDataGrid()
{
//Do refresh
}

Parse the instance of FormA to FormB when constructing FormB. You have to create FormB contructor to take FormA instance.

private FormA myFormA;
public FormB(FormA formA)
{
myFormA = formA;
}

Now you can call FormA.ResfreshGrid() method from FormB.

myFormA.RefreshGrid();

Thanks

ontheline89 18-Jan-13 1:44am

ok thank you so much.
I am trying it now.

[no name] 18-Jan-13 1:51am

Sure dear... Any issues plz do add a comment...

ontheline89 18-Jan-13 1:55am

My form 2 is not opening.
The idea which i get from you that, making form 2 and placing a button there, when a user press button it will update datagrid in form 1.

ontheline89 18-Jan-13 1:56am

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace WindowsFormsApplication2
{
public partial class Form2 : Form
{
public Form2()
{
InitializeComponent();
}

private void Form2_Load(object sender, EventArgs e)
{

}

private Form1 myForm1;
public Form2(Form1 form1)
{
myForm1 = form1;

myForm1.Refreshdatagridview1();

}

}
}

[no name] 18-Jan-13 2:14am

Keep this method "myForm1.Refreshdatagridview1();" in form1 page load in postback and try. No need to create another form here.

ontheline89 26-Jan-13 0:42am

Sisir Patro, is there any other way to refresh Datagrid automatically ?

[no name] 26-Jan-13 0:53am

Actually I have more knowledge about the C# application in form application I don't have much knowledge. In C# we can able to do so in many ways... Using jquery its too easy. but in foem application I hv a little knowledge... Sorry bro...

ontheline89 26-Jan-13 1:01am

Thanks for your reply.
You are so helpful thanks again.

[no name] 26-Jan-13 1:08am

yours welcome dear...