Setting up Asp.net Mvc3, EF and Structuremap - ASP.NET Discussion Boards

Data Access From SQL SERVER to Asp.net Application

shuja0829-Jul-13 0:06

9-Jul-13 0:06

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

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

facebook wall programatically

Member 99727867-Jul-13 21:31

Member 9972786

7-Jul-13 21:31

How to fetch facebook wall of a user programatically in .net

Re: facebook wall programatically

Blikkies7-Jul-13 22:50

Blikkies

7-Jul-13 22:50

You can use the Facebook Graph API

add checkbox in ever row of flexgrid

samsamn6-Jul-13 23:58

samsamn

6-Jul-13 23:58

hello
i want add checkbox in ever row of flexgrid in mvc.
please help me.
thanks.....

Re: add checkbox in ever row of flexgrid

samsamn7-Jul-13 19:41

samsamn

7-Jul-13 19:41

please help me...
thanks

Re: add checkbox in ever row of flexgrid

Santosh K. Tripathi7-Jul-13 20:27

Santosh K. Tripathi

7-Jul-13 20:27

Hi,

Please chcek this may b helpful for you.
http://forums.asp.net/t/1639271.aspx/1[^]

Re: add checkbox in ever row of flexgrid

samsamn8-Jul-13 0:25

samsamn

8-Jul-13 0:25

thanks but i want add to flexgrid in mvc
flexgrid in mvc is not a server control.it is a html control...

Remove styling from Web Controls

Glend Gjermeni6-Jul-13 7:13

Glend Gjermeni

6-Jul-13 7:13

Hello, I'm a web developer who has worked with PHP and I'm delving into the ASP.Net world. Now how do I remove all the default styling (the inline-css) from these web controls? I can't use !important everywhere, it just seems silly.

Re: Remove styling from Web Controls

jkirkerx6-Jul-13 10:31

jkirkerx

6-Jul-13 10:31

css like width is added when you assign a value to width,

really need to see an example first of what you want to remove.

what is entty framwork

tarun kumar sahu hs6-Jul-13 2:06

tarun kumar sahu hs

6-Jul-13 2:06

what is the benifit of entity faramework

Web Crawler

silentspeaker5-Jul-13 19:59

silentspeaker

5-Jul-13 19:59

Please help me How to create web crawler. what are the main things that could build a web crawler.

Last Visit: 31-Dec-99 18:00 Last Update: 28-Apr-24 6:35

Refresh

ᐊ Prev 1...349 350 351 352353354 355 356 357 358 Next ᐅ

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