DataSource Controls :: Store Formulas To Use Later In Web Application?
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
Similar Messages:
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
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
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
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
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
Apr 24, 2010
is datable data store in asp.net dataset.. ?
View 1 Replies
May 19, 2010
I want to execute a Store Procedure and then get the Output in one table. However I am not getting the query. I want something like this execute 'Stored procedure name' 'param1','param2','param3' and then get the result into some table. Is this possible?
select * into #table from (execute 'Stored procedure name' 'param1','param2','param3')
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 11, 2010
I have problem with retrieve value from Microsoft Access (MDB)..
I want get a value from Database and change it and Store it (Updated Value) again..
For example, I have number 2 in my DB, i want get it and Add 1 to it and store number 3 (Updated number 2) again..
I use SELECT Command but i can`t store values to a place for change them..
View 2 Replies
Jan 11, 2010
i want fetch multiple values from the database and store in one local array and once again i will send it that multiple values to the database
View 4 Replies
Apr 15, 2010
I want to store value like 01,02,03 in database but whenver i do so the database transfor those figures into 1,2,3. The field is Int Type.
View 4 Replies
May 4, 2010
I have DataTable in which I am storing formatted string (in one of the columns)
[Code]....
I want to store the formatted string in SqlTable, because I am in a situation where I cannot reformat.
How to do it
View 8 Replies
Jan 1, 2010
storeprocedure code:
ALTER PROCEDURE sp_CheckForDuplicates
(
@UserName VARCHAR(50) = NULL,
@FirstName VARCHAR(50) = NULL,
-----------------------------
Error show :if (objReturnPara>0)
[Code]....
operator '>' cannot be applied to operands of type 'object' and 'int'
operator '>' cannot be applied to operands of type 'object' and 'int'
View 14 Replies
Jan 8, 2010
I need to enter text in sql in nvarchar(max) .. the text contains titles and paragraphs.
I was using a separate table called paragraphs to enter paragraph title and paragraph content. These get a 'article ID' so I can read them out of SQL. On my page I format title and content differently.
Now I was wondering if I can enter Title format information into sql (as the <br/>) tags, so that i can enter all article information into 1 table column.
View 4 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 7, 2010
I am using SqlDataSource control to query my data via store procedure. Based on which option the user picked from the RadioButtonList control, I want to dynamically at run time to choose which store procedure gets executed. How do I do this? I am already using Query String for my parapmeters. I can could use this for the store procedure as well. The problem is, how do I get the SelectCommand to pick the store procedure name from the parameter passed in the URL?
View 7 Replies
Mar 10, 2010
When I try to create a stored proc in SQL Server Express 2008 by right clicking on the Stored Procedures folder of my database and selecting New Stored Procedure, then attempt to save, it saves the procedure as a SQL query in the projects folder instead of saving it as a stored procedure in the Stored Procedures folder of my database.
View 2 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
Mar 19, 2010
my problem is my asp.net and C#.net application should read flat files(.txt,.doc) from folder automatically and read the data from file and stored into database
my file like this :
BNK20100312APPHU6658994 // BNK,20100312(date),Ap,PHU6658994 So we have to store these..
BNK20100312APPRU5104220
BNK20100312APPRU5761800
BNK20100312APPZU3739288
BNK20100312APPZU4454037
BNK20100312APESU2552894
BNK20100312APAXU4302543
BNK20100312APCKU1613369
View 1 Replies