I have created class in C# i need to use objects from this class to add them to a databse table.
the information come from textbox go into the object of the class than from this object i want to preform databse function.
i have the following code:
[Code]....
I was trying to implement as above. How can i call this class from the code behind of my page, and call the methods Open and Close connection ?
How do i instantiate the object ?
I am developing a couple of small ASP.NET application and would like to know what pattern. approach do you use in your projects.
My projects involve databases, using Data access and Business logic layers.
The data-access approach that I was using so far is the following(I read in some book and liked it):
For DAL layer:
Creating an abstract class that will define all database manipulation methods to implement.
The abstract class will contain a static "Instance" property, that will load (if instance == null) an instance (Activator.CreateInstance) of the needed type (a class that implements it).
Creating a classes that implement this abstract class, the implementation will be according to the databases (SQL, mySQL and etc) in use.
With this I can create different implementation according to database in use.
For BLL layer:
A class that encapsulates all all retrieved fields , and static methods that will call the DAL classes.
I have several Include files in asp classic that I would like to convert to the class in C#, I have bunch of variable, Constraint, functions, DB connection. Is class the best way to convert them?
View 2 RepliesI have a member function that does not depend on any member variables of the class. (in my case the class is an ASP.Net Page)
The function is protected, I dont need it outside of this class. Its only purpose is to build an URL from an given object.
Should I make all my functions static if they dont depend on the class, even if they are not used outside of this class?
I have a base class called BasePage, and a master page called SiteMaster. All my content pages inherit BasePage using BasePage instead of System.Web.UI.Page. Now, I need to access some functions in BasePage from my master page SiteMaster, let's say, the function is called "DisplayClientName()". How can I do it? Searched the Web, have found tons of similar questions but not solid solutions.
View 2 RepliesI have an existing web application that uses EF and POCO objects. I want to improve the client experience by exposing some of my objects through WCF(JSON). I have this working fine but where I am unsure is how to handle derived objects(not sure if that is the correct term) or IEnumerable anonymous objects if you will.
Let's say I have 3 tables structured like so:
Templates
ID
Template
Groups
ID
Group
Instances
ID
TemplateID
GroupID
This is obviously a one-to-many type relationship. I have my navigation properties setup correctly and getting strongly typed object properties works great. However, how do I send serialized anonymous type object(s) over the wire. Like an object that sends all instances that are equal to groupid=1 and include the names of the template and the object.Am I missing something or do I have to create another class object for WCF that would look like this:
WCF Object
InstanceID
TemplateID
TemplateName
GroupID
GroupName
I guess I could alter my tables to account for this but that seems wrong too. I know that IEnumerable objects can't be serialized and I know that throw away objects are probably not the way to go either. I want to do this the right way but I am not sure how to go about it.
I'm trying to create a class, DataCommon, to contain all my SQL Data manipulation functions. I've created a Subroutine called Init that initializes a SQLDataAdapter:
[Code]....
From my other classes I am creating an instance of DataCommon, calling Init, and calling another subroutine in DataCommon that pulls data from SQL and loads the data into my dataset. This part is working great -- no problems at all. I'm loading three different Datatables in the Dataset with no issues.
At this point, I'll perform my various manipulations on the datatables -- add/delete/modify rows -- again with no problems. All of this is creating postbacks...and this is where my problem begins. After I've done all my manipulations to the data and am ready to update my SQL tables, I have to re-initialize my SQLDataAdapter. I thought I could do something like:
[Code]....
But I get the error: Exception inserting Class. Thread was being aborted.
In my initial data load from SQL, each datatable is getting loaded from a single SQL table, so I was hoping to use the autogenerated Update/Insert/Delete statements by the SQLDataAdapter. As a test, as soon as I filled the dataset initially, I added a new row to one of the datatables and used the SQLDataAdapter.Update() method before a postback occurred, and it worked perfectly.
So, with all that being said, I guess my question is, how do I reconnect the table mappings between my SQLDataAdapter and dataset to autogenerate the updates after a postback occurs? I've tried researching this, but I get confused after reading about FillSchema vs TableMappings vs everything else I've read about.
I am creating HTML objects in my code, and giving them IDs (see below) :
[Code]....
But whenever I try to make reference to this ID in my code, it does not work. After viewing source, the ID has been changed to ctl00_ContentBody_divMTR. Why is this happening and can I prevent it?
I am using Linq To Sql to get List of objects with data from database. To bind data with a grid view i am creating a dataset explicitly and then adding List values to that explicitly created dataset.
Now my question is whether it is a good pratice to do what i am doing (in terms of resource utilization) or is there any better way to this...
I have a form which I use to create an issue. WHen you post the form, the form elements are that of a custom DTO. The DTO is then used on my POST method to create the new entity. That all works fine.
However, I want to add the functionality to add multiple issues at the same time from the same view. In effect, the user would click something like 'Report Additional Problem', and an extra set of form fields would appear (I will like use jquery for this, which I don't have an issue with). However, even with just leaving one set of form fields, the user should still be able to create just one issue. But if I habve my post method take a list or array of my DTO, it doesn't work.
Here is the post method before editing:
[Code]....
What I want to do is for this to take an array or list of NewIssueDto. I would then loop through each one in the list and create a new issue from it.
I have an assembly that i have built with a linq to SQL item, a web reference and a class that brings it all together.I build the project and it all seems fine but when i reference the object from another project the web reference and linq objects are available but the class isnt.
View 2 RepliesIn my Code Behind I use several times this code below to bind and rebind (for refresh) e GridView after an insertion or other operations completed using EF objects.
Using a simple gridview.DataBind(); does not work because I call EF programmatically so I thought to use a Class to keep in memory this code that can create Objects for my GridView and call it how many time I need in my code avoiding redundancy.
IEnumerable<CmsContent> queryContents = myCurrentSlot.CmsContents.Where(x => x.IsPublished == true);
uxManageContents.DataSource = queryContents;
uxManageContents.DataBind();
Or do you know a batter way to Refresh the gridview after EF executing some commands? how to do it?
remember that I do use any data source web control for the gridview but i bind it programmatically.
I am using Interface for Respositary.where these can be best used.Also googling to understand these.
What do mean by concret class and domain objects?
I was assigned a task on creating a web application that connects and display database information on a grid view. My supervisor suggested me to download .NET pet shop 4.0 to serve as a template for my project.As I only have limited basic knowledge on C# and HTML codings, the .NET pet shop 4.0 is too difficult and complex for me to understand. So I have a few questions:
Which functions are required to connect to the database? Which functions display information of the database? How do I change the categories of the .NET pet shop 4.0? If I want to add a grid view to display the records instead of listing informations of the products, where should I add the code and how will it roughly look like?
In page behind classes I am using a private and shared object and variables (list or just client or simplay int id) to temporary hold data coming from database or class library. This object is used temporarily to catch data and than to return, pass to some function or binding a control.1st: Can this approach harm any way ? I couldn't analyze it but a thought was using such shared variables may replace data in it when multiple users may be sending request at a time?
[code]...
I have a function:
public List<Car> GetFourWheelDrives()
{
return dataContext.Cars.Where(c => c.IsFourWheelDrive == true).ToList();
}
Firstly it's kind of obvious what I'm trying to do here. Any suggestions on how I'm doing this? Any improvements?
So now I want to unit test this. Well is it a unit test? A unit test isn't suppose to touch the database right? So this is a functional test?
So say I write a test
[Test]
public void GetFourWheelDrives_NoParameters_ReturnAListOfOnlyCarsThatAreFourWheelDrives
{
Assert.Greater(dataContext.Cars.Where(c => c.IsFourWheelDrive == false).ToList().Count, 0);
var cars = GetFourWheelDrives();
Assert.Greater(cars.Count, 0);
Assert.AreEqual(cars.Count, cars.Where(c => c.IsFourWheelDrive == true).ToList().Count);
}
So first Assert I'm making sure cars that aren't 4WD exist in the database otherwise it wouldn't be a valid test.
Second Assert I'm making sure at least one was returned.
Third Assert I'm making sure that all the cars returned were in fact 4WD.
I know this isn't a good test because I'm using the same logic in the test as the function I'm testing. However this is the only way I can currently think of to do this.
when make buakup to my data base and open the database digram this error appear : Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects.
View 1 Replieshow to create a class library file and how to implement in web forms?
View 3 RepliesI have a 50 x 50 image button layout. That's 2,500 image buttons. I want to assign each imagebutton a picture depending on what is in the database. Will this be too much to do? Is there a faster way?
View 18 RepliesIn my class1.cs class I am not able to create class2 class's objects and vice versa. It says class2.cs/class1.cs could not be found.
View 3 RepliesI'm building an MVC 2 RTM app, and I want to be able to share my model across applications. I'd *like* to be able to implement it like:ASP.NET MVC2 app (holds Views and Controllers)Class library to hold Model(s)WCF app to handle the data transactions with the models via different data stores across apps I had the MVC app working fine, but I wanted to abstract the data stuff and be able to work with the model across apps through the WCF site, so I created a class library project and moved all of the Models classes into that and set-up a WCF app, then added project references to the MVC and WCF apps that point at the class library. The idea was I can create services that take and return objects from the model via method calls across apps. It appears that everything's wired up correctly in the MVC project, so I'm passing the objects stored in the Models class library between controllers and views and everythig is compiling just fine, but for some reason the data is not being passed back from the views to the controller on POST -- all of the properties in the classes are null or empty.
When I debug the app, I can see that the values are stored in the model data dictionary but not the model object itself. What am I doing wrong? Am I on the wrong path, or missing something obvious (to some)?
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 RepliesBelow is my class file.
[Code]....
We are consuming third Web services.
Instead of using datatypes from web service proxy we need to create our own class which will take the values from web service output.
Since the web service data types are so much deep,we are facing lots of problems to create our cutom classes.
Is there any tool available to create classes directly from web services in ordered way....