how to insert data - C# Discussion Boards

Re: Using code behind to retreive ms access data

markymark825-Jul-07 9:46

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

Re: Using code behind to retreive ms access data

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;

Re: Using code behind to retreive ms access data

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

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

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

led mike

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

led mike

5-Jul-07 4:42

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

Registry Problems NullException

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 | :)

Re: Registry Problems NullException

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 )

Re: Registry Problems NullException

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

Re: Registry Problems NullException

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);

Re: Registry Problems NullException

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 )

Re: Registry Problems NullException

StevenWalsh5-Jul-07 4:42

StevenWalsh

5-Jul-07 4:42

Christian Graus wrote:
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.

i broke it down some more and narrowed to problem down to the string "value" i made value an object datatype and it now works.

user id,password.etcc..

myat_035-Jul-07 3:05

myat_03

5-Jul-07 3:05

this is the problem

Create a User class. This class should at least contain the following fields:
User ID
Password
First Name
Last Name
E-mail Address
Status - valid values are 'Inactive', 'Active', 'Deleted'
Define constructors that accept the following parameter lists:
All parameters: User ID, Password, First Name, Last Name, E-mail Address, Status
User ID, Password and E-mail Address
User ID and Password Only
** The status field should be initialized to 'Active' upon creation
** Constructors 2 and 3 should use a constructor initializer

Define read-only properties that return the following:
IsActive – whether or not the account's status is active
FullName – a concatenation of the account's first and last names
Define additional properties that behave as follows:
UserID
Set operation should ensure the user id does not start with a digit and should only update the user id field if the given value is valid
Get operation just returns the user id
Password

pls help me... Cry | :((

just notify me through my email...

......

Re: user id,password.etcc..

originSH5-Jul-07 3:10

originSH

5-Jul-07 3:10

Thats a nice specific specification so just impliment it.

You need only the most basic knowledge of c# to achive this.

Re: user id,password.etcc..

myat_035-Jul-07 3:25

myat_03

5-Jul-07 3:25

i am in a short period of time and i do have problem on my computer..i can't practice now..i find source of this project and i try this site that someone could help me to this problem..

......

Re: user id,password.etcc..

originSH5-Jul-07 3:36

originSH

5-Jul-07 3:36

So because it's got to be handed in soon and you didn't do it in time you want someone else to do it for you?

Re: user id,password.etcc..

Christian Graus5-Jul-07 3:56

Christian Graus

5-Jul-07 3:56

every homework request comes with a sob story. This is really straight forward. If you try to do it yourself and you need help with specific things, that's different, but for you to just post your homework and hope someone will do it is, frankly, kind of rude.

So, I ask again, which specific bits are confusing you ? Do you want to ask some specific questions to help you in approaching this task ?

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 )

Re: user id,password.etcc..

Christian Graus5-Jul-07 3:19

Christian Graus

5-Jul-07 3:19

Which part of your (pretty simple) homework is confusing you ? This is a basic exercise in OO. We never do homework, but this in particular, is pretty vital for you to understand, and really not hard.

I would guarentee that any text you've been assigned will cover all you need to know to do this.

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 )

Re: user id,password.etcc..

Paul Conrad5-Jul-07 6:02

Paul Conrad

5-Jul-07 6:02

This is very straightforward and do your own homework. People will help with a specific problem you may have, but not do your homework for you Big Grin | :-D

"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus

Change column title in DataGrid

Muhammad Gouda5-Jul-07 2:20

Muhammad Gouda

5-Jul-07 2:20

My table contains fields like (empId, empName,...)
And when I load my table to a DataGrid, the columns' titles become the sames as fields names in my table.
I need to assign them new titles (e.g. Employee ID, Employee Name, ...)
Anybody can help?

Mohamed Gouda
Egypt

Re: Change column title in DataGrid

kubben5-Jul-07 2:28

kubben

5-Jul-07 2:28

I wrote an article that shows how to do this in .net 1.1
http://www.codeproject.com/useritems/DataGrid_TableStyles.asp[^]

Hope that helps.
Ben

Re: Change column title in DataGrid

Muhammad Gouda9-Jul-07 21:21

Muhammad Gouda

9-Jul-07 21:21

Many Thanks
I expected more effort is needed for this. But it was so easy Big Grin | :-D

Mohamed Gouda
Egypt

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.