in my website i use Entity Data Model and i use linq to insert record to sql database
in one action i need to insert 2 record in 2 difrent related table. first i have to insert a topic and get the id of that topic and use it for post inserting.
have a table where there are no timestamp/date fields and I would like to determine the datetime or timestamp that each record was inserted into the table.
View 4 Repliesmy requirement is that SSRS 2005 report should show all records with checkboxes(or can be by any other means of flagging ?) .
Now the records for which checkboxes are checked or flagged are only to be included in the exported excel sheet or pdf .
[Code]....
this is my html code
[Code]....
this is my code behind
[Code]....
this is my bal code
acuttally
in my javascript popup i am getting the checked values but i need it in record by record in the lblsave data
The website is over half way done and the functionality for the blog is (except for adding posts) is already implemented and working correctlyI have a SQLExpress 2008 backendBlog posts are rendered on the page with full HTML markup within a label control.
All of the above is done and working. Though I am essentially new to creating websites with ASP.NET, CSS and SQL, I am sure that I could simply carry on and make a login page with some controls that would allow me to add records (blog posts) directly to the database on the host server. However, I am fearful of doing this because I know that malicious code can be passed in this way. Also, because of my lack of knowledge, the only way that I know of to pass the code from a control to the database is to disable validation for the page the control is on. Without a doubt I do not want to do that.
So what are my options for getting blog posts into the database? Is it safest for me to fully create the post in html and update a copy of the database that resides on my local machine? If I do it this way, how can I merge the records from the database on the local machine with the records on the remote server?
i have a question regarding grid view. i have done almost all work i needed. but one thing i want to do is i have set 4 of page size of grid. so when i show records on the web page i want to set a iframe after first two records then iframe and then two more records like i have shown in the example image. i have used LINQ with C#.how to do it. if you people want i can show you my code.
View 3 RepliesI have a datagrid control which is bound to a table which containing more than 1000 records. And i want to show only 25 records once a time. I have used paging in datagrid. But each time the next page index is set, query is fired again. This takes lots of time. So what is the easiest way to bound data in this case to improve performance.
View 3 Repliesim tryin to create repeater from code behaind using C#. The data bind is working good, im tryin to put some pager. the pager is half working. i can see the pager links at the bottom, i can see the the code split the records to 10 lines each page as i set it but when i click the next link the records stay the same it wont changing for the next 10 records. my code
[Code]....
i have 500 records to show in webpage. i am using DataList in that webpage. if i use direct binding it is slowing down the performance of the page and is taking time to load. now i have used update panel and i want to append data records by records(i want to append as first 50records and then next 50 records something like)
View 4 RepliesI have a table in which i insert Record like 'ABC321' and want to Get that id only the Perfect id
I have a web Application in which many user would be Insert Record at the same time.....
so i need the find the id of that Record only
Is there is a way when i insert Record like
insert into Msg_Msgs (MsgToID) Values('321') and Get id of that with one line Query or some thing like that
How I would get the ID of the row that was inserted using the following? (VS2012 VB.NET)
Code:
Dim connString = ConfigurationManager.ConnectionStrings("DBConnectionString").ToString
Dim conn As New SqlConnection(connString)
[code]....
In my database having 50 records,i wnt to display the first 10 record on first page of gridview and next 20 record on second page and so on..
View 1 RepliesI know this is a common request, I've googled loads but found lots of complicated code for such a simple task.
My basic insert code is below, can someone tell me how/ where I can modify it to get the last ID?
[code]....
I have a reports table with column report id and and report version. I created a trigger on this table to execute an application to do some processing each time a row is inserted in reports table. I need to pass the new report id execute this application from the trigger. How do I get the report id from the row that was inserted?
View 1 RepliesThe only thing I can think to do is to call GetByExample(entityJustInserted) and pick the one with the highest ID. Not great...anyone got a better way?
View 1 RepliesI 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 have a gridview with checkbox column. I loop through all the rows of gridview, if it's checked I enter the second column text into my database. The second column text at one point shows the word Küche, but when I take that text (in order to insert it in db) it gives me Küche and that's what I see when I then read it from db.
View 4 RepliesI'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 have a small form of 4 fields, I am using Ajax to save record and give alert to user on same page. all is working fine but I want to clear all 4 fields after record is inserted and don't want user to press again and duplicate,
Right now I am using
this._studentName.text = "";
but is there any easy method to get same result coz I have another form where there are more then 40 fields and don't want write .text = "" 40 times
in my application i have tab container with several tabs, inside everyone of them
i have textboxes, dropdowllists etc. i want to get those values filled by the user,
how can i do this, the intelisense don't recognize them.
I have insert page - data is getting inserted properly with all validations .But the main problem is that after insert if anyone clicks on the refresh button on the Internet explorer browser , data gets inserted again the same data which insert on submit button.
View 3 RepliesI setup my gridview to handle the edit,delete, and insert operations correctly. My grid also supports paging and sorting. My question is how to highlight and go to the newly inserted row in my grid?
View 2 RepliesI need to retrive the id of the inserted record to use it with another table as a FK when the user click the button this is my code that insert the record and the id in auto-increment:
[Code]....
I tried to select the id after inserting using a sqlcommand but it gave me the following error The INSERT statement conflicted with the FOREIGN KEY constraint "FK_masc_img_Mascotas". The conflict occurred in database "ads_site", table "dbo.Mascotas", column 'IDMascotas'. The statement has been terminated.
I use the sitemap, Web.Sitemap file and the asp:menu control in my website for navigation. It has a few navigation tabs, e.g 'Home', 'First Page', 'Second Page'.....
When I click on the 'Home' tab, it goes to http://www.mywebsite.com/Default.aspx. When I click on the 'First Page' tab, it goes to http://www.mywebsite.com/FirstPage.aspx., and so on....
Everything works as expected.
However, after starting the web application, after a few days a set of weired characters will be inserted to the URL as follows:
http://www.mywebsite.com/(A(8WD4a1wHywEkAAAAMTQzN2FjNDMtOThhMi00ZmNmLWI3YTQtMDY1M2EwOGRmYjliJ-h1Vp9RJnoGNTpb9d3ZfJuoncc1))/FirstPage.aspx.
I checked with the MSDN and found that the strange characters above is the Anonymous-ID embedded in the URL by asp.net (this is the link: http://msdn.microsoft.com/en-us/library/aa479315.aspx)
The tabs still work, and I can still go to the First Page, Second Page... etc. even with these strange characters embedded in the URL. However, once it appears, the 'SiteMap.CurrentNode' that I use in the codebehind always return null, and I can no longer get the 'SiteMap.CurrentNode.Title' property.
And all the submenu will disappear too (I am not sure if it is caused by the SiteMap.CurrentNode problem above or by something else).
I have explicitly set the cookieless mode for the Anonymous-ID in web.config to "UseCookies" as follows:
<anonymousIdentification cookieless="UseCookies" enabled="false" />
but I still get this embedded Anonymous-ID every few days. And once it appears, I have to restart the web application in IIS to fix it. Then it will appear again after two or three days.
how to stop this Anonymous-ID from inserting to the URL?
I'm inserting data into a database with Linq to SQL and would like to access the primary key of that record WITHOUT doing a query for the values I've already captured.
Here is my insert startment:
[Code]....
There is a value in the table that is an auto increment integer.
Rather than doing a query for the pagetitle, description and content I'd like to just access the primary key that I would have just generated by performing the insert.
Is this possible or would I have to perform the query as I've just mentioned to retrieve it?