[Message Deleted]

LOLZ!!! Stupid me! Thanks!

I am trying to compare dates from my C# project file to the dates from my database. What I want to achieve is to check if the same date occured in the database. How do I do this? For example I want to check if DateTime.Now already existed in the database. I am trying to read it from there, however I need only the date, not the time. I have to omit this, because my plan was to convert them to strings and then just compare if they existed already. Can anyone help?

I already have an IIS installed. And about the localhost . Mozilla Firefox issued me a username and password. I tried my computer login and everything I think possible, but still it did not allow me to access the page. Why is this? And how do I deal with it? Someone also told me that I should create first an html file and make IIS host it. How do you host that? I'm sorry. I'm very new to this. :(

How do you do that? Someone also told me that I should create a simple html first then try it to host in my IIS. How do you do that? :confused:

Thanks for the reply. I did what you just said, however, it still did not connect. I am currently reinstalling my activesync since it is also encountering its own issues. I took the IP address of my wireless network btw.

I have successfully connected my desktop application to a web service. My web reference is in http://localhost/ however when I tried it on my application for my phone, I cannot seem to connect to it. Do you know how I can connect to the web service? Is it different when connecting to it via a device application from a desktop app? Or is it just because I'm using a localhost url? I am simulating my phone by an emulator and just cradling it. :confused: I get this web exception: Could not established connection to network

modified on Sunday, December 7, 2008 11:36 AM

Yeah I just noticed. LOL. I removed the Identity Specification for the newly created tables. THANKS A BUNCH! You guys were a great help! :)

I got it working now. Thanks! I just created a new database however I have a new problem. Yesterday I was able to successfully migrate my data to another database, using this query: "INSERT INTO Records SELECT * FROM MMDAserver.dbo.Records", then being stupid, I accidentally deleted the newly created database from the project file I attached into. Now when I created the new database again with the same name and same everything, I already get this error when I try to copy them again: Msg 8101, Level 16, State 1, Line 1 An explicit value for the identity column in table 'Records' can only be specified when a column list is used and IDENTITY_INSERT is ON.

I tried attaching the database on a newly created project. Still the same. Not recognized in the crystal report wizard. Sigh.. Oh well. I'll just try this newly created database first. Hopefully it works.

Root problem? I'm sorry, but what did you mean by root problem? I'm not really sure myself though. A few days ago I was able to attach the tables on the dataset with the same database, and get recognized in the Crystal Report Wizard. Then when I duplicated my project file, and redo what I did in my "backed-up" project file, that started the strange problem. And if you mean that getting and successfully querying the database is a good condition, Yes. My database is in good condition for that part.

hi. How do you transfer data of a database from another database. I am using MS SQL. I have hundreds of data there and I need to transfer it to another database since I'm having problems with the previous one with regards to attaching it to the dataset with crystal reports. It only recognizes the newly created databases in SQL Express and I don't know why. So I just planned to recreate my recent database and transfer all of the existing data to a new one. How do I do that? Thanks!

I'm not sure. But I'm only having problems with my old database. When I created a sample database and attached it on my CR, it recognizes the tables attached to the dataset. However, with my old database with procedures, the CR wizard cannot recognize them at all. I have no images in my database. Just pure text and integers.

Hi. I am having problems with configuring my crystal report. When I attached a dataset to my application, and dragged the table from my newly created database to the dataset, and added a .rpt file which is a crystal report; on the ADO.NET node (which is in the Crystal Report Wizard), I was able to see the dataset I just added plus the table I dragged into the dataset. However, when I attached my old database, which was created months ago, I cannot seem to view the table I dragged into my dataset. It's always empty. That's why I cannot create the fields needed on my added crystal report. Why's this? And does anyone know how I can deal with this? :confused:

Hi. How can I store PDB files in my MS SQL Database? I want to have a compilation of those files for quick retrieval. There's only an image and xml file in the datatype list. What about other files? :confused:

I already have set the font size to 7 but still its the same. They overlap. I can't omit the other columns because they are required information. For the layout, how do you set that? Are you referring to the list of layouts of the crystal report like "Drop Table?"

hi. i was able to successfully place my table on the crystal report viewer however, I have too many columns that are crowded in. I want to make them fit on the page and make the text visible. How do I do that? Some column names also have quite long labels like, "Registered Address" or "Registered City Code". How do you make this visible and fit in one page. Say I have 12 columns?

I see. I'm sorry but I'm very new to ASP.NET, and I can't seem to understand what you meant by a service with SQLProcName and SQLParameter. I have scanned a few tutorials and few ebooks but nothing seems to lighten me up. And also, I tried to create a webservice, added a windows form, and I tried to test run it but I get an error message like this: "Windows start service failure: ---------------------------- Cannot start service from the command line or debugger.A windows service must first be installed (using installutil.exe) and then started with the server explorer, Windows services Administrative tool or the NET START command. " -------------------------------- :(

Hi. I have a desktop application that I want to load on the internet or just its database. I really have a vague understanding on how web service works other than your application being loaded on the web. My goal is to retrieve data from the internet instead of a direct connection in a wifi connection. I was asked to load the data on the internet before being retrieve by the user. Can someone tell me how I can migrate my desktop application to the web? What I would need? What I have to do? Do I have to recreate my application again if I'm going to place it on the web (It would be a hassle)? In simple terms, the client (PDA phone) retrieves data from the internet, then sends information to the server (desktop app) but must go through the internet. So basically. Instead of a direct wireless connection from wifi, we are required to add the internet as a bridge of communication between the two. P.S. - By the way, it doesn't necessarily have to be used by a certain webhost. Using localhost would be just fine with me, as long as it can connect via wifi. I really really need your help for this. Thanks!

modified on Wednesday, November 19, 2008 7:17 AM

wait. im sorry about that. this is the right code. #include #include #include using namespace std; int main(){ stack syntax; string word; while (cin >> word) { syntax.push(word); } cout << "Number of words: " << syntax.size() << endl; while(!syntax.empty()) { cout << syntax.top() << endl; syntax.pop(); } cout.flush(); return 0; }