when i want insert a record i see an error like this
Can't perform Create, Update, or Delete operations on 'Table(MainMenuLink)' because it has no primary key.
with this codes:
MyLinqDataClassesDataContext db = new MyLinqDataClassesDataContext();
MainMenuLink li = new MainMenuLink { Link ="../error/error.aspx", LinkSubject = "subject" };
db.MainMenuLinks.InsertOnSubmit(li);
db.SubmitChanges();
ShowLinks();
what is the problem?
my table have a primary key but i dont know why give an error!!!
when i want insert a record i see an error like this Can't perform Create, Update, or Delete operations on 'Table(MainMenuLink)' because it has no primary key. with this codes:
MyLinqDataClassesDataContext db = new MyLinqDataClassesDataContext(); MainMenuLink li = new MainMenuLink { Link = "www.tprogrammer.com", LinkSubject = "subject" }; db.MainMenuLinks.InsertOnSubmit(li); [code]....
I have placed Chekc box in Gridview when i select the check box can perform 2 operations simultaniously one is entire recordset is populated into form fileds and second one is can delete the selected record permanently from database table.following code for this fuctionality.
Is it possible to perform an update command which performs addition using a value from a textbox? For example: User inputs a number into TextBox1 (I use regular expression validation to ensure this is an integer).
[Code]....
Basically if the user inputs 5 into TextBox1, I want the update command to subtract 5 from that user's ballance.
I find myself needing to preform the same actions on both HtmlControls and WebControls. I am a firm believer in DRY and find the fact that there is only the Control class to use if I want to consolidate the functions on both types. The problem that I have with using Control is that there certain properties that both HtmlControl and WebControl expose that Control does not. In the current case, the Attributes property is the problem. how to avoid the duplication of code in this type of instance?
Is it possible to perform mathematical operations within a .aspx View.? for example..lets say i have a total number of pencils of say 100. and i have 12 students on a data table with his or her name, and the number of pencils she has
Student Name: Pencil #
John 10
Sarah 12
Linus 19
But while rendering the view i want to calculate the Percentage of pencils one student possesses out of the total. (John would have 10% of the total 100 pencils)
How would i just perform this basic math operation, and encode the result into the view. I know i need to store the 100, and divide by each count of pencils for each student within the foreach loop. but i keep getting 0. This seems very elementary i know.. Help would be very appreciated. Google seems to have nothing for me.
how to check performance of sql server query with load ,also wants to create load by any tolls like load runner,if any url for download load runner or any other tolls by which we can create load please give me some idea related to it.
in generate the Stored Procedures when using Create TableAdapter configuration Wizard in VS.it can not generate the Stored Procedures for Delete and Update Commands, but it generated for Select and Insert. i tried many times, but still get the same problem.
I have a gridview that pulls data from two tables, CLIENT and PAYMENT. I want to add the edit, delete functions to the gridview for the payment portion of the table, that is to edit or delete the payments but not the client. I've manually enabled the edit, delete functions and input the queries. I've also deleted the textboxes from the templates which draw from the CLIENT table so they cannot be edited. Everything looks good on the surface until I actually go to edit or delete anything, and it has no effect.Here's the structure of the two tables:
UPDATE [PAYMENT] SET [PaymentDate] = @PaymentDate, [PaymentAmount] = @PaymentAmount, [PaymentDetails] = @PaymentDetails WHERE [PaymentNumber] = @original_PaymentNumber AND [CLIENT$ClientID] = @original_CLIENT$ClientID AND [PaymentDate] = @original_PaymentDate AND [PaymentAmount] = @original_PaymentAmount AND (([PaymentDetails] = @original_PaymentDetails) OR ([PaymentDetails] IS NULL AND @original_PaymentDetails IS NULL))
Finally, here's the delete query:
DELETE FROM [PAYMENT] WHERE [PaymentNumber] = @original_PaymentNumber AND [CLIENT$ClientID] = @original_CLIENT$ClientID AND [PaymentDate] = @original_PaymentDate AND [PaymentAmount] = @original_PaymentAmount AND (([PaymentDetails] = @original_PaymentDetails) OR ([PaymentDetails] IS NULL AND @original_PaymentDetails IS NULL))
I just want to be able to create a site that will allow users to insert/update/delete information from the site and the information will be recorded on the SQL DB.
Went through couple of Videos and Tutorials, it can't be that complicated?
i want to create a web service which consists of CRUD operations Create, Retrieve, Update and Delete. creating web methods on insert and update operations.
I have a detailsview which I am populating using a SQLDATASOURCE, which is bound to a table in a SQL db. Because the number of columns in the table will change, I am using SELECT * from [TABLENAME] to populate the view, this works fine.
My problem is that I need to also be able to update the table and I thought the best way was to generate the updatecommand in the code behind. This is no problem, code is as follows:
[Code]....
But the next stage is to create the relevant parameters for the update command. Does anybody have any thoughts on this? All of the information I have found for the updateParamater reference knowing the final value.
What I really need to do is the code behind equivalent of
I'm using the 'Configure Data Source' wizard to connect to my database and show the dataset in Gridview. I want to be able to update, insert and delete entries but am unsure how to build the query. I can write simple update statments to change database entries but how can I do this for entries that have been changed within the gridview?
I am trying to use SqlDependencyCache buthave come across a problem that I wouldn't have thought was unique. We have a InformationDatabase which uses a combination of its own tables and views to other databases on the same server. One of these views points to our HRDataWarehouse database. My stored procedure obviously uses this view to get its information but because the table change is happening on the HRDataWarehouse table the notification is not being sent to my app and as a consequence the cache is not removed.
Is there a tidy way of doing this or do I need to create a trigger to update a table in my informationdatabase and then have a listener on this with a removecache callback delegate added to the cache object?
I have a gridview with checkboxlist for each record. I was updating each record individually based on that check, but now they want it to be a bulk update instead of individual. So i have commented out my individual update and added a button below the gridview and created my button event, how to loop thru the gridview and find the checked records and call my update procedure.
i found something kinda close to what i need, but its in VB and not sure how to convert that to C#
if it's possible to use the Gridview (SQLDatasource) UpdateCommand to actually perform an INSERT and not a true update.Here's the dealUsing a Select statement in my SQLDatasource,I'm retrieving records for which there are no History records for a specified period.(Essentially, I'm asking "Show me all records for which there are no historical records within a specified range").I'm using that result set to feed my GridView. Basically, I'm displaying all I need to know about the insert records sans one piece of info.When the user choose the "Edit" button, the row goes into edit mode.Using a template field, I've created a drop down box to allow the user to input the status of the data for that particular time period.When they click the save button,the idea is that the UpdateCommand will fire.However, when I click the save button (in edit mode),I get a postback error that tells me System.Data.SqlClient.SqlException: Must declare the scalar variable "@EQP_PK".
My web application calls a stored procedure and stores the result in a .NET datatable. I'd like to use this datatable and join it with other tables in my database. Is this possible?
Would the best way to set this up be to create another datatable and then use a dataview to join both datatables?
I get from SQL Server Server Data. I need to use datas form 2 colums of my SQL query for a VB.NET. The VB.NET need 2 values for both colums and produce 1 answer. I what to display the value on the same line instead of the 2 1st values. How can i store the 2 colums wich lot of SQL values on my vb.net script and diplay the result with the other data from the SQL query ?
As you can see, the first 3 documents are for the same NIIN, and their total QtyReq is 6, however there are only 5 Available for this NIIN.
I need a way to remove the document 12346 because it cannot be filled, the other 2 document can though. I cannot figure this one out, but it seems like it should be pretty easy.I am using MS SQL Server 200