Recent content by rnooraei

Hi I would like to add double quote around ListBoxColumn.Items(counter).Value which is comming from listbox, I tried to use "\"" but it did not work. Thanks for help For counter = 0 To (ListBoxColumn.Items.Count - 1) If ListBoxColumn.Items(counter).Selected = True Then...

Here is the code Dim SqlMetroDateMin As String = "select top 1 Format(E13A101.TIME, 'yyyy/mm/dd')AS tmin from E13A101 where fmin=(select min(fmin) from E13A101 where month(TIME)= " & ddlMonth.SelectedValue & " and year(TIME)= " & ddlYear.SelectedValue & " ) and month(TIME)= " &...

Hi Is there any way I can capture data from detail line of crystal report(in runtime) and save it to database. Any help is appreciated. Thanks Ramin

Hi This syntax is working with ACCESS database crReport.SetDatabaseLogon("bar_adm", "******") Now I migrated the database to SQL SERVER and the syntax shoulb like crReport.SetDatabaseLogon("bar_adm", "******", "KINGSTON", "BAR_TEST") but I can not log in to database. here is my connection...

Hi Any suggestion for this error message. I got this error message when I did migration from my access database to SQL Server. Thanks Line 3: Incorrect syntax near '?'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace...

Hi I have a small application which has been built with ASP.NET 2.0 and Access database. Now I want to move this application to SQL Server, Should I rebuilt the datasource with SQL Server? I did change the connection string but didn't work for me. any help appreciated. here the sample of my...

Hi Jason, I used ASP.NET 2.O to build my application that why I am not sure I only need to change connection string and reconnect the SqlDataSource to SQL Server .... Thanks

Hi I would like know what will be involved to migrate from Access database to SQL Server database. My application it works based on windows authentication. Any help appreciated Thanks

I have the following formula which is attached to a group. The ELSE part is not working. It supposes to check for CONTACT_ID and if there is no CONTACT_ID, it should show "Not Assigned" but in my case it doesn't show any title for this group. any help appreciated. if not isnull...

Hi Jason, Here is exactly what I have in my VB code. I am also new to ASP.NET so, how could I modify this code base on what you posted for me. you mean I should create a page with ASHX format and not using aspx Thanks Partial Class AppListing Inherits System.Web.UI.Page Protected...

Hi I have this code that open my crystal report. I would like to send it dircet to pdf file not open with crystal report because when I open it in crystal report I get broken link for print, export, ... I tried CRRedist2005_x86.msi and it didn't work. is there any way to do that? Thanks...

The user wants to use this database for creating their own report, so there is no program. I also have another problem which when I created my MDW file seems every database I open it will effected by this new MDW. I should say that I create this file in the different directory. (not existing...

Thanks for you reply

Hi I have created a new System.mdw file using Work group Administrator in different place and call it BAR.mdw. I would like to have only my BAR.MDB connect to this MDW but seems whatever database I open, it will be effected by this file. Any help appreciated

Hi Jason, I asked infrastructure team to implement this package but it didn't work. Do you have any suggestion? Thanks