harcaype

hi. my thread title seems strange but its really about comparing unlike values as an output. I want all values that are not LIKE the other values. To make things clearer. Here's my query: [ICODE]SELECT Records.[Officer ID], Records.[Plate Number], Records.[Violation Commited], Violations.[Violation Code], Records.[Street Name], Records.[City of Apprehension], Records.[Vehicle Category], …

hi. I'm trying to delete a row by specifying the actual row number. When I call all columns from one table it does work but when I already multiselect them I get an error: [COLOR="red"][I]Msg 4405, Level 16, State 1, Line 1 View or function 'Records ORDERED BY rowID' is …

[B]Is it possible in a query to delete a row specifying its row index?[/B] I want to delete a row from my table. I'm trying to figure this because when I delete rows from my datagridview, it does not update. So I was thinking if I just directly delete it …

In relation to my previous post. I was able to delete the rows in the datagridview (thanks to ema005), but now I am having problems with the updating of it in the database. It's deleting in my datagridview alright. But not in my database. My codes are already going on …

[ICODE]Update requires a valid DeleteCommand when passed DataRow collection with deleted rows.[/ICODE] This is the error I get when I'm deleting a row in my datagrid. I referred my code to a running program but when I embedded it on my own it occured that way. Here's the code: [ICODE] …

I've been figuring out how to insert data directly on the datagrid. It's like when I click on a row, I can edit it or add another just by clicking on that specific row and then update it. Can someone help me do this? I've search the net and what …

I'm trying to update/refresh my data grid but it doesn't seem to update whenever there's a new entry. I've search the net about it and they were talking about databind(). I can't seem to have that in my datagrid. My intellisense only shows DataBindings not databind(). here's my code (when …

I am trying a multi select query in management studio and I am only expecting a result that is a single output per row, however, when I tried executing it. The rows I called repeated once. For example I have 2 rows in my column1 and when I multi-selected my …

Hi. Can anyone tell me how to copy data from a table from another database? I was able to copy but I only got the columns and not the data it contains. This is how I copied it: I tried this first: USE MMDA GO SELECT * INTO MMDAserver.Vio.ViolationList FROM …

hi. im having problems with comparing a string and a string array. I know it should be as simple as something like if(str == strn[0]) and if this is true, it will go to that if block statement. I've tried all kinds of test already and it seems that whether …

Hi. Can anyone tell me how to populate items in listview? I need to call a column in a database to load all its list.

Hi. Can anyone tell me how to create a mobile database and application using SQL Server Management Studio Express?

Hi. Can anyone tell me how to find and install IIS? I need it for developing my mobile application with SQL Server Mobile and create a database. Or if you have any suggestions... Do you know any other way on connecting from mobile applications to databases (other than MS SQL) …

Hi. Can anyone give me an idea on how I can create a search box just like a search box in the contacts window in a Nokia phone?

Hi. I have been figuring out how to deal with my dilemma. I'm developing a mobile application in C# in Visual Studio 2005. And I have a question regarding the adding of listview items from a form to another listview in another form. I have got my application running but …