Data Access From SQL SERVER to Asp.net Application - ASP.NET Discussion Boards

sk_ko9-Jul-13 21:51

9-Jul-13 21:51

hi, friends,
I am developing the web app for touch device.
I have the gridview inside the DIV, showing the list of data.
if I used the scrollbars for this div, it is no good to scroll by touching on touch device.
I want to scroll up/down on the gridview content like the swiping.

because, the users will try to swipe the DIV by touching rather than scrolling on the scrollbar.

how can I achieve?

rich text editor

blachsmith9-Jul-13 16:00

blachsmith

9-Jul-13 16:00

i've got a problem about the text editor , it runs well on the computer . but when i visit the website through my cellphone's browser ,the textarea is just the original style;

how can the text editor come into effect? Unsure | :~

Displaying Database

Athul Tuttu Baby9-Jul-13 7:33

Athul Tuttu Baby

9-Jul-13 7:33

Hi,
I have a table created in database. What i want to do is to print the data from a column in table inside <menubar>

For example:

XML

<div id="menubar">
        <div id="top_nav" class="ddsmoothmenu">
            <ul>
                <li><a href="index.aspx" class="selected">Home</a></li>

In the above code instead of the text of li "Home", i want to print the content of column in table.
Please help me soon.
Thanks.

Re: Displaying Database

ZurdoDev10-Jul-13 9:01

ZurdoDev

10-Jul-13 9:01

You need to get the data from your database. Where are you stuck?

There are only 10 types of people in the world, those who understand binary and those who don't.

JasperReport and Asp.net MVC4

kiemieuk9-Jul-13 6:09

kiemieuk

9-Jul-13 6:09

Dear all,

Need to ask you guys who have work on JasperReport with Asp.Net MVC 4.

I've done some project which required report in pdf, and we have choose jasperreport since it easy to use with mysql.

When i call the report through jasperreport web service REST, it return the stream but i cant to make it be downloaded as pdf.

So is there anyone have work on jasperreport and asp.net?

Need your guys help

Crystal Report with Data Set running on the Windows server 2008 64bit ...?

fasher_the_one9-Jul-13 5:42

fasher_the_one

9-Jul-13 5:42

long ago that I have been researching how to create a report with crystal report server that runs in iis 7.

I have done various forms all running on my machine, only to put on the server, the report never appears .. I wanted to know how to do through dataset. I have a stored procedure that makes my select and this takes 1 parameter to perform the search. I need to know how to create a dataset where I pass this stored procedure, and then the steps you need to take to create my report through this dataset, and then put on the server, so that everything can work perfectly ... any ideas??

Data Access From SQL SERVER to Asp.net 4.0Application

shuja0829-Jul-13 0:07

shuja082

9-Jul-13 0:07

Dear All,

I have a question regarding data access from SQL server 2008 to Asp.net 4.0 application... My question is what is the best method to get data from SQL Server, Table, View, Stored Procedure, function.. My Problem, why I am asking this question, I want to access data from Stored Procedures and I have to define parameters on creation time of procedures and have to use them all in asp.net form to access data. But I want to give rights to user, get data with nos of parameter if he wants to use otherwise no filter all data would be displayed... and he has right to use all filters or no filter or whatever that is defined. So in this situation what would you guys recommend to get data from SQL using Stored Procedure, Tables or Views and how is that possible?

Thanks in advance for your reply
Shuja

Data Access From SQL SERVER to Asp.net Application

shuja0829-Jul-13 0:06

shuja082

9-Jul-13 0:06

Re: Data Access From SQL SERVER to Asp.net Application

chester_it2111-Jul-13 8:45

chester_it21

11-Jul-13 8:45

hi Shuja,

at its base is all activities when using Parameter Stored Procedure, we must define its parameters simultaneously dengna making its Stored Procedure.
using LINQ or the Code definition ConnectionsClass (SqlClient, ODBC, OleDb etc. ..), its all the same to use parameters.
but if you want to save the program code, you can make it with a parsing technique parameters such as the example below:

in SP,

SQL

ALTER PROCEDURE [dbo]. [GET_SALER_ORDER]
(
@ SALESNAME VARCHAR (20)
)
U.S.
SELECT * FROM WHERE TABLE_SALES SALES_NAME LIKE @ SALESNAME

and in its asp.net code, you can call him by implanting code like this:

salesname var = "%" + parsingsalesnamevalue + "%";

             var sqlcmd = new SqlCommand ("GET_SALER_ORDER", sqlcon);

             sqlcmd.CommandType = CommandType.StoredProcedure;
             sqlcmd.Parameters.AddWithValue ("@ SALESNAME", salesname);

This means, if the value of its parsingsalesnamevalue empty, meaning the application code to call the data without the filter, if its opposite, meaning the application code to filter based salesname.
is this what you mean,
or you can tell me more detail about your wishes,
hope this helps as a prefix you in building your applications

cascade report

samsamn8-Jul-13 22:12

samsamn

8-Jul-13 22:12

hello
i create a cascade report with devexpress control and now i want convert this report to column report this meanse i want show convert insted grid to column... Confused | :confused:

Any Isses with ASP.NET with IE 10?

Xarzu8-Jul-13 12:14

Xarzu

8-Jul-13 12:14

Has anyone had any problems where a website behaves differently with Microsoft Internet Explorer 10? I got a call from someone who said that he could not use a drop-down window on a web page I manage after he upgraded to Internet Explorer 10 and he did not have any problems before.

If my memory serves me, it is not possible to have two versions of IE on a computer (which is what I would like to do to test this). Is that right?

Also, is it possible to uninstall and reinstall Internet Explorer?

Re: Any Isses with ASP.NET with IE 10?

Bernhard Hiller8-Jul-13 23:23

Bernhard Hiller

8-Jul-13 23:23

With Internet Explorer 10, conditional comments were abolished. And other types of browser sniffing were greatly discouraged by changing the browser identification string.
When your web site works correctly on a current version of Firefox or Chrome (without browser sniffing!), it is expected to work with IE10 too.

Re: Any Isses with ASP.NET with IE 10?

Richard Deeming9-Jul-13 1:17

Richard Deeming

9-Jul-13 1:17

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

Re: Any Isses with ASP.NET with IE 10?

jkirkerx9-Jul-13 8:50

jkirkerx

9-Jul-13 8:50

That was a good article to read.

It's getting harder to trace down all those little bugs with new browser versions, and some of the asp.net features used in my programs, like maintain scroll position.

What kicks my butt is safari on the iphone and ipad, like how drop down and list boxes are treated.

Thanks for the tip.

Setting up Asp.net Mvc3, EF and Structuremap

Member 100042608-Jul-13 6:02

Member 10004260

8-Jul-13 6:02

Hi guys I'm kinda new here so please bear with me, well as per the title I just want to have an idea on how to setup a MVC 3 application using, Entity Framework Code First and Structuremap, how do i register classes that I've created with structuremap, TIA.

Re: Setting up Asp.net Mvc3, EF and Structuremap

Jameel VM9-Jul-13 19:33

Jameel VM

9-Jul-13 19:33

You can install Install ASP.NET MVC3 from here http://www.asp.net/mvc/mvc3[^]

Install EntityFramework via Nuget. For more go through this link http://nuget.org/packages/entityframework[^]

Install StructureMap via nuget.For more go through this linkhttp://nuget.org/packages/StructureMap-MVC3/[^]

Re: Setting up Asp.net Mvc3, EF and Structuremap

Member 1000426010-Jul-13 0:41

Member 10004260

10-Jul-13 0:41

Hi Jameel thanks but I do know how to install all of them maybe the title of the thread is wrong but my main quesstion is how do I implement this kind of approach. TIA

Re: Setting up Asp.net Mvc3, EF and Structuremap

Jameel VM10-Jul-13 4:52

Jameel VM

10-Jul-13 4:52

First You need to nuget. You can download from here http://nuget.org/[^]
After install this Opentheproject >> VisualStudio >> Tools >> LibraryPackageManager>>Select Package Manager Console

from the command window type the command for the package you want to install such as Structuremap,EntityFrameWork etc.The command you got from the link that i have provided earlie

WebException timeout Problem.

vishalmudrale8-Jul-13 4:07

vishalmudrale

8-Jul-13 4:07

We are using a web service(asmx) to communicate with service provider.

Problem: We are getting a web exception while sending and receiving response.

Exception Details :
1) Exception Message : The request was aborted: The operation has timed out.
2) Exception Status : timeout

We are getting this timeout status within 40 seconds whereas we have set webrequests timeout property to 180 seconds.

Can anybody please suggest me the solution of this problem??

Vishal

Re: WebException timeout Problem.

onelopez8-Jul-13 4:18

onelopez

8-Jul-13 4:18

Double check your time again, the WebRequest class uses timeout in milliseconds, so if you did something like

webRequest.Timeout = 180;

That just means that it will expire in 180 milliseconds and not the expected 180 seconds.

If your time is correct, then check with the server and make sure that the server does not close the connection after sometime without completing the request.

Re: WebException timeout Problem.

vishalmudrale8-Jul-13 19:28

vishalmudrale

8-Jul-13 19:28

Thanks for reply friend,

My timeout time is correct, I have set webRequest.Timeout = 180000;

I am getting two types of webExceptions :
1)
Exception Message : The request was aborted: The operation has timed out.
Exception Status : timeout

This timeout happens within 40 seconds, whereas I have set timeout 180 seconds for my webrequest.

2)
Exception Message : The operation has timed out.
Exception Status : timeout

This is normal timeout. It happens after 180 seconds.

Re: WebException timeout Problem.

vishalmudrale8-Jul-13 19:58

vishalmudrale

8-Jul-13 19:58