View Complete Post
I'm using VS 2008 and SQL 2008.
I have created the tables and the stored procedures in SQL 2008.
In VS 2008, I created DataSet1.xsd in App_Code and created the connectionString in web.config file.
Then when I go into the DataSet1.xsd and try to add a TableAdapter, strange things happened.
First I chose the data connection, then selected "Use existing stored procedure", then there was nothing listed in the dropdownlists (in Select, Insert, Update, or Delete).
I'm sure the connectionString is correct because if I choose "Use SQL statement" and type in a "select * from mytable1", the TableAdapter can be created without any problem.
I'm trying to build an BDC file that will pull information back from two tables in an Oracle database, I can import it without any errors, but then it tells me I do not have a filter when I try and select an item. When I add a filter I get an error
when I import the file. The error I get is the following.
"Application definition import failed. The following error occurred: The IdentifierName Attribute of the TypeDescriptor named 'TestDate' of the Parameter named ':TestDate' of the Method named 'Get_TestTwelve_List' of the Entity named 'TestTwelve' does not match
any of the defined Identifiers for the Entity. Error was encountered at or just before Line: '133' and Position: '16'."
Here is the section of
<Property Name="RdbCommandText" Type="System.String"><![CDATA[ Problems while creating the Stored Procedures with Concatination Hi
I am creating one Stored Procedure where want to use concatination in that. For that I had written the query but I am unable to do it, so I need help for this.
My SQL query is:
SET QUOTED_IDENTIFIER ON
CREATE PROCEDURE Team
SELECT * FROM Emp WHERE ID = @Int + '@str'
In @str is we are passing the value at run time (like @str =AND NAME = 'Test')
Actuall quey is:
SELECT * FROM Emp WHERE ID = 1 AND NAME = 'Test'
Thanks in advance
does exist a wizard like asp.net for creating resource file based on every control of my form?
here an image that i usually create resource file in asp.net
does exist something like this in windows form?
I have a cube with several measures in it. I also have 2 time dimensions called Repoting Date (RD) and Business date (BD). The reporting date dimension is pretty small only containing the dates as the end of the month. The business date dimension is
a normal time dimension on day basis.
Now I want to create a set or filter where the reporting date is the same as the business date. And that should apply to all measures.
So I should get (BD.Date.2010-01-31, RD.Date.2010-01-31), (BD.Date.2010-02-28,RD.Date.2010-02-28)
Any thoughts on this one ?
I am trying SP2010 and I have main web collection. In collection anything seems allrigt. But if I create a new site (for example team site), I can't reach site settings and some other problems. When I try site settings, sharepoint returns me his 404 Error.
File cannot be found. If I use directive ServerRelativeUrl in some webpart via Visual Studio, webpart returns only root "/". If I want to show and manage lists, all lists are linked to the root site in collection. For example I have collection http://share2010/
. In this site I have Lists Pages and Images. In this collection I create new site Subpage with address http://share2010/subpage . In http://share2010/ site settings works fine. In http://share2010/subpage dont. And in http://share2010/subpage "list of
lists" linking http://share2010/Lists/Pages and http://share2010/Lists/Images. But I need http://share2010/subpage/Lists/Pages. Can anyone help me?
I am attemping to create a new site collection in code. This works fine on my test box, but when I moved it to production I keep getting access denied. Here is some of the code I am using:
Protected Sub btnCreate_Click(ByVal sender As Object, ByVal e As EventArgs) Handles btnCreate.Click
'Create the new site collection
Dim elevatedCode As New SPSecurity.CodeToRunElevated(AddressOf CreateSite)
End Sub ' End btnCreate_Click
''' Create the new site collection
I have inherited a sharepoint distribution from a previous set of contractors, which I am now trying to set up for a developer hired to fix a few bugs in custom code.
This sharepoint installation consists of a farm that includes the following:
192.168.1.1 - Not Configured
192.168.1.2 - Windows Sharepoint Services Incoming E-Mail, Windows Sharepoint Services Web Application
192.168.1.3 - Central Administration / Excel Calculation Services / Office Sharepoint Server Search / WSS Incoming email / WSS Web App
192.168.1.4 - Office Sharepoint Server Search / WSS Incoming email / WSS web app
SQLCluster - WSS Database
I have a development machine with a single install of sharepoint / mssql 2005 that I would like to set up as a test server for code/database changes
I set out thus to export (stsadm -o export etc.) a copy of the live site, and import it into my test server. This gave me a lot of errors regarding features, which I looked up to be custom solutions that were not installed, so I installed those, and attempted
the import again, this time another error regarding features missing. I checked the features/template directory and noticed on live there are a few features that are not listed in the solutions panel, these look to be mostly custom webparts
SELECT CASE WHEN Client_Details_New.CliDOB IS NULL THEN 0 WHEN dateadd(year, datediff(year, Client_Details_New.CliDOB, getdate()), Client_Details_New.CliDOB) > getdate() THEN datediff(year, Client_Details_New.CliDOB, getdate()) - 1 ELSE datediff(year, Client_Details_New.CliDOB, getdate()) END AS Age, CASE WHEN Age BETWEEN 17 AND 25 THEN '17 - 25' ELSE 'Other' END AS AgeBandsFROM Client_Details_New
My query is above ^^... when I execute the query it just says "Invalid Column Name 'Age'" - this error is showing for the 2nd case statement... not sure why im getting this error when I have set the column name "age" when doing the age calculation on the DOB field :S
any help is much apprecited!