I have a client requirement wherein client needs a web Application. My team has decided to build it with ASP.Net Using C# as front end. Now my problem here is, client has back end as MS Access and due which numbers of users that are allowed to connect simultaneously to application is restricted to 15-20 users at the most. But client have big number of users who will accessing the site simultaneously.
View 3 RepliesI am having an issue with a join statement. The join is based on the customer id in both databases, however, I just happen to have the exact same spelling for the email field which is contained in both the customer database and the office database. How do I display the proper email address. The email I am sending sends to the office email address rather than the customer address.
View 2 RepliesI am trying to delete record from table with proper mapping from linq to sql.There is an error stating that Rmove method not found and are u missing an assembly reference.
AdventureWorks db = new AdventureWorks("Integrated Security=sspi");
var query = from con in db.Contact
where con.LastName == "Klein"
select con;
foreach (Contact del in query)
{
db.Contact.Remove(del);//???Remove not working
}
db.SubmitChanges();
textBox1.Text = "Contact deleted.";
how can i create a backup table for my MySql base table.my base table name is FAB when ever user store the data into FAB table same records should be stored into back-up table automatically.how can i acheive this.i am really thank full to you if any one provide me solution.
View 3 RepliesI need to develop an application, which will get records (orders) from one application and process them. The updates to this records (order updates) will be sent back to the source application for end customer reference. I'm planning to achieve this data synchronization at the database level using triggers and stored procedures to insert database between the 2 databases.
But, the issue is I have to deploy this application in 3 different customer sites and I have to change the database names (cannot use the same database name) in each deployment manually. Because of this deployment issue, I was thinking of handling this within the asp.net application where I can store the db name in the database and then build the query within the application, but I dont want to do it as building queries like that doesnt look very professional.
I touched on this last year sometime, but I was frustrated at the time and might not have made much sense. I'd like to try again to see if I can get some constructive advice. I am having an issue in choosing a persistence engine. My first choice is FluentNHibernate / NHibernate. However, I am having severe difficulties with their criterion and projection mechanisms. Searching for examples is difficult and when I do find something, I really don't understand what I'm looking at. After a year of trying to bring this together, it still eludes me. I know I could just ask here for help with certain things, but you guys have more things to do than sit and teach me nhibernate criterion. My second choice is Entity Framework 4. I am leaving the CTP 5 off the list for now as there is a major bug in how self-referencing tables are handled at the moment. Now, I have two sub-choices here. The first involves using code first by turning off code generation in the designer and place my enities and edmx in separate libraries (.Domain and .Persistence.Mapping) but this involves a bit of extra work. Then again, for simplicities sake, I could just dump the edmx designer right in the domain library. But this means having the mapping info in the domain library. Not ideal, but it'd work. I still retain the ability to map collections, references and properties as protected or private, and add logic-checking accessors to the entities, as well as setting a protected and public constructor. The entities would still be strong, valid business entities. With these points in mind, what direction should I head?
View 11 RepliesI've wasted two hours of sleep on a stupid problem. I have an excel 2003 file (xls) that I'd like to import into a table in Sql Server 2008 Express edition. I've done this before, but I can't remember how it's done really. Here's the problem: When I start DTS, I set the excel file as the "data source" and click Next. Now I'm supposed to name/point to the mdf file, but how do I do that? The only thing that appears in the "Server name" text field is the computer's nameSQLEXPRESS, but the mdf file is of course residing in the web site's folder. Also, what should I choose in the "Destination" drop down menu: SQL Server Native Client 10, Micorsoft OLE DB Provider for SqlServer, or what? Regardless of what I choose, I don't find my mdf file in the "Database" drop down menu below . What am I doing wrong? I imagine it's really easy!
View 6 RepliesI am a final year computer science student from Mumbai University, India.The topic of our undergraduate project is SOA.Under this project we are supposed to build 3 service components and one example website that uses those components.I am quite good with Java and have no experience whatsoever with C# or .NET.I am having hard time deciding the language and platform for our project.Can you please suggest what platform I should go for?Please give me a brief comparison between Java/J2EE and C#.NET/ASP.NET in terms of complexity, ease of development, ease of deployment etc.Edit:The original reason why I put this question is:-
We have to do final year project in group of three. My both partners want to do this project in C# and asp.net and I want to do it in java. Since our project is more of server side, java holds some advantages like cross platform over C#Also this point:-What if we implement 2 parts in C#.net(which they will build) and 1 part in Java(which i will build) and then use them to build a sample website.What level(kind) of difficulty it will accompany?
I have a page on which I've thrown a LinqDataSource and a GridView. I've created a DataContext LINQ-to-SQL class called dcResidents.dbml. When I attempt to configure the LinqDataSource to utilize the dcResidents data context - it doesn't appear in the list of options...though under class view (tab in VS) it does appear.
I do have several other working datacontexts - why is this one not being recognized by VS?
I am returning records from the database and I need to compare those records against my checklist box to determine which ones should be checked.
Query is working properly and returning 3 records.
Vehicle ID = 40, Option ID = 1
VehicleID = 40, Option ID = 36
VehicleID = 40, Option ID = 37
[Code]....
This is not working, can anyone point me in the right direction???
I follow the following link for add dropdownlist in gridview.Adding Dynamic Rows in GridView with DropDownLists in ASP.Net..In this template field the drop down list contain 500 items how can i search the paticular item
View 1 RepliesI've read several other questions on this topic (here, here, and here), but have yet to see a great answer. I've developed my fair share of data access layers before and personally prefer to use instance classes instead of static classes. However, it is more of a personal preference (I like to test my business objects, and this approach makes mocking out the DAL easier). I have used static classes to access the database before, but I've always felt a little insecure in the appropriateness of such a design (especially in an ASP.NET environment).
Can anyone provide some good pros/cons with regards to these two approaches to developing data access classes with ADO.NET providers (no ORM), in an ASP.NET application in particular. Feel free to chime in if you have some more general static vs. instance class tips as well.
In particular, the issues I'm concerned about are:
Threading & concurrency
Scalability
Performance
Any other unknowns
I have a dropdownlist for categories.
DataTextField = "Name";
DataValueField = "ID";
drp.Items.Clear();
drp.Items.Add(new ListItem("--select category--", ""));
drp.AppendDataBoundItems = true;
ID is int and I've got this
drpsub.Items.Add(new ListItem("--select category--", ""));
I want to insert some information plus ID in databaseeverything is ok when user select category from dropdownlist (for example: India, Iran, China) but when the userchoose --select category-- she face an error because the value here is "" not an ID(int value)how can i don't let user choose --select subcategory-- ?
How do I connect from a web application to db2 database?
View 3 RepliesI am developing a web application with back end as Oracle. I call the procedures from web application when ever some update, create or delete for the records needs to be performed. How to maintain the connection in these scenarios.
Can I open the connection and maintain it through out the application till user logs out?
I could do backup and restore mysql database at my web application run time with VWD 2008 Express. But I test these with IIS, any web browser's progress bar is not increased. My code is the same with this link - URL] . Here, Some facts that makes it not process - I think
My database admin has no password. At run time with VWD, Command Prompt appears and ask to enter password. With IIS, this not appear.I run VWD as a admin. So is there any security with IIS?Finally, we will use this web application with Remote or Virtual Server. Now we could access this application from Remote Server via any web browser. So I test this backup portion but it not work. Here, I give the file path - D:DB - that is valid in my client or current pc but IOException generate message 'Device is not ready.' Drive D is not in Remote Server. So I change Drive E: that is valid in Remote Server. This time, Run time error appears and Description is "An application error occurs on the server...". I think that any client can save backup file under his current pc.
[Code]....
Is the "asp.net - oracle" a good solution for web applications?
View 6 Replieshow i can use Oracle database with asp.net mvc 2 web application?
View 3 RepliesMy Application uses two SQL databses, one for membership/roles (ASPNETDB.MDF) the other for my data. When deploying to a server do I have to use two connection strings, one for each database? I am using the publish to provider wizard with VWD 2008 to replicate the databases on Sqlserver 2008 (Windows server 2008 R2). I have my data connection working fine, I am just trying to get mebership and roles working.
View 3 RepliesI'm currently using VS 2008 and I am trying to make my web application to print only 1 specific data set from my SQL database.
For example, i got 3 rows of data sets, how can I choose only 1 data set to be printed?
string reportPath = Server.MapPath("CrystalReport2.rpt");
I have a stored procedure in SQl and i am calling through Entity framework through import functions. Stored procedure is returns columns from 2 different tables.. now what should be return type at Entity framwork end ?
View 1 Repliesi want to search for data in informix using a like('%Name1%') from my .NET application. The query that i have written is something like this:
select * from tableName where columnName Like CONCAT('%',CONCAT('Name1','%')) ......
this query when run from the front end does not yeild the desired result set ......however when i execute it from the db level i get the correct result .... also an intersting thin that i noted is ...if i do a LIKE('%' || 'Name1' || '%') from the front end i get a syntax error ...however this works just fine when i execute the query from the db...... ive spent over 10 hrs trying to figure this out ......but have not found a solution for it on my own ...... also, the following works perfectly :select * from tableName where columnName LIKE CONCAT('%','Name1') .....from the application...
likewise select * from table name where columnName like CONCAT(Name1,'%') works ...........* the vale fields need to be replaced with a '?' in the front end ...informix automatically replaces it when executing the command statement....so the commantext for all informix commands look something like this :
select ColumnName from tableName where columnName1 LIKE CONCAT('%',CONCAT(?,'%'))
parameter is 'Name1'
I am supposed to develop an enterprise-class ASP.NET Web Application that connects to multiple databases. For example when the web form loads, I should populate different ASP.NET controls (GridView, DataPager, TextBox, DropdownList etc) from multiple databases (SQL Server, Oracle, DB2, SAP Server etc) and also, edit the data in the controls and save the data to the respective databases on button submit.
Should I use Web Service or WCF for data integration, if so is there a limit on the size of the data?
What should be the architecture considering the application should be scalable and easy to maintain?
at our office we take daily backup of ASP.net application ms access backend for the next few days we need to evaluate the changes made to records in the database tables at the end of each day i want to compare 2 access databases first database is the backup of yesterday and second database is the backup of today i thought of the following algorithm, how to proceed to compare the datatables / gridviews
i need to display th rows / cells containing the differences / updates / deleted data
[code]....
I have a web app where user uploads a file.ile is saved in server locally and I want to read some data from it.Currently my development server has office 2003.So do I need office 2007 in order to be able to read an excel from office 2007 ?
Microsoft.Office.Interop.Excel.Application excelApp = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Workbook wrkBook; // = new Microsoft.Office.Interop.Excel.Workbook();