I'm new in asp.net .... I want a tree view to the family member that stored on database.SQL server
I have 2 table
one for username password
and the second one for family member
contain member name and relation like wife , mother ..
how i can do that
2 table enough or I need more table?
I am looking for any source code for my website to include a genealogy. I am not having time to build it up from the scratch. If any one can provide me the libraries or any partial code, so I could use it
View 2 Replieshow to create database tree view using jquery
View 2 RepliesI am an experienced .NET developer with approximately 5 years of experience. Unfortunately, I have worked primarily on the back-end and as an desktop/smartclient developer. I have worked as a consultant for a total of 1 1/2 years on web development using both the MVP pattern and some Silverlight. I am wanting to develop a personal site, (My wife is due with our first in 7 months!) and figured while I was at it I would target particular technologies that I want to learn. Being that my current employer
uses Monorail with NVolocity and is plannning a migration to ASP.NET MVC with (most-likely) NVelocity, I figured that would be a good tech stack to use. In addition, I would like to add JQuery to the set-up.
I have done several ASP.NET MVC tutorials. Including one on this site (Great job!). However, adding NVelocity and JQuery to the mix muddies the water a bit for me.
So, my question is, does anybody have advice of where to start? Do you know of any good books, online tutorials, etc.? Do you think this is a good stack to use? Better view engine?
I am new here so I will try and give you as much detail as I can:
(C# + SQL)
I am developing a web site that has holiday prices which are taken from a different database and loaded into two SQL databases.I have two girdviews to display each of the prices data.What my issues is that I need to load an SqlDataSource on database 1,when 'Family' is selected from a dropdown list and run an SqlDataSource on database 2 when 'Themed' is selected and then run both when 'Don't Mind' is selected.
how to create C# classes to represent one to many relationships in C#. I have a Customer and an Address table in my database. I also have a Customer class in my C# solution but how do I introduce the multiple address element? Do I have a separate Address class? Do I create a subclass in the Customer class or create a method in Customer called GetAddresses of type List which contains all of the relevant logic? In my code I need to be able to return a customer with all associated addresses and I just cannot picture the best way to achieve this using OOP.
View 9 RepliesI'm having a hard time wrapping my head around how to use the Memberships in MVC. I know there is the built in ASPNETDB database which has all the basic tables for users and such. But what if I wanted to add a relationship between one of my custom tables and this built in user table?
If I had a database table that contained blog comments, we'll call it Comment. And each Comment had a userID associated with it could I do something like?
User.Comments.Add(someCommentObj)
I have a table that contains item data. If the item is a particular type further information exists to describe the item. The additional information isn't that heavy however the number of records in relation to the main file will be quite small (less than
5%).
So I have 2 scenarios:1) Put the additional data in the main table and take tha hit on storage
2) Create an additional table and link the 2 together
If we were talking huge amounts of data I can understand that 2) would be the obvious choice but given the simplicity should 1) be a consideration?
If 2) is the answer - is it possible to create a dependency between the 2 tables when the item is 'that' particular type. In other words wnsure the addition data is populated for the required items and not others.
Can someone help me create a tree view like radio button list? Say I have 2 radio buttons. When they select one radio button it will populate a sub radio button. The user than make his/her selection and click submit.
View 7 Repliesi want to use the tree view for the menu,
how to create the tree view in using user control.
how to create a tree view using a text file i have a textfile..ab.txt...................
Personal
lmnk................................................
Qualification Educational[code]...
how to create a tree view with node
Personal;Qualification Educational;
Experience
I wanna use font in my vb.net website but i found difficulties.
View 1 RepliesI just want to build a quad/Binaray tree in my Webform the data is collected from the DB how it is possible.
Now i am bulding a sample application that deals the all activites of chain marketting(network ) marketing system here i have to build tree from the data base to webform for displaying the bussiness growth of a customer.
SRS:Each customer can add 4 child under his name .My Table format is follow
Table Name:tbl_bussinessData
perentID:-store perant id
leftMiddle:store the iD of first child
left:=store the ID of Second
rightMiddle:=store the id of Third Child
right:=store the id of fourh child
from this structure of Database how i can build a tree upto 10 level or give some advice in DB desin or show some Example
NB:Not drawing or implimenting Binary DATA STRUCTURE
I want to create a Tree View using XML that is fetched from SQL Server. How I can directly assigned to tree view, the below code I tried, but throwing error 'dsXML' is not an IHierarchicalDataSource. The XML heirarchy is proper. When I use XmlDataSource with the xml file, tree view is shown.
<asp:SqlDataSource runat="server" ID="dsXML" ProviderName="System.Data.SqlClient"
ConnectionString="Data Source=Server;Initial Catalog=database1;Persist Security Info=True;User ID=userid;Password=password"
SelectCommandType="StoredProcedure" SelectCommand="spGetXML">
[code]....
how to create a tree menu in asp.net using vb and connect it with microsoft access database , can I do this and How.
View 5 RepliesI have three tables
tbl_Cus CatID (Int) CustID(int) CabID(int)
tbl_Cat CatID(int) CatName(varchar) CusID
tbl_Cab CatId(int) CabID(int) CabName(varchar)
I am using Tree View control for the first time.
The above tables I want to bind it to a tree view control the tree view should look some thing like this.
Cus Name1
Cat Name1
CabName1
CabName2
CatName2
CabName1
CabName2
Cus Name2
Cat Name3
CabName1
CabName2
CatName4
CabName1
CabName2
Is it possible to create a route, who accepts a random number of Categories/subCategories and is still able to understand /ProductID/ProductName where Product ID is an int and ProductName is a string.
[Code]....
Perhaps using a custom route handler.
I am looking to create an employee hierarchy in a trace tree and have 2 specific fields in my table ( employee , reports to )
Now a sample data looks like follows
Employee Reports to
User A Manager A
Manager A Senior manager A
User B Senior Manager A
User C Manager A
so on and so forth
Now how do I get a trace tree so that when i click on Senior manager A I get Manager A and User B , and then expand manager A to get user A and User C.
I want to create the structure like following 1. Main Area 1 A. Sub Area 1 B. Sub Area 2 2.Main Area 2 A. Sub Area 1 B. Sub Area 2 Whenever I will click on main area or sub area it should re-direct to that page and also, if add new area in database it should reflect in the structure Also specify me whether should i use sitemap for this?
View 1 RepliesI have two control page in my aspx page. first one left side "tree view",second one right side " form design".Form design will change based on tree view selected index changed.i have 4 level child node(site, master , slave, space). I have seperate forms to each level of node.
cannot update tree node when update the forms. so i reload tree view.
now i need how to auto selected index change to tree node.
ex.
1 parent node
1.1 child node
1.2 child node
i have update "1.2 child node" rename to "1.3 child node"
and reload treeview so it will chage...
how set tree node.selected index = 1.3 child node....
(1) SELECT a.HD, a.HEAD, a.SH, a.SUBHEAD, a.TRK, a.TRACK, a.TGT, a.TARGET, a.PDC, a.DT_RELEASE, a.STATUS, a.CO FROM V_HIERARCHY1 a
(2) and Data is
HR HR Rec Records Leave Leave Records HRL.0001 Policy and Process for leave record. 27.06.2010 30.06.2010 WIP Edlink
HR HR Rec Records Leave Leave Records HRL.0002 Quarterly Review 01.07.2010 04.07.2010 Planned Edlink
HR HR DB Database SAL Salary DDS.0001 Calculation of Monthly salary 08.08.2010 09.08.2010 WIP Edlink
HR HR Rec Records Ind Induction Records HRI.0001 Completion of dossiers. 08.07.2010 10.07.2010 WIP Edlink
HR HR DB Database Emp Employee HDE.0001 Offer letter 06.07.2010 09.07.2010 WIP Edlink
IT Info Tech SW Software ERP.Web Web based ERP ISE.0001 Version 1 10.07.2010 12.07.2010 Overdue Edlink
I am writing an application in which a remote url web site ( says url1 that is sender) sends xml data to another web site (says url2 that is receiver) by using .NET WebRequest. On the receiver url2 if I use .NET Page.Response and .NET Page.Request to store posted/received xml data into an external text file, then the data is stored. However, if I store the received data into database, I do not see the data is stored into the database.
trouble shoot the codes so I can store such remotely posted data into database on the receiver side url2.
I host both url1 site and url2 site in my computer using IIS like [URL]
1/ Receiver page's codes that store remotely posted xml data into database do not work:
protected void Page_Load(object sender, EventArgs e)
{
Page.Response.ContentType = "text/xml";
StreamReader reader = new StreamReader(Page.Request.InputStream);
String xmlData= reader.ReadToEnd();
ProductNameSapce.ProductCollection.InsertReceivedProduct(xmlData).ToString(); // data is not stored ; the method is tested and works well with hard-coded data
reader.Close();
Page.Response.End();
}
2/ The version of the receiver page at url2 that stores into an external text file works:
protected void Page_Load(object sender, EventArgs e)
{
Page.Response.ContentType = "text/xml";
StreamReader reader = new StreamReader ( Page.Request.InputStream );
String xmlData= reader.ReadToEnd ();
StreamWriter s;
s= File.CreateText ( Server.MapPath(".")+@""+ Guid.NewGuid () + ".txt" );
s.WriteLine ( xmlData); // data is stored in an external text file
s.Close ();
reader.Close();
Page.Response.End();
}
I suppose this question has been asked to death all over the web, but I can seem to find a clear cut answer. What I am trying to achieve is as follows: I have a web application that lists various products, their descriptions, names etc and also an image of that specific product. The user will type in a product code or name of the product and a page will pop up with al the previous mentioned info and image or images of that specific product. The problem I am having is: I read somewhere that storing images in a database is 'bad idea' since it effects performance, then I read somewhere else to keep it in the images / or app_data folder. But what would be the best approach and how would I call it from the database (if that's the best way)? And if App_Data / images are the way to go how many images can I put in there (??) already the product catalog has several hundred images of various products. So how would one go about sorting everthing in those folders without having a few hundred images rolling down in my solutions explorer.
View 5 RepliesI have a web application, which I have a SQL express database attached. I tried to upload a Japanese character into a varchar (max) column, and the result when displaying in the web page is '?'.
I tried to fix by the web config and in the page display to display japanese but it doesnt work.
I am building a website that have a number of dropdownlists. The user selects his/her choice and this is sent to a number of companies. Therefore the choice has to be changed to the corresponding value of the individual company i.e value 1 will be coverted to the corresponding value of "AB" for company "x". What way would be most efficent to achieve this. A database seems to be unefficent with the calls to the database. Would a 2-D array in a class be best?
View 2 Replies