Helper Class For Sql Server Database
Mar 30, 2011
When is it appropriate to create a helper class for a sql server database using the asp.net framework? Basically I'm trying to create a minature wiki (with multiple pages) and storing all of the data/strings for a specific page into a table on it's own.
View 3 Replies
Similar Messages:
Jun 30, 2010
I have a class instance which is created by using Activator.CreateInstance() method. That class instance contains helper methods which are frequently used throughout the application. In order to avoid creating the instance multiple times, I'm just thinking about implementing an appropriate caching mechanism. The following consideration should be taken into account:
1) I can't use static class and methods.
2) There are around 6 instances (1 instance per class) per App Domain.
View 4 Replies
Jan 4, 2011
To be able to implement paging i need to create a helper class (as mentioned on one example in the net ); so i have created a class that encapsulate the paging logic
public class PagingList<T> : List<T>
.
..
but when i reference this class in my view using the code below:-
Models.PagingList<Article>
The following error occurred. Server Error in '/' Application. Compilation Error Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately. Compiler Error Message: CS0246: The type or namespace name 'Article' could not be found (are you missing a using directive or an assembly reference?) Source Error:
[Code]....
Source File: c:UsersMohannadAppDataLocalTempTemporary ASP.NET Files
oot1f3f505f568b8e69App_Web_index.aspx.82d38c66.ffjpt45i.0.cs Line: 172
Show Detailed Compiler Output:
View 9 Replies
Jul 1, 2010
I wanted to write a code for JQgrid in asp.net .I have tried the same in asp.net MVC,but i want it now in asp.net .n MVC we use Helper class,and return json data,so what to do in asp.net where helper class can not be used.Serialization can be done with data to get it in json.,but what about Htmlhelper.
View 2 Replies
Jan 24, 2011
I need to use the standard ASP.NET membership database tables in plain winform projects, and I DO NOT WANT to add the ASP.NET dll, because my app must run with .NET Client framework, and not full framework. Does somebody knows of a helper class that links to ASP.NET tables in plain vanilla VB ot c# code? I mean with functions equivalent to CreateNewUser, CheckUserCredentials, isUserinRole, RoleList etc...
View 1 Replies
Nov 5, 2010
I have just added routing in a new asp.net 4 web forms application, and have got my route table set up ok and page requests are working fine. What I now want to do is use the Page.GetRouteUrl method whenever I need to generate one of my seo friendly Url's. I started to implement this across various pages then thought it might cut down on code a bit if I had a method in one of my own helper classes, that constructs this url (using the Page.GetRouteUrl method) as I might have several parameters that need to be specified against the Page.GetRouteUrl method each time.
However, within my helper class, it doesn't know what 'Page' is. I was thinking I could pass in 'Page' from the page that wants a routed url to be generated, but in some cases I want to construct one of these Url's in another class which doesn't know what 'Page' is, and in that scenario wouldn't be able to pass it in as a param (and therefore wouldn't be able to use the Page.GetRouteUrl within my helper class). What is the normal approach when wanting to use Page.GetRouteUrl within classes that don't have an instance of the Page object?
View 1 Replies
Jun 30, 2010
I'm working on a page with two sets of collapsable panels. using nHibernate) I get category objects with a list of items in them, and for each category generate a left panel and right panel. In both panels, there is a ListBox. Items are pre-populated to the left list box and the user can select and move items into the right list box (under the corresponding category.) As I've built and worked on it, I ended up with a lot of generic methods like buildPanel(side,categoryID) and then ended up with a lot of repeated if statements inside them to differentiate between the two sides
if type=PanelType.Left then
set these 5 id strings to access components
else
...
The code got messy, so I moved a lot of the logic and static builder strings for the component ids into a private helper class in order to make other parts of the main class easier to read and follow. The problem I see is that the private class is extremely dependant on specific structures in the parent class. There's a very minimal amount of encapsulation going on and I'm possibly making the logic harder to follow even if the individual components in the code are easier to read.
My question is: When you're using a private class like this, is it acceptable to have it tightly integrated with the parent class (since it's private and implemented in the same file), am I better to refactor again and find a way of either simplifying my original code to be as short as possible without the helper class (stick all category/panel functions in one spot and hide them in their own region when I'm not using them), or should I move towards putting more of the logic in the helper class and simply mapping my events directly to the subclass. After typing all this out, I'm leaning towards the last option, but I'm still torn/confused about the whole thing...
View 2 Replies
Mar 2, 2011
I was using the default MailMessage and SmtpClient classes for creating and sending HTML emails from a web forms website. The problem is I have a lot of hard coded HTML for formatting the email that gets sent. Is there a class that helps format emails for .NET?
View 2 Replies
Feb 3, 2010
With asp.net MVC 2, I have been trying to get Matt Hawley's Localization helper to work in my web application, but I am getting stuck feeding a null into the Language string variable. I can't figure out why I am doing this.
namespace MvcLocalization
{
public abstract class LocalizedControllerBase : Controller
{
public String LanguageCode { get; private set; }
protected override void Initialize(System.Web.Routing.RequestContext requestContext)
{
LanguageCode = requestContext.RouteData.Values["languageCode"].ToString();
if ( !AppConfig.SupportedLanguages.Contains(LanguageCode) )
LanguageCode = AppConfig.DefaultLanguageCode;
System.Globalization.CultureInfo culture = System.Globalization.CultureInfo.CreateSpecificCulture(LanguageCode);
Thread.CurrentThread.CurrentCulture = culture;
Thread.CurrentThread.CurrentUICulture = culture;
base.Execute(requestContext);
}
}
}
View 1 Replies
Sep 18, 2010
I have a static class (an helper class) which has the responsability to create control and add them to a panel passed by parameter, this method is used by a lot of
View 5 Replies
Dec 17, 2010
Is there a way to pass a reference of a page to a helper class? Scenario: [ASP.NET 2.0 Web Application] The page is a content page which has a MasterPage. The page calls a method in the helper class and passes the page byRef as an argument. The method in the helper class tries to find a control on the passed in page and set values. Problem: Only the MasterPage is being exposed and not the page I am trying to pass. Any recommendations on passing the page so that I can set the values of the controls within it?
View 5 Replies
Mar 15, 2011
recommend a data access class / helper class for Access databases, similar to the sqlhelper class found in the (Data Access Application Block)?
View 6 Replies
Jan 23, 2010
from years go i use "SQL Helper" class that exist in Microsoft Application Blocks for .NET and i used it for about 1 year in many projects but after that many senior recommend me not to use as it's have many problems in big projects and i let it but know in a new company they want to use it in a projects ... Could any make his recommendations about it / and if it's really excellent to use it have already issues ?Is there any other good solution rather than SQL Helper ?
View 2 Replies
Jan 30, 2011
we have been able to return information from the database and then select the relevant link and return that row of information from the SQL table. The next part I am working on is adding information to the database.
So far all the coding in done in a class file, we are using stored procedures and have used user controls to return the information from the database and then also to select the row of information for each news item from the database. The sql database connection information and executing the stored procedure information is all done in the class file. how to add the news items to the SQL table. Below is the code that is used to return each news item from the SQL Table, how i need to amend this to rather than display the information, save it to the database. Also having used stored procedures, would I need to create another stored procedure to to the INSERT INTO statement
[code] ....
View 3 Replies
Jan 9, 2010
I am new to MVC. why HTML helper methods are inside asp server tags?
for example <%=Html.Textbox("Textbox1")%>
are they equivalnet to asp.net web form server tags. Like in web forms we have
<asp:TextBox runat="server"></asp:TextBox>
If someone can kindly explain.
View 1 Replies
Feb 4, 2010
I have build a server control that uses ajax postbacks in order to do db insert/update/delete.While redesigning our website, we are using JQuery for most postback. So we are using simple aspx pages that return only the html code we need to display. However when I am using this control, Ajax functionality does not work.First of all, I need to put a FORM element which later is removed since the behaviour of JQuery with two forms is strange.Second, I am receiving an error that __VIEWSTATE is invalid. Tried to remove it with no luck.How am I going to use this control with full functionality in a page which is used by JQuery to return results?
View 1 Replies
Sep 29, 2010
I have a local database which is updated regularly. Now I need a good way to reflect the local database changes into the remote sql server. Both the server have same database structure.
All the above pocess should work automatically from the local database server because I need to update the remote one so that the website visitor can get the updated results in the morning.I need a detailed description/ procedure to accomplish the work.
View 3 Replies
Apr 10, 2010
i have a table ("WebSettings") that have some information about Website like what is the name of website which theme use and so on i want to creat a class to return the website settings can you give me some information obot what is the best way in this case to get the informations and how can i creat this class?
View 1 Replies
Apr 9, 2010
During an adaption of a book based example application, to use an access database instead of sql server - I have come up with the final issue: It will not insert into the database! I suspect it might be to do with the OrderID, I do have it set to autonumber,but I am not too sure. This is the class that does the inserts, by adding customer information to customer table, order information to order table and ordeitems information to the orderitems table. When submitting this information on the webpage, there is the custom error that an error has occurred in your order due to this code page code behind
bool success = OrderDB.WriteOrder(order);
Session["cart"] = null;
Session["order"] = null;
if (success)
[code].....
View 9 Replies
Mar 9, 2011
I use the class below in my code-behind to connect to my database. How would I (overload?) this class to choose between multiple connection strings (databases)?
Or should I have a separate class for each connection?
[code]....
View 5 Replies
Jan 19, 2011
how make the class for database activities and it can be used in code behind
coz i want avoid the connection opening, closing activities, insert,update etc methods in code behind frequently.
the class should include connection open and closing method, passing values to stored procedures etc.
How should we construct it?
View 8 Replies
Feb 2, 2011
I would like to know how I can create a class that consists of my database connection and then how I can call that class within my C# code. Consider simple database call as follows,
SqlConnection conn = new SqlConnection(
"Data Source=InOrder_Play;server=play;user id=web;pwd=mypass;Application Name=myap .NET Cart;Persist Security Info=False;Connection Timeout=90");[code].....
View 7 Replies
Mar 4, 2010
Since I'm using Postgresql and can't use LINQ to SQL, I wrote my own wrapper classes.
This is a part of the Student class:
[code]....
It works now! I replaces all Run methods in the Student class with DB.Run
But I want to know if it will work fine with a lot of people online, not me only. I'm not sure how static things work with ASP.NET, maybe it'll eat a lot of memory?..
View 3 Replies
Aug 19, 2010
I can't see it nowhere in Visual Studio's Solution Explorer. The tutorial that I am following is using the Northwind database and hence the need to add the code line "using NorthWindTableAdatpter;" statement.So I thought I needed to add "using myDBTableAdapters" statement in my code which I did, but it's giving an error saying:
"The type or namespace name 'myDbTableAdapters' could not be found (are you missing a using directive or an assembly reference?)"
What's wrong? Where is the class for myDB's table adapter? I searched the .xsd file, but there's no mention of "myDBTableAdapters".It's not there in the Solution Explorer.
View 1 Replies
Mar 14, 2011
I am new to Visual Studio 2010 and ASP.Net, and when I first connected my SQL Server to Visual Studio it created huge files full of my SQL classes (maybe this was LINQ classes), and I accidently deleted/corrupted those files, and now I want it to create those classes again. Can someone tell me how I can do that?
View 5 Replies