I am putting together a small database for recording stock movement.I have a table which will hold
StockID
StockItem
QtyInStrock
I want the user to enter in a textbox the number required from stock then do the subtraction before updating the QtyInStockWhat is the best approach for doing this.
am getting the value of quan and quantity like below i have given... so i want to subtract these two and update it in item_quan field in c_item table. but quan and quantity getting from query giving correct value but its not getting updated in the query below given the bolded update query below...
da7 = new SqlDataAdapter("SELECT item_name, item_quan,item_cat FROM c_item WHERE (item_name = '" + fname + "') AND (item_cat = '1')", con);
I want to store Session Data after Close browser.
View 1 RepliesI am confused about how to reference objects in session, how to update, and copy.
if I create
MyObject obj = new Object ();
then
Session["object"] = obj;
MyObject temp = (MyObject)Session["object"];
If i change something on temp, will the object in session be updated? do i need to follow changes with Session["object"] = temp?
how the date subtract in day in C#
<asp:textbox id="d1" runat="server Text="1-Jan-2011"/>
<asp:textbox id="d2" runat="server Text="11-Jan-2011"/>
the final output is
d1-d2=10 days(in C#)
I have seen a lot of info on how to subtract one datetime from the other and how to add years on to a datetime. but the following is giving me a headache....When a user inserts a record a hidden field called subdate with a value of datetime.now is added to the db.I then need to have an 'old records' page that lists all the entries that are over 1 year old and was hoping to use something (but using subtract method) similar to;
(DateTime.Now.AddYears(1))
but there is no SubtractYears available? Why?
I need to subtract one minute from the TimeOfDay
[Code]....
dear i want to subtract 60 seconds from current date.
View 3 RepliesHow do I subtract a month from a date object in VB.NET?
I have tried:
Today.AddMonths(-1)
However, given that Today is 01-Jan-2010, the result I get is 01-Dec-2010. The answer I want is 01-Dec-2009.
Is there a convenient way of doing this within the .NET framework?
I have 3 textboxes.
1 Textbox = Start date and time
2 Textbox = End date and time
3 Textbox = End date and time SUBTRACT Start date and time
Any idea on how to subtract these two dates.
Example
Textbox 1 = 2010-01-20 11:33:52
Textbox 2 = 2010-01-20 12:53:59
Textbox 3 = the difference of textbox 1 and textbox 2 which is 2010-01-20 01:20:07
Im doing this in VB.
I made a project to use the access membership provider from [URL] and it works. But I need to edit my database but when I configure my database, I cannot see the tabel, I can only see the queries in mdb file. when I select the field from query, I am unable to update it. My code is as follows:
[Code]....
I have 4 file uploader in my form to upload 4 images in the DB for each article submitted. My issue when I want update/edit my article with some new pictures and I want delete or update the old pictures with the replacement with the new one.
How I can implement it? I am using ASP.NET based on VB.NOT .... NOT C#
I have a GridView, that contains 3 Textboxes. Say Textbox1, Textbox2 & Textbox3
Now how do I subtract the value of Textbox1 & Textbox2 & show the result in Textbox3?How to do this in JavaScript?
I have the following two pages. One is a search page that have a few listbox/textbox/and dropdownlist. The other will be the result page that take from session those 3 data and using an if/else statement to sort out some detail. After that it will form an access/sql selectcommand to search the database base on that 3 criteria. But for some weird reason only the first part of my if and else statement work. Can anyone check and help me out why the rest of the if/else doesn't work. Or point me to another direction?
---------------------Search.aspx-----------------------------
[Code]....
-------------------SearchResult.aspx-----------------------
[Code]....
[Code]....
i am facing some problem in update, edit and even create new data into my access database using data detail view. i am using microsoft visual web developer 2008, i can do the same when sql server database were to tore the data. but when i try to do the same using access database, an application error. may i know whats going wrong? and how to solve this problem?
View 7 RepliesI have a query that gives me the average number of days between 2 dates in the database. It gives an error saying line does not reconize the subtract method. What is the best way to do this, i prefere not to have to get the whole table as a list and loop though.
Using em As EE.EclipseEntities = New EE.EclipseEntities
Return em.OrderLines.Where(Function(w) w.Received_Factory_On.HasValue) _
.Average(Function(a) CDate(a.Received_Factory_On).Subtract(CDate(a.Sent_Factory_On)).Days)
End Using
I am trying to get into grips with AJAX/JQuery and MVC. i need to access the session on the controller. This doesnt seem to be initialised at the constructor level but there needs to be a way I can store items in the session in the constructor depending on the parameter values (an extra constructor is written here) I am also doing unit testing here, which has been provided by 3rd party and they are using this extra constructor.
So the idea here is that when the page is loaded, JQuery will request a collection of items (which will be stored in session) and also be able to post to the page so items are added into the collection too. So, what is the best way here to get access to the session in the constructor of a controller?
I have a pagemethod defined with the attribute [WebMethod]. The pagemethod accesses the session with no problem (HttpContext.Current.Session).
However I just read somewhere that in order to access the session in a WebMethod, you need to define it like so: [WebMethod(EnableSession=true)]
So my question is, what gives? How come I can access the session even though I dont have that code? Apparently EnableSession defaults to false if its missing, so I should not be able to access the session. The web application uses ASP.NET 3.5 and uses InProc Cookieless sessions.
I'm populating an object model with a linq query. The model looks like this:
MyModel{
DateTime AppointDate {get; set;}
int TotalAppoints {get; set;}
int AppointDuration {get; set;}
}
The linq-to-sql query looks like that:
public static GetAppointsFromDB(params){
var MyQuery = from....where...
select new MyModel{
AppointDate = ...,
TotalAppoints = ...,
AppointDuration =...};
return MyQuery as MyModel;}
In the master page, I'm looking to load the result of this query in the session like this:
if (Session["Appoints"] == null) {Session["Appoints"] = GetAppointsFromDB(...);}
When I run with the code, the session is always null. I added this line a second time, just right after, and the query runs again. When I'm looking to use the session at some other point in the code, it is null too there too. The query works because when I put a breakpoint on the return statement, I see the object properly filled.
I have a Datatable store in the Session. This Datatable has a column call Qty. I have one button on the page that will update the Qty. How can I update my DataTable Qty column?
[Code]....
I have written a script to write several values to an Access Database Table, but I need to ammend i so it checks for two values (Asset and LName) to see if they match if they do it updates the record if not it writes a new record, my script so far is as follows :
[Code]....
I'm just stuck as I can't work out the best way to do it,
I want to access the session value at client side.
Code:
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
btnGetSessionValue.Attributes.Add("onclick", "javascript:return GetSessionValue();");
}
}
[code]...
I've my ASP.Net HTML 5 Application, Which have the image byte array in Session, I'm using the Latest 5.X C# facebook SDK from CodePlex.
But when user is authorized and Coming back to my canvas page at that time I can't access my ASP.Net Session, its give me a null value.
Here is my Code.
[code].....
Now pls give me some suggestion, Where I'm missing, How can I access my Application Session.
I have 2 projects in my solution.
MVC Web application
Class library
The MVC Web application references the class library.
The class library contains a class that extends the default ASP.Net Controller.
I'm putting a variable in session in the application's Global.asax.
protected void Session_Start(object sender, EventArgs args)
{
HttpContext.Current.Session["DomainName"] = Request.Url.Host;
}
In the class library I'm trying to get the value from the HttpContext.Session, but HttpContext.Session keeps coming up null.
[code]...
HttpContext.Current.Session doesn't seem to be an option in controllers.
in one request i am updating session variable. in the other request, i am trying to access that session value, but it was blocked until the first request finish. I am using C# with ASP.NET 2.0 UPDATE: My page code looks like this.
while(int progress = DoWork() && progress <= 100 ){
Session["Progress"] = progress;
}
and my handler just return Session value.
context.Response.Write(Session["progress"].toString());
context.Response.End();