I've got a grideview with a primary key as show below:
DataKeyNames="ActionID"
I've also got an Edit button inside:
<asp:Button
Text="Edit Record"
CommandName="outcome"
ID="btnEdit"
runat="server"
OnClick="btnEdit_Click"
CausesValidation="false"
/>
what's the best way to retreive the "Actionid" on the click event?
I have the following gridview (ID=Gridview1)
I have added pid (primary key), chkblood,chkurine,chkstool,chkmalaria as datakeynames.
what I want to pull off here is .... when I click select I'll be redirected to this wizard
[Code]....
I did that....now I want to hide / skip steps in the wizard depending on the condition of checkboxes (chkblood, chkurine,chkstool,chkmalaria)
but I cant get the value from these non-primary datakeynames...
I am working on lazy loading page the problem is
when i bind first time page (10) records then primary properly bind with records and when my next 10 records load using lazy loading then the primary key not change it shows 1st records primary key
check the below code in which i am assigning assetid (primary key) but its not assigning properly...
function OnSuccess(response) {
//alert('testing');
var xmlDoc = $.parseXML(response.d);
var xml = $(xmlDoc);
pageCount = parseInt(xml.find("PageCount").eq(0).find("PageCount").text());
var customers = xml.find("AssetSummary");
[Code].....
I would like to know If I can Get the Primary Key of the Selected Row without display the PrimaryKey Column? I Created a S.P which return me a DataTable of the Customers Tables (There Details only, without there ID which is the Primary Key) I set it to GridView for Display the Customers list. Now, I want to get the Selected Customer ID (His Primary Key) How can I do this? I tried to set the DataKeyNames of the GridView to "CustomerID" But, it didnt recognize me CustomerID. what to do, to fix it?
View 12 RepliesI have 2 GridViews. One is working perfectly. What I would like to have happen is when a row is selected on GridView1 (with Primary key of OrderNumber), the matching records from the field in GridView1 ClientID to show up in GridView2.
[Code]....
I think I've narrowed my problem down to CilentID is not a primary key, but still there should be some way to link them.
I have gridview control on my webform and I have datakeyname setup on gridview, also I have up and down to button, on gridview,
when I click on down button on one row , I want to be able to get primary key of row right below , How can I do this,
I can't get the primay key of my gridview1.
here's my code:
[Code]....
my gridview1 datakeynames = "ID"
during my debug, the irow is correct, however, when i check the 'keys' it says that the value is 'NOTHING'
I am gettinga syntex error. Is Primary field is a bit data type in the database.
<asp:TemplateField HeaderText="IsPrimary">
<EditItemTemplate>
<asp:CheckBox runat="server" ID="chkIsPrimary" Checked='<%# Eval("IsPrimary").ToString() == "1"? true : false %>' />
</EditItemTemplate>
</asp:TemplateField>
i added one linkbutton in listview and set commandname="select" from sqldatasource.
now i want to get id which is datakeynames in listview. i try from selectedindexchanging but it is not going to this event.
after this i'll take this id and will use in session.
does anyone knows how to get this datakeynames in listview when commandname is set to select?
[code]....
in gridview i hv columns like
name | phno. | emp_name(in dropdown) | buttonfield
wen user comes on this page this grid comes filled but then I need to select 1 emp_name from dropdown and click button(in last column) corresponding to that row. then on clicking that row button it should fetch that toq Primary Key and dropdown corresponding id. how? Wen I m fetching its fetching row index as 0 though it is no.4 record as per database(coz my records are in desc.order). I mean its giving row index as per grid and not as per my actual table(primary key).
I have two gridviews, where the first is databound to a sql table (but does not display the primary key info), and want to filter the data displayed on the second gridview by using the primary key info from the first gridview table, indicated by the selected row in the first gridview - how I could achieve this? its kind of like using the gridviews as a menu and sub menu display!
View 1 RepliesI have a textbox that takes an integer value, and a submit button that when clicked passes the value to a detailsview to display the database record at that index.
What I'd like to do is, when the button is clicked, compare the number to the keys in the detailsview's datasource so that if the record ID doesn't exist, I can display a label telling the user that the ID# doesn't exist.
How would I go about doing this? Is there some sort of compare method for the datakeynames property?
I'm trying to create a Formview in ASP.net 3.5. The underlying SQL Server table does not have an identity field based Primary Key. The primary key is a 4 character user entered field. I have created the form and all looks good but I get the following error message when I try to insert a record
Could not find a row that matches the given keys in the original values stored in ViewState. Ensure that the 'keys' dictionary contains unique key values that correspond to a row returned from the previous Select operation.
I thought ViewState was supposed to resolve the issue. I have viewstate enabled on the page and the formview but that doesn't seem to make a difference.
How can I create a form view with a user-entered text field as the primary key and get the b.... thing to work?
I have SQL Server Database Primary Data File.
I want to recover the data from that file in to my data base which has the empty tables.
I have Microsoft SQL Server Query File which contain the table structure.
If I am passed a datatable and I cant change the column structure..is there anyway to set an existing column to a Primary key so I can easily Find() the row I am looking for?
View 1 RepliesI have two tables - Advert and Student
adID is the primary key (Advert) and acts as the foreign key for Student
I have two pages, both of which each have a detailsview in insert mode
what I want to achieve is to create a new record in advert.aspx (e.g. adID = 4), then when item is inserted, redirect to page student.aspx (which a student record is created) where the foreign key is the ID from the advert just created (e.g. student.aspx?adID=4).
I am using Visual studio 2010 express and I have a details view databinded to an sql database table. When I use the Insert option on the view it causes an error due to it trying to insert a null into the primary key field. If the Insert function does not create a new primary key entry how is it created?
View 9 Repliesi get the following exception (missing primary key) in the line of using Find() method "Table doesn't have a primary key." I've rechecked the Database and all Primary Key columns are set correctly.
DataTable dt = p.GetAllPhotos(int.Parse(Id));
DataTable temp = new DataTable();
temp = dt.Clone();
temp = (DataTable)(Session["currentImage"]);
DataTable dtvalid = new DataTable();
dtvalid = dt.Clone();
DataRow[] drr = new DataRow[1];
drr[0] = dt.Rows.Find((int.Parse(temp.Rows[0]["photoId"].ToString()))+1);
foreach (DataRow dr in drr)
{
dtvalid.ImportRow(dr);
}
dtvalid.AcceptChanges();'
In the database one number like a 91-9685748596 and, 2nd number like 9122-9685748596 and another one is 9685748596 .when we are try to formate it using substring function it all are may be9685748596,9685748596,9685748596.Mobile number is assigned as a primary key.so its showing error "Primary key violation".We can not the remove primary key also and there are 50 lack data in our database.
View 6 RepliesLet's say I have a table that holds information about books, with a column called bookid as a primary key with auto increment of 1. When I create a couple of records, it assigns 1 to the first row and 2 to the second row for the bookid column. If I delete the second row and enter another row, even though table now only has 2 records, the primary key column says 1 and 3 for their bookids. Is it possible to change back the bookid of the second record from 3 to 2 or is it just server assigned and can't be changed.
View 9 Replieshow i insert,update and delete data in multiple table .such tables in which primary and foreign key constraint are
View 1 RepliesIn my application, users fill out a form to submit a "Job Request" - once they submit the form it is stored as a new row in a table in the Sql database. Each "Job Request" that is submitted is given a "JobID" which is a number and also the primary key of the new row in the database (the number is generated by the database). Once the users hit the "submit" button, I'd like to return the value of the "JobID" (the primary key) so that the user can know what it is. How would I achieve this? In the future, I will have to expand the application so that the users would be able to edit an older "Job Request" and get a similar JobID number (so if before it was 1234, the new one would be 1234-1 or something like that), so this is not simply a matter of searching for the highest number in the primary key field in the table and returning that. I'm using Sql for my database and writing in VB.
View 1 RepliesYes..i know this is ASP.NEt forums but the SQL server doubt i will be going to ask is related to ASP.NET
I have a table 'a' in my database where i store User information - each time they visit the website a new record is added
so in a high traffic website - the information will be collectively huge(i dont care about this as i have too much of disk space)
but the problem here is with the primary key - I want a datatype of the primary key which should never end Bigint can store some zillions of records but it finally ends... how will i be able to accomplish it.
My codes below are to insert a new data into the database. The thing is, this code can insert the primary key(DeviceID) into the database automatically but I cant seem to find the code to insert the primary key into the database. point me the statement that insert primary key(DeviceID)..
This is the snippet of the submit button event
Protected Sub SubmitDevice_Button_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles SubmitDevice_Button.Click If Session("canUploadBool") = False Then ClientScript.RegisterStartupScript(Me.GetType,
"canuploadScript", "")
Exit Sub
End
Dim insertNewProcess As String = "INSERT INTO Device_Table("
Dim deviceColumn As String = "DeviceRevision, CustomerName, CustomerCode, CustomerResponsibleEngineer, Date, DevicePartNumber, PackageType"
Dim deviceValue As String = ") VALUES ('01', '" + CustNameDropDownList.SelectedValue.ToUpper + "', '" + CustCodeLabel.Text + "', '" + CustomerResponsibleEngineerTextBox.Text.Trim.ToUpper + "', '" +
Format(Now, "dd-MMM-yyyy").ToUpper + "', '" + DevicePartNumberTextBox.Text.Trim.ToUpper + "', '" + PackageTypeTextBox.Text.Trim.ToUpper + "'"
i have to make a three primary key in one table
View 2 Replies