Your problem is that SQL Server does not allow an in clause to be a variable: TRANSFER_ID IN (@TRANSFER_IDS) for example will not work. What you need to do is split the variable into a table variable and join to that. Google has loads of examples Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP

tried using that code, it doesn't work Ferron

Ah, I see! Thanks Deresen, that will be handy to know! :laugh:

I used a data list control to display all my records, but i have been trying to add paging capability. :( Ferron

Care to share the fix? ɹǝʌo ɹoʇıuoɯ ɹnoʎ dılɟ sıɥʇ pɐǝɹ ʇ,uɐɔ noʎ ɟı

Format the data as XML and use an XSLT to produce HTML pages. only two letters away from being an asset

I'm sorry but if the problem is in the aspx, that's something where I'm not able to help you. I suggest that you try ASP.NET[^]-forum. I believe you would get good answers from there. The need to optimize rises from a bad design.My articles[^]

No, it would be pandering to your laziness. "Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997 ----- "...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001

Here is one way, but there are many: public class User { private string _firstName; private string _lastName; private string _id; // or int not sure what type yours is public void Load(string id) { UserManager manager = new UserManager(); manager.Retrieve(this); } // properties and other methods } public class UserManager() { public void Retrieve(User userToRetrieve) { SqlCommand cmd = new SqlCommand(); cmd.Text = "SELECT FirstName, LastName FROM UserTable WHERE UserID = '" + id + "'"; // Here use an adapter and fill a DataTable // If the DataTable has rows then assing the proper columns to the userToRetrieve object // If no rows then throw an exception to advise no User was found with the given id. } } You UI code can be something like this: User aUser = new User(); string id = "123"; try { aUser.Load(id); this.LabelID.Text = aUser.ID; this.LabelFirstName.Text = aUser.FirstName; this.LabelLastName.Text = aUser.LastName; } catch(SomeException ex) { MessageBox.Show(ex.Message); } If you still can not do it then buy a book on C#. Please note this code might have errors but it is just to give you an idea.

i tried what you guys suggested and it doesn't seem to be working. What i really want something to convert from the datetime e.g. 12/3/2007 to 12 of December two thousand seven here is my code //Convert the value to a string representation String mydateString = System.DateTime.Now.ToString("ddMMyyyy"); lblDATE0.Text = Convert.ToString(mydateString); Ferron

ferronrsmith wrote: I wanna create a form that grabs data from a database and insert it in my layout Instead create a usercontrol (which should have your forms' controls) to bind the data, and put a for loop for number of querystring items, and call the usercontrol and bind the data. That should solve your problem. Cheers, Sudhanva

What you need to do is have some event handler. The auto-updating will be fired by some event (click of button, entry into text field, getting or losing focus...) then in the event handler calculate what you need and update the page accoringly. Here is some more help ^ Yusuf

protected void CheckBox1_CheckedChanged(object sender, EventArgs e) { if (CheckBox1.Checked) { TextBox1.Visible = true; } else { TextBox1.Visible = false; } }

What do you mean by saving a form to a database ? The data in the form ? It's overall state ? A form is an instance of a class, you can't save the whole form and restore it, not as such. You can write code to save whatever data you want from the form, and restore that from the DB. Christian Graus Please read this if you don't understand the answer I've given you "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

4guysfromrolla.com has some nice examples on basic webforms and more advanced things, you could also pick a place(connecting to database, creating web form, UI, etc..) to start and try google searches or article searchs here for whichever piece you are currently working on. If you dont want to do it yourself you could try rent-a-coder or a consultant firm, mabye even craigslist if you're in one of the cities it has listings for, or somone here may hired to do it. When i was starting out this site and 4guysfromrolla had great articles and tutorials for almost any individual piece i needed to use. Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Start by asking in the correct forum. You are looking for ASP.NET.. xacc.ide - now with TabsToSpaces support IronScheme - 1.0 alpha 4a out now (29 May 2008)

ferronrsmith wrote: I need to create a hashtable collection of all the forms in my project. It needs to be done in code and it needs to be done without any user input. I'll ask again. Why?? A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007