.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

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

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

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


View Complete Post

More Related Resource Links

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.

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.

change the PHP page with WCF service on Servers only, without chnging code on the calling client sid



I need to change the PHP page with WCF service, but the problem is that many of our clients are sending(usig POST) large stream data like binary files to our PHP website, now we are upgrading our system and moving towards wcf services,

The problem is that we want our clients to only change URL, and do not need to change any code in their calling mechanism or no need to create proxy on their cliend side. We simply change php to wcf services on our Servers only. Our clients are using .net 2.0 client application. Is there any way to do this. or Is this possible ?

One thing which I get from internet is use Rest based wcf services.

Have anybody some example or idea to accomplish my task.


how do i do a minimal client tool install to execute SSIS packages


I am trying to migrate our processing from command line based scripts and foxpro to SQL so I need to run the SSIS packages using dtexec. I copied the dtexec file and a few dll's that are missing to our production servers but i cant execute the packages. I dont want to install the full client tools (particularly managment/business inteligence studio) on our production servers due to the overhead and limited system disk space.

Can somebody tell me what the minimum install would be so I would be able to run SSIS packages using the dtexec or dtexecui tools? I would also like to install some of the other command line client tools like osql etc.

Can a table name impact generating the service client when creating Service Reference?


I have a new WCF service I'm writing under VS2010 and IIS 7.5.  The service includes a table named Client.

When I built my test class and added the service reference, the first test was confirming the creation of the client.

My service reference did not generate any client that I could call .Open on!!!! I was wondering if it is due to that table name???

 Edited to add that I tested the service through the browser and it brings up the page and XAML fine.

Thanks for any assistance!

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

Table name Change


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

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

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