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

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

Table name Change

Posted By:      Posted Date: October 03, 2010    Points: 0   Category :Sql Server

Hi all I need to change the name of a table from Student_ind to Student_tbl.  There are three tables that have a relationship with it, is there a nice and smooth way of changing it without upsetting the Relationships involved??

View Complete Post

More Related Resource Links

Change grid view from table to other HTML layout



You'll have to excuse my ignorance, I'm coming at this from a front-end perspective, and don't really know how to deal with data views in ASP.NET.

Basically, I'm trying to change the layout of some repeated data from a straight table, to something more design-heavy.  It's the same data, just re-organised slightly.  The current ASP.NET code looks like this:

                    <asp:GridView ID="GVMoments" runat="server" AllowPaging="True" AllowSorting="True"
                        AutoGenerateColumns="False" PageSize="20" RowHeaderColumn="FirstName"
                        SkinID="GroupSkin" DataKeyNames="moment_id" 
                        <PagerSettings Mode="NumericFirstLast" PageButtonCount="20" Position="TopAndBottom" />
                        <RowStyle />
                                <asp:BoundField DataField="moment_id" HeaderText="moment_id" ReadOnly="True" SortExpression="moment_id"
                                    Visible="False" In

How to change connection string of a pivot table pointing to SSAS 2005 cube using excel 2003?

Hi All,I am not sure if I should have posted this query to Excel 2003 forum. But posting it here as it applies to SSAS 2005 as well.Ok, let me give the background before I tell the actual problem.We have users on ABC domain and the SSAS server is also on ABC domain. Users on this domain can acess the excel pivots by connecting to cube to browse the data. They leave the Userid & password field blank while they setup the connection string and it works fine. Thanks to windows authentication that takes the credentials of user logged in. Let's say I have two users A and B, they login to ABC domain with their own windows ids.  Now when user A creates a excel file having a cube pivot and then sends this file to user B, user B can refresh and modify the same excel file (he can select new measures to pivot, new hierarchies in filters and so on).Now, let's say I have another user, user C. He has excel 2003 installed on his PC and cannot migrate to excel 2007. He is on different domain XYZ but have a valid windows userid on domain ABC. The domain ABC & XYZ can not be setup to have trusted relationship. Now, when user A sends the same excel file to user C. When user C opens the file and try to refresh it or try to modify the pivot by selecting/deselecting any elements, he gets below error prompt:" An error was encountered in the transport layer." and "Errors in the

Managing TypedDataSets when there is a change in backend Table / Stored Procedure / Database schema

Hi All, I am just curious to know if there is any easier way to synchronize the TypedDataSets with the chages made to backend Table / Stored Procedure schema.  I use Typed DataSets in my project extensively and I found them very useful and easier to code, but difficult to maintain  The difficuly I have always faced is whenever there is a change in a backend database table structure or stored procedure that is linked to any of the Typed DataSet in our project requires to recreate whole DataSet again by scrapping the old one. The backend changes will not be reflected unless and untill you recreate the whole stuff again. Is there any easier way to synchronize those typed datasets with the changes made to backend database schema or any other workaround that will not required to recreate the whole DataSet again.Hope above question makes sense. Any ideas.

List.aspx:datagridview Change the links to parent table from Details to list


The List Page display  child Entity using the  gridview each row will have  link to the  parent 


How can I change the link so it shows the parent but in list view(using list.aspx) not detailes (detailes.aspx)view






I checked the



List.aspx:datagridview Change the links to parent table from Details to list


The List Page displays a child Entity using the  gridview, each row  has a to link to the  parent in detailes view how can I change to list view .

use list.aspx?parent=32 not detailes.aspx ?parentId=32

How Prepopulated Table will Change into the client PC with minimal effort.


Hello Everyone

I am using SQLCE and some prepopulated table,
but whenever master data will chage so we need to chage my whole code.
Wherever I had wrriten my Category and CoAName so is there any way we can't change my code,
but I am able to access my CoA(Chart of Account Table).


An Error when trying to change the table


When I'm trying to change somthing at my table, on saving I get an error massage to "Drop or Re-create" the table.

How can I change or add parameters in my table without re-creating it all the time????



EF4 DD site, change the Display Name of a table?


I'm using .net 4 with a link to entities web application, and I"ve got the data annotations starting to work, but I'm wondering if there is a way to display a friendly name for my tables?

this code gives me a compilation error that says:

Error 1 Attribute 'Display' is not valid on this declaration type. It is only valid on 'method, property, indexer, field, param' declarations. C:\Kens Files Oct 2010\Visual Studio 2008\Projects\ManagementAndDiagnosticsWeb\EFWebApp\EntityClasses\ScaffoldRules.cs 37 10 EFWebApp

public class ClientMachineMetaData

how to table row click row color change in jquery


how to table row click row color change in jquery

  i have two row

<table id="abcd>  



      <td>  Name </td>





      <td>  Name 2</td>




when i click in Second row than Second row color is red and (2) green

when i click in First  row than First row color is red and (2) green

How to change data format in result coming from SQL table


On one of my webpage i am displaying datalist in which i am using this label:

<asp:Label ID="nameLabel12a" runat="server" Text='<%# Eval("CreatedOn") %>' />

This label is displaying created on date along with time (10/18/2010 2:45:07 PM), but i would like to display it something like this:

7sec ago

20min ago

30min ago

23 hours ago

10/3/2010 (if the time is more than 24 hours then it should display the date)

how to accomplish this ? please guide me...

With Excel pivot table client using SSAS cube, how to change the measures to rows?

I want the measures as rows instead of columns in Excel pivot table on a SSAS 2008 cube. How do I do that? Thanks.

How to make sure that the entire table tag won't change ?


Hi everyone,

I know this sounds a bit noob but I still don't know if there's a way to do this or not. Let's say we have 3 columns. 2nd column (the middle one) is populated with a detailview when the user click something on the first column, then it shows in the middle column detailview. So, it's like

column1        column2(middle)        column3
Something    DetailView                  Something more

But the point is, if the detailview is a bit longer, then the entire table size change. column2 becomes very long and column1 and column2 also changed their style by shrinking the same size as in column2. I have no idea if there's such way to make those layout flexible. I don't seriously wanna limit the height of the column2 from CSS though. Thanks all.

You cannot add or change a record because a related record is required in table 'Member'.


Hi, I am using Table Adapter to insert records into my database. I first insert my member record into the database and it has no errors, after that i insert the contact records into the table. however I got the following error:

You cannot add or change a record because a related record is required in table 'Member'.

This is my code:

              For index = 0 To contactList.Items.Count - 1
            newContactRow.memberIc = memRow.nric
            newContactRow.number = CType(contactList.Items.Add(index), String)
            Contactdt = CType(ds.Contacts.GetChanges, dbDataSet.ContactsDataTable)
            If Contactdt IsNot Nothing Then
                    MsgBox("Contacts have been added into database")
                Catch ex As Exception

                End Try
            End If

Memdt = CType(ds.Member.GetChanges,dbDataSet.MemberDataTable)
        If Memdt IsNot Nothing Then
                MsgBox("Member has been added into database")
            Catch ex As Exception

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.

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.

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.
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