Hi friends, I have to create a Message board. I'm planning to create a class for this, whick is going to include a collection of messages. This is the general idea: MessageBoard Class UserId Collection of Messages AddMessage() RemoveMessage(messageID) MarkAsRead(messageID) MarkAsUnread(messageID) Message Class MessageBoardId Text Read I have read some about Collections I saw some examples where they use ArrayList, SortedList and CollectionBase among others for this. What do you think is the most suitable Collection type to use in this case? Thanks a lot

HI friends, I have a web form with several controls I'm posting to a database. For two of them(textboxes) I'm looking up the values using a popop window, so the user cannot edit the actual textboxes values, they have to go through the lookup process, which populates the controls. What is happening is that everytime I set the readonly=true or the enabled=false for these textboxes, the ViewState seems to not store their corrent values. In both cases when I do the postback and the page comes back, the control shows up the the previous value, not the one I posted back with the page otherwise it will show the correct value(readonly = false; enabled = true) This is the asp.net code for the textboxes: Any idea on this?

I think so. The parameters in the SP are DateTime..and I'm passing DateTime as parameters too.

HI friends, this question is regarding Crystal Reports in VS 2005 My report here is attached to a SP. I'm trying to pass parameters but it raises an error: Procedure or function 'sp_wfsAppByCounsReport' expects parameter '@StartingDate', which was not supplied. Here is my code, I'm passing the parameter. I can even trace it and the rdDocument variable has them attached after the SetParameteValue....why the report is not sending them to the SP??? Here is my code:

protected void Page\_Load(object sender, EventArgs e)
{
    DateTime dtStartingDate =  DateTime.Parse(DateTime.Today.Month.ToString() + "/" + "1" + "/" + DateTime.Today.Year.ToString());

    ConnectionInfo ciLogin = new ConnectionInfo();
    ciLogin.ServerName = "myserver.com";
    ciLogin.DatabaseName = "mydb";
    ciLogin.UserID = "dbuser";
    ciLogin.Password = "mypass";
    TableLogOnInfo tbLogonTable = new TableLogOnInfo();
    tbLogonTable.ConnectionInfo = ciLogin;

    ReportDocument rdMonthReport = new ReportDocument();
    rdMonthReport.Load(Server.MapPath("couns-month.rpt"));
    rdMonthReport.SetParameterValue("@StartingDate", dtStartingDate);
    rdMonthReport.SetParameterValue("@EndingDate", DateTime.Today);

    foreach (CrystalDecisions.CrystalReports.Engine.Table tbTable in rdMonthReport.Database.Tables)
    {
        tbTable.ApplyLogOnInfo(tbLogonTable);
    }
    CrystalReportViewer.ReportSource = rdMonthReport;
    CrystalReportViewer.RefreshReport();
}

Any help is appreciated!!

Hi friends, I had a website running in my local computer with no problem. When I tried to uploaded to my server all the DB permissions were messed up. I tried to reproduce the error in my local PC but I ended up messing up my site config, I'm using memberships to manage accesses to my site. I want to create a website from scratch so I will have a brand new ASPNETDB database. How can I do this? I have created several new websites in different folders in VS but that only created the App_Data folder with no database in it. How can I start from scratch??? Thanks a lot

Hi friends, Thanks to those who answered my first question. Now I have other. Do you think it is worth it to buy books for C# 2005 and .Net 2.0 when VS 2008 and .Net 3.0 are around the corner? I'm afraid of buying those books, eat them and then, Microsoft changes the examinations to the latest technology. What do you think? I'm thinking in buying this pack: http://www.amazon.com/gp/product/0470048409/ref=olp_product_details?ie=UTF8&me=&seller=[^]

Thanks for all your answers. Help very appreciated. I will check them and get the book. pd: Any other opinion is welcome.

Hello friends, I hope this is the right forum to place this question, if it isn't, please apologize me. I'm thinking in taking the C# certification examinations and I need some help finding the right book or documentation to study. If any of you did it before, perhaps can give a hand telling me the books you used so I can buy it. Thanks a lot.

Hi friends, I'm trying to create a job in SQLServer 2005 and I' gettin this error: "Unable to cast object of type Microsoft.SqlServer.Management.Smo.SimpleObjectKey into type Microsoft.SqlServer.Management.Smo.JobObjectKey" Does anyone have had the same error? Any help will be very appreciated!!

Thanks a lot Pete!!!! That worked. As you stated there was not necessary a cursor here!!

Thanks Pete, I will be more specific, I tried your suggestion but still doesn't work...I'm not an SQL expert :o) I will rite here the involved tables and their main fields: Orders(OrderId) OrderDetail(OrderId, ProductSubCode, Quantity) Products(ProductSubCode, Quantity) When an order is canceled I want to get all the items on it and re-insert them in the Product table (summarizing with the amount already in that table) If I do a select of all the items in a given order as you told me I will get something like this: "SELECT * INTO #TMP FROM ORDERDETAIL WHERE ORDERID=30" OrderId ProductSubCode Quantity 30 BD0002 10 30 BD0004 4 Now I need to re-insert those quantities into the Products table. I can't figure out how I ca do that without a cursor since I need to iterate through the records in the temporary table. Of course I can still be missing alternatives Thanks a lot.

Hello Friends, I have never written a cursor before and I have a situation in which I need it. I have two days trying and still couldn't make it work...I need some help I have three tables one for Items, one for Orders and one for OrderDetail. I want to check every X days that all the unpaid orders(which has items blocked on it, defined in OrderDetail) free their items and increase the amount on the Items table. Evey time a customer make an order, the items are reserved, so they need to be freed if the order is canceled or remains unpaid for a given time. In this case I need a cursor that iterates through all the items belonging to the same unpaid order, then increase the amount in the Items table and delete the record in the OrderDetail table. Please, could you help me in this problem?? I will appreciate any help Thanks.

Hi friends, I'm having a problem when trying to connect to any DB using ADODB.Connection server object. I'm using classic ASP and my OS is Windows Visa Business. The message I'm getting is: "An error occurred on the server when processing the URL. Please contact the system administrator" ...and it comes when the code reaches this line: mycnn = Server.CreateObject("ADODB.Connection") I will appreciate any help.

Thanks a lot to all of you. JustChiragPatel, your solution was the one!!!

Hi friends, I have a page with a dataview binded to a datatable. I want to delete all the rows with a checkbox marked on it. The problem is that in the button's OnClick event the DataSource property of the DataView is NULL. I cant have access to it in order to know the IDs of the marked rows. How can I do this? Thanks averyone

My mistake....I mean ListBox control I apologize for that.

Hi friends, I have a web form with a ListView bound to a DataView. I need to fire the OnSelectedIndexChanged event to capture the index in the ListView in order to retrieve the data from the DataView. The problem I have is that this event does not fires when I click on a different item in the LV. It only fires when I change its content by filtering the DV etc... What is happening here?...Is this event not suppose to fires when a user change their selection in the LV? Thanks

Hello friends, I'm entering the ASP.Net technology World and I have some beginer questions, so please, don't be too hard ;) Ok, I need to do a "left side" menu. I have a table with main categories and other table with subcategories related to its main categories. In the old ASP I just iterate with two "for", one for the main categories containing the other for the sub-categories belonging to the current category. Quite easy, just put the ASP code in the right part of my page and I have my menu. But in ASP.Net and the code-behing pages I don't know how to o this, because I can't put the ASP.Net code embebed into the HTML code. I know this should be a very thumb questoin but....everybody has a begining :) Thanks a lot

Oh, thanks a lot friends(both of you). I'm happy to find a place to ask my newbie's and more advenced quiestions. You're very kind. -- modified at 17:28 Saturday 12th August, 2006

Hello..I'm trying to make my first console app in c#. I've just read a very good book and some articles. So, I'm sure many of my fistr questions may seem very dumb for most of you...please don't be so hard ;o) Q: I sow that to declare a constant value, it should be declared indide a class. So...what if I want to declare a constant value with scope in my whole app?..should I declare a big class envolving all the code?. Is this a good practice valid even for console and windows apps? Thanks