View Complete Post
I am using VS2010
When I try to updated or insert a record in my User table I am getting an error that does not make sense to me and I cannot figure out what is wrong.
Also, when I try to insert a new record I get a validation error saying that the Id is required. However it is an identity field in the db so it should not be necessary to send it to the server.
Could you please shed some light?
An error has occurred. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: Microsoft.Web.UI.WebControls.EntityOperationException: An error has occurred.
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
[EntityOperationException: An error has occurred.] Microsoft.Web.UI.WebControls.DomainDataSourceView.PerformCudOperation(ChangeSetEntry operation, Action`1 operationPerformingEvent, Action`1 operationPerformedEvent) +331 Microsoft.Web.UI.WebControls.DomainDataSourceView.UpdateObject(Object oldEntity, O
I am coding a .cs file that handles the metadata for a particular table. I am putting a custom validation that allows me to update or insert only if the PubMedID is not already in the database. This would be easy except that the PMID should also be allowed to be null as some of the references in the database were not from PubMed. So i perform a query on the database to see if there is already an identical PMID in the database. This works great when using Insert. However, when using Edit, it does not. The PMID is already in the database because the one currently being edited has the same PMID!!! So I know exactly how to change my query etc. However, I do not know how to tell from inside this Edit/Insert agnostic page, which one it is being called from. Thanks for your help!
i am developed on simple user registeration application in that i gave address field .when i am trying to enter something like this (1st main,b'lore) but wont take while inserting.
my query is
sqlcommand cmd=new sqlcommand("insert into registeration_form(name,address)values('"+txtname.text+"','"+txt_address+"')",con);
how can i pass the quotes also to my query please if any one know reply me.
I am trying to insert data to Excel Document using OLEDB as follows:-
sql = "Insert into [MyFirstSheet$] (" + Title1 + "," +Title2 + "," + Title3 + ")
values('" + Value1 + "','" + Value2 + "','" + Value2 + "')";
myCommand.CommandText = sql;
But, the Title1 ,Title2, Title3 are in the 3rd row of the Excel Document. So, the data is not inserted.
Can someone help me on How to insert Image (jpeg) into MS Word Programmatically using VB.NET..not C#.NET???
I could hardly find any articles for the coding. Preferably using Bookmark...can i have the sample code.
I have built a site that I am using google maps on. The default page has a google map with info windows containing links and all works great... until a user clicks on the link in the info window. Doing so takes them to a community page that I have built. On this community page, I have an ajax update panel that has 2 panels nested inside of it with the visibility set for one to be on and the other off. The default panel shows community photos, and the second panel I want to show the google map and common directions to the community. In testing, my buttons to switch the visibility of the panels works great as it should without postback, but when I try to add the map to its panel, it does not show up. I am new to ajax as well as google maps and I'm not sure why the same code would work fine on my default page but not the community page. The only obvious thing I can assume is because the community page map is in an update panel.
How do you insert a google map into and ajax updatepanel and have it work correctly? Many thanks in advance.
I want to use gridview and bind the data and after i want insert the data in database using jquery,
below the link i got for delete
but i want the sample example for insert row from gridivew and add the database.
I have three column comes from database table(Table1) and one column is for entering data for the user let us consider it look like this
ItemNo ItemName Qty uservalue
001 A 50 20
002 A 20 5
003 B 50
004 C 60 10
005 D 40
006 E 90 15
If its 300 row from database to gridview it will show 50 record with page navigation..
What i need is i need to insert data in to database table which gridview row has user value..
The output of the another table(Table2) will look like this after insert
ItemNo ItemName uservalue
001 A 20
002 A 5
I am getting error in here
987 is where i put clientname.text
Dim objCmd As New SqlCommand("Create Table " + clientname.Text + "(name
Varchar(50), event Varchar(50), date1 datetime, username Varchar(50),
password Varchar(50), " + strCommandText + ")", objConn) objCmd.CommandType = CommandType.Text objCmd.ExecuteNonQuery()
Dim objConn2 As New SqlConnection("Data
Catalog=mrpoteat; User ID=xxxxx; Password=xxxxxx;") objConn2.Open() Dim strCommandText2 As String = "" For index2 = 1 To Attachments1.Items.Count Step 1 If String.IsNullOrEmpty(strCommandText2) Then strCommandText = "@pic" + index2.ToString() &
I have an InfoPath web-enabled form in MOSS 2007, that is integrated with a K2 blackpoint process for an approval workflow.
Once the form (a Purchase Order request form) has been approved in the K2 workflow process, I switch the form view to a "print-friendly" view for the requestor to view from the browser. However, now I need to go one step further with this scenario:
1) I need to somehow insert/embed an image with the scanned-in signature of the approver (likely stored in a SP doc library) at the signature line section of my form. Also, what are the security requirements for storing such images, but not granting
all users access to these (e.g. only services accounts that need to access this for embedding into the form, etc.)?
2) Then I need to convert this final "print-friendly" view of the form (with the signature image) to a PDF document so that I can store it in SharePoint (and email it to the requestor using K2's email event capabilities).
Can anyone help me with a solution to both of these requirement, or point me to some resources for this (even 3rd party components are open-game).
is it possible to insert some table i have in another database in the wss_content?
i need to link the userinfo table to some table in my database. and i cant create a foreignkey between these 2 tables.
Suddenly sharepoint designer decided today that it doesn't want to insert a custom list form anymore...
To be more specific, it doesn't work anymore in a site that uses the Microsoft budgeting and tracking template. In a website that uses an out of the box template, it still works.
It did work before, because I did it in other websites using the same template (it's broken there as well now).
Why oh why does SharePoint refuse to do this now?
I searched google and here on the forums, but all I could find was some issues after installing SP1, but we did that already long time ago and it was still working after that. I checked with our infrastructure guys and they didn't install new updates they
I also tried the solutions listed here:
But they don't fix the problem.
So my problem is, I can go to Insert > SharePoint Controls > Custom List Form
I pick my list, content type and form type, I hit OK and... nothing happens.
is it possible to create a custom list in sharepoint designer to enter a vacation request and using a work flow that goes to the HR department. but when the HR department approve the request the HR can store these requested data into another database?
what i mean is, the employee fill a form in to request some vacation days using a custom list in my wss3 site. i assume that these data will be stored in the WSS_content database. now when the HR department get this filled form they have to store the data
of the form in to a database but not in the WSS_Content database.
is this possible?
doesn't any1 know the answer of my question?
i'm trying to create a data view with the edit, delete and insert function.
the edit and delete works fine. only the insert gives me this error:
The data source control failed to execute the insert command.