accessing values from a database with datalist?

Hello, I'm new to ASP.NET 3.5 with C#. I really need some help.

I used a Repeater control to create a simple (editable) list where, when a user logs in, they can edit their list of expenses.  The ASP page works fine.

 My issue is with the code-behind.  I am really confused with how to extract the values from the repeater control. The FindControl method does not seem to be working.  Also, the code I am using resets my 'Amount' values back to 0.00. (0.00 is the amount the user sees when they first encounter the page).

 Here's a portion of the code on the ASP page:

<asp:Repeater ID="Repeater1" runat="server" DataSourceID="SqlDataSource1"

            onitemcommand="Repeater1_ItemCommand">

.

<ItemTemplate>

.

<td><asp:Label ID="lblExpId" runat="server"  Text='<%# Bind("ExpId") %>'></asp:Label> </td>

 <td><asp:Textbox ID="lblExpense" runat="server" Width= "190px" Text='<%# Bind("ExpenseName") %>'></asp:Textbox> </td>

 <td><asp:Textbox ID="txtAmount" runat="server" Width= "100px"

Hi,

I have the variable value 10.57
10.57 If I write, it stores data: 1057.00

 I need 10.57 into database

thanks.

hi experts,

i wanat to display Client Name, Field and  image in datalist. Stored Procedure like this

ALTER proc [dbo].[get_clients_services]

as

SELECT     Clients.ClientName AS Client, Fields.FieldName AS Field, ServiceType.ServiceType AS Services, ServiceType.Servicelink AS Link, 

                      Clients.ClientLogo AS Logo

FROM         Clients INNER JOIN

Accessing the same database many people at once

  

I there.

 I made a website, 1 database;  We have 4 cumputers, the 4 are using the same website and saving datas at the SAME TIME.

 The problem that i have is that when 2 people click in the save button at the same time, only onces is in the database, but the others get lost.

 

 Visual Studio 2010, Framework 3.5, MS-SQL 2008, C#.

 The conecction is in c#, everthing is in c#.

 

Thanks!!!!!!!!!!!!!!!!!!!!!!!!!!!

 

 

Accessing my Web Application's database with MSSMS at the same time.

  

Hello,

I wish to acces my database using MSSMS at the same time that I am running my web application. When I tried to access my database with MSSMS I get the following error:

Failed to retrieve data for this request (Microsoft.SqlServer. Management.SDk.Sfc)

Additional Information:

Unable to open the physical file "C:\inetpub\wwwroot\myapp\App_Data\aspnetdb.mdf".
Operationg system error 32: "32(The process cannot access the file because it is being used by another process)". (Microsoft SQL Server, Error:5120).

What can I do to being able to view my database with MSSMS at the same time?

Thanks for your help,

Louis

Get list of Correlation Key Values from Database

  

I want to know from the the Sql database (workflow persisted) how I can get a list of the unique ids I have correlating to the workflows started.  I have no problem getting the system generated Workflow Instance Id GUIDs, however I want to display our OrderId instead.

My Info

-Using Workflow 4.0

-Workflows are getting persisted to database

-correlation handle is set to my unique Id (OrderId) in the ReceiveActivity

Assigning values from a Database to a Label

  

Hello,

I want to select all the values from a table in my database and then put each value in order into labels that are on the asp page.

I can Select all the values from that database fine but I am rather stuck as how to put the values into the individual labels? Here is the code I have connecting to my database.

  Dim cmd As New SqlCommand
     
        Try
            Dim myConnection As New SqlConnection("Data Source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\Alerts.mdf;User Instance=true")

            myConnection.Open()
            cmd.Connection = myConnection
            cmd.CommandText = "SELECT DateTime, Description FROM EmailTemplateLoad"

                cmd.ExecuteNonQuery()

        Catch ex As Exception

        End Try

How can I put the DateTime value into Label1 and the Decription into Label2??

I have had a nose about but can't seem to find the information I need.

Any pointers greatly appreciated.

Accessing gridview cell values

  

Hi All,

In my application Iam using GridView, in this there are fields (Quantity, Price, Amount) the user can enter Quantity Field value which is a template field (textbox). Iam calculating Amount(Quantity * Price) using Javascript and assigning to the Amount Column cells as below

Gridviewcell.innerText=Quanity * price.

and when user clicks on the Save button I want to add these details of Gridview to the database.

when I try to access the values of the gridview using below code

For i=0 to GridView.rows.count-1

GridView.Rows(i).Cells(2).toString ( for Example)

Next i

It is not displaying the changed value instead it is displaying the default value before calculating the amount.

Before implementing the Javascript part, I had done this in the code behind and it was working fine... Now I just dont want the page to get load so I used javascript.

Can any one help me out in able to access the value of Gridview cells which are assigned using Javascript.

Thanks

 

dropdown list wont populate values from database

  

	Hello everyone i need help. Ive been having this problem for almost  3 days now. dropdown list won't populate from database Below is the code i am using: <%@ Page Title="" Language="VB" MasterPageFile="~/Site.master" AutoEventWireup="false" CodeFile="PhotoAlbum.aspx.vb" Inherits="PhotoAlbum" %> <asp:SqlDataSource ID="categoriesDataSource" runat="server"       ConnectionString="<%$ ConnectionStrings:ConnectionString %>"             SelectCommand="SELECT [CategoryID], [Name] FROM [Categories] WHERE ([UserId] = @UserId) ORDER BY [Name]">      <SelectParameters>          <asp:QueryStringParameter Name="UserId" QueryStringField="ID"/>      </SelectParameters>  < load new page and populate the values without database    hi, I'm creating a website of 5 pages using c# (asp.net). How do i link 2 pages, ie., on click of a button on first page should take me to second page. Advance thanks, neo Datalist not displaying image from database    My database table contains the image file path which will be stored from a file upload control.The image path in the table will be like "C:\Projects\projectname\projectfolder\Files\1_129308367798080000_images1.jpg" I am trying to display that image through a datalist control as follows <asp:DataList ID="cobrandlogolist" runat="server">                <ItemTemplate>                 <asp:Image id="CobrandLogo" ImageUrl='<%# DataBinder.Eval(Container.DataItem, "CobrandLogo") %>' Height="100px" Width="100px"                  runat="server"/>                </ItemTemplate>                </asp:DataList> and i am retrieving the image names from the db and assigning as datasource of this datalist in the load event as follows     DataTable dt = new DataTable();            Accessing a .mdb database in 64 Bit Platform    Hi, I want to upgrade the 32bit application to 64 bit application. In my 32 bit application i use Microsoft Access as the backend database ( simple only with some few tables, no relations) I have used MFC database classes like CDaoDatabase, CDaoRecordset for accessing the database. During the upgrading process i came to found that CDaoDatabase classes are now no longer supported in Win64 platforms. I get the following error:  fatal error C1189: #error :  DAO Database classes are not supported for Win64 platforms Also going through some of msdn Q/A articles, i found that CDaoDatabase classes have been deprecated now, or sth like there is no provision for accessing the .mdb in X64 platform. Is there really no method for accessing the Access database in X64 platform. Are there any other solutions..... Is switching to ADO.Net will be the solution.... Hope Somebody will put the light on this topic.. Regards Anur RS..
Categories:
ASP.Net Windows Application   .NET Framework   C#   VB.Net   ADO.Net   Sql Server   SharePoint   Silverlight   Others   All