Comments by RKeyy Sii (Top 22 by date)

no I can't find for version 14 or 15. I found this link

https://www.nuget.org/packages/Microsoft.Office.Interop.Word/

but it needs to install NuGet first. I don't have permission to install new things in my laptop. And all I can see and download is Version 10.0.4504.0

Maybe you know sites where I can download microsoft.office.interop.word.dll?

Yes. Actually I'm running my application in another server using remote desktop.

Thanks :)

I tried this already, I modified the TestLogin page to match the page that is currently using the master page. And I got an HTTP Error 404 - Not Found. when I run my application.

uc means for user controls right? Do I need to put something for that? I got an error 'Unknown server tag 'uc1:WACHeader'.

It says 'Unrecognized tag prefix or device filter 'uc1', I'm sorry I'm not familiar with this. Can you explain it to me? Thanks

When I double click the cell then move to the next though the single quote will be invisible, so I always need to do that?

@CHill60 I'm sorry, but it's still showing the single quote in the excel

Improved my question

sorry for the late reply haven't been online for a while. I already tried putting a single quote in my code in vb and yes it shows '08-20 in excel but is it possible to hide the ' (single quote) when viewing or displaying in the excel?

like this?

Dim sql As String = ""
sql += " SELECT DISTINCT UserID FROM tblUserInfo WHERE IsActive = @IsActive"

cmd.CommandText = sql

parameter.ParameterName = "@IsActive"
parameter.Value = "1"
cmd.Parameters.Add(parameter)

how about when I put this code in Page_Load

Dim ctrlname As String = Page.Request.Params.Get("__EVENTTARGET")
If ctrlname <> Nothing And ctrlname <> String.Empty Then
If Not ctrlname.ToLower.Contains("dropdownlist") And ViewState.Item("Query") <> Nothing Then
BindGridview(ViewState.Item("Query"), ViewState.Item("CountQuery"))
End If
Else
For Each ctrl As String In Page.Request.Form
Dim c As Control = Page.FindControl(ctrl)

If Not TypeOf (c) Is System.Web.UI.WebControls.Button Then
If ViewState.Item("Query") <> Nothing Then
BindGridview(ViewState.Item("Query"), ViewState.Item("CountQuery"))
End If

Exit For
End If
Next
Exit Sub

End If

When I click for the next page it's working but when I select another from the dropdownlist and click Generate button the girdview on the first page is blank but when I click for the next page it has record and it's working. Do you think what could be the problem?

it's still the same showing the gridview with blank records

yes it has records. when I click generate button it shows the first page with records but when I click for the next page it shows the gridview with blank records and even if I go back again to page one it remains blank. I'm sorry I ask too many question I'm new to this.

@zafar Now it shows the GridView but when I click for the next page all the rows are blank.

But I already DataBind it inside the PageIndexChanging. What could possibly be the problem?

Protected Sub GridView1_PageIndexChanging(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewPageEventArgs) Handles GridView1.PageIndexChanging
GridView1.PageIndex = e.NewPageIndex
Dim dt As DataTable = TryCast(GridView1.DataSource, DataTable)
GridView1.DataSource = SortTable(dt)
GridView1.DataBind()
End Sub

Sorry for the late reply, I haven't been online for the past few days.
I have the gridview's viewstate enabled as false and the gridview will be lost when I click the next page and when I enabled it as true it shows No Record Found. Can you tell me what can I do for this? Thanks.