I am using SqlCommand to insert new value to a table. My table has 2 fileds1. IDDT (Auto increment) (numaric)2. Name (VARCHAR)i am runing below code to insert new value
[Code]....
Acording to the table the IDDT value will be inserted automatically. I need to get that value using above code.
I've been searching on the internet about this issue but all studies returns a ID value that is integer. However, in my system primary key field is a GUID, I mean uniqueidentifier. How can I get this value? Should I use SELECT SCOPE_IDENTITY() which is integer ?
View 2 RepliesI followed this BRILLIANT article and found out how to make a data layer, i just need the insert method in this code to return the ID of the record inserted.
For example, when the user captures the details, the save button is clicked, i will want to display in a label "Your Reference Number is "
try and have look at the article so you will understand how the code is, so it will not be hard to edit my code.
[URL]
I am trying to insert some string values into database.
The problem here is that, the string is truncated without warning..
Here is my vb.net code
[Code]....
And here is how I declared the varible in stored procedure
[Code]....
And If I insert "myCode01234567890" then it's truncated without warning at all.
How can I let it throw an exception rather then truncate the string without any warnings ?
Im using Objectivation as a DAL with GridView !
I would like to link item when i create it with the InsertMethode :
I have this 2 table :
Item ( id, name )
ItemRelation( idrelation, idParentItem, idSonItem)
I have a page with a gridview with the liste of item in relation with another item (Same table) : Select * From Item where id IN ( Select idSonItem where idParentItem = @TheItem )
When i add an item from this grid i would like to link it with the current Item : So I insert the Item with the GridView InsertMethod then I do another Query an the ItemRelation with idParentItem as the courant Item and the Inserted Item as the idSonsItem !
so the question is : How to get the id of an inserted Item after i get executed the InsertMethod ?
I am using a FormView to populate data, then inserting it using a LinqDataSource. The primary key is an autoincrementing identity. I'd like to handle the ItemInserted event to update some other tables, but I cannot find how to get the primary key of the newly inserted record. The insert happens fine, but nothing for the PK.
I realize I can change to using a SPROC, or change to creating the new row and doing the insert myself, but I'd prefer to continue with the LinqDataSource's automatic insert.
How can I get the PK?
I am trying to get the identity column on which the record is inserted but i couldn't using stored procedure
see
[Code]....
My Code Using ASP.NET C# i am trying to display the identity in textbox
[Code]....
I have this image upload code...that works....but I need a code to get the Id of the image that i just uploaded..
Protected Sub ImageButton_AddImage_Click(ByVal sender As Object, ByVal e As System.Web.UI.ImageClickEventArgs) Handles ImageButton_AddImage.Click
Dim IntLength As Integer
Dim ArrContent As Byte()
[Code]....
I need to insert two rows into a tableadapter - and then take the identity column from each row and update them into a column on each row.
My problem is that I cannot update a column on a newly inserted row. Stepping through the code seems to indicate that I have updated the column, but when I check the database - the column indicates null.
I have tried calling Update on the TableAdapter, then performing the update on the column, and then calling Update again, but the update still isn't taking.
I've done a lot of searching on this here but I can't seem to find anyone who has done this. I'm sure it's a common problem but I can't figure out the right keywords to search for the solution so I'm sorry if this is a duplicate.I have a dataset where I've used the Generate Insert, Update, and Delete statements as well as the Refresh the Data Table options so that I can retrieve the last inserted ID when I'm using an ObjectDatasource.however, when I'm handling the ObjectDataSource-Inserted method, I'm getting a 1 as a return value, which I assume is the affected rows. I don't want that, I want the ID so that I can use it in my code.I looked at the generated code for the insert method and it is doing a SELECT after inserting, but it returns the whole row not the ID, so how can I get at this row to retrieve the value?
View 6 RepliesI have a detailsView that I use for Insert. Once a record is Inserted, I need to get the new idenetity value.
Is there some function that grabs the inserted identity value? Or do I need to query it somehow?
By the way, the reason I'm doing this is the user is inserting a record into a 'general' list that is being applied to a 'specific' list - example, an employee can select a vendor from a list, but the vendor isn't listed so the employee adds the vendor in the vedor list and while the new vendor is inserted, the vendor info is also applied to the new order record.
I have an SQL Server table named "Fields" with an autoincrement identity column "FieldID" as the primary key, an nchar column "Phrase" that textbox entries are to be stored in from a web page, and another column that is defaulted to null. The following is the recommended example on how to use Scope_Identity() to get a newly inserted table row identity value:
//C#
string query = "Insert Into Categories (CategoryName) Values (@CategoryName);" +
"Select Scope_Identity()";
int ID;
string connect = @"Server=.SQLExpress;AttachDbFilename=|DataDirectory|Northwind.mdf;" +
"Database=Northwind;Trusted_Connection=Yes;";
using (SqlConnection conn = new SqlConnection(connect))
{
using (SqlCommand cmd = new SqlCommand(query, conn))
{
cmd.Parameters.AddWithValue("@CategoryName", Category.Text);
conn.Open();
ID = (int)cmd.ExecuteScalar();
}
}
Obviously, this example uses a Categories Table in a Northwind database, which I do not have. So I am confused by how to adapt this example for my application. The following is my data context:
DataClassesDataContext db = new DataClassesDataContext();
Could you explain how I can adapt the example for my "Fields" table in my "EFMDB" database?
I am having a table named Invoices.From that table I want everything the newly inserted and updated rows from that table.
View 3 RepliesI would like the ObjectDatasource insert and update data methods to return the inserted or updated object like LinqDataSource do.
View 2 RepliesI am using an auto-numbering index column as the primary key for many of my tables. Is there any way for me to know what the new row count is for newly inserted rows?
View 2 RepliesI am using LINQ to store and retrieve data from tables with a clustered index key. However, I also need to know how to obtain an inserted table row identity with an auto-increment Primary key. The "Go To Definition" feature for my data context of dataClassesDataContext provides the following information:
[System.Data.Linq.Mapping.DatabaseAttribute(Name="EFMDB")]
public partial class DataClassesDataContext : System.Data.Linq.DataContext
I am asking for the C# code that is needed in a button click event handler that will insert a row of data in a table named "Fields". It only consists of an auto-incrementing primary key column (FieldID), a string column (Phrase) and a null defaulted variable column.
i made one window base application in VS2008 (VB.net). i made one simple code where i can insert data.and after inserting i can see that data on grid.when i am inserting data insert query runs perfect.after that for debugging purpose i fire select query and get result in dataset and its show data too.but when go
into database my inserted data not showing there.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim con_str As String = "Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|Database1.mdf;Integrated Security=True;User Instance=True"
Dim con As SqlConnection = New SqlConnection(con_str)
Dim cmd, cmd2 As SqlCommand
Dim adp As New SqlDataAdapter.....
I've sucefully created a method to insert values through EF, but i've a question (maybe, a newbie question).
Should i send the values to be inserted as strings to the DAL, and then i create the object there or should i create the object in View Layer and then send him to DAL?
Example 1 (DAL):
[Code]....
Example 1 (View Layer, on a click button for example):
[Code]....
Or should i receive the strings in DAL like this: public bool NoticiasInsert(string tituloPT, string tituloEN, string descricaoPT, string descricaoEN)
Then i create the object cdcModel.noticias and set the fields there with the strings values.
What do you advice me to do? I know that both ways works, but i'm trying to develope with better patterns (i don't know if this is the exacly word, sorry my bad english)
cdcModel.noticias campos = new cdcModel.noticias();
campos.tituloPT = "a";
campos.tituloEN = "b";
campos.descricaoPT = "a";
campos.descricaoEN = "a";
if (DAL.NoticiasInsert(campos)
i am developing an application using ASP.NET with C#.Net and SQL SERVER 2005. here i am importing data from excel sheet to database.in my excel sheet some fields have large data.and for those fields i had taken NTEXT as data type in my database.when i am trying to import the data,the fields which have large text are not inserted completly.i.e some data is missing. the field in database accepts the data upto some characters only.what would be the reason for this? and which data type can i use for inserting large data?
View 8 Replies[Code]....
how can i call the event in another event.like Button Click event.
how can I get the ID of the item that inserted into a formview? I want the ID to appear in a textbox right after the insert. How can I do this?
View 2 RepliesI have a SQL 2005 database table with a column that has a datatype of nvarchar(255). It holds URLs.I created a FormView to edit records in the SQL table. The value for this column gets put in a TextBox in the FormView.When trying to edit the record, any text placed in the textbox gets truncated at 50 charactersI checked the TableAdapter in my dataset, and in the properties for that column, it has "255" for MaxLength.
View 4 RepliesI have a series of classes that loosely fit the following pattern:
public class CustomerInfo {
public int Id {get; set;}
public string Name {get; set;}
public class CustomerTable {
public bool Insert(CustomerInfo info) { /*...*/ }
[code]...
I have gridview, and in this gridview, I insert a new row dynamically depending upon a value from the database all the way down the table. Even though this is all working well, I need to access a number of controls that I added to the inserted row. Namely, a checkbox and label. When I try to access these controls, I am getting an error message - object not set to reference. Then I tried saying "Gridview1.Rows[rowIndexVal].Cells[1].Text = myTextVal", but what this does is to insert the value on a different row.
Therefore, I have two problems, which I am really desparate to try and solve:How do I access the correct row and control that I have added to my inserted row, andBecause I have a checkbox control on my inserted row, which has an event associated with it, how do I get the selected row the user clicked. When I try doing this using FindControl, I always get a row index of zero.I am using Table object and TableCell to add a new row dynamically to the gridview, and then using ColumnSpan to make it fit the number of columns in the gridview.
I have a repeater control and a text box, and likewise a button to post data to database.after i insert the data to the database in thwe click event of the button, the datalist will not update the displayed content. at the end of the button's click even, i added the code line:
Response.Redirect(Request.RawUrl)
But still, the datalist will not update automatically. What do I do next?