get data in gridview from database...

Question

0.00/5 (No votes)

See more:

I have a salary_master table. And I want to fetch those data from database into the datagrid-view when the form loads using dataset.So, how to fetch only required data (i.e some of them but not all) from dataset and also keep the headers of gridview that I have defined as it loads the the columns also from database. below is the code for fetching data into the gridiew. Also which is better : dataset or using data-reader
---------------------------------------------------------------------
code:
---------------------------------------------------------------------

VB

Private Sub Load_Data_Grid()

        Try
            con.Open()
            ss = "SELECT * from salary_master"
            com = New SqlCommand(ss, con)
            da = New SqlDataAdapter(com)
            da.Fill(ds, "salary_master")
            DGV_Salary.DataSource = ds.Tables(0)
            com.ExecuteNonQuery()
        Catch ex As Exception
            MsgBox(ex.Message)
        Finally
            con.Close()
        End Try
     
    End Sub

--------------------------------------------------------------------
and in Load event I have called the above procedure...

Posted 9-Mar-15 7:02am

A94

Updated 9-Mar-15 7:03am

v2

Add a Solution

Comments

CHill60 9-Mar-15 13:13pm

When you say "some of them but not all" do you mean some rows or some columns?

A94 10-Mar-15 3:00am

I mean some columns like id,name,designation,salary..

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)

bojammis · Answer 1 · 2015-03-09T12:10:00

You can create sql parameters that would limit the number of records returned, for example:

Dim con As New SqlConnection(sqlConnectionString)
      Try
          con.Open()
          Dim ss As String = "SELECT * from myTable where id=@id"
          Dim com As New SqlCommand(ss, con)
          Dim da As New SqlDataAdapter(com)


          Dim param As New SqlParameter
          param.SqlDbType = SqlDbType.Int
          param.ParameterName = "@id"
          param.Value = 7200
          da.SelectCommand.Parameters.Add(param)


          Dim ds As New DataSet
          da.Fill(ds, "my_table")
          dg.DataSource = ds.Tables(0)
          com.ExecuteNonQuery()
      Catch ex As Exception
          MsgBox(ex.Message)
      Finally
          con.Close()
      End Try

Look here for further info:

https://msdn.microsoft.com/en-us/library/ms254953(v=vs.110).aspx[^]