ASP.NET

Re: optimistic concurrency

14-Dec-08 19:25

Your code is broken. Hard to say much else, based on this.

Christian Graus

Driven to the arms of OSX by Vista.

Re: ASP.NET Login

Abhijit Jana14-Dec-08 19:29

Abhijit Jana

14-Dec-08 19:29

It seemes there are some problems on your implementation logic. As Brij suggest, it would be better if you put those line of code that would be helpful for us to answer.

cheers,
Abhijit
My Recent Article : Beginner's Guide to ASP.NET Application Folder

optimistic concurrency

billcodes14-Dec-08 17:23

billcodes

14-Dec-08 17:23

hi,
how to use optimistic concurrency in asp.net(c#)?I'm using sqldatareader to select the data from the database to the data gridl.when there are more than one person to update,there arises the concurrency issue.

please help me with code.

Regards,
Bill

Christian Graus14-Dec-08 17:37

14-Dec-08 17:37

Most people lock records when one person starts to edit, there's no simple solution to marking records so that two people can easily edit them at the same time.

Christian Graus

Driven to the arms of OSX by Vista.

AutoSuggestMenu help

Dio2214-Dec-08 17:19

Dio22

14-Dec-08 17:19

Hey all,

I'm trying to incorporate the AutoSuggestMenu on autosuggestmenu.com and I keep getting random javascript errors. Mainly 'XUtils' is undefined. Here's the code. Thanks for your help Smile | :)

<%@ Register TagPrefix="Custom" Namespace="ENTech.WebControls" Assembly="AutoSuggestMenu" %>
...
<custom:autosuggestmenu runat="server" id="regAutoSuggest" targetcontrolid="txtSearchReg" usepagemethods="false" usepaging="false" ongetsuggestions="getRegSuggest" resourcesdir="~/asm_includes/" xmlns:custom="#unknown">

autosuggestmenu.dll is in bin directory..
asm_includes directory is in the root of my project.

Code behind:

public static List<autosuggestmenuitem> getRegSuggest(string keyword, bool usePaging, int pageIndex, int pageSize)
{
List<autosuggestmenuitem> menuItems = new List<autosuggestmenuitem>;
...
return menuItems;
}

Re: AutoSuggestMenu help

Christian Graus14-Dec-08 17:38

Why is it the log4net doesn't work in deploy

14-Dec-08 17:38

Dio22 wrote:
autosuggestmenu.com

Do they not have a forum ? Seems to me they will have more people who have used their library than CP will.

Christian Graus

Driven to the arms of OSX by Vista.

C#Coudou14-Dec-08 13:48

C#Coudou

14-Dec-08 13:48

mates,
need help!!!

i used log4net to track the error of my page. in my localhost or my in developing machine. the log4net is 100% working. i have logs in log.txt. But when deploy it in virtual pc, WinXP IIS 5.1 becuase II6.0 is for Win2003 Server only. The log4net is not totally working, also some of controls also doesn't working such as buttons, grids, etc. Note: I used Visual Studio 2005 - ASP.NET 2.0.50727.0

C# コードMicrosoft End User
2000-2008

「「「「「「「「「「「「「「「「「「「「「「「「「「「「
The best things in life are free
」」」」」」」」」」」」」」」」」」」」」」」」」」」」

Re: Why is it the log4net doesn't work in deploy

Colin Angus Mackay14-Dec-08 14:35

Colin Angus Mackay

14-Dec-08 14:35

C#Coudou wrote:
i used log4net to track the error of my page. in my localhost or my in developing machine. the log4net is 100% working.

If you are using Cassini (Visual Studio's built in web server) then you will be running your web appliation in your account. When in IIS it will be running in the account you've assigned to it (defaults to something like IUSR_[machine-name]) which will not have permission to write to the file system, unless you explicitly grant permission.

Developer Day Scotland 2 - Free community conference

Recent blog posts:
*Throwing Exceptions
*Training Developers
* Method hiding or overriding - or the difference between new and virtual

Recreating the VBA ComboBox Functionality on my aspx page

Ginozzzz14-Dec-08 10:38

Re: Recreating the VBA ComboBox Functionality on my aspx page

14-Dec-08 10:38

Hi all. I have wrestled with this for a week now.

I have a website in .net 2.0, created with VWD Express, and I use VB in my code. The site is designed to sell size based products. I have a reasonable amount of experience with VBA in Access databases, but I'm struggling to get to grips with this new way of thinking when working with online applications. Please excuse my ignorance with terminology etc.

In Access, I was able to use a combobox to hold a recordset. For example, my combox could hold this info:

OptionName | OptionPrice | PriceMethod
------------------------------------------------
Pink £10.00 1
Brown £12.00 1
White £5.00 2
Red £9.00 3

In access, the CB would be populated with all the above detail on the PageLoad event with all the options for a particular product.

Usually, in Access, I could quickly reference the 2nd and 3rd column values in code and make calcualtions on them.

This would enable me to quickly re-price an option if the CB value is changed without going back to the database. This makes so much more sense than waiting for a round trip to the DB, and means that price calculations are instant.

How can I recreate this in asp.net?

I have investigated some custom controls which mimic ComboBoxes, but I'm struggling to get them to work properly, and what I've seen so far don't really seem that stable.

I have questioned whether it's possible to send the Recordset to a hidden field or viewstate, but having scanned lots of newsgroups I can't find any examples of similar situations, so I'm reluctant to waste days investigating. I'm also unsure on how to reference the table values in code, since I can't find any documentation.

I thought about using a multi array variable, but again, this seems a little crude and long-winded given the simple task I need to acheive.

Worst case, is that I'll probably have to use Ajax to make a trip to the DB. But I simply can't believe that Microsoft would replace the CB with that feeble Drop Down List. Surely there's a simple way???

Any inspiration would be appreciated.
Thanks.

Christian Graus14-Dec-08 11:08

Re: Recreating the VBA ComboBox Functionality on my aspx page

14-Dec-08 11:08

You can use a gridview to show columnar data. A drop down can show them only as a single string. You can hide data against that tho, a drop down has a data field to go with the field that is shown.

Ginozzzz wrote:
But I simply can't believe that Microsoft would replace the CB with that feeble Drop Down List. Surely there's a simple way???

Your core issue is that you don't understand what's going on here. ASP.NET creates websites. So, Microsoft is not at liberty to decide what goes on, they are creating a framework which generates HTML and CSS. Your options are indeed AJAX, or simply using javascript to grab the values needed from the box when a selection changes, and showing the result. That's how web developement works. Microsoft did not invent HTML, CSS or AJAX, they merely provide libraries to help people use them.

Christian Graus

Driven to the arms of OSX by Vista.

Nishant Singh14-Dec-08 18:24

Nishant Singh

14-Dec-08 18:24

Hi Gino,
Grid view would be better option (Graus is right on that account)
But if you are using DropDownList then after data bind ,
You have to loop through all the ListItem
and add attribute like "optionPrice" and "PriceMethod"
to each list item
As example in the below code snippet

ListItem Li=ddlAll.Items[itemno];
Li.Attributes.Add("optionPrice",dt[itemno]["optionPrice"])

Re: Recreating the VBA ComboBox Functionality on my aspx page

Ginozzzz14-Dec-08 23:26

Re: Recreating the VBA ComboBox Functionality on my aspx page

14-Dec-08 23:26

Thankyou Graus and Nishant for your replies.

Graus, I don't need to show the user the 2nd and 3rd columns. They are there solely for the purpose of looking up record information without going back to the DB.

IF it where possible to have a hidden gridview, then I could look up the record from the Grid, based on the value selected in the DDL.

Nishant, are you saying that once I bound the data to the DDL, I can add columns(unseen) to the DDL, and populate them from the datatable, effectively giving me exactly what I want?

Thanks again.

Nishant Singh15-Dec-08 1:15

Nishant Singh

15-Dec-08 1:15

Ya exactly ...but you have to do it ....For each Item in DropDownList

Re: Recreating the VBA ComboBox Functionality on my aspx page

Ginozzzz15-Dec-08 1:57

Re: Recreating the VBA ComboBox Functionality on my aspx page

15-Dec-08 1:57

Ok, I'll have a play around. I'll post the results.

Ginozzzz15-Dec-08 9:40

DetailsView and dropdownlist

15-Dec-08 9:40

Okay, I'm a little stuck. I have posted my code of how I am filling my DDL. I am using a datareader.

Protected Sub FillOptionsList()
  ddl1.Items.Clear()

  Dim sqlStr As String = "SELECT Option1, Option2, Option3 FROM TblOptions WHERE Bid=1"

  Dim con As New SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings("myConnection").ConnectionString)
  Dim cmd As New SqlCommand(sqlStr, con)
  Dim reader As SqlDataReader

  Try
    con.Open()
    reader = cmd.ExecuteReader()


    Do While reader.Read()
      Dim newItem As New ListItem()
      newItem.Value = reader("Option1").ToString()
      newItem.Text = reader("Option2")
      ddl1.Items.Add(newItem)
    Loop
    reader.Close()

  Catch ex As Exception
    Label1.Text = "Error Reading list" & "  " & Err.Description
  Finally
    con.Close()
  End Try

End Sub

Please can you help me with the code to get option3 into an 'unseen column' within the DDL? I have tried a few things (not posted) but with no success, and I can't find any help online for this feature.
Thanks.

Sandraa14-Dec-08 8:01

Sandraa

14-Dec-08 8:01

Hi all, i have a little problem that even i don't know like solve. I know that is possible but I don't know how.
I have a project ASP.NET with VBasic.NET
I want to add a dropdownlist to DetailsView with diferent source that detailsview.
I put my code and the error:

Dim InsertComboUsuarios As DropDownList = DirectCast(detailsView.FindControl("InsertComboUsuarios"), DropDownList)
Dim UsuariosServicios As New DataTable
UsuariosServicios = Servicios.ObtenerUsuariosServicios()
InsertComboUsuarios.DataSource = UsuariosServicios
InsertComboUsuarios.DataTextField = UsuariosServicios.Columns("Usuario").ColumnName.ToString()
InsertComboUsuarios.DataValueField = UsuariosServicios.Columns("IdUsuario").ColumnName.ToString()
InsertComboUsuarios.DataBind()

the code in aspx:

<asp:TemplateField HeaderText="Usuario del Servicio" >
 <ItemTemplate>
    <asp:Label ID="lblUsuario" Text='<%# Eval("Id_Usuario") %>' runat="server"></asp:Label>
 </ItemTemplate>
 <EditItemTemplate>
    <asp:DropDownList ID="EditComboUsuarios" runat="server"></asp:DropDownList>
</EditItemTemplate>
<InsertItemTemplate>
    <asp:DropDownList ID="InsertComboUsuarios" runat="server"></asp:DropDownList>
</InsertItemTemplate>
</asp:TemplateField>

and the error is:
System.NullReferenceException was caught
Message="Referencia a objeto no establecida como instancia de un objeto."
Source="App_Web_ie3hu1zc"

The source failed when pass by InsertComboUsuarios.DataSource = UsuariosServicios

some idea?
thanks very much for your help

Marcelo Emmerich14-Dec-08 9:30

Marcelo Emmerich

14-Dec-08 9:30

Hi Sandraa,

I have done this many times. I don't know exactly why it does not work for you (did not try it out), however, I want to show you a snippet of my working code. Besides being C# the main difference is that I use declarative syntax only:

First the dropdown declaration in the .aspx file:

<br />
<asp:dropdownlist ontextchanged="OnTextChanged" xmlns:asp="#unknown"><br />
                                     SelectedValue='<%# Bind("fake_flag1")%>' <br />
                                     ID="ddl_test1" <br />
                                     DataSourceID="TestDS" <br />
                                     DataTextField="someDescription" <br />
                                     DataValueField="someID" <br />
                                     runat="server"><br />
</asp:dropdownlist><br />

Next the declaration of the datasource for the above dropdown, which is different of the detailsview the dropdown is in:

<br />
 <asp:sqldatasource id="TestDS" runat="server" connectionstring="<%$ ConnectionStrings:ConnectionString %>" xmlns:asp="#unknown"><br />
        SelectCommand="SELECT * FROM TEST"><br />
    </asp:sqldatasource><br />

Hope this helps. Maybe the problem in your code is the point in time when you try to set the datasource?

Cheers,

Marcelo

--
Marcelo Emmerich
Software Development - Computer Graphics - Mobile Computing
http://bytethings.blogspot.com

Sandraa14-Dec-08 9:43

Sandraa

14-Dec-08 9:43

Thanks Marcelo but your code is for aspx and I am using aspx.vb, I don't know like call well to dropdownlist from aspx.vb page and from detailsview.
Remenber that my dropdownlist is into a detailsview Frown | :(

Thanks for all Wink | ;)

Christian Graus14-Dec-08 10:14

14-Dec-08 10:14

Sandraa wrote:
but your code is for aspx and I am using aspx.vb

Yes, he said you'd have to convert C# to VB, that's trivial to do. Also, he said he's doing it in the aspx, is there any reason you can't try it that way ?

Christian Graus

Driven to the arms of OSX by Vista.

Nishant Singh14-Dec-08 17:09

Nishant Singh

14-Dec-08 17:09

Hi Sandraa,
Are you sure

Dim InsertComboUsuarios As DropDownList = DirectCast(detailsView.FindControl("InsertComboUsuarios"), DropDownList)

This line is returning you a DropDownList object ???
That is to say InsertComboUsuarios is not null ??