.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Master Table

Posted By:      Posted Date: August 30, 2010    Points: 0   Category :ASP.Net
My application consist of region,compaign(IBM,Microsoft,Dell),Line Of business(lob),weekly schedules of employees,Employee Data.User(Company Authorityuploads weekly schedules of the employee by selecting region,Compaign and LOB in dropdownlist. Should i need to use master table for this,if yes can i use same master for the all the compaigns.One authority may upload dell copmaign data with 500 employees schedule,another authority may upload microsft compaign schedule. Give me table struture for this. EmpNo,EmpName,Monday(date and tiimings in and out).sunday,Region,Compaign and LoB

View Complete Post

More Related Resource Links

Master Page and table layout

Hi, i am in the process to learn create master page using HTML table layout.I find out many resources online that use table to design their master page layout.I have 1 thing that i do not undestand:all of them using heigh= n pixel to control their footer, header, content  and navigation menu.My concern is that by doing so, the master page is fixed to only particular resolution only.In future there might be higher resolution available, the master page design need to be changed from time to time which is considered not so good programmer.OR in future, the when site need to have something like "Best view in resolution 1024 x 768", somethign like that...Is there any other way not to do so? Are they doing their master page correctly?

retrive details records as a field in master table


I have 2 tables:

Student table with Id, Name fields

Phone table with Id,StudentId,PhoneNumber

Now, I want to show student list with all it's phone numbers in 1 row.

this query: "select student.*, phone.* from student inner join phone on student.id=phone.studentid" shows me the list of students with duplicate per each phone number.

I want something like this:

1 paul       66665566,7766665

2 ben        5566556,8877667

3 sam       4444334,3454332,7656765

Please on how to check updated records in a master table.


I have two tables. One is holding records temporarily while the other is master table. I am trying come up with a sql that will be picking a record at a time from temporal table then check is if the record has been update dated in the master table. If it has been updated it does nothing else it updates. Now I am having challenges. The table fields are as follows: Please help


Master table

Id   Firstname  Surname  Location  Amount   status  Position




Temporla  Table

Id   Firstname  Surname  Location  Amount   status  Position

first ssis project - with master child table


Hello all,

I'm planning to develop a new SSIS project where I have a data in a table (Raw form) and I want to put into our production database. I just want to start with a test project and if you provide me little inside that will be helpful.

Here is what I'm trying to do

Typical order table (Order Header and Order Detail)

Temporary table with raw data which need to import in Order Table.

Order Header contains auto increment primary key which needs to be in order details table. So how should I develop a project where I go thru each record of temp table, write a record in order table, get order id (pk) and write data in order detail table.

Hope it is very much clear.

Hopefully I will get expert advice soon.

Thanks in advance,



mark it as answer if it answered your question :)

SSRS Reporting with Sub Report or Master-Child Table.


I have a list called "Product" which contains list of products with category. The product is available in More then one category. The product category is available in list called "Category".

Following table explain how the data is strored in the "Product" List. 

Product ID   Name   Category 
P1  Product1  Cat1
P2  Product2 Cat2
P3  Product3 Cat3
P4  Product4 Cat1, Cat3
P5  Product5 Cat2, Cat3
P6  Product6 Cat4
P7  Product7 Cat1,Cat4

Now i want the data to displayed SSRS report in following way. So kindly provide valueable inputs to achive same. 

asp:Content is displaying over the table of Master. Why?



I have a div like this and a CSS style sheet

<div id="item">


	width: 100px;
	height: 100px;
	/* margin: 10px auto; */
	top: 300px;
	position: relative;

I have a <table><tr><td><asp:button id="XXX" runat="" text="XXX"></td><td></td><table> My problem is what ever the items i add in <div id="item"> it displaying over the button XXX. Why? Iam using master page and my content is in second TD. How to solve this?

Export Visio Database Table Names to Excel

If you use the Enterprise Architect edition of Microsoft Visio for data modeling regularly, then there is a good chance that at some point you've wanted to export just the table names into Excel. You might want to do this to map logical ERD entities to physical data model tables, track project status by entity, or track overlap between database versions.

Master-Detail with the GridView, DetailsView and jQuery's ThickBox

One more article about grids from Matt Berseth. This time he shows how to create master-detail with the gridview, detailsview and jQuery's ThickBox. He writes:
So I thought I would check some of this out and along the way rebuild my Master-Detail with the GridView, DetailView and ModalPopup Controls and replace the ModalPopup with jQuery's ThickBox. I found it pretty interesting - read on to see how it went

GridView inline Master/Detail record display

This code drop is part of a smash and grab series. If you're in a rush, you can just grab this code and insert it into your application, no understanding is required. When you have some time (ya, right) you may want to review the source code.

Insert value using Table Value Functions

a real gem in Sql Server 2008. mostly people still using Stored procedure may be they shifted to SQL Server but they are not using TVF right now.

Master-Detail with the GridView, DetailView and jQuery's ThickBox

An example of using the jQuery ThickBox with ASP.NET's GridView and DetailView controls

Using jQuery to Filter Table Rows

The project is using the .net GridView control, so I had limited control over the output HTML code. Still, I think this code can work for most tables. One thing to notice: you should use the class "filterable" on your table or on one of its parents for the code to work.
First, we need a text box:

RadioButton Groups, Table Rows And NamingContainers in asp.net

The RadioButtonList. Very handy for inviting users to select just one item from a list although because of the screen real estate it takes up, used less and less in favour of the DropDownList. In plain HTML, the browser knows to enforce the unique selected value amongst a list of radio buttons because they all have the same value for their name attributes.

RadioButton Groups, Table Rows And NamingContainers

(In which AJAX-enhanced CheckBoxes become more useful than RadioButtons but inheritance saves the day, and a simple RadioButton-derived control establishes the purpose of a control's naming container)

The RadioButtonList. Very handy for inviting users to select just one item from a list although because of the screen real estate it takes up, used less and less in favour of the DropDownList. In plain HTML, the browser knows to enforce the unique selected value amongst a list of radio buttons because they all have the same value for their name attributes.

Building a 3-Tier App with Silverlight 3, .NET RIA Services, and Azure Table Storage

Silverlight 3, .NET RIA Services, and Windows Azure Services Platform makes a 3-tier Cloud application easier to build: Silverlight 3 as presentation tier, .NET RIA services as the business logic and data access tier, and Windows Azure Table as the data storage tier. The sample application in this article demonstrates the architecture with a simple Survey application with all these technologies working together from Windows Azure.

GridView control to show master-child or master-slave data, written in c#, asp.net

I previously made a master slave datagrid using Visual Studio 2003 .Net (original article) that would allow users to show data to clients using collapse and expand features. These features however did not carry over to gridview for many users. This tutorial will explaing how to create a collapsable/expandable gridview in frameworks 2.0 and higher

Master Pages in MOSS 2007

'MasterPages' feature in sharepoint 2007 makes the entire customization job easy.In 2003 we used to face lot of issues to get the same look and feel and the standard behaviour for overall site. In 2007, customizing the look and feel for the entire site can be done in a simple way by using 'MasterPage' feature.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend