Search results for query: *

If I use the first config following in my Webconfig I can connect Crystal via the Wizard to my database which is housed in SQL 2005 with no problems. If I use the one under it (#2)where the database is located in my App_data folder and uses SQL EXpress i get the error message above.. Can...

I'm trying to use the OLE DB provider to get a crystal report off of a database titled testfeet.. My connection string in webconfig is <add name="TestFeetConnectionString2" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\TestFeet.mdf;Integrated Security=True;User...

I can't get Crystal to connect to my datasource.. I'm using SQLExpress.. My database is called testfeet and its under the App_data folder in my website.. I have tried to get Crystal to connect but I keep getting ado erro code 0x SQL state4200

Cool thanks!

Hello, I have a details view that updates all fields except my dropdown list selection..is there an extra step I missed when adding a dropdown selection to a template in edit mode of the details view? My table is called tblServiceQuote which has a field called TypeID.. TypeID is a foreign key in...

Hello, I'm trying to create a trigger that will copy the CustID from the customer table to the tblServiceQuote table whenever a new record is added to the customer table.. I'm getting the error message: the parameter is incorrect.. What am I doing wrong? See below.. ALTER TRIGGER customer...

Thank you both!! Works great:)

Hi, I'm trying to create a trigger that inserts a new record into tblService with the QuoteID from tblServiceQuote when tblServiceQuote.Accepted = true or = 1( it's a bit).. Anyway, I'm struggling and I'm wondering if someone can tell me where I'm going wrong.. CREATE TRIGGER servicequote...

I know how to pass the value just not how to retrieve it in the new page.. Thanks

My class only meets once a week and my teacher suggest using online forums for help..I'm a professional DBA but no little about ASP.net.. I do have books but they are not covering my questions..

I have books and I have gotten to a certain point but can't get any further...see my post titled gridview row command... I know SQL very well. I'm a DBA.. I'm very new to ASP.net and know very little although I am taking a class that only meetis once a week so based om my teachers...

I have a datagrid on a page called(quote.aspx)that when the customer selects their name their CustID is suppsed to be carried over to another page (quote2.aspx). I think that all works except I don't know how to get the CustID inside a form on the second page.(quote2.aspx). How do you retrieve...

Here is the scenerio.. I want a customer to find their name and address in lets say a listbox and when they select it their customerID will go in a new form.. After their customerID is in the new form they can finish typing in the other fields in the form and then insert into the SQL table.. The...

I read the code and I think I understand but if you could hold my hand just a bit more.. Actually a lot more.. What do I name my list box so the code you gave me will refer to it? How do I get the data from the list box ( lets say the PK) so it will show the person all of their info? For...

Thanks, my email notification is not set up correctly and I did not know I had a reply.. Let me try this.. Thanks!

Thanks but this is for a school project and I need to know to write the VB code that once the link is clicked a pop box ask for a passord ( hardcoded back in ) and if the password is not correct the link fails.. Please help Thanks, Cheryl

in asp.net i have an admin page i want to password protect..so when the user clicks the admin link a simple password prompt pops up.. if the password is incorrect the link does not work. i know a little vb but i do not know c#..can you help? Thanks! Cheryl

How do you create a drop down list in ASP.net 2.0 that allows the user to start typing in a last name and find their name from a table and then select their name and have their information (such as customerID)populate a datagrid that will update another table? I prefer VB over C# becuase I do...