DataSource Controls :: How To Store The Hierarchy Data For The Organization
Feb 19, 2010
Here I store the hierarchy data for the Organosation. Under_Level_ID denotes under which Level_ID the current Level is lying. e.g. for Branch the hierarchy in above table will be likeHO-->REGION-->Branch & for ZONE the hierarchy will be same as branch. Now my problem is I need all the hierarchy below a given Level. i.e. if am passing 132 as level then the SP should return me all the hierarchy elements lik Zone, Branch, fgfgfhf, Cluster,
CREATE TABLE [dbo].[T_LEVEL_MASTER](
[Level_Id] [numeric](18, 0) IDENTITY(1,1) NOT NULL,
[Org_Id] [numeric](18, 0) NOT NULL,
[Level_Desc] [varchar](100) NULL,
[RM_SB] [varchar](50) NULL,
[Under_Level_Id] [numeric](18, 0) NULL,
CONSTRAINT [PK_T_LEVEL_MASTER] PRIMARY KEY CLUSTERED
(
[Level_Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
View 3 Replies
Similar Messages:
Mar 6, 2010
I,am trying to create a self association relation for an organization chart data tree in Entity Framework,after trying different ways for prevention of exceptions like 3007 and etc. I found that when I put my foreign key in my POCO near Parent and Items navigation properties its work.but I think this is not correct that we have both ParentID scalar property and Parent navigation property. review this and tell me is it correct or not.I'm using VS 2010 RC and ofcource .net framework 4.0 RC
[Code]....
View 2 Replies
Mar 11, 2010
i have to show organization chart for an organization. i have no idea how to do that,,how can i use system.graphics name space to show this chart can anybody help me with this..??data is basically coming from data base, the whole hierarchy is there in the database i have to show it graphically on organisation.aspx page.
View 3 Replies
Apr 24, 2010
is datable data store in asp.net dataset.. ?
View 1 Replies
Mar 4, 2010
in ASP.net website C# code
example:
in SQL server, I have table TaxTable with column named TaxID, SalaryFrom like this:
TaxID SalaryFrom
1 1
2 2083.00
3 2500.00
4 3333.00
5 5000.00
6 7917.00
is there a way to store the values under salaryfrom column into an array?
note: In C# , Im using system.data.common.DbProviderFactories
this is so that I can read data from both sql server and mysql
View 2 Replies
Jun 22, 2010
want to store videos in database using linq i am using a object data source and calling a addvideo method but i have no idea how will be the query to insert data in sql server using linq and how i will store binary data in database using linq.
View 1 Replies
May 14, 2010
I am trying to store data from an XML file to a table in my database, but I keep getting the same error.
This is my code from the cs file:
[Code]....
And this is my error:
Violation of PRIMARY KEY constraint 'PK_Areas'. Cannot insert duplicate key in object 'dbo.Areas'.
The statement has been terminated.
In my XML file I have both existing rows and new rows for the database table. I'm guessing I have to do something to sort out the the rows that are not already in the database, but so far I have been unsuccessful to figure this out.
View 1 Replies
Nov 19, 2010
I have a GridView that sorts and has paging features. I need to grab the data from the SORTED DATA from the GRIDVIEW and put it into a DataTable. Who Do I get that sorted data gridview and store it into a DataTable. I am an ASP.NET Programmer. Goal: Get and Store Sorted GridView Data into a DataTable.
View 2 Replies
Jan 30, 2010
1)How to convert 64base string to binary in asp.net and store into sql server.
2)when i convert 64 base string into binary & try to store it into database then it has taken so much tiime to insert. The size of 64base string is 1.5MB. and when i converted to binary then the size is 11MB.so the best way to insert the binary data into sql server. The data type of column is varbinary(MAX).
3)How can i insert the varbinary data into sql server uisng asp.net?
View 1 Replies
Jan 1, 2011
I have int datatype declared in my store proc.
When I try to pass parameter from code behind in sqldatasource as :
SqlDataSource3.SelectParameters.Add(ContactNum",
System.TypeCode.Int32,
"1")
I get error "
Error converting data type nvarchar to int. "
View 3 Replies
Jan 26, 2011
I have one SqlDataSource control as DataSet with enable caching in one page aspx. Filtering is applied to this SqlDataSource control, so that the page always returns one record data.
My question: How to get the record data value from SqlDataSource control (one record data value) and store it as String variable?
View 3 Replies
Mar 25, 2010
Is it better to store images directly in a database or to just store the name of the file in the db and display that file? I would think that just storing the filename of the image would keep the db size low...
View 1 Replies
Oct 7, 2010
I need to display data in GridView with Multileve hierarchy same like Treeview.
View 5 Replies
Aug 14, 2010
i have Successfully binded the Schedular from Objects and its looking Good and the Following code has done that.i am using the Telerik Grid , but the implementation to the grid is the same as the Gridview. What i need is a guidance on how to bind hierachy grids from ojects or lists
[Code]....
Now with the same results i want to bind a Hierachy Grid as it Shows in my attached image. I am using EAE that means the is no Fixed Column name, so the Binding of the Grid Should be Dynamically.
View 2 Replies
May 6, 2010
I want to pass the Array ( object[]) or Structure data type value to the store procedure through
ibatis .net. I can do same by commandtext using SQLDBType.Structure. I am using Table value function in sql server 2008 and .Net 2010.
[URL]
View 2 Replies
Feb 8, 2010
I had a little problem with the value that one of my SPs returns. In my SP, I create some temporary tables to store certain data from multiple tables and contains some queries for an advanced calculationBut precisely yesterday, the value that the SP returns was incorrect. I tried to look at the SP and the data again and everything was OK, but not the result from the SP.And what the heck!!..today the value is totally right ...I truly have no idea what's wrong with the SP..Is there anyone knows what the root of cause is?
View 4 Replies
Feb 4, 2010
I have a table which contain products, I want each record in the table to have an image. I've created the field with the datatype image. How to I manually add image to the table ?
View 5 Replies
Feb 23, 2010
What data type in SQL should i use to store an XML file? And how do i do it?
View 5 Replies
May 3, 2010
i have follwing column in databse Name,age,Education,Intrest,MyImage(optional field)
i want to store the follwing info in databse using linq to sql, i know how to store other type of data then image, how to store image with above information keep in mind that image is optional...
View 4 Replies
Feb 3, 2010
General Flow is : Receipt, Dispatch, Issue.Receipt & Dispatch are normal.Item Received, Qty...etc entered through UI database updated.Item Dispatched, Qty...etc entered through UI database updated.Further Issue is subdivided into 3 types :1. Qty entered through UI DB Updated.2.Rates are defined for items & after entering the Qty through UI Amount is calculated.3.Scales are defined for Items & based upon those scales & the strengths of Consumers formula for these items is calculated.
[code]...
View 2 Replies
Jan 13, 2011
I am using VS 2010 for developing asp.net application. we have a requirment to display 3 level hierarchy data into the server controls, how can I do this implementation. My data look like.
Reporting Divisions (1st Level)
Reporting Groups (2nd Level)
Reporting Units. (3rd Level)
Ex:
Division1 Description (1st Level)
Group1 N/A (2nd Level)
Unit1 Unit1 Description (3rd Level)
Unit2 Unit2 Description (3rd Level)
Unit3 Unit3 Description (3rd Level)
Group2 Description (2nd Level)
Division2 (1nd Level)
Group1 Description (2nd Level)
DivisionN Description
how to implement this? And user need to edit the "description" data from the controls also.
View 2 Replies
Nov 11, 2010
Its related to datatable in gridview store in session and then session retrive and store to database. basically i am using gridview here creating new row for button click and these row adding untill user's last entry then submit all these entry to database. so i want to use session variable to store this data temporarily and after final entry user click on submit button and all data shold be save in db.
View 9 Replies
Apr 14, 2010
I have a sql which the data read from the store procedure is very dynamic.
i have finish the first part of the sql in stored procedure but having problem in executing it.
[Code]....
How do i use EXECUTE SP_EXECUTESQL to do this??
View 2 Replies
May 22, 2010
I know this is a wrong place to ask this but i cant resist
I want users of my website to store article with Images..How a i able to store the content in SQL Server?
View 3 Replies
Oct 13, 2010
I'm not expecting a full solution here (unless you really want to), just some tips and pointers.
I have a User table and an Area table. The User table has userID, userName etc., and the Area table has areaID, areaName etc.
I'm binding the list of Areas to a checkboxlist where the user MUST choose between 1-3 options. I'm using a stored procedure to update the DB.
Is there a common solution to this problem that I haven't found?
I have thought about saving it as a comma separated string in a field in the user table. This looks like a temporary and ugly solution though, do you think?
A nicer solution would be to create a UserArea table where I save the ID's as foreign keys from areaID and userID. But I don't know how to write this stored procedure where I update and insert the choices made.
View 5 Replies