Search results for query: *

Hey All! I have a repeater that I have received the rows that I need from the database by Repeater.DataSource = ds.Table(0) Repeater.DataBind(). On the Repeater.ItemDatabound I would like to only display the rows that meet a certain criteria. Does anyone know how to do this? Any help is...

I hope that I can explain this correctly. I am new to Javascript. I have a Classic ASP page that loads the information from the database. There is a textbox with comments which came from the database. I have a hidden field with those comments value. The user will be able to change those...

I am new to Sybase so please bare with me. I have created a table and created a store procedure to insert the new record into the newly created table. I am doing a direct Execute statement like this: EXECUTE dbo.usp_change "NP1016", 220804, "MOM", "May 2 2005 8:13PM", "NP201", "May 2 2005...

Nevermind. I did this and it worked! Dim dr As DataRowView = DirectCast(e.Item.DataItem, DataRowView) Thanks for all your help!

I keep getting an error: InvalidCastException was unhandled by user code Unable to cast object of type 'System.Data.DataRowView' to type 'System.Data.DataRow'.

This is what I have. Protected Sub MainRepeater_ItemDataBound(ByVal sender As Object, ByVal e As RepeaterItemEventArgs) Handles MainRepeater.ItemDataBound Dim ars As New app.core.CoreService Dim ro As New app.core.ResultObject SecurityHelper.SetSoapHeaders(ars)...

Hello All! I am sure this is probably a dumb question, but here it goes! I have a repeater and in this repeater I have a name, gender, etc. Ex: John Smith, Male Susan Smith, Female If the gender is a Male, I need for the name, John Smith, to be a asp:linkbutton. Otherwise, to be...

Hello All! How can I create a table in Flash? Please help!

I am a newbie to the ActionScript arena. I have an application that has some Flash content in the middle of it. I have a .Net page that holds the session variable before getting to the Flash content, then at the end I have hard coded the URL where I want the last page on Flash to go to. This...

Sorry! Dim sb as New StringBuilder sb.Append("ALTER TABLE lessons ADD old_Id int DEFAULT(0) ") sbSQL.Append("GO ") sbSQL.Append("UPDATE lessons SET old_Id = lesson_Id WHERE lesson_schlyr = ").Append(intPrevYr) sbSQL.Append("INSERT INTO lessons (lesson_title, lesson_desc, lesson_inst...

This maybe a stupid questions, but I need to ask....... I am trying to use a string builder to alter, update a table in sql server 2000. On sql server this statement works: ALTER TABLE lessons ADD oldId int DEFAULT(0) GO However, when I insert that into my string builder It gives me this error...

This is what I have now that works: ALTER TABLE lessons ADD oldId int DEFAULT(0) GO UPDATE lessons SET oldId = lesson_Id WHERE lesson_schlyr = '2008' INSERT INTO lessons (lesson_title, lesson_desc, lesson_inst, lesson_schlyr, oldId) SELECT lesson_title, lesson_desc, lesson_inst, '2009', oldId...

I inserted a temp column which consisted of the old ids. It created that and made the new lessons with the new school year. I was able to insert the new assignments with the new years, but when I referred back to the lesson table of the column oldId, it did not update to the new ids. I used...

This is my lessons table: less_id lesson_title lesson_desc inst schlyr 61 Lesson One Exploring Careers 1 2008 132 Lesson Two Self-Awareness 1 2008 133 Lesson Three Goal Setting 1 2008 134 Lesson Four Understanding 1 2008 135 Lesson Five Workplace Skills 1 2008 136 Lesson Six Career...

Thanks for your quick response. Ok. I am not sure what you are suggesting but in the Lessons table I do have a PK of lesson_id. When I copied the old school year to the new school year, this is all within the same table. I also have a PK in the Assignments table of assign_id and a FK that...

Hello All! Is this possible and if so, how? I have 2 tables a Lessons table and an Assignments table. Each Lesson has multiple Assignments. The previous years' Lessons and Assignments need to be copied with the new school year of 2009. I was successfully able to copy the previous year's...

Hello All! I have to insert mutiple rows into 5 tables. Basically, I am trying to copy the previous year's entries into the same tables with a new year. Is this possible? (Doing and insert with inner joins) INSERT INTO a.module_title, a.module_desc, a.module_instructor, a.module_schlyr...

Hi All! I am trying to copy multiple rows from a table into the same table. However, one of the field values needs to change in the insert. This is what I have so far. INSERT INTO MODULE(MODULE_TITLE,MODULE_DESC,MODULE_INSTRUCTOR,MODULE_SCHLYR ) SELECT MODULE_TITLE, MODULE_DESC...