DataSource Controls :: Building A Website By C#?
Feb 2, 2010I want to building a website. I don't know step build a new website. I don't know use DataSet or create new class store connection string connection to DB ?
View 3 Replies
Similar Messages:
DataSource Controls :: Building Where Statement Dynamically Based On Parameter Value?
Aug 9, 2010How can i check a parameter value and add onto or remove conditions from my where statement.Here is what i mean.. i have a stored procedure that is being used for returning small set of fields based on a parameter that it is expecting. Since the only difference between the select statements are the last AND condition, i was wondering if i can check that parameter as im doing now but change that AND condition so that i have only 1 select statement instead of 3 within my procedure.Current Example:
if @rptNum = 1
begin
Select * FROM tblName
[code]...
DataSource Controls :: Building String To Pass Into StoredProcedure From CheckBoxList?
Jul 1, 2010I have a CheckBoxList that I need to get the values from, concatenate, and pass into a stored procedure in SQL Server 2005 utilizing Visual Basic. Due to the way our data layer is I cannot use a SqlCommand object at this level.
I have no problem getting to the selected values in the CheckBoxList:
Dim selectedValue As New StringBuilder
For i = 0 To cblMethods.Items.Count -1
If cblMethods.Items(i).Selected Then
selectedValue.Append(cblMethods.Items(i).Text)
End If
Next
The problem is that I do not know how to list the values in such a way that my stored procedure will pull data:
SET @MethodNames ='GetWords','GetLetters'
SELECT * FROM TABLE WHERE method IN ( @MethodNames )
I've tried experimenting with apostraphes but cannot make it work:
selectedValue.Append("'''" + cblMethods.Items(i).Text + "''', "
DataSource Controls :: Building Dropdown Search Box For A Field In A Database Table?
Dec 20, 2010I'm building dropdown search box for a field in a database table. How can I code search all in web form and Stored procedure?
View 4 RepliesMVC :: Building Website For IPhone?
Jul 25, 2010I would like to ask for advice how to build mvc web application for iPhone.
If you have any code sample, Good example how to start and get deep into it.
Building A Website Supporting Many Languages / Cultures?
Sep 19, 2010I am building my first ASP.NET MVC site and this site needs to be in 2 languages.
When a user selects a language from the menu, the site would present itself in that language.
The content likely will be loaded all from resource files. Can I respond to a change in the culture definition at runtime so it load the correct resource file?
I want different URLs for both languages. Perhaps something like mysite.com/en/home/index.
Is this possible? The users should be able to forward and save links and that the site will be loaded in their language.
How can this be done with ASP.NET MVC?
Web Forms :: Find Error While Building A Website?
Nov 13, 2010I cant able to find the error page while building a website.
See the above 3rd line error in image.
So ,how to know where the exact error is occured.
How Much Work-power And Time Does It Take For Building Website Like Stackoverflow
Feb 20, 2010I'm wondering building a website like StackOverFlow (approximately the same features using ASP.NET ) How much Work-power and time does it take in your opinion . My boss has asked me to estimate for work-power , time , cost and suitable technologies .
View 6 RepliesVisual Studio Erroneous Errors When Building A Website?
Apr 9, 2010Visual Studio 2008 shows a lot of erroneous errors when building a website (not a web project) in the errors list. These errors are usually corrected (removed) when I rebuild the site a couple times but they cost me wasted time.Is there anyway to hide the erroneous errors?
Update:
I've decided to look into this to see if I could reproduce it. This is the exact behavior I am seeing, using the website model, I type some invalid syntax on a page. The errors list fills up with errors. I correct the error and the errors list does not update. I build the project and the errors list still shows the errors but the build shows as build completed. I build the project a second time and the errors list is cleared.
My question is there anyway to make the errors list clear on the first build? I thought it might have something to do with page build vs website build but it seems to make no difference. I am not using any third party dlls on this website.
Web Forms :: Event Handler - Building Usercontrols For Something Like A WebSite Kit
Jan 18, 2010i've got a weired problem using an event-Handler in a Usercontrol I built. The Question to this is pretty simple. I don't get the "SelectedIndexChanged" Event on one of my ListBoxes which I turned to a Multiselection Dropdownlist with jQuery. It's a simple ListBox which should return the new values and should fire the "SIC" Event right? But it doesn't. I don't even get the new values as I try to change values and then read them. I spent more then 2 days searching for an appropriate answer but didn't find anything. As I tried to build a WebSite using some Usercontrols combined with AJAX I'm thinking about letting the Usercontrols out.
View 3 RepliesC# - Building An Administration Area To Control A Dynamic Website?
Oct 1, 2010I've learned asp.net from books available on the internet, but I didn't find a good book that teaches you some techniques or logic to follow to build an administration area to control the front-end.I mean they talked about security, membership and roles. but still they didn't show you how to manage anything that's not related to a database, anything that's related to a database you'll probably create a page to display some info from a db with some SELECT commands and another page for the admin to INSERT, DELETE, UPDATEbut how can I connect to the other controls from my admin panel.for example : a textbox in the admin.aspx will edit the value of a certain label in display.aspx
another example : I built a web user control to retrieve articles from a DB and another control to be placed in the admin page, which will let the admin add new articles and it will insert it to the database, how can I add more power to the admin page to control the number articles to display on the page, or to control the sorting of the articles, etc...If i could get a name of a book that helps me with the logic or basics of creating a page that works like my admin panel to control the front-end it would be great,
Visual Studio :: Building A Project From Website Files?
Oct 30, 2010I have been asked to do some work on a website. I downloaded all of the files and chose "open website" in Visual Studio. In the picture below you can see the file structure. When I run the project I get some errors such as "could not load type 'AdminSite.Partner.Listing" or "file project/adminmaster.master does not exist'. Now, those files are indeed there. I have noticed that within the Admin folder and the Home folder there are compiled DLLs in the bin folders. Also, there are project files within each of those folders. I've tried opening the project files and the projects only encompass the files within each of the Admin and Home directories respectively. I'm just wondering what the best way is to set up this solution. As I've done so far, by opening it as a web site, why is it not seeing the DLLs in the bin folders when I run it? Do I need to reference them somehow?
View 5 RepliesBuilding An Extranet Loan Status Check Website Using .NET MVC With A WCF Backend?
Feb 13, 2010We are building an extranet loan status check website using ASP.NET MVC with a WCF backend. Its a pretty standard design with the MVC site using a WCF service reference to get customer objects. The ervice uses an Oracle backend + http binding, and won't be hosted on the same server as the MVC site (so we can't use tcp binding to reduce latency).
The problem we encountered is that every call to the service is resulting in a 7-8s response time which is unacceptable for an extranet site and much higher than the 2s magic mark. The service method(s) call 12 stored procedures to create the customer object. The database is, unfortunately, denormalized (we can't change it as its also used by other inhouse production systems) so most of the calls are basic select statements which populate the customer object and its associated objects. The service proxy is properly opened and closed/disposed in the MVC actions so there are no instances of any service connection leaks. A new client proxy is created for every request (i.e., we are not using the singleton pattern for the service). how we can speed this up ?
What Is The Best Architecture For Building A Website That May Also Support A Native Mobile App In The Future
Sep 30, 2010I am in the planning phases of building a new ASP.NET website. The website is really a transactional web application where the users will log in and perform basic CRUD data operations. For right now this website will be accessible through a traditional desktop browser and a mobile browser. For the mobile browser we will build a separate scaled down version of the site.In the future we may decide to create native mobile applications for Android or iOS devices also.
So the question I have is what is the best way to design the system to easily support that? Here is what I am thinking. I am thinking of building out 3 tiers to the site. The back end will be the database - SQL Server 2008. We will use stored procedures for all data access. The middle tier will be a web services tier. This tier will be built using RESTful web services and will contain all of the business logic. These web services will provide access to the database. The front end will be built using ASP.NET. The front end will only contain presentation logic. These tiers will actually be deployed on physically separate servers.
Then I am thinking that when we decide to build a native Android or iOS app that we could build those apps to simply call the same RESTful web services that the main site is calling.Does this seem like a reasonable approach? The only thing I can think of is that the way we are building it right now the web services would be behind the firewall and would not be accessible to the outside world. When we want to support a native mobile app then we would need to make the web services accessible to the outside world.Any thoughts? Does this seem like a good approach for building a high availability, high usage web app that needs to support native mobile apps in the future?
Visual Studio :: Building A Static Website Using Web Developer Express
Jan 3, 2011i want to build a simple information web site , that contains;
1. text
2. links
3. images
4.tables
i do not need to connect to a database or other services , no login is required .
so is it possible to create such a simple web site using Visual web developer express?
Visual Studio :: Windows XP Crashes On Building Website In VS2008?
Mar 24, 2010I am ruuning VS 2008 on Windows XP Service Pack 3. The problem I am facing is that my windows crashes after a blue screen whenever I run a website in VS2008.Its only with websites projects in VS2008 but not with WinForms projects. WinForm applications running without any problem.This happens in this sequence that when I run the project, it starts, debugs and port is opened for my project (a popup that comes right near the system clock in taskbar) and suddenly after that a blue screen comes and Windows restarts. After restarting,
a message comes that system has been recovered from a serious, send report to Microsoft blah blah blah...Can anybody figures it out what problem there can be?
DataSource Controls :: SqlDataSource And Parameters Query / Trying To Accomplish Is Building Dynamic Query
Aug 22, 20101. I have a GridView on my page and it uses sqldatasource with parameterized query. What I want to do is, on page load (where nothing has been selected so no parameter supplied), I want it to query everything (something like SELECT * FROM [this_table]) but since my SelectCommand is something like
SELECT * FROM [this_table] WHERE [this_column] = @someParameters AND [that_column] = @someParameters.
Can I play around with default value to achieve something like that but how ? Now, when the page loads, it doesn't show anything (No Gridview).
2. On my page, I made something like (username, gender, address, and more) and one single search button. That means, no single control enable auto postback. What I am trying to accomplish is building dynamic query
(if username specifed -> SELECT * FROM [this_table] WHERE [username] LIKE @username).
If both username and gender are specified (SELECT * FROM [this_table] WHERE [username] LIKE @username AND [gender] = @gender) and you know the rest. How can I do this using GridView and SqlDataSource ? To my knowledge, I can only specify one SELECT statement in a sqldatasource.
Visual Studio - Way To Create Project From Existing IIS Website, Building Stuff
Sep 27, 2010I'm left maintaining a proprietary codebase from a third-party vendor. The vendor is still sort of around, but support is limp. The site is ASP.NET.I have made some changes but I am having a really hard time getting IIS to compile these changes in. The bin/ directory has what I believe is a precompiled dll for the core classes. I've changed these but it doesn't recompile. I have tried deleting the dll but then the app refuses to build saying that the Global.asax can't inherit the type anymore, so I don't really know how to rebuild with changes.
View 3 RepliesWeb Forms :: Building A Website For Displaying Latest News And Updating Same Periodically?
Nov 24, 2012I am required to develop a page for news updates where user of the website can see the latest news updates with images in hindi. Like some news paper website. [URL] ....
When user click on the read more or on the title of the news complete news will displayed on news on new tab.
when admin of the website update the new it will appear on the page. where recently updated news is display first position.
admin of the website have authority to do following task
1. update the news.
2.edit the news.
3.delete the news
Can i make use of sqlserver for storing the news or xml.
DataSource Controls :: Run Queries From Website?
Jun 28, 2010I need to fire sql queries in my website and get the results from the Database. for example: I will give select * from emp in a text box. It shud return the results for me. DO any of u have a sample/links of such application, through which i will be able to implement in my application share me the links/sources/app if u have any.
View 2 RepliesDataSource Controls :: Website Not Connecting To Database
Mar 8, 2010Could not establish a connection to the database. If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider. I have set up a db locally which mimics the production DB, THe production db and website has no has no issues.
THis used to work till i had hard disk failure and had to reinstall all software and do the db from scratch. Used the table scripts and ran the aspnet_regsql. I am using sql server express 2008 asp.net 3.5 I am using custom provider for Roles and custom membership provider for Memberships. Pretty sure the problem is in the db permissions, though I have set up Users in the Security of the DB.
[Code]....
DataSource Controls :: Managing SQL Connections In A Website?
Jun 18, 2010My lecturer insists that a web site should NOT have a static SQL connection as its not good practice (didn't explain why) but then I thought that if one makes instances of an SQL connection everytime I want to save, delete or edit then surely thats a bottleneck as I would need to everytime establish a connection and then do the save process. From what I have read online, the process of establishing a connection to the server is the longest (about 5 to 10ms)...
How would one manage their SQL connection. At the moment I do something like:
[Code]....
DataSource Controls :: How To Improve Website's Performance
Jun 5, 2010I had created a web site with asp.net and sqlserver. How can i improve the my website's performance in with regard sqlserver connection?What's your mind about use pool connection? In this regard what the defualt values is set for 'Max Pool Size' and 'Min Pool Size'?What's your mind about use Asynchronous access to data? What's your mind about other ways that you think?
View 3 RepliesDataSource Controls :: Start Sql Agent Job From Website
Jun 25, 2010Start Sql Agent Job from Website Can this be done in VB?
View 2 RepliesDataSource Controls :: Website Doesn't Run From Localhost?
Jan 8, 2010im developing a web app in asp.net. it works fine when i run it from visual webdeveloper. however when i run it from localhost i get the following error:
Server Error in '/zoo_webservices' Application.
The SELECT permission was denied on the object 'Zoo', database 'zoo_network', schema 'dbo'.
