C# Discussion Boards - CodeProject

OriginalGriff4-May-09 21:59

4-May-09 21:59

To add to this most excellent reply, they also aid with encapsulation. Because you expose a method rather than a field with get, set, the implementing class can replace the internal implementation of the property without affecting the outside world. If your class keeps a hard count of elements in a tree (say) and exposes that via "public int count" then it must retain that count for all time. If it is exposed via

public int Count
   {
   get { return count; }
   set {count = value; }
   }

then it is at liberty to dispose of the "count" field and replace it with a new implementation at will. This will not affect classes relying on the "Count".

Further, it allow you to error check the assignments:

public int Count
   {
   get { return count; }
   set 
      {
      if ((value < 100) && (count >= 0))
         {
         count = value;
         }
      else
         {
         throw new Exception(string.Format("Value out of range: {0}", value));
         }
      }
   }

But I agree - read a book, because if you don't know this stuff, there are a lot of other complexities you need to be aware of before you go much further!
Good luck.

No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced.

This message is made of fully recyclable Zeros and Ones

Re: get set property

Member 44703545-May-09 0:00

Member 4470354

5-May-09 0:00

1 word: Encapsulation

How to read CSV file

kaushik_dass4-May-09 20:38

kaushik_dass

4-May-09 20:38

HOw i Display CSV File Data TO DataGridView
Please Help me With Connection string And Code.

Re: How to read CSV file

King Julien4-May-09 21:09

King Julien

4-May-09 21:09

Hi!!!

Try to do some research by yourself instead of asking code from others....

have a look at this site....
csv to datatable[^]
Can give you some insight regarding the issue....

Have a Happy Coding.....

Re: How to read CSV file

kaushik_dass4-May-09 21:15

kaushik_dass

4-May-09 21:15

I have tried it But i got Error Path is not correct even i give it to right path

here is my code

string Con_Str = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\My\a.csv;Extended Properties=Text;HDR=No;FMT=Delimited";

OleDbConnection cn = new OleDbConnection(Con_Str);
cmd=new OleDbCommand("select * from Book1.CSV",cn );
da=new OleDbDataAdapter(cmd);
ds=new DataSet();
da.Fill(ds,"ex");
dataGridView1.DataSource=ds.Tables[0].DefaultView;

Re: How to read CSV file

Dave Kreskowiak5-May-09 4:31

Dave Kreskowiak

5-May-09 4:31

So what's the filename of your CSV file?? In your code you have, in the connection string, C:\My\a.csv. But, in the OleDbCommand, you have Book1.CSV. So, which is it??

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Re: How to read CSV file [modified]

Jack Li4-May-09 21:46

Jack Li

4-May-09 21:46

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Reflection;
using System.Runtime.InteropServices;
using Excel = Microsoft.Office.Interop.Excel;
using System.Data.OleDb;
using System.Security.Cryptography;

public DataSet ExcelToDS(string Path)
{
//return one dataset

object missing = Missing.Value;
Excel.Application excelApp = new Excel.Application();
excelApp.Visible = false;
try
{
excelApp.Workbooks.Open(path, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing);
excelApp.Workbooks[1].Worksheets[i + 1];
Excel.Worksheet ws = (Excel.Worksheet)excelApp.Workbooks[1].Worksheets[1];
string sheetName = ws.Name;
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + Path + ";" + "Extended Properties=Excel 8.0;";
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
string strExcel = "";
OleDbDataAdapter myCommand = null;
DataSet ds = null;

strExcel = "select * from [" + sheetName + "$]";
myCommand = new OleDbDataAdapter(strExcel, strConn);
ds = new DataSet();
myCommand.Fill(ds);
conn.Close();
excelApp.Workbooks.Close();
excelApp.Quit();
excelApp = null;
return ds;
}
catch
{
MessageBox.Show("Not close EXCEL", "Err Info", MessageBoxButtons.OKCancel, MessageBoxIcon.Error);
KillProcess("EXCEL");
return null;
}
}

modified on Tuesday, May 5, 2009 3:52 AM

Confirm message on successful validation

Ramkithepower4-May-09 20:27

Ramkithepower

4-May-09 20:27

Hi ,

I am developing an application with a datagrid using which user can update the data in the datagrid row. Its all in ASP.Net c#.

on click of a button i should do the following.
Check if user has modified atleast one row.
1. If the user has not modified even one row, then i should display a messsage stating user to action atleast one row.--- I have done this check and works good.
2. If the user has changed atleast one row then i should display a alert asking for confirmation if they would like to proceed. If the user selects 'No' i should stop the execution. if he clicks Yes the execution should proceed. -- I need help on this .. I am not able to trigger it becuase the button is already clicked.

Please help me sort the point 2.

Re: Confirm message on successful validation

Christian Graus4-May-09 20:35

Christian Graus

4-May-09 20:35

WE have an ASP.NET forum

Christian Graus

Driven to the arms of OSX by Vista.

"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )

Re: Confirm message on successful validation [modified]

mohmeh834-May-09 20:42

mohmeh83

4-May-09 20:42

if the useer click no whit action must be stopped?

modified on Tuesday, May 5, 2009 3:29 AM

Re: Confirm message on successful validation

Ramkithepower4-May-09 20:50

Ramkithepower

4-May-09 20:50

On the click of yes the changes done by the user in datagrid is updated in databases. This should not happen if he clicks no.

Re: Confirm message on successful validation [modified]

mohmeh834-May-09 21:16

mohmeh83

4-May-09 21:16

if(MessegeBOx.Show("Are you sure?",...,MessageBoxBottunYesNo) == DialogResult.YES)
update();
else
return;

modified on Tuesday, May 5, 2009 3:28 AM

Re: Confirm message on successful validation

Jack Li4-May-09 21:50

Jack Li

4-May-09 21:50

You'll using right to limit the buttom, and user right from userlevel list table.

Typed DataSets

Illegal Operation4-May-09 19:16

Illegal Operation

4-May-09 19:16

Hi.

I have a question. Say you have a database with 10 tables, they all are related to each other. Now you start your Windows application and obviously you implement a typed dataset to enable offline work etc.

My question is this, is it better to create a few datasets or just one? Can I create a dataset for each table in the database?

Illegal Operation

Re: Typed DataSets

N a v a n e e t h4-May-09 19:36

N a v a n e e t h

4-May-09 19:36

Illegal Operation wrote:
Can I create a dataset for each table in the database?

A DataSet can contain many tables, so creating separate dataset for each tables is not required.

Navaneeth

How to use google | Ask smart questions

Re: Typed DataSets

saanj4-May-09 20:10

saanj

4-May-09 20:10

DataSet has DataTableCollection, DataRelationCollection and ExtendedProperties using which you can store multiple tables inside a dataset. So there is no need use multiple datasets.

Either you love IT or leave IT...

How can I know raw header information through BHO?

svt gdwl4-May-09 18:39

svt gdwl

4-May-09 18:39

I had small application of BHO in c#, when the events gets fired I used perform the operation that I

want to do on browser(IE). The thing is I want to know the header information? as the data gets loaded

on browser packet by packet, how can I know these header information regarding content length,

content-type that the data gets loadad on IE.
Thus how can I know header information through BHO?

debuggin in windows service

mark_me4-May-09 13:54

mark_me

4-May-09 13:54

Hi,
I am having some trouble debugging a windows service. i have attached a debugger to the service but after each change, do i have to rebuild my windows service, rebuild setup and uninstall and install the service. There must be an easy approach to this.
Please provide help

Re: debuggin in windows service

N a v a n e e t h4-May-09 19:33

N a v a n e e t h

4-May-09 19:33

Solution explorer -> Right click on project -> Debug -> Choose any option

Smile | :)

Navaneeth

How to use google | Ask smart questions

Highlight text in a datagridview cell.

edlanka4-May-09 13:28

edlanka

4-May-09 13:28

I have a datagridView in a winform and i display the results of a particular search. How do I highlight/bold only the charecters or the substring in the cell that matches my search.

(the best analogy would be the google finance, in which as you type ahead it bolds the characters that match the search)

thanks.

Display image on Hover on a button in a winform

edlanka4-May-09 11:43

edlanka

4-May-09 11:43

I have a image button in a winform. On mouse hover i would like to change the image of the button. When the focus is lost i would like to show the original image .
I am handling the mouse_hover and mouse_leave events and changing the value of image property to the image i need. My images are stored in the resource file.
Is this the right way to do it?

Please let me know..

Re: Display image on Hover on a button in a winform

Christian Graus4-May-09 12:05

Christian Graus

4-May-09 12:05

Yeah, that seems the best way to me.

Re: Display image on Hover on a button in a winform

mohmeh834-May-09 19:51

mohmeh83

4-May-09 19:51

you can use a imageList and insert your images into it and on mouse events change button imageIndexes for example:
mybutton.ImageIndex = 0;

Problem uninstalling win service

mark_me4-May-09 9:52

mark_me

4-May-09 9:52

Hello,
i am assigned to work on a windows service developed by another programmer. I am having problems attaching to the windows service. the service was communicating with a remote server and for testing purposes, i want it to work on my local host.Whenever i get disconnected from LAN, it won't run probably because it can't make a connection to server, but i want to insert a breakpoint right at the beginning so whenever i find a connection to remote server, i change it. this didn't work,
so i thought of uninstalling the current service and installing a new instance of it with local host only, But i am having the following probs.///i don't know the exact path. solution (folder)has been pasted to another location

c:\Program Files\Microsoft Visual Studio 9.0\VC>installutil /u marketordermanage
r.exe

Exception occurred while initializing the installation:
System.IO.FileNotFoundException: Could not load file or assembly 'file:///c:\Pro
gram Files\Microsoft Visual Studio 9.0\VC\marketordermanager.exe' or one of its
dependencies. The system cannot find the file specified..

i don't have it in controlpanel\add or remove programs...

i even tried the sc command, it didnt work. how do i delete this service.

thanx inadvance

Re: Problem uninstalling win service

mohmeh834-May-09 19:56

mohmeh83

4-May-09 19:56

I think if you use "service" control in cs you can solve your problem.

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