Using code behind to retreive ms access data - C# Discussion Boards

Re: Include IIS in Windows Service

5-Jul-07 6:39

I don't understand. If you want an IIS hosted WebService why not just create one?

Roland Bär5-Jul-07 7:15

Roland Bär

5-Jul-07 7:15

Maybe I have to explain a little bit better (or at least I try to...)

I have a windows service that starts when the server is started. This windows service does its job in the background, receives data, makes function calls etc. and is allways running as it should. The windows service makes some function calls through web services.

Now I want to create a web GUI that shows the state of the windows service, using asp.net, ajax etc. One way to get the data would be to communicate with the windows service through .net remoting. But as the other Interfaces are web services and therefor are easy to call for testing I would like to be able to receive the data from the windows service through a web service interface.

But to be able to provide the interface as an web service I need a web server inside my windows service (or at least I think it could work like that).

Hope my idea is now clearer.

Thanks and Greets
Roland

Hi! I'm a signature virus. Copy me into your sig file and help me spread!

Follow your Euro notes in their tracks

Re: Include IIS in Windows Service

led mike5-Jul-07 7:44

Using code behind to retreive ms access data

5-Jul-07 7:44

Roland Bär wrote:
One way to get the data would be to communicate with the windows service through .net remoting. But as the other Interfaces are web services and therefor are easy to call for testing I would like to be able to receive the data from the windows service through a web service interface.

Doesn't Remoting have an HTTP channel that uses SOAP?

ComboBox Data Binding

goldoche5-Jul-07 5:47

goldoche

5-Jul-07 5:47

Hi, I have a ComboBox to which I give a string array as a DataSource. It works. I also have a DataSet and one of the columns of a table contains the SelectedIndex of this ComboBox, but when I bind it, it does not select the right index.

I've decided to bind it to a numericUpDown and it works, so what's going on with the comboBox?

Here's my code:

// The numeric updown displays "3", which is good!<br />
numericUpDown1.DataBindings.Add("Value", dataset.LoadModule, "RampUpSpeed");<br />
<br />
// The selected index of the comboBox is 0, which is not good!<br />
rampUpCombo.DataBindings.Add("SelectedIndex", dataset.LoadModule, "RampUpSpeed");

Thanks!

markymark825-Jul-07 5:05

markymark82

5-Jul-07 5:05

hey all,

I'm tring to pull records from an access database in my c#.net web app.

Doing it using VS2005 in the gui view is fine but I want to set up a connection server side and pull records using a reader like I would with sql, however, I can't seem to find the syntax. I have created the connection string but from there on it seems quite a bit different from an sqlconnection.

I'm after the equivilant of below:

//------
OleDbConnection dbConnect = new OleDbConnection(@"Dsn=MS Access Database;dbq=C:\Program Files\Sage\Accounts\DBFile.mdb;defaultdir=C:\Program Files\Sage\Accounts;driverid=25;fil=MS Access;maxbuffersize=2048;pagetimeout=5;uid=manager");

OleDbCommand dbcommandCom = new OleDbCommand(@"select * from [invoice]");

dbConnect.Open();

OleDbDataReader RecReader = null;

dbConnect.Open();

RecReader.Read();

dbConnect.Close();
//-----------

Can someone please help as I have a short timescale for the project.

Thanks in advance
mark

Christian Graus5-Jul-07 5:21

Christian Graus

5-Jul-07 5:21

Basically, I believe you call Read over and over, and each time you do, the reader points to the next record, and you can access the columns of that row before calling read again.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Guffa5-Jul-07 6:23

Guffa

5-Jul-07 6:23

It looks like you create a connection object, a command object and a reference for a data reader, and hope that they will automatically find each other, execute the command, create a data reader object and place in your reference. They don't. You have to make the command object use the connection, then you have to use a method in the command object like ExecuteReader to execute the command, and assign it's return value to your reference. Then you can start to read from it.

Look at any examples out there. They are everywhere.

markymark82 wrote:
I have created the connection string but from there on it seems quite a bit different from an sqlconnection.

On the contrary. From there on the code is very similar.

---
single minded; short sighted; long gone;

markymark825-Jul-07 9:46

markymark82

5-Jul-07 9:46

ok,
so should I actually be using the 'OleDbConnection', as currently I keep getting errors about the provider for it, the only suggestion i've found is 'provider=sqloledb;' in the connection string, but obviously its not an sql db so that doesn't work, what would the equivilant be for an ms access db?

Otherwise the only other connection object I have found that does not error is:
'AccessDataSource db = new AccessDataSource(@"Dsn=MS Access Database;dbq=C:\Program Files\Sage\Accounts\ODBC.mdb;defaultdir=C:\Program Files\Sage\Accounts;driverid=25;fil=MS Access;maxbuffersize=2048;pagetimeout=5;uid=manager", @"select * from Invoice");'

but from there I have no idea how to open a reader as I can't find an option for it and I can't see how to read the records that are returned from it?

thanks for you help so far, much appreciated

mark

Guffa5-Jul-07 11:09

Guffa

5-Jul-07 11:09

Open the properties for the connection that you are using in Visual Studio. There you will see the provider and connection string.

Otherwise connectionstrings.com[^] is good for connectionstrings.

OleDb is the preferred provider for Access.

---
single minded; short sighted; long gone;

send/recieve email + ping to pc in netwerk using a pocket pc

markymark825-Jul-07 11:14

markymark82

5-Jul-07 11:14

Thanks for the help,

I really appreciate it.

I shall try that outbut for now I have found a way slightly around the problem.
I have created a system odbc object that links to the .mdb file and then linked to it through odbcconnection. This has worked fine for now but I'll still try doing it the other way as i wont have to create odbc objects on each machine its to be installed on.

thanks again

mark

faladrim5-Jul-07 4:21

faladrim

5-Jul-07 4:21

hi,

i've made an app on my pc who pings to see who's in my network and is able to send emails
i want to do the same on a pocket pc, but i cant seem to find how this works
i get stuck on the fackt that pocket pc in vs 2005 doesn't have :
using System.Net.NetworkInformation;
using System.Web.Mail;
does anybody know were i can find examples or how i send emails or ping ???
plz help! Sniff | :^)

grz muk

Retrieve Installation Path

terrible835-Jul-07 4:09

terrible83

5-Jul-07 4:09

Hi,
i've created a setup project and it works fine. Now i want to retrieve the installation path because i need to set it as current directory for the windows service i've created. How can i do it?
I need to pass through windows registry (how?) or exists a variable or a property which i can read?

Thank you all!

Gianluca

Re: Retrieve Installation Path

originSH5-Jul-07 4:13

originSH

5-Jul-07 4:13

[TARGETDIR] is the property which contains the installation directory.

You can add registry keys via the installer.

Re: Retrieve Installation Path

led mike5-Jul-07 4:39

5-Jul-07 4:39

terrible83 wrote:
because i need to set it as current directory for the windows service i've created

As someone pointed out in the past few days, best practice is to use absolute paths.

To obtain the path you can access the installation path using the Windows Installer SDK in your service, that is what you are asking correct? However AFAIK this should work:

System.Reflection.Assembly.GetExecutingAssembly().Location

how to insert data

csanda15-Jul-07 3:59

csanda1

5-Jul-07 3:59

Hi
Im doing an application in Visual C# 2005, my application can read data from my database but cant save into the database. Heres the code. What am I missing....Pliz Help!!!!

private void btnSave_Click(object sender, EventArgs e)
{
string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;"+"Data Source=YAC.mdb";
OleDbConnection conn = new OleDbConnection(strConnection);
conn.Open();
string strCommand = "INSERT INTO ClientProfile(Name,Surname,Gender,IdNumber) Values ('" + txtName.Text + "','" + txtSurname.Text + "','" + cbxGender.Text + "','" + txtIdNumber.Text + "')";

OleDbDataAdapter adapter = new OleDbDataAdapter();
adapter.InsertCommand = new OleDbCommand(strCommand, conn);
(this.yACDataSet.ClientProfile);

int t1 = adapter.InsertCommand.ExecuteNonQuery();
conn.Close();

if (t1 > 0)
{
MessageBox.Show("added successfully!");

}

csanda

Re: how to insert data

led mike5-Jul-07 4:42

Registry Problems NullException

5-Jul-07 4:42

Welcome to CodeProject. There are a large number of C# Database Articles here follow the link[^]

StevenWalsh5-Jul-07 3:47

StevenWalsh

5-Jul-07 3:47

I'm trying to query the registry on a remote server to verify a value. using the code

<br />
RegistryKey RemoteKey;<br />
                                         string RemoteComputer = LabName + "isp0001";<br />
                                         RemoteKey = RegistryKey.OpenRemoteBaseKey(RegistryHive.LocalMachine, RemoteComputer);<br />
                                         string value = RemoteKey.OpenSubKey("SOFTWARE\\Twrap\\Packages\\Completed", RegistryKeyPermissionCheck.ReadSubTree).GetValue("1.3", 0).ToString();<br />
<br />

When i run it i see this:

A first chance exception of type 'System.NullReferenceException' occurred in LabMonitor.exe
A first chance exception of type 'System.NullReferenceException' occurred in LabMonitor.exe

and the exception message is: "Object reference not set to an instance of an object"

Please help Smile | :)

Christian Graus5-Jul-07 3:55

Christian Graus

5-Jul-07 3:55

StevenWalsh wrote:
and the exception message is: "Object reference not set to an instance of an object"

You're bound to get that when you chain together calls without first checking the return values. I'd assume that OpenSubKey is failing, but you should step through and check it yourself, and write more defensive code in future.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

NassosReyzidis5-Jul-07 3:56

NassosReyzidis

5-Jul-07 3:56

Hello Steven,
either the RemoteKey is null or
the "RemoteKey.OpenSubKey("SOFTWARE\\Twrap\\Packages\\Completed", RegistryKeyPermissionCheck.ReadSubTree)" is null

change your code from:

RegistryKey RemoteKey;<br />
string RemoteComputer = LabName + "isp0001";<br />
RemoteKey = RegistryKey.OpenRemoteBaseKey(RegistryHive.LocalMachine, RemoteComputer);<br />
string value = RemoteKey.OpenSubKey("SOFTWARE\\Twrap\\Packages\\Completed", RegistryKeyPermissionCheck.ReadSubTree).GetValue("1.3", 0).ToString();

to:

RegistryKey RemoteKey;<br />
RegistryKey RemoteSubKey;<br />
string value;<br />
string RemoteComputer = LabName + "isp0001";<br />
RemoteKey = RegistryKey.OpenRemoteBaseKey(RegistryHive.LocalMachine, RemoteComputer);<br />
if (RemoteKey != null)<br />
{<br />
     RemoteSubKey = RemoteKey.OpenSubKey("SOFTWARE\\Twrap\\Packages\\Completed",RegistryKeyPermissionCheck.ReadSubTree);<br />
     if (RemoteSubKey != null)<br />
     {<br />
          value = RemoteSubKey.GetValue("1.3", 0).ToString();<br />
     }<br />
}<br />
if (value != null && value.Length>0)<br />
{<br />
   //The SubKey exist do your staff with the value<br />
}

GanDad

StevenWalsh5-Jul-07 4:09

StevenWalsh

5-Jul-07 4:09

Hi, i've tried your code, and i'm still getting the exception here is where it is stopping

RemoteKey = RegistryKey.OpenRemoteBaseKey(RegistryHive.LocalMachine, RemoteComputer);

Christian Graus5-Jul-07 4:22

Christian Graus

5-Jul-07 4:22

Breaking it down will just help you work out where the problem is. It won't change that you are making a call which is returning null, and not checking it.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )