ASP.NET Discussion Boards

How to compare the values of a particular column in an excel sheet

Member 1184147115-Jul-15 23:57

15-Jul-15 23:57

I want to upload only the details of students belonging to my department, the file is in excel format which contains many columns of which one column is the department column. Now, i have to obtain the column values for each student and compare with that of my department and only, if it matches, it has to upload.

Re: How to compare the values of a particular column in an excel sheet

Richard MacCutchan16-Jul-15 0:14

Richard MacCutchan

16-Jul-15 0:14

Very interesting; and what is your question?

thirdparty cookies

SantoshKuamr15-Jul-15 22:32

SantoshKuamr

15-Jul-15 22:32

Hi Friends ,

iam using one iframe in my application. In that iframe iam Display another web application in that have registration form with captcha , when our submit the Registration its working in chrome and mozilla but its Not Working in IE because of third party cookies are Disable by Default. how can i enable third party cookies using code.

Re: thirdparty cookies

Wombaticus15-Jul-15 23:11

Wombaticus

15-Jul-15 23:11

You can't - it's a setting made by the user

Re: thirdparty cookies

SantoshKuamr16-Jul-15 0:18

SantoshKuamr

16-Jul-15 0:18

Thankyou for replay. any other way can we add webpage in out application.

Re: thirdparty cookies

F-ES Sitecore16-Jul-15 0:17

F-ES Sitecore

16-Jul-15 0:17

What use would security features be if you could simply disable then via your code? The fact that you are showing a different site in yours via an iframe and you're having captcha problems makes me think that whatever you are doing probably isn't ethical anyway.

Re: thirdparty cookies

SantoshKuamr16-Jul-15 0:27

SantoshKuamr

16-Jul-15 0:27

Thank You for Your Replay ,

yes, but i want captcha in my Registration Page, how can i sue the captcha with out using cookies?

Re: thirdparty cookies

Richard MacCutchan16-Jul-15 1:47

Richard MacCutchan

16-Jul-15 1:47

You need to add information on the page to tell the user to enable cookies for your website. If they do not do it they cannot register. But as with all of these issues the user owns the computer, and so retains the right to allow or disallow what other applications can do.

Re: thirdparty cookies

The Tigerman20-Jul-15 10:31

The Tigerman

20-Jul-15 10:31

Why not write your own captcha, that way you are not invoking third party code and cookies...

how to insert data in table with foreign key

Praveen Kandari15-Jul-15 19:22

Praveen Kandari

15-Jul-15 19:22

how to insert data into table with foreign key using the max id of primary key table.

using asp.net VS2013, DB-Ms-Access.

getting following error when i try to insert data using "select max(id) from table 1"

Re: how to insert data in table with foreign key

User 418025417-Jul-15 9:35

User 4180254

17-Jul-15 9:35

What error you are getting here?

modified 20-Sep-20 21:01pm.

Gridview

simanungkalit14-Jul-15 22:35

simanungkalit

14-Jul-15 22:35

hi all,

how to make in gridview like bellow question :
https://forums.asp.net/t/2059612.aspx?Gridview[^]

somebody help me

thanks

Re: Gridview

Richard MacCutchan15-Jul-15 1:50

Richard MacCutchan

15-Jul-15 1:50

See http://www.codeproject.com/search.aspx?q=gridview+asp.net&doctypeid=1[^].

Re: Gridview

User 418025415-Jul-15 11:37

User 4180254

15-Jul-15 11:37

Is your question about gridview formatting?

modified 20-Sep-20 21:01pm.

Entity Design for web service

whizkidgps14-Jul-15 15:33

whizkidgps

14-Jul-15 15:33

My client will be sending the request as described below in SOAP format.

XML

<RequestTimestamp>2014-08-22T11:28:00Z</RequestTimestamp>
<SystemID>TestProcessor</SystemID>
<Version>1<Version>
<QWID>201507080000001</QWID>
<QWID>201507080000010</QWID>
<QWID>201507080000001</QWID>
<QWID>201507080000010</QWID>
<QWID>201507080000001</QWID>
<QWID>201507080000010</QWID>
<CHL>201507080000010</CHL>

In every request, QWID should come as batch and I proposed below entity design to adopt above data.

public class APIRequest
{

    [DataMember]
    public DateTime RequestTimestamp;

    [DataMember]
    public string SystemID;

    [DataMember]
    public int Version;

    [DataMember]
    public string[] QWID;

    [DataMember]
    public string CHL;
    
}

With above entity design, SOAP request generated as

XML

<request xmlns:a="http://schemas.datacontract.org/2004/07/QWID.Services" xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
  <a:RequestTimestamp>0001-01-01T00:00:00</a:RequestTimestamp>
  <a:SystemID>WireSystem_001</a:SystemID>
  <a:Version>0</a:Version>
  <a:QWID xmlns:b="http://schemas.microsoft.com/2003/10/Serialization/Arrays">

    <b:string>20141023010232_ORG99000002_CTR.fedwire</b:string>

    <b:string>20141023010842_ORG99000001_CTR.fedwire</b:string>
  </a:QWID>
</request>

XML

My client expecting the SOAP request in the form of <QWID>201507080000001</QWID> instead of coming under <QWID><b:string>20141023010232_ORG99000002_CTR.fedwire</b:string> </QWID> as string tag.

How do i do the entity design (without grouping of QWID) to achieve client expectation as described above? Please help me on this?

modified 14-Jul-15 21:54pm.

oAuth Custom Service with MVC

slSoftware13-Jul-15 7:18

slSoftware

13-Jul-15 7:18

Hi All.

In my e-commerce web application, im using one of finance application to transfer invoices, therefore i have to use there o Auth api service and Authenticate from them. Can you please share some sample for create custom oAuth service which will open as Pop-up and asking the credentials...etc. Same time i need retrieve the token from them.

Thanks

Re: oAuth Custom Service with MVC

Wendelius13-Jul-15 7:28

Wendelius

13-Jul-15 7:28

Do not cross-post questions. You have already asked this at Custome oAuth Service[^] so stick to one question and be ready to provide more input if needed.

RDLC Report in Asp.Net

Zeyad Jalil11-Jul-15 23:52

Zeyad Jalil

11-Jul-15 23:52

Hi All,

I used the rdlc report in my Web form application c#, and in the development environment every thing work fine, but when publish the Application Over the IIS the report viewer didn't show any thing and an error occurred.
"System.NotSupportedException: The given path's format is not supported."

Please let me know how to solve this issue.

Thanks All

Re: RDLC Report in Asp.Net

Wendelius12-Jul-15 0:01

Wendelius

12-Jul-15 0:01

Without seeing the actual code etc it's quite hard to say why the problem occurs but the problem is that the path given is not valid.

So (re)check:
- That the path is a real path.
- If drive is defined in the path, check that semicolon ( : ) is the second character.
- No extra characters anywhere in the path definition.

I believe it would be a good idea to write the path into a log file so you can see what path is actually used on the IIS server.

Re: RDLC Report in Asp.Net

Zeyad Jalil12-Jul-15 0:48

Zeyad Jalil

12-Jul-15 0:48

Hi,

I recheck and print the report path in the log file and it is a correct path but still the report not shown in the report viewer and the same error occurred.

Re: RDLC Report in Asp.Net

Wendelius12-Jul-15 1:00

Wendelius

12-Jul-15 1:00

What does the path look like that you use?

Re: RDLC Report in Asp.Net

Zeyad Jalil12-Jul-15 1:12

Zeyad Jalil

12-Jul-15 1:12

Hi,

This is the path and it is a correct path when use it the report file open.

C:\inetpub\wwwroot\HRNEW\Reports\PermitsRpt.rdlc

HRNEW: is my application.
Reports: is reports folder in my application

Re: RDLC Report in Asp.Net

Wendelius12-Jul-15 1:25

Wendelius

12-Jul-15 1:25

Looks perfectly legit...

Did I understand correctly that the exact same path from exact same variable is working in another statement and is not working in another. Could the value be changed in between?

Also if you concatenate the path from parts, I suggest using Path.Combine[^].

If these do not help, please post all relevant code parts.

Re: RDLC Report in Asp.Net

Zeyad Jalil12-Jul-15 1:42

Zeyad Jalil

12-Jul-15 1:42

Hi,

I use the path.combine and still the same thing,
The report viewer not show the data and the log file contains the same error.

"System.NotSupportedException: The given path's format is not supported.
at System.Security.Util.StringExpressionSet.CanonicalizePath(String path, Boolean needFullPath)
at System.Security.Util.StringExpressionSet.CreateListFromExpressions(String[] str, Boolean needFullPath)
at System.Security.Permissions.FileIOPermission.AddPathList(FileIOPermissionAccess access, AccessControlActions control, String[] pathListOrig, Boolean checkForDuplicates, Boolean needFullPath, Boolean copyPathList)
at System.Security.Permissions.FileIOPermission..ctor(FileIOPermissionAccess access, String path)
at System.Web.InternalSecurityPermissions.PathDiscovery(String path)
at System.Web.HttpRequest.MapPath(VirtualPath virtualPath, VirtualPath baseVirtualDir, Boolean allowCrossAppMapping)
at System.Web.HttpRequest.MapPath(VirtualPath virtualPath)
at System.Web.HttpServerUtility.MapPath(String path)"

Re: RDLC Report in Asp.Net

Richard Deeming13-Jul-15 0:47

Richard Deeming

13-Jul-15 0:47

You're passing a physical file-system path to the MapPath method, which only accepts virtual paths.

Try using ~/Reports/PermitsRpt.rdlc as the path instead.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.