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..
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 RepliesI wonder what is the best place to store the enums I should use like constants in my n-tiers Application.
So I have an application with a DAL(connect to database), a BLL(Business processes), a Data Transfert object "Layer" (classes without any methods but just fields, this one is reacheable by all the others) and the interface layer with the asp pages.
My question is : I have a enum:
[code]....
Where can I put this enum(and all the others) to be clean? Not in the Data Access Layer the Interface layer will not see the struct, not in the Business Logic Layer, this is not really business.. Maybe in the Data Transfert Object but is it really a "Transfert object"?
I have read the post at http://forums.asp.net/t/1403132.aspx regarding login control. Is there a place to store the User logged-in ID (info) for later checking and use? I don't need to use the session object. I don't need the page to expire. I don't need the user to use a page saved in the favoites.
View 3 RepliesIs 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 RepliesHow to change the values in gridview on text change of templated control without databind again?the value of templated text boxes should change If i change the value of one of the templated textbox then accordingly(By mathematical calculations) the vlaues of all tempated textboxes should also change.
View 7 RepliesMy sqldatabase is inputting NULL instead of the information from my form. Form is collecting different names and multiple phone numbers for each. names, addresses, zip codes are going in as entered on form but phone numbers are not they are going in as NULL. Columns are set as header is Cell, nvarchar, Length is 15 and I have setup as I did other columns. code for my form is (i have removed some lines that are working as expected)
[Code]....
I would like to store some business flags (like: isFavorite, isOnLive etc.) per an html table row that won't be visible to user.
In practice, I have a simple ADO.Net DataTable on my code-behind which is used as a data-source for a asp.Net GridView control.
This table contains some business flags on its 0th, 1st, 2nd columns.
I need to store those columns on the rendered HTML of the grid-view -so that I can reach them via JavaScript- but I do not want them to be visible.
I want to calculate the service tax on some amount. The value of service tax must be taken from textbox1.text and amount from textbox2.text and then after calculating it must be store in another textbox say,textbox3.text
service tax = textbox1.text - 14.5%amount = textbox2.text - 44000total amount= textbox3.text -((14.5*44000)/100 )+ 44000 ;
The Value of ((14.5*44000)/100 )+ 44000 after calculating will be store in textbox3.text
[Code]....
I am trying to store decimal values from detailview. But it doesn't work. It stores decimal values after rounding. Let's say if I enter length/width as 4.2000 then in sql it stores as 4.0I am using sql server 2008 and the field is defined as decimal(8,4).I tried diff combination but nothing is working.
Please try to guide me how to achieve this one. my application need to do reading the PDF document and want to store the values in Database.Actually what happens is my customers sends me the OCR scanned copied in the form of PDF file. i need to read those scanned pdf files and store the customer information into my table.
View 1 RepliesHow can I make the code string connStr = ConfigurationManager.ConnectionStrings "staceys_cakesConnectionString"].ConnectionString;
work generically and not need the staceys_cakesConnectionString? Or how can I set it somewhere else so I only have to change it one place when I change it?
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
[Code]....
I m working on ASP.NET using C#, i need to compare the data from two DataSets with a "ID" which is in both the DataSets and then add all the matching rows to a New dataset.
View 2 RepliesI have an ASP.NET application that needs to remember some info about a user (and what company they are from) across pages, within a session. I imagine this is a requirement of just about any ASP.NET application of a certain size. I've used a few different approaches over the years. In the past, I've passed around an id in querystring parameters like so: [URL] and then instantiated the object on each page (from the database). Another common way of doing it is storing my objects in session variables:
Session["User"] = currentUser; // store at login
User currentUser = (User)Session["User"]; // retrieve on some other page
which saves a trip to the DB, but I worry about memory used if the User object is complex and the site has many concurrent users. I have recently inherited an application that uses public properties on the master page, like this:
Master.theUser = currentUser; // store at login
User currentUser = Master.theUser; // retrieve on some other page
This saves the cast, and looks more readable to me I think, but I don't know if it's better or worse performance-wise. It also has some logic in the getter where if the private value is null, it tries to get it from the Session variable, though I'm not sure if that's never used (or used every get!?) or what. My latest idea is to use my page class. I have a custom page class derived from the standard System.Web.UI.Page base class. It includes objects like CurrentUser as public properties. This seems to work OK. I like it even better. But I really don't know what's going on under the covers. Can anyone give an opinion on which approach is better and why?
Update: I've done some checking use trace.axd and Trace.Write and it looks like neither the masterpage version nor the custom page class version "remember" the values between pages. The "get" methods have a line of code that checks if the User property is null, and if so, reads it from the session variable. This happens when a page accesses the property (Master.User or the derived class's this.User) for the first time on a given page, then subsequent requests can get the value (without going to the session variable). So thus far the best solution looks something like this:
public class MyPage : System.Web.UI.Page
{
private User user;
public User User
{
get
{
if (user == null)
{
user = (User)HttpContext.Current.Session["CurrentUser"]; //check if session[CurrentUser] is null here and log them out if so?
}
return user;
}
set
{
user = value;
HttpContext.Current.Session["CurrentUser"] = value;
}
}
}
Then on any webpage.aspx.cs, you can do something like this: UsernameTextBox.Text = User.FullName;
i m using a place holder in which i m inserting checkbox list but i m unable to retrive selected values
[Code]....
I want to retrieve and store(in an array) all the row values of a particular column in a gridview..i.e,if I have gridview with columns col1,col2 and col3, I want to retrieve rows of col1 by specifying col1..And,store all the rows in an array
View 4 RepliesI want to place two datalist controls at the same (x,y) position. When the first is visible, second should be invisible.
How would I go about implementing this?
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 RepliesI 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 ?
What data type in SQL should i use to store an XML file? And how do i do it?
View 5 Repliesi 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...
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]...
I'm trying to count the number of activities in a month without using the Case When clause
This is what I was able to produce so far
SELECT COUNT(MONTH(irActivity.ActivityDate)) AS 'JAN'
FROM irActivity INNER JOIN pdEmployee ON irActivity.Act = pdEmployee.Act
ORDER BY 'JAN'
I'm trying to place a filter by "MONTH(irActivity.ActivityDate) = 1)"
Which then gives me a syntax error
I've created 3 buttons, first button is to load the values in textboxes added to placeholder. Then button2 is to extract the data from button 1 and display out. Now the 3rd step, I want to edit the values from the textboxes, after edit, how do I grab and display out the new values in label and textboxes?
Code:
Partial Class _Default
Inherits System.Web.UI.Page
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim x As Integer = 1
Dim message As String
[code]....
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??