I want to create web application. I use SqlServer 2008 and asp.net (framework 3.5 sp1).
In my task, user can create database arbitrary structure. and i must write system that generate web site by template. is it possible?
i am new to WebServices, i have a ClassDataLibrary.dll which include classes like Users,Products,Articles...
i want to create a structure like this in my webService. as i saw the examples of creating web services the web methods written on the same page. but i got over 50 methods in dll and i want to share these methods with flash so flash user get data using my webService but it will be difficult to find the method he wants so i want to give my webService in a structure like:
Service1.Users // he will finds the methods about users
Service1.Products // he will finds the product methods
how could i do it ? is there any example or something to share with me?
I am setting up a routine whereby I have to copy the results of a MySQL stored procedure into a DataTable so that I can add fields to the end of the result.
Normally I would convert the Msql DateTime to something that I could more easily manipulate; however, the existing code that I have specifically addresses the MySql DateTime type in too many ways to easily change.
So I thought I could do something like this:
Code:
myDataColumn = new DataColumn("ETD_DT");
myDataColumn.DataType = System.Type.GetType("System.DateTime");
returnDataTable.Columns.Add(myDataColumn);
And substitute "MySqlData.Types.MySqlDateTime" for "SystemDateTime", but it fails with "Column Requires a Valid DataType".
I am trying to create a TreeView nested structure with the use of self referencing table fields. Here is a simple example:
Category 1
Product 1
Toy 1
Toy 2
Product 2
Toy 3
Toy 4
more categories.. The database table has a single table called "Category". The ParentCategoryId points to the Category which is the parent. So, for the Category 1 the ParentCategoryId is null since it is parent. For Product 1 the ParentCategoryId is that of the Category 1 id and for Toy 1 the ParentCategoryId is that for the Product 1 id.
I am using the following code but it does not generate the TreeView (ASP.NET) successfully.
public void BuildTree(List<Category> categories, TreeNode treeNode)
{
if (treeNode == null) return;[code].....
I am not new to ASP.Net application development but I haven't used some of the new frameworks or features that are used in applications these days.
For cross-cutting concerns, things like: Logging, Caching and DAAB are used in projects these days to implement proven and efficient source code from either Microsoft or other third party vendors such as Log4Net for logging purposes.
i want to copy the structure (with the documents) from our vss server to an webserver. Therefore i want to create an application which is on this webserver. i want to use asp.net.
i don't know what exactly i need therefore :> I have to build somekind of connection? then go throw the structure and copy it somehow :> ?
important: i want to copy the documents with the right creation date ( it changes when i just copy the doc.)
are there APIs for asp.net <-> vss?
I have a series of SQL database tables but would like to be able to have a table entry that can support a list of primary key's for another table - how I can do this?
View 1 Repliesi have one database named as sampleDB its having more than 100 tables. this database running on production. here we have one requirement need to add companyid feild all the tables in our sampleDb. is it possible to write query to alter all the table.
View 3 RepliesI am saving relative path of files in my DB as string. I want to create a treeview from this input. There can be multiple folders for a file path.
View 1 RepliesI've created a deployment package in visualStudio, the package is generated, but it has an awfull structure, which is basically, the path where I've my project(e.g "CONTENT/D_C/WorkSpace/MyCustomer/TheProjectName/TheDevelopmentBranchFolder/TheCurrentBranch/TheWebApplicationName/obj/Release/Package/PackageTmp/TheSiteIsFinallyHere!!!"
It's problematic, because with the web deployer of IIS, it recreate this path.
So how can I avoid the "D_C/WorkSpace/MyCustomer/TheProjectName/TheDevelopmentBranchFolder/TheCurrentBranch/TheWebApplicationName/obj/Release/Package/PackageTmp" part in visual studio?
I have an SQL 2008 DB and I need to transfer the structure and the data to an off site, off network database. I need to somehow create a physical file that represents the structure and data within the db that can be loaded in another instance of SQL Server 2008.
View 1 RepliesI´m about to program a common application/website scenario. It contains pages which are presented to users, and some business logic behind, with a database connection class.
My questions are:
Q1: Should the database class be singleton? If so, why? Because does it even matter when every single user is in their own process on the server, and therefore each user has their "own" singleton database instance?
Q2: How would you normally direct users around the site? Would the Default.aspx page create instances of the required classes? And when the user is directed to a new page, how would you normally refer to these instances?
Q3: What kind of general information do you save in the Session variable? Is it a big no-no to save class instances?
In my form there are about 6 parameters and two of them have multiple values, upto 6. I'm imposed by the restrictions that I can't change the table structure. The table have 8 fields one for ID as primary key, one for foreign key and other to store data. The two fields which have multiple values are color and size. A size may have different colors and vice versa.
The programmer which have developed the site earlier used a stored procedure to store the data in database. And he implemented the above scenario one by one for each color/size. Now I have to put all in one.
How can I do this. As I can't change the table structure at current moment as this will disturb the whole E-commerce site.
In classic ASP I would write some logic to get a nice menu on the site, but now with the Menu-control, it's as easy as it gets.. Maybe to easy. I can't quite figure out how I would do this.. I have a multilevel navigation structure (from a database) that I want to put into the Menu-control, but I don't know which approach is the best/easiest way for me..
I'm all into performance, usability and all that.. The only thing I have really decided is that I want to use the Menu-control, I haven't decided what datasource I should use or how to style the individual links my way The data is coming from a database and is not supposed to be changed very often (maybe once or twice every month).. Thought of making an XML-sitemap, but also of making some sort of SQL-hookup.. I'm leaning towards the XML-sitemap because it wouldn't take long to generate the XML every time the navigation changes and that won't happen very often. The next issue is styling, how to do that? I have the neccesary css ready for the individual links, but I'm still unsure of how to get it to the Menu-control.. The css I have looks like below and in its current form is intended just for the anchors
[Code]....
Currently, on our production IIS web farm, we host about 15 applications in a single App Pool (Default App Pool). There are two websites and about 13 virtual directories.A colleague has recommended that we change our IIS configuration so each application is a separate App Pool (with identical settings).
Is there any drawback or potential issues to doing this?Is it possible that ASP.NET applications could have been built with the requirements that they are all within the same App Pool?
how to migrate an existing database from a specific application to a new Ms Access based application(database)?
View 4 RepliesI am looking for some adivce about the possbility of doing the following while working whith MVC. Firstly sorry if the subject line is not very descriptive. I have put something together in ASP WebForms where by I can put a few core fields on my page that identify an object, e.g. a Name and ID... and then I can add arbritrary fields to the aspx page that are now saved and retrieved with the "owning object". These extra fields are stored in a seperate table on the database to the primary object fields. A short explanation of how this works:
1. I have my own version of TextBox (and other input controls) called r3d:TextBox (etc.) and this text box has XmlParent and XmlElement tags, this is done by way of an interface.
2. I have a r3dBase page that all my forms inherit from and this page check for the existstance of any r3d:TextBox (and other input controls) that have the XmlParen and XmlElement tag defiened.
3. When an iheriting form is saved the controls with the Xml tags defined are also saved, but I don't have to change any code in the code behind pages. The framework I have put in place takes care of this for me. The data is saved
4. When an inheriting page is loaded all controls with the XmlParent and XmlElement tags are populated with any data that has previously been saved for them that belong to the main object being displayed on the page.
This provides for a nice easy way for me to extend my forms with non core data when clients request new fields. It also means that different clients can request different new fields and I don't have to make any modifications to the core objects. I have another mechanism that determins what fields are seen by which clients.
Anyway I am completely new to MVC (not written a single line of code) so I have no idea as to whether this paradigm will lend itself to the above described mechanisms or not. Does any one have anythoughts about this, approaches I might try to achive the above to of functionality or perhaps completely different suggestions that would achive a similar end that might work well with MVC
I have a question about Html.ActionLink.
Imagine:
@Html.ActionLink(item.title, "Singlet", new { id = item.blog_id })
produces http://[url]/[controller]/Singlet/[id]
But what if I want to suffix some more arbitrary data at the end? For example:
http://[url]/[controller]/Singlet/[id]/#comments
To jump to the comments div. I know I can just make the string myself with something like:
@( new HtmlString(String.Format("<a href="Blog/Singlet/{0}/#comments">link to comments</a>", item.blog_id)) )
But I am hoping there is a cleaner way, perhaps with ActionLink?
We have a web portal product from which we customize portals from customers. We use the precompiled web app and create a virtual directory (vd) where the customization resides. In addition to this we do some changes web.config in the web app folder. We would obviously like to keep these customizations under TFS source control.
When I try to add the precompiled web app (which I don't want to add to source control), a warning tells me that the vds cannot be added. If I only add the folder that is referenced to by the vd, I lose the references to assemblies in the precompiled web app.
My questions are:
How do I structure a solution for adding IIS (sub application level) virtual directories and still retain the references to assemblies? Is it possible to add other directories/files from the web application level (like App_Theme, web.config etc.) to the solution?
Since we already use Visual Source Safe, we have established a tree structure for each customization project:
Project Root
|
|-Custom Sql
|
|-Custom Portal Files (which is added as a virtual directory)
|
|-Other Customizations
I could probably do a lot of this manually through the source control explorer, but I'd like to have everything done through a solution.
I've followed the instructions using this article: [URL], but this doesn't address the exact problem that I have. Oh, and we are currently using Visual Source Safe for portal customizaton, but are eager to make the move to TFS.
My skills are failing me, and I know I've seen the code around for this but I can't find it. What's the quickest way to take any arbitrary URL, run it through your asp.net mvc routing system, and come out with a reference to a controller instance on the other end?For example, code execution is inside some arbitrary controller method. I want to do something like this:
...
string myURL = "[URL]";
RouteData fakeRouteData = new RouteData(Route???, IRouteHandler???)
RequestContext ctxt = new RequestContext(this.ControllerContext.HttpContext,
fakeRouteData);
ControllerFactory factory = ControllerBuilder.Current.GetControllerFactory();
Controller result = factory.CreateController(ctxt, controllername???)
I'm trying to get an instance of a controller just like the routing system does, regardless of where the code is executing. I'm unclear as to how to fit the pieces together at this point.
Given an instance of an HttpContext object, is there a way to determine the CurrentCulture and/or CurrentUICulture for the thread it is executing on? Or more generally, is there a way to gain access to the current thread under which it is running?
View 1 RepliesIs it possible to say something to the effect of 'SomeClass.Out.WriteLine("hello world")' and have it actually show up for the browser to render? I ask, because I notice that the HtmlHelper BeginForm implements IDisposible. So at the end of the using block, a closing tag is written to the browser.I am not saying I would use this practice, as it seems like a bad idea, but I just want a better understanding of what is going on under the hood of C# ASP MVC.
View 1 RepliesIf I were to respond to an http request with a plain text in PHP, I would do something like:
<?php
header('Content-Type: text/plain');
echo "This is plain text";
?>
How would I do the equivalent in ASP.NET?
How may I post arbitrary data to a REST WCF webservice? I mean, wihout use contracts.
Because my data is dynamic and I cannot have contracts, I want to get ride of the serialization overhead.
How should I declare my service and method?
I'm looking for a good way to add arbitrary properties to the objects in a strongly typed list, based on the principle that I shouldn't pass a DataTable from my business layer to my presentation layer.For example, I might have a Category class with the properties CategoryId and Title. On one page I would like to fetch a list of all categories (ie. List<Category>) together with the most expensive product in each category.A while ago, I would have just returned a DataTable with some additional columns in it with the product data in, but I'm trying not to do that -- it would be trivial to set up it's not good practice. One option is to add a MostExpensiveProduct property to my Category class, but I might want to display the most recently added product in another case, or the cheapest product, so I'd end up adding a lot of properties to cover all the options. This just doesn't feel right to me.Am I missing a trick here? What is the best way of doing this? Or should I just be returning a DataTable to which I can add as many columns as I need and not worry about it?
View 3 Replies