CREATE TABLE People
personID int not
, name nvarchar(50) not
, addrLine1 nvarchar(50)
, addrLine2 nvarchar(50)
, suburb nvarchar(30)
View Complete Post
Scenario: If you create a table with a column of type nvarchar, populate it with some content and try to modify it using the WebMatrix editor, from nvarchar to ntext, it does not display any error message or warning that this is not possible. It silently saves and reverts the change, back to nvarchar. Wasted some hours on this issue as I thought my column was ntext, but in fact was still nvarchar.
Expected behavior: It should change to ntext, or if SQL CE doesn't support that, it should notify the user that no change was applied.
after deleting an unused calculated field id_2 at my sharepoint list I get the following error when creating a new item with my Infopath 2010 form (update item still works):
"The form cannot be submitted.
Exception from HRESULT: 0x80131904"
The joblog tells me:
09/28/2010 13:24:46.96 w3wp.exe (0x093C) 0x0C7C SharePoint Foundation
Logging Correlation Data xmnv Medium Name=Request (POST:http://test-project.xx.intranet:80/project/ideas/_layouts/Postback.FormServer.aspx) f8ffa9c3-f81c-429b-91de-3f76739e446a
09/28/2010 13:24:47.03 w3wp.exe (0x093C) 0x0C7C SharePoint Foundation
Logging Correlation Data xmnv Medium Site=/project f8ffa9c3-f81c-429b-91de-3f76739e446a
09/28/2010 13:24:47.19 w3wp.exe (0x093C) &nbs
Can somebody tell me why I am getting this error when I try to insert data in a DetailsView 2.0?
Cannot insert the value NULL into column 'Title', table 'C:\INETPUB\WWWROOT\TEST\APP_DATA\QUIZ.MDF.dbo.Question'; column does not allow nulls. INSERT fails.
I used the Configure Data Source wizard to set this up and Question ID is a autonumber.
When you autogenerate the Insert button on a Detailsview control and click on that button during run time the control posts back with text input areas where you are supposed to type the Title, Answer1, Answer2 etc. Obviously I typed data in to this text area labeled Title. It didn't work and that's why I'm asking about the control. Because I can't debug the control I am having a hard time figuring out where the problem is.
Here is the code and thanks for any help.
<asp:DetailsView ID="EditDetails" runat="server" Height="50px" Width="550px" AutoGenerateRows="False" AutoGenerateInsertButton="True" AutoGenerateEditButton="True" AutoGenerateDeleteButton="True" CellPadding="4" DataSourceID="SqlDataSource1" ForeColor="#333333" GridLines="None" AllowPaging="True"> <FooterStyle BackColor="#5D7B9D" Font-Bol
I have a table called category that has tow attribute (Cid,Name)
what can i do to insert category name only without allow user to insert category id in my webpage, I use view detail control and make the wizard link but when run the error message appear (Cannot insert the value NULL into column 'Cid)
note the identity properties is not pass.
The next version of Microsoft SQL Server, code-named "Yukon," represents quite a few steps forward in the evolution of XML integration. Yukon supports native storage of XML data using the XML data type, which makes it possible to run native queries on XML data using the emerging industry standard XQuery language. Data integrity of the XML data type can be enforced through schema validation and XML-based check constraints, and special indexes can be defined that help speed up queries. In addition, Yukon has the built-in ability to expose its data through Web services. This article discusses these and other XML features of Yukon.
MSDN Magazine February 2004
MSDN Magazine February 2001
MSDN Magazine December 2000
i am creating a column in the list while creating a column i will have an option for choice field on selecting choice i can see dropdown, radiobutton, Checkbox to select and can enter list of values. and on clicking ok i will get a column with
radiobutton. in newform.aspx and also in editform.aspx
so i need to create the similar functionality with my custom radio button, so on create column i need to show my custom choce on selecting this i need to show my custom radiobutton and can enter list of values then on selecting it then click
ok to create a column, in edit form and new form i need to show a radio buttons with values.
Thanks in advance