If you are capturing images then you will probably want to store them in a database as a BLOB (Binary Large Object) or on your computer with a path to the images stored in the database.


You are...

Hi Guys

I hope you can help share some light on my problem.

Basically, I have a MS Access table...ID, firstname, surname, Address1, Address2 etc

What I want to do is Select all from table...

Just incase anyone is interested ... Ive found a thread that explains the mobile file structure and how to find the new file you just created ....
...

Hi Guys,

Surely this shouldnt be such a complex task! I have done this before for a desktop application where I typed in data on the UI clicked a button and a new text file was created on the C:...

Thank you VERY much Dickersonka :)

:S I will look into this ... I greatly appreciate the assistance you have given me.

Have a virtual hug lol :)

OK am I missing something?

By server in mixed mode, what do you mean? At the minute I have no idea of which server the end result of this system will be loaded on to.

Properties of Server ?? - ...

Hiya,

Ok, so inside the 'Server Explorer' tab of the Visual Studio IDE I right clicked on the database.mdf file and clicked 'Modify Connection'. I then changed the radio button to 'Use SQL Server...

Yes initially I chose Windows Authentication to set up the connection to the database as I naively thought it shouldnt matter for developing the system, but I need to change it to use the Username...

Hi

I have just been informed by a few work collegues that the database system that I have created should now be set to use Server Username and Password.

Is it a big deal to change this without...

Hi

I have just discovered a development environment called MobiForms available at http://www.mobiforms.com/ for developing mobile applications.

I had a wee read through it but cant see any real...

Hi, that program requires Oracle client and networking components! Why is that if im only using SQL Server

Hmmm ok

Im stiil trying to figure out how to set that up properly ... Teratrax Performance Agent > Server Configuration > SQL Server Instance name.

Actually no im not sure lol :) My login is simply textboxes and I then programatically check that what the user enters matches a set username and password.

I have it set up on the one machine ......

OK thanks

Do you know of any tools available to VS2008 and Sql Server 2005 that may help me

Ive double checked the case and the spelling...thats all correct!

Ive been reading about a tool called Sql Profiler, its not available on my machine, I have tried googling for it and came across...

Hi

I have run my program again, and even created a new stored procedure containing the same code that "does what it says on the tin" while executed within the stored procedure itself. It adds to...

That sounds like something I had to do for an assignment at University. I had to make an application that allowed the user to create a new document, save, open and close etc.

You may want to look...

My stored procedures dont have that option ! Im no longer at work, but I will post the sql code on monday :)

Thanks for your help in the mean time :)

SqlConnection myConnection = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|DatabaseName.mdf;Integrated Security=True;User Instance=True");


public void...

No - its just meant to be a simple app, (an interface to a database) im making it for in-house purposes, so it just has the one user (hardcoded login for now anyway)

Ive already tried prefixingwith dbo with no joy :( lol

I have other sproc's that work ... like I have an AddCustomers sproc that just inserts the values into the table .... (Eazy peezy)

but ......

I think I see what you are trying to do .. but I have 3 tables

Customer (aka Company)
Vehicle
Customer_Vehicle

so the @idcompany is the primary key from the Customer table

stepping through the code in debug mode at that point, it picks up the CommandText as "AddNewVehicle" and stepping on through the rest of the code it see's the values for each of the parameters ...
...

lol

yes - but ... :)

when I test the stored procedure itself...it DOES add to the database...

but when I run the code its throwing a fit!!

Thats a valid point :)

but either way I will still be faced with the problem of inserting the ID value for the Customer name selected from the DropDown list.

How can I write a stored procedure...

I have two different versions of the AddNewVehicle sproc (purely because the program threw a hissy fit by saying it couldnt see the CreateVehicle sproc)

the content of both are the same as defined...

The Green highlighted pieces show the code that I had that successfully added the data to the tables but I had to manually enter the ID number ... the code then selected the ID_Company based on that...

Hey People :)

A little quesion for you all ...

I have a stored procedure which retrieves an ID from a Customer table and the ID from the newly Inserted row of the Vehicle table and adds them to...

I got the combo box issue sorted

was able to get the SelectedIndex value and from there I get the SelectedItem (string)

yeah fair point !

In ASP.NET there is an onPageLoad() (or something similar) so that you can force a DropDownList to be automatically filled with data ... the user then clicks their desired info...

Ooops I mean a ComboBox



Yes, I have tried that. But for some reason its not working. I am probably doing something in the wrong order.


private void...

oooh yea lol

but still ... surely there is a simple property of the comboBox control to force the DATA to be passed to a VARIABLE (which could be used for further manipulation)

I have used a...

Hi

I have a stored procedure that returns the unique ID for a particular Name/string passed in.

On my windows form I have a ListBox control filled with a list of names (returned from another...

Hi

Would it be because while you are testing it in the IDE the database connection string is pointing to the mdb database file within your bin/debug folder explicitly rather than replacing the...

Never mind, Sorted :)

Hi

I have a tabbed control. Tab1 is for adding new customer details and Tab2 is for searching for existing customers (from a comboBox) and then adding additional information for that customer.
...

Hi,

Sorry for posting again but this is really starting to annoy me now.

I have created a form with textboxes for user input!

Stored procedures to add the parameter data to the table (which...

One last question Jerry. For the highlighted method call above. How did you write that method? I really do have a lot to learn !!


public void GetSqlConnection()
{
...

Thanks very much Jerry, that looks very neat :) I'll give it a go and let you know how I get on

Thanks

Jerry,

I have a question related to this post!

I am trying to develop a Windows Application interface to an SQL Server database. I have a stored procedure that executes properly and...