locked
vb.net in visual studio: how to generate a gridview using SQL + session variable RRS feed

  • Question

  • User-1819590134 posted

    How do <g class="gr_ gr_22 gr-alert gr_tiny gr_spell gr_inline_cards gr_run_anim ContextualSpelling multiReplace" id="22" data-gr-id="22">i</g> connect this SQL statement to a <g class="gr_ gr_19 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" id="19" data-gr-id="19">gridview</g>? My database is Microsoft Access.

    Select Posts.[Post_Value], Posts.[Date_Time] FROM
    Posts WHERE posts.[user_ID] = '" & Session("user_id") & "'

    My database connection as a string is this:

    Dim connectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data 
    Source=" & Server.MapPath("database/Database.mdb")

    I know <g class="gr_ gr_31 gr-alert gr_tiny gr_spell gr_inline_cards gr_run_anim ContextualSpelling multiReplace" id="31" data-gr-id="31">i</g> have to open the connection to the database, but what <g class="gr_ gr_32 gr-alert gr_tiny gr_spell gr_inline_cards gr_run_anim ContextualSpelling multiReplace" id="32" data-gr-id="32">i</g> cant figure out is how to fill the <g class="gr_ gr_23 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling" id="23" data-gr-id="23">gridview</g> with the data including the session variable? I also want this to happen on page load.

    I am doing this in windows visual studio, so if you know what <g class="gr_ gr_24 gr-alert gr_tiny gr_spell gr_inline_cards gr_run_anim ContextualSpelling multiReplace" id="24" data-gr-id="24">i</g> need to do on the <g class="gr_ gr_18 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" id="18" data-gr-id="18">html</g> side <g class="gr_ gr_17 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del" id="17" data-gr-id="17">aswell</g> that would be a huge help!

    This is as far as <g class="gr_ gr_25 gr-alert gr_tiny gr_spell gr_inline_cards gr_run_anim ContextualSpelling multiReplace" id="25" data-gr-id="25">i</g> have got with my code, but <g class="gr_ gr_26 gr-alert gr_tiny gr_spell gr_inline_cards gr_run_anim ContextualSpelling multiReplace" id="26" data-gr-id="26">i</g> know its rubbish and may not be anywhere near what <g class="gr_ gr_27 gr-alert gr_tiny gr_spell gr_inline_cards gr_run_anim ContextualSpelling multiReplace" id="27" data-gr-id="27">i</g> need.

    Private Sub Page_Load1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
    
        Dim connectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" 
        & Server.MapPath("database/Database.mdb")
        Dim strSQL As String = "Select Posts.[Post_Value], Posts.[Date_Time] 
        FROM Posts WHERE posts.[user_ID] = '" & Session("user_id") & "'"
        Dim connection As New OleDbConnection(connectionString)
        connection.CreateCommand()
        Dim oledb As OleDbDataReader(connection)
    
    
        Dim dataadapter As New OleDbDataAdapter(strSQL, connection)
        Dim ds As New DataSet()
        connection.Open()
        dataadapter.Fill(ds, "posts")
        connection.Close()
        GridView1.DataSource = ds
        GridView1.DataMember = "posts"
        GridView1.DataBind()
    
    
    End Sub

    In case <g class="gr_ gr_20 gr-alert gr_tiny gr_spell gr_inline_cards gr_run_anim ContextualSpelling multiReplace" id="20" data-gr-id="20">i</g> haven't been clear, what <g class="gr_ gr_21 gr-alert gr_tiny gr_spell gr_inline_cards gr_run_anim ContextualSpelling multiReplace" id="21" data-gr-id="21">i</g> would like to have at the end of this is: - at page load, a <g class="gr_ gr_16 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling" id="16" data-gr-id="16">gridview</g> will appear with all the posts from the user that is signed in to the session.

    Honestly, any pointers would be hugely appreciated!

    Monday, April 16, 2018 2:45 PM

All replies