View Complete Post
1 My DataTable Return following Data
Acct Books AnnualAcct Books MonthlyAcct Tax Income TaxAdmin GH EqptAdmin Offc EqptAdmin Offc MiscAdmin Offc EqptBPO DE DE.USCorp Comp InsuranceCorp Legal CourtCorp Legal Court
but i require in this format
I create table:
DataSet data=new DataSet();
DataTable myTable = new DataTable("NewTable");
DataColumn keys = new DataColumn; // create column keys = new DataColumn(); keys.DataType = System.Type.GetType("System.String"); keys.ColumnName = "PointID"; myTable.Columns.Add(keys); &nb
I want to make databas? that will send daily to all members that leave email?Please if you can help me
The next version of SQL Server, code-named "Yukon," includes quite a few enhancements and expanded language support. For example, Transact-SQL now conforms more closely to the ANSI-99 SQL specification and makes querying more flexible and expressive. Yukon can execute user-defined functions, stored procedures, and triggers written in CLR-targeted languages, including Visual Basic .NET and C#. It supports a subset of the W3C standard XQuery language, and has native XML support.In this article, the author outlines the most significant language features and builds an order-entry sample app.
MSDN Magazine February 2004
SQL Server 2000 Meta Data Services is a repository technology that stores and manages metadata for SQL Server. Instead of building database schemas over and over, Meta Data Services allows you to freeze an entire schema for use in other projects. You can also use these schemas for training, testing, or debugging. In this article, the authors will review the various components of Meta Data Services and show how it can be programmed using a Visual Basic client, XML, and XSLT. They will also show you how to manage and manipulate your metadata by generating a simple database schema using a SQL Server repository.
Alok Mehta and Ricardo Rodriguez
MSDN Magazine May 2003
I have database already on the server. However, when I created new table, the new created table Schema is not dbo. it is my user name. How to solve this?
It shows the new created table Schema is my username but not dbo.
Even though I rename it, it couldn't change. I can see this in table property.
Hi, I have installed Visual Studio 2010 Express in my local system.
Steps 1. File->New Website
2.Open datbase explorer, right click on dataconnection
3.Select Create new connection
4.use Microsoft SQL Server Database file
5. Type new databse filename
6. Now i want to use SQL authentication which is not working
7.If we use windows authentication its wokring without any problem
8.But i need sql authentication to be used.
9.I have not installed SQL studio.
I am only using the one which is packaged in VisualStudio 2010 SQLClient. Let me know how can we create a new database file with userID and password. So that i can host it in other systems as well without any windows authentication. I know that VS2010 setup also installs the SQL client which is requiredto create and manage sql databse files/quries etc
i dont know the default userID and password for SQLauthentication. As the express setup did not asked any credentials while installing SQL components
Thanks and regards
I have created a KPI list and I want to show sections of the list on various parts of my site, however, I dont seem to be able to filter the list. Has anyone tried this and had any success?
I had already setup roles for my pages and requirements call for ability to manage and create users.
So i was looking at code that allows you to do so using membership, even though i got the page to work, it was creating a database in my app_data folder.. i already have SQLExpress setup with the asp schema, but cant figure out how to get my application to use that instead of creating the db in the folder?
What am i missing or doing wrong?
I have the following setup in my web.config file..
<add name="SqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider, System.Web, Version=18.104.22.168, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
We have a manual process that we do on a SharePoint list to export data from SharePoint to a spreadsheet that can then be used by non SharePoint programs. I'd like to be able to automate this process so that it can be scheduled as a Task to run on
a daily basis. Not sure if a workflow can do what I'd like it to. I have SharePoint Designer 2007 as well.
Here are the steps:
1. Load a particular View of a SharePoint List
2. From the view's Action menu, "Open with Access"
3. Save the resulting Access database as a file to a specific Folder on the computer hosting SharePoint
This would be run as a Task on the computer hosting SharePoint.
I need to display a List of Hyperlinks that are stored in a database. I want it to be a SharePoint List so it can be Indexed and Search properly in SharePoint.
SharePointSite Table - Columns:SiteName(nvarchar(256)), URL(nvarchar(256))
Example: Acme Foods, http://www.acme.com
I need a List that shows:
Acme Foods and is a clickable hyperlink to
What is the best way to get access to the data and feed it to a List and then host it on a Site landing page?
This is meant to be a directory of Site Collections. We have 175 Site Collections that host our customers Report Libraries.