Data Controls :: Import Excel With Parent Child Relationship Data To Database
Mar 26, 2016
I have an excel sheet which has several parent records/rows and every parent row/record has several child sub-records under it. I have a field called ID which is of the type String as it contains a mixture of characters and numbers and is common for both parent and child records. How do I store the parent and child records in separate database tables, retrieve them and display them in a nested gridview?
View 1 Replies
Similar Messages:
Sep 1, 2010
a FormView that is linked to SqlDataSource1a Repeater control (inside the formview) that is linked to SqlDataSource2 Thus representing a simple "1 to many" or "parent/child" relationship in the database!
SqlDataSource1 is simple in that it just retrieves a straight set of records from a table and they are displayed back in the FormView (nothing special happening there).
SqlDataSource2 has parameters that filter the contents of the repeater based on the record that is shown in the Formview. This would normally be simple enough to set up by setting the parameter to the formview.selectedvalue property.
HOWEVER - THE PROBLEM ARISES...
The formview has multiple DataKeyNames because the table that the SqlDataSource1 links to has a compound key. So to filter the Repeater correctly SqlDataSource2 needs to map 3 parameters to 3 data key values in the formview.
I've tried setting the SqlDataSource2 parameters to:
<SelectParameters>
<asp:ControlParameter ControlID="FormView1" Name="Parameter1" PropertyName="DataKey(0)" />
<asp:ControlParameter ControlID="FormView1" Name="Parameter2" PropertyName="DataKey(1)" />
<asp:ControlParameter ControlID="FormView1" Name="Parameter3" PropertyName="DataKey(2)" />
</SelectParameters>
but it doesn't seem to like that approach. I'm expecting the answer is something similar .
View 1 Replies
Mar 3, 2014
I have nested gridviews, in the outer grid I am displaying the question and in the inner grid 4 options are displayed in radiobuttons. I have kept Lock Answer button inside Item Template in inner gridview , so this button is coming with each and every question and when i click on Lock Answer button in front of any question, its saving the corresponding answer in the database. For ex, if there are 10 questions this button is coming with all the questions, all the questions are on single page and all are multiple choice. Now everything is working mine, my requirement is that I need on 1 common Lock Answer button at the bottom of the page and not with all the questions. And when I click on that common button it should run for all the questions that are displayed on the screen at should fetch and update each unique answer corresponding to that question in the database. Below is my code:
<asp:GridView ID="gvouter" runat="server" GridLines="None" AutoGenerateColumns="False"
AllowPaging="false" OnRowDataBound="gvouter_RowDataBound" Width="100%" OnRowCommand="gvouter_RowCommand"
OnPageIndexChanging="gvouter_PageIndexChanging" >
<PagerSettings Position="Top" />
<Columns>
<asp:TemplateField>
<ItemTemplate>
[code]...
View 1 Replies
Jul 2, 2010
i am binding a gridview through a query like select * from table, But i am not showing all fields in gridView. Only few fields i am showing in gridview. Now I want to import data to a excel sheet. i want to import data showing by gridview and also which is not showing by gridview. i meant all fields in database table should import to excel sheet.
View 1 Replies
Jul 31, 2013
I am making a form to import excel sheet from local computer to azure sql database easily.
I am using [URL] ...
I have made The ID as : Identity, Not Null.
As in my Excel sheet data the ID column is empty, as normally i used to integrate whole excel to sql db so it auto generate, but its waste of my time.
So I want to ask in order to make it successful in case i have no ID numbers for my data in excel file and have Not Null at azure sql db and want to auto generate ID on sql server db after the data that is already on the sql server db.
Because the table where data will be stored is having like already 142302 records and i want to generate my uploaded excel file to there and numbering automatically for ID as 142303, 142304 .... So on.
View 1 Replies
Jul 30, 2010
how controls (txtbox, radio, etc) are mapped to properties in my Model. Now to the next part : My scenario (example):
Model: three tables: tblPerson, tblPersonOptions, tblOptionsConfig
UI:
Person Name: ______ (required)
Person Age: ________ (required)
radio button: Does Person want to select options? Yes / No ? (required) If yes, then show a checkbox list of options from tblOptionsConfig: (required if yes above). Scenario I tested:
Person Name: Tester User Person Age: Left blank (check if validation error is thrown)
Radion button: Yes. in options check ..let's say 3 out of 5 options. The UpdateModel throws the validation error and the page is returned back to the view(add.aspx).....................
View 9 Replies
Sep 20, 2015
How to populate or bind TreeView from one table use SQLSERVER database in ASP.NET & C# table include
ID,Name,ParentID
View 1 Replies
Dec 8, 2010
how to insert parent/child data to the database. I have a form with two 'dropdown' lists and two text boxes and a 'Comment' text area. I need to save some fieldsto the Parent table and some fields into the child table.
View 2 Replies
Nov 22, 2015
In the above mentioned article at "[URL]" instead of selecting the existed table in dbserver is it possible to create a dynamic database table based upon the structure of the excel file to be loaded??
View 1 Replies
Mar 15, 2010
i am developing an appilication using asp.net 3.5 with c#.net and SqlServer 2005 as backend databse. in my application i have to import the data from excel file to database table.
View 6 Replies
Feb 16, 2010
Am building a website using asp.net 2.0. I just want to know about how to import the data in excel(.xls) format to the sqlserver database. Provide with the exact steps needs to be done to import data into sqlserver DB. Plz provide with sample data n sample code which implements the same.
View 2 Replies
Jul 15, 2012
I am having a drop down list box which list the table in the particular database. Consisder the table TBl_Admin which have two columns (UserID, Name). I having a excel which contains some list of records with the column userid and Name.
When i choose this excel file and press upload, i need to insert the records found in the excel to the table TBl_Admin in the database.
View 1 Replies
Jul 15, 2010
I am currently trying to figure out the best way to handle a data formatting issue. I have a stored procedure that pulls back basically all the data I need, but using a gridview doesn't really give me what I need.
For example...currently the gridview displays data like:
Date1 ProjectCode1 Hours ApproveChkBox
Date1 ProjectCode2 Hours ApproveChkBox
Date1 ProjectCode3 Hours ApproveChkBox
Date2 ProjectCode1 Hours ApproveChkBox
...
I would like to be able to display the information like:
[code]....
Is there anyway to do this using a nested gridview? Or is there a proper way to display this type of format?
View 1 Replies
Apr 6, 2010
I have a requirement where I need to show the data in parent/child form .For Example - Lets says we have have customers and each customers can have multiple orders.I need to display it like this -
Cust1
Info about the customer
Gridview (showing all the orders for the cust1)
Cust2
Info about the customer
Gridview (showing all the orders for the cust2)
What controls should I used
View 9 Replies
Mar 2, 2011
i am use this code for read excel file:
[Code]....
how to read special cells in excel and I save to DB.
for example: B4 and C4 is merged with named B4.how to read Data of this cell.
View 4 Replies
Apr 15, 2010
Can anyone suggest a good Article which shows this operation.
View 4 Replies
Feb 25, 2016
With reference to this article [URL].... I'm trying to access parent gridview datakey in child gridview edit row event. Code below.
protected void grvSubmittedExpensePerMachine_RowEditing(object sender, GridViewEditEventArgs e)
{
GridView grvSubmittedExpensePerMachine = sender as GridView;
grvSubmittedExpensePerMachine.EditIndex = e.NewEditIndex;
string site=this.grvSubmittedExpenses.DataKeys[((row.NamingContainer as GridView).NamingContainer as GridViewRow).RowIndex].Value.ToString();
[code]....
View 1 Replies
May 7, 2015
I am working in Asp.net 4.5. I need to create a grid as like below, I am struggling to make the merging cells and make it as multi header row by combining all the cells...
Is there any sample to make gridview like this.... I need to do this on codebehind. I browse through the internet and found couple of sample but those are not having the header like i posted. I am little confused about making full header as merged cells....
View 1 Replies
Jan 29, 2011
I am using a collapsible child gridview inside a parent gridview. When I click on the expand image, the data to displayed is put up correctly, however when I make some changes in the child gridview, they seem to be lost!! That is, the changes do not get reflected in the database.
View 3 Replies
Feb 2, 2010
I got data retrieved from Sql DB in a 3 different dataset. I need to get all data from
View 7 Replies
Mar 11, 2011
Is there a way to import an amount of data from an excel sheet using the sheet rowindex, something like: SELECT * FROM [PLAN1$] WHERE ROWINDEX BETWEEN 1 AND 1000?
View 1 Replies
Jan 11, 2011
I have created a search page for web application that will allow a user to search the database based upon employee name or supervisor name. It is a multiple table database that is linked together by an unique employee number column, primary key in people and foreign key in supervisor. I have a parent/ child datalist used to display the record. When searching by the employee name it will return the record correctly if there is a record found. However, if I search by supervisor name and there is no match for the supervisor name, it will return all the records and create the parent datalist with all the employee details there, but the child datalist with the supervisor information is not display as there is no record with that supervisor name.
[code]...
View 1 Replies
Jul 21, 2010
since APS.Net 4.0 I have a curious problem with an event.
There is a FormView and inside of the EditItem there is a GridView. In the Footer of the GridView I put Controls for inserting records.
But when I fire a markup defined RowCommand of that GridView then the same event is getting fired for the Parent FormView. First I had 'Insert' as the CommandName and so I was getting the Error that my FormView had to be in insert mode to insert a record. Then I changed the RowCommand of the GridView to 'xxx' and I got also the RowCommand 'xxx' at the RowCommand eventhandler of the Parent FormView.
The project was migrated from .Net 3.5 a few days ago, but nothing was manually changed in the code/markup. And the problem was not there with the "old" framework.
[Code]....
Of course, I could simply change the CommanName of the LinkButton e.g. to 'InsertChild' but I would like to know:
Is this a known change or a bug of ASP.Net 4.0?
View 1 Replies
Apr 30, 2010
I am using nested repeaters and wanted to access a value from my parent repeater within the child...is this possible?
View 3 Replies
Dec 29, 2010
I have a treeview and all nodes are check box, when user clicks on a button, how can I get all the checked child nodes belongs to specific parent? I wanna something better...
private TreeNodeCollection GetCheckedNodeForParent (string parentNode)
{
TreeNodeCollection treeNodeCollection=new TreeNodeCollection();
foreach (TreeNode node in tvBaseline.FindNode(parentNode).ChildNodes)
{
if (node.Checked)
treeNodeCollection.Add(node);
}
return treeNodeCollection;
}
View 2 Replies
