I am trying to insert some records using objectdatasource but getting no result.
I am sure I have to write some code in insertbutton but what I am not getting to it.
Here is my code used:
[Code]....
[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
i have a detailsview in insert mode and that is bound to objectdatasource. now the class that is attached to objectdatasource is :
[Code]....
here ResturantId value has to be in session or from Dropdownlist and rest of the value from Detailview. So how to assign that value?
currently I am doing a web application project using 3-tier formating to do out the project. In the grid view is displayed with data retrieved from the database and at the footer there is a row of empty fields for the user to insert records into database and when user clicks on Add New, a new row of empty fields will be populated below.
The database.cs and stored procedure is used to stored the data into the database.
[Code]....
This is the stored procedure code:
[Code]....
I am not sure of how to code out for the business logic?
I code this in business logic but its wrong as the error states the Insert method could not be found:
[code]....
In my asp.net gridview i want to count how much peoples are qualified in MCA Â and display the value in a lbel in same page. The qualifications are in COURSE field in my table anme persadata
table name is PERSDATA
PNO Â Â NAME Â Â Â Â Â Â COURSE Â COMPANY
121 Â Â Â RAJU Â Â Â Â Â Â BCA Â Â Â Â Â TCS
234 Â Â Â RK SINGH Â Â MCA Â Â Â Â Â Â TECHNO
525 Â Â Â P RAJ Â Â Â Â Â Â MCA Â Â Â Â Â Â KELTRON
325 Â Â Â ANIL Â Â Â Â Â Â BBA Â Â Â Â Â Â BPL
235 Â Â Â KUMAR Â Â Â Â Â MCA Â Â Â Â Â Â TATA
I am unable to insert records into the database due to this error:
Exception Details: System.NullReferenceException: Object reference not set to an instance of an object
This sentence is highlighted in red:
osdb.Insert_ItemsRecords(txtID.Text, txtItemName.Text, txtItemDesc.Text);
BindGrid(true);
How do i set set the osdb to a valid instance?
Name
Product
section of job
Quantity
Max Quantity
A
ABC
offset print
100
1000
B
ABC
water base
200
1000
C
ABC
offset print
950
1000
How to insert multiple records like above at once, and how to manage quantity user input is not over max quantity. In example above: Max quantity of Offset printing is 1000 (bind from database, visible=false)
Woker A does Offset printing with quantity 100, C does Offset printing also but with quantity 950, if we sum quantity A and C do will be over 1000 Ã message box: warning
How to use ObjectDataSource Update query from code behind.using edit and cancel button in GV asp.net.
View 1 RepliesI've been wracking my brains for a while. I have a master record that I want to add children to. In a database it's a one to many relationship with a foreign key in the child table.
I have a formview that I want to use to fill in all the master record info, and choose the child info from a dropdownlist, and click an add button, and have the add button add the child info to some control on a page. Then when the user clicks insert, the formview has an ItemInserting EventHandler that will handle all the logic for inserting the master, grabbing its primary Key.
So, I know what to do, I'm just not sure of what control to use, or what memory object etc., that I want to store the child info in until the master record gets created.
I'm sure this has been done a million times, but for all my searching, I couldn't find anything to help me. Does anybody have some advice or can anybody point me to an internet resource where this has been hashed out?
i have one xml blank file in my project .. i want to insert data from text boxes... my xml structure like
<?xml version="1.0" encoding="utf-8" ?>
<userdata>
<Project_name id="">
<datasource></datasource>
<database></database>
<server></server>
</Project_name>
</userdata>
project_name should be like Primary Key.. how can insert data through code
I have this ListView that has a Drop Down List.Everything works fine (I think/hope) except that the drop down list are not showing its result correctly.This is the code.
Front-End
[Code]....
The code behind consist of the page_load and the ItemDataBound
[Code]....
Conseptually what I'm doing is simple, and technically it may even be simple, but I'm still rusty. Here's what I'm trying to do:
I have a webform that allows the user to enter a new record, and in there I have also included a couple FileUpload controls. Upon clicking the "Save" button, I'm saving the details entered into one table (ITEMS), and also inserting the FileUpload details (path, id, upload_user) into another table ATTACHMNTS). Because one ITEM can have many attachments, I needed to split the tables up. So on save, I need to save the ITEM, save the ATTACHMENT, and then also put the ITEM_ID in the ATTACHMENT table. I'm second guessing myself because I think all I'd have to do is after I do the ITEM insert, do a SELECT MAX on the ITEM table and hold the newest (MAX) id in a variable and then use it in the ATTACHMENTS update. I'm not 100% on this because there IS a chance that someone else could save a few milliseconds later and I'll link the wrong ITEM. See my delima?
How do I insert records into database using Ajax editor.Â
View 1 RepliesI am using link button in updatepanel and click on asp:linkbutton it refereshes all page. to stop _dopostback on link button click.or any alternative to use linkbutton.
View 1 RepliesI want to do bulk insert,bulk edit,multiple delete records in gridview.
View 1 RepliesHow to add checked records in nested gridview to database in ASP.Net?
View 1 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've an ObjectDataSource & its datasource from typed dataset which is bind to 3 textboxes.
One of that textbox text concatenate with other two textboxes values.
Some thing like this,
textbox1.text=textbox2.text & textbox3.text
How can I customize my insert query for this?
I could not see the insert query in my objectdatasource.
In the procedure function, there will be queying several times based on conditions.
Suppose each query retrieves several records, can I caumulate those records in on table, then return that table.
Benifit I want to success here is that I want to save time, so instead of making several functions each has one query, each one requires a connection to databae, so it will take time.
I am using an objectDataSource for the first time. My objectDatasource looks like this:
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server" TypeName="CustomerData"
DataObjectTypeName="Customer" DeleteMethod="DeleteCustomer" InsertMethod="InsertCustomer"
SelectMethod="GetCustomersByObject" UpdateMethod="UpdateCustomer" OldValuesParameterFormatString="original_
[code]...
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 RepliesSuppose we have a website with 10,000 viewers each second. And we want to insert the viewer's information to the SQL database. So we must insert 10,000 records to the SQL each second. And it may take long time to do.
My question is: How can we decrease this process.
im 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 code for inserting a record into the db, it works fine from the admin part of my website but when i put it on the customer side duplicate records are inserted into the db, any ideas? I cant for the life of me see why. I have just also noticed that when i add the claim the first time it adds the duplicate entry, if i press the button again it only adds the entry once, if i refresh the page add the info again, 2 entries, click add again 1 entry?
[Code]....
