i want to know if the only way to get information from database and transform them into objects is with a datareader or with a dataadapter and them looping throw the datarows, cause i have a lot of records in the table and i have to find the fastest way to do it. (like 10,000,000 records).
View 3 RepliesI just want to know, What parameters or attributes should be taken in connection string so as to handle high traffic enterprise applications? Like in general we use server, initial catalog, userid, passwd. Some times we add timeout , and in some scenario pool etc. But i don't know what attributes should i take in as my common practice apart from above.
View 3 RepliesIn pages that have a viewstate that spans 10-15KB what would be an optimal value for
<pages maxPageStateFieldLength="">
in the web.config in order to reduce the risk of potential truncation leading to viewstate validation errors?
I'll be starting a complete re-write of a system in the coming weeks. I'll be using ASP.NET MVC 2.I'm still trying to determine what I should be using as far as TDD, mocking, and IOC is concerned. I was thinking:
VSTEST for writing my TDD tests (or possibly nUnit) Moq as my mocking framework (for creating doubles and fakes) Moq for IOC development Not sure exactly what the ideal setup should be and I'm continuing to research what's available. I'd like some feedback from the community on the most optimal toolsets for TDD, mocking, and IOC.
What is the best method to cache the following? I am creating an intranet web application template that will display the message, e.g., Good Morning, Justin Satyr! near the top of my master page header. Obviously, I will have to determine whether to show Morning, Afternoon or Evening. For clarity, my code is below:
string partOfDay;
var hours = DateTime.Now.Hour;
if (hours > 16)
{
partOfDay = "evening";
}
else if (hours > 11)
{
partOfDay = "afternoon";
}
else
{
partOfDay = "morning";
}
I do not want to re-determine this on each page load because that seems moderately redundant and because I have to poll a SQL server to retrieve the user's full name. What is the best way to cache this nformation? If I cache it for the length of the session, then if the user begins using the application at 11:00 AM and finishes at 3:00 PM, it will still say Good Morning. Is the best thing to do simply re-determine the M/A/E word each page load and cache the person's full name for the session? Or is there a better way?
If that is even the right combination of controls to use.. I have a page that will display a list of files that have been processed or processing.. its not really time sensitive, but would like for the page to refresh the gridview every say every minutelonger(not determined yet)Is that the most optimal way to accomplish this, i mean if you are on the page, i dont want you to have to hit refresh to see any new records or status changes to the existing records..
View 4 RepliesI have a requirement where I would not know the columns and any result set information at design-time, so I'd be generating the data-display control dynamically.What is the most suitable way to display this type of information on-the-fly in a table/grid like structure on an ASP.NET page considering the following parameters (in order of importance):
Performance
Extensibility
Usability
I know I can dynamically generate a gridview/repeater/listview control but what I'd like to understand is which option (from stated ones or any other beyond these) would be an optimal solution..S. Paging and Sorting are part of desired functionalities, but can be overlooked if the solution is overwhelming. :)
I am trying to run the 15 minutes movies MVC application but I got the following error:
Object reference not set to an instance of an object.
Description:
An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.
Source Error:
[Code]....
I am confused over this point that Connection with databse in ado.net is a managed object or unmanged object, from the past couple of years i was assuming that it is unmanged but a post from MSDN says it is managed (Correct me if i am wrong :)), i am attching the link of that post herewith
[URL]
I have several web sequential pages which will modify a record and its child records in the database, called a "project". Such a project is currently passed between pages using its database ID in the URL parameters.
A project has some information specific to itself, and also consists of one or more Tasks, which each have information specific to itself.
Is it faster (alternatively, more maintainable or more easily understood) to hit the database each time I need to query the same project (and its tasks), or should I query the database once (either once for each page or once for all pages and save to Session) and check the saved object rather than the database?
Recent we are deploy(Setup and Deploy) our Product which is develop in ASp.Net(C#) using SqlServer Here We Face one Problem i.e.
When we install the porduct there is no issue if we manually run the sqlScript file in sql server(manully we create the DataBase and All DataBase Object i.e. Table,StoreProcedure,Function,Views....& We are enter the Sample Data) But We know that is not the Right Approch.
Any one Can tell me the procedure "How to Building DataBase & All DataBase Object with Sample Data when we click the Install and set up file"
In Setup and Deploy wized it ask for any Dependence file for the application i have attach the Dependence file(.sql) but i am not getting any OutPut .
Is there any Command prompt Utility(SqlServer/VS Commandprompt) ?
I want to convert sql server 2000 database into sql server 2005 database. I am using sql server 2005 express.
I am trying by taking backup/Restore method, but it not work.
How do you insert an object into a database, here is the object from the class:
public static Int32 InsertBaseCar(BaseCar theCar)
{
Int32 newBCarId = 0;
try
{
SqlConnection cn = new SqlConnection(_connectionString);
SqlCommand cmd = new SqlCommand("sp_InsertBaseCar", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@id", theCar.ID);
cmd.Parameters.AddWithValue("@make", theCar.Make);
cmd.Parameters.AddWithValue("@model", theCar.Model);
using (cn)
{
cn.Open();
newBCarId = Convert.ToInt32(cmd.ExecuteScalar());
}
}
catch
{
// write code here.
}
return newBCarId;
}
And here is my attend at inserting the code into the database:
public void InsertBaseCar()
{
BaseCar theCar = new BaseCar();
theCar.ID = Convert.ToInt32(txtBId.Text.Trim());
theCar.Make = txtBMake.Text.ToString();
theCar.Model = txtBModel.Text.ToString();
//InsertBaseCar();
txtBId.Text = string.Empty;
txtMake.Text = string.Empty;
txtModel.Text = string.Empty;
}
I am trying to get the FailedPasswordAttemptCount from the ASP.NET built in objects and I am not able to find one, is there any way I can get this value without creating a new storedProc?
View 1 RepliesI recently have a problem while switching from regular sql datasource to the object datasource using the dataset object.
I have only 1 sql server so I create 2 database 1 for testing and 1 for running. After I create the dataset object I can use it fine with my test site and database. However, when I upload to it use on the production database (I actually just have to switch the sql connectionstring in web.config), I keep getting error of target of invocation throwing errors.
When I do a search for the test database in the project, I can see that in the dataset object the test database's name is automatically added to my select stored procedure name (i.e. [Test].[dbo].[My_stored_procedure] instead of just [dbo].[My_stored_procedure]). I thought this is my problem but even when I replace [Test] with my [Product] database name it still won't work.
I have a form where users upload a file (csv), then the server does some processing, and generates a datatable. the table will be shown in grid. however, the table's column is unknown, and sometimes, the table is huge. I need show this table in another form.
It seems session variable is not good for this since the table maybe huge. is there a way to write this table to sql, then load it again in the other form?
Is there a way to display pdf from local directory or database in a object tag.
My problem is I am trying to display pdf print dialog after pdf is loaded.
This is possible if I load pdf using object tag, but currently my pdf is getting loaded dynamically using response.binarywrite.
whan i create new table using sql express 2010 to an excisting database in sql server 2008 this error message comes
Invalid object name 'dbo.DrugsCaegory';
where DrugsCaegory is the new created table by sql express by visual studio 2010 it works correctly local but when run it on server this error message comes
note:all other tables was created by sql server 2008,but this new table creayed by express 2010
is this is the reason ???
but it works local ,
on local database is express version 2010
on server database sql server 2008
how to use database return many field and insert in a object(like any Collection ,Array,Hashtable etc)
[code]....
I ask this because i'm using Partial classing to extend my db model, and in doing so some snags i've run into using inheritance and also snags i've run into declaring my db model in another class as a property and just using it like that ie: Public Property DBModelClass as DBModelClassType - however, doign direct partial classing has worked out the best, with no snags... except for an issue i seem to be running into now.
that is, i create new properties with half-page code in the 'Get' part of the property decleration, these are like virtual/new properties that the db or db model isn't supposed to know anything about, the sort of stuff you generate/use but without saving it in your db, as i'm sure all of you have these. every time i submit my DBModel through an action, somehow, one of these properties 'Get' section is running (being called) even though i'venever asked for it to. of course, because it aint ready to run (it shouldn't) errors like null errors get returned (however, they wouldn't error if it were to run only when i asked for it to).
edit:
so this second part of my question, are all properties in a model generated from a db (linq to sql) ran or called by the model state automatically? without being asked to do so?
an aside:
(i do do a modelstate.isvalid - however, this running occurs before isvalid is called as it errors out before i even see validation information). that being, is the auto calling of all properties on a db model object even when not used normal? i tried using bind(false) and scaffold off on the problemed properties. and the first part of my question, just as a reminder, is if i should or should not be using partial classing as a substitute to inheritance when extending db model's?
I been working on a simple site today and when I found myself surprised about this. I got a object model that gone have like a lot of emails to it so I thought Ill do a string array to keep them, then I paused and tried to figure how do I save that to a database and how do I work with this? I always found myself working with collections of objects instead. So I'm kinda embaries to say this but how do I work with this? can I save a array to database
[Code]....
I have a products table whereby I want to return a single row via a product id and use it as a data object.
I have used a .xsd dataset and a product class where I return a dataset and add the values into the product object that I created but I don't like having to write code like
"Product[0].ProductDescription" to get the product description. Is there a way of returning is straight as an object rather than a dataset?
how to populate a ilist object with data frm a sql table in code behind
View 1 RepliesI have several stored procedures in my database, some of them have params, some have no params. I tried to fill a business object by calling the stored procedures, but failed so far. How could I do that dynamically? Later, I want to use this object as a datasource for a report...but thats the next step. The important facts are:
different stored procs return different amount of columns stored procs can have params, but its not required
I use ASP.NET MVC with Entity Framework. I have an Edit method in my Controller. It takes an entity object which was created by a HTML form:
[Code]....
Where Page is my entity object. However, the manually changed property (newPage.LastModified) is not recognized when updating the model. I am aware that I somehow have to connect the entity object to the Entity Framework, but how to do this?