[Code]....
How to get SUM in TextBox1 = Najdinaloge.Kilometrov.ToString();
and how to get SUM in TextBox2 = TextBox2.Text = Najdinaloge.Kilometrov2.ToString();
If I use
var Najdinaloge = (from p and db.tbl_PotniNalogis
join t and db.tbl_RelacijeZaMestneVoznjes
[code]....
works, but there is only one figure sum.
I can't get the total from the row of the grid as I enter in the cells of the first row. Doesn't SelectedIndexChanged fire asI leave each cell?
I set a break point in the code and it's not stopping there.
<asp:GridView ID="GrdDynamic" runat="server" AutoGenerateColumns="False"
onrowdatabound="GrdDynamic_RowDataBound"
onrowediting="GrdDynamic_RowEditing"
onselectedindexchanged="GrdDynamic_SelectedIndexChanged" SelectedIndex="1"
AutoPostBack="True">
</asp:GridView>
protected void GrdDynamic_SelectedIndexChanged(object sender, EventArgs e)
{
double total = 0;
for (int colIndex = 0; colIndex < 16; colIndex++)
{
if (GrdDynamic.Rows[0].Cells[colIndex].Text != "")
total += Convert.ToDouble(GrdDynamic.Rows[0].Cells[colIndex].Text);
}
GrdDynamic.Rows[0].Cells[16].Text = total.ToString();
}
[Code]....
Summing a column in a datagrid
In my table of entries, there are other entries commenting on the orig entry. The comment entries are marked in the table by having a commentID field that matches the ID field of the post being commented on. Follow?
How would I sum the nbr of comments for each orig entry?
I want it displayed in upper superscript fashion like the "2" in E=MC "2"
is there a SQL statment i could write that would sum each column and allow me to then access each sum individually
i.e
Dim objCmd As New OleDb.OleDbCommand("SELECT SUM(expression) FROM orderForm WHERE OrderDate=@OrderDate", objConn)
is there anything i can replace expression with such that all the columns in orderForm could be summed and returned as one record
or is there a way to replace expression with something that would allow me to just keep changing the paramater so i could continuously reexectute the same command w/o having to create a new command for each column
I wrote an ASP .NET database app, that store data in the database, for some reason, and i've tried all that I know, when two or more users submit info simultaneously, their data gets store wrong, i.e. the data gets mixed up.
View 8 RepliesI currently have a datasource that displays several rows on an editable gridview where the user can update several rows at once. Each row contains an ActivityTotal column per row. I'd like to sum all the ActivityTotal rows displayed and have one totalValue.
for example
row 1 activityTotal = 4
row 2 activityTotal = 3
row 3 activityTotal = 1
totalValue = 8
How can I incorporate this into the code?
I would like to display the following information for each "Camera" (in the format below) on my web page in an HTML table. All the data is contained in one table in my database:
For Camera = Canon (e.g.):
Type (Text via asp:Label)
Lens Size (Text via asp:Label)
Storage (Text via asp:Label)
Max. video resolution (Text via asp:Label)
Max. photo resolution (Text via asp:Label)
Weight (Text via asp:Label)
Dimensions (Text via asp:Label)
Sensor (Text via asp:Label)
...where (Text) is the value retrieved from the database for the given Camera. advise on the best way to retrieve this data? The only method I can think of (from my limited experience!) is to have a separate VB function for each value, to run separate SELECT queries for each field, and then to set the (Text via asp:Label)
value accordingly. I am already doing this for datagrid retrieves etc. For example:[Code]....
BUT... I know there must be a better method for the above requirement!
I have placed Chekc box in Gridview when i select the check box can perform 2 operations simultaniously one is entire recordset is populated into form fileds and second one is can delete the selected record permanently from database table.following code for this fuctionality.
GridviewCode
<asp:GridView ID="GVData" runat="server" Height="75px" Width="76px" CaptionAlign="Top"
Font-Size="Medium" EnableModelValidation="True" [code]....
I am trying to reproduce a threading error condition within an HTTP Handler.
Basically, the ASP.net worker procecss is creating 2 threads which invoke the HTTP handler in my application simultaneously when a certain page loads.
Inside the http handler, is a resource which is not thread safe. Hence, when the 2 threads try to access it simultaneously an exception occurs.
I could potentially, put a lock statement around the resource, however I want to make sure that it is infact the case. So I wanted to create the situation in a console application first.
But i cant get 2 threads to execute a method at the same time like asp.net wp does. So, my question is how can you can create 2 threads which can execute a method at the same time.
Edit:
The underlying resource is a sql database with a user table (has a name column only). Here is a sample code i tried.
[TestClass]
public class UnitTest1
{
[TestMethod]
public void Linq2SqlThreadSafetyTest()
[Code]....
I have two ASP.NET AJAX UpdatePanels . there are two timers with diffrent intervals. is it possible to update two updatepanels simultaneously together ? like multi thread application . each should be UpdatePanel Update in separate thread in one time. i wrote this code but second timer does not work :
<asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent">
<h2>
Welcome to ASP.NET!
</h2>
<p>
[Code]....
i am doin my final year project and in my project i want to watermark multiple images simultaneously where image,logo,position,alpha and key value is stored in a database table ....i need to retreive these details from db table and perform watermark on those images....
View 3 RepliesI am using HTTP load testing tool to stress test my asp.net 2.0 application. I faced problem that, when I have 1 user access to the system (currently only test on login.aspx), it is very fast ~ 1-2 secs. However, when I run with 10 virtual users at the same time, it takes 10-12 secs for each.
User Response Time (s)
1 10.12
2 10.22
3 11.00
...
10 12.78
My question is, why ALL of them also takes 10-12 secs? Is it normal? I was thinking that should be some users take 2-3 secs and some 5-6 secs and etc.
I have 2 Web applications in the same IIS with the virtual directory structure below:
http://www.mydomain.com/site1
http://www.mydomain.com/site2
both site1 an site2 are using form authentication and creating the token further adding in cookie as below,
FormsAuthentication.Initialize();
FormsAuthenticationTicket ticket = new FormsAuthenticationTicket(1,username,DateTime.Now, DateTime.Now.AddMinutes(20),rememberMeSet,globalID ,FormsAuthentication.FormsCookiePath);
// Encrypt the ticket.
String hash = FormsAuthentication.Encrypt(ticket);
//Create the authentication cookie
HttpCookie cookie = new HttpCookie(FormsAuthentication.FormsCookieName, hash);
My problem is when I'm logging in to Both site1 and site2 then these two are not running simultaneously on single browser using different tab for same user name.one is being logged out when logging to the other application and vice verse.
I have Asp:TextBox,Asp:RegularExpressionValidator and Asp:RangeValidator on .aspx page.
These two validators have ControlToValidate value equal to textBox Id.
RegularExpressionValidator have validation Expression such that it allows only number.
Range validator have maximum value ="100" and if I enter any text then both validators get fired .
Logically only RegularExpressionValidator should fire if I enter any textvalue.
Is there any property of Range validator such that it check for numeric value to compare and disbled if value entered in textBox is some text so that no handling of event(Client side and Server side both) is required.
I have an update panel in my ASP.NET web form with a trigger that will fire a click event when the contents within my update panel is updated (it's a grid view with fields). The event that is fired when then take the changes user made and do some calculation and then update another update panel with that information. This is all fine and dandy when the user tabs along the form and fill out the form in a orderly fashion before hitting any buttons on the page.
If a user accidentally hits another button on the page while changing the content in my grid within the update panel, for example, the user enter a value in my grid view control, without tabbing, the user click the save button. Logically, i believe that the trigger should fire the click event first (event A), and then the save button event (event B). But, consistently I haven't seen event A gets fire correctly while event B gets fire all the time. is there a way to ensure event A always gets fired before event B? also if event A update another update panel without the page will event B fire after the update is complete?
I have two ajax time for my aspx web page but while the one is ticking , the other stops running. How can i make it both timer run together like the windows form?
View 1 RepliesI have a page in which there are multiple updatepanels and each of these update panels are trigerred by different triggers.
These update panels are used to do Async post back and the page is updated with the data retrieved from the async post back.
Now the issue i am facing is that since there are multiple update panels, the update done by one panel is lost when the other panels does the post back.
let me know if any one knows on how to solve this issue.
I have recently combined my aspnet membership database and main website database into one database file, I'm happy with the schemas, stored procedures etc. (This is a development project not yet a production project.)
My problem is that I can no longer simultaneously connect to the database from Visual Studio if a user is logged in to the website.
EG:
Scenario 1: No user is logged in to the website. I can go to the Data Connection window in VS, choose "Add Connection" and then inspect the contents and schemas of the database. This is fine.
Scenario 2: A user is logged in on the website. I try to connect to the website in VS and get the error:
"Cannot open user default database. Login failed. "
Scenario 3: I am connected to the database in VS and nobody is logged into the website. If someone tries to log into the website they get the following error:
Cannot open user default database. Login failed.
Login failed for user 'NT AUTHORITYNETWORK SERVICE'.
So it seems from the above that there can be only one connection to the database at a time? However this was not the case before I combined the membership database with the main website database. I could always make changes as a user logged into the website and at the same time see those changes through the connection in Visual Studio.
I want to know if we can use multiple membership providers simultaneously in a single ASP.net application.
View 1 RepliesI have a asp.net web page.Inside i am calling 2 stored procedures.. which causes huge performance hit on the page
I need to call the both the procedures simultaniously using threading
Both procedures return data which will displayed on the page
Was wondering if someone can help me out with this multi update problem
I have a webform that populates a single table but due to certain dropdown data conditions it could also potentially populate 3 other tables
The tables information populates a gridview with amounts from accounts etc..
e.g.
Table 1
Site DataType account update
34 SS 12.50 N
Table 2
Site account
34 12.50
Say the above entry has the updated column changed to Y via the webform the amount 12.50 should disappear from the gridview. I was
a bit shortsighted and added the additional tables afterward. The information on the gridview pulls from the additional tables and since
the first table and the additional tables are not linked the data still stays the same in the gridview
I do have an Id column on both tables but unfortunately I added the rest of the tables after the first one so the Id's do not really match.
How can insert, Display ,update multiple records simultaneously through GridView in Asp.net.I have Button for insert, update . I want insert, update multiple records through a GridView in a single click.
View 1 RepliesI'd like to know how to save the same GUID simultaneously in two separate tables.
Example:
table1:
Type: 4931281279831231
table2: 4931281279831231
I'm having a problem when two or more users simultaneous work on a webpage and provides info to create a new record in my database. the issue is that for some reason, their entries get mixed up and the wrong data gets commited to the database, how can i fix this. All the webpages i browsed for help provide optimistic concurrecny on updaing/deleting existing records, not creating new ones.
I also turned off SessionViewState, but I don't think it helps.
I'm not using a ObjectSource Control, i'm creating new instances of the BLL Classes in my code as I need. Should I null the objects after I use them? They are only created in the scope of a method, so it should essentially dispose of the object when the method completes.