C# Discussion Boards - CodeProject

Re: an array question

fly90426-May-09 5:59

fly904

26-May-09 5:59

I concur

My failometer is detecting vast quantities of FAIL!

"Its SQL - hardly programming..." (Caslen)

Re: an array question

bluetx26-May-09 6:04

bluetx

26-May-09 6:04

yes here shopping i forgetten i closed door back idiot

Re: an array question

fly90426-May-09 6:07

fly904

26-May-09 6:07

bluetx wrote:
its a gibe.you are very emotional.wake up

My failometer is detecting vast quantities of FAIL!

"Its SQL - hardly programming..." (Caslen)

Re: an array question

bluetx26-May-09 5:55

bluetx

26-May-09 5:55

yes yes advice and after you send me money.

yeah go to hell.

Re: an array question

fly90426-May-09 5:57

fly904

26-May-09 5:57

Talking to your self?

My failometer is detecting vast quantities of FAIL!

"Its SQL - hardly programming..." (Caslen)

Re: an array question

0x3c026-May-09 5:53

0x3c0

26-May-09 5:53

While I appreciate your remark was probably intended as a joke, it was in poor taste. These boards are for advice. Asking for code is very bad form, and may result in a refusal to help, being put on a hit list, getting flamed or one or more of the above

importing data from a xls file to an array

guchu26-May-09 4:29

guchu

26-May-09 4:29

can neone help me with importing data from a xls file to an array ... i am not using databases and i want it to be importes into an array in c# class Sniff | :^)

Re: importing data from a xls file to an array

EliottA26-May-09 4:39

EliottA

26-May-09 4:39

Where did you get stuck? Seems pretty straight forward...

Check out the CodeProject forum Guidelines[^]

reading an excel file

guchu27-May-09 9:20

guchu

27-May-09 9:20

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Reflection;
using Excel = Microsoft.Office.Interop.Excel;

I am learning to use c# at the moment .. i have this code to read an excel file ... its incomplete now asi am yet to define the other varibles but as of now i want to have a user input in textbox1 and then that is to be the file name of the excel file to open ... can ne one help me

namespace WindowsFormsApplication7
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

private void Form1_Load(object sender, EventArgs e)
{

}

private void label1_Click(object sender, EventArgs e)
{

}

private void textBox1_TextChanged(object sender, EventArgs e)
{

}

private void label2_Click(object sender, EventArgs e)
{

}

private void button1_Click(object sender, EventArgs e)
{
try
{
// open the users excel workbook.
Excel.Application ExcelApp = new Excel.ApplicationClass();
ExcelApp.Visible = true;
String WorkbookPath = "c:/Users/Guchu/Desktop/a.xls";
Excel.Workbook ExcelWorkbook = ExcelApp.Workbooks.Open(WorkbookPath, 0, false, 5, "", "", false, Excel.XlPlatform.xlWindows, "", true,false,0,true,false,false);
Excel.Sheets excelSheets = ExcelWorkbook.Worksheets;
string CurrentSheet = "CurrentSheet";
excelSheets = (Excel.Sheets) excelSheets.get_Item(CurrentSheet);

}
catch (Exception theException)
{
String errorMessage;
errorMessage = "Error: ";
errorMessage = String.Concat(errorMessage, theException.Message);
errorMessage = String.Concat(errorMessage, " Line: ");
errorMessage = String.Concat(errorMessage, theException.Source);

MessageBox.Show(errorMessage, "Error");
}
}

private void button2_Click(object sender, EventArgs e)
{

}

}
}

Re: reading an excel file

EliottA27-May-09 9:23

EliottA

27-May-09 9:23

Why not just use the process class with the start method to instantiate excel.exe to open with your workbook in question?

Check out the CodeProject forum Guidelines[^]

Re: reading an excel file

guchu27-May-09 9:29

guchu

27-May-09 9:29

as i have told u that i am new to c# hence i might have done it the harder way ... but it will be easy for me to understand if u can give me the code ...

what i did was ...

for the text box i wrote...
this.textbox1 = new system.windows.forms.textbox();
string a = textbox1.text,

then in the button 1 part for opening the code i want to insert this string a as the file name in the file path

string workbookpath = @ "c:\.....\" + a ;

but this doesnt works ... can u tell me the correct way

Re: reading an excel file

EliottA27-May-09 9:44

EliottA

27-May-09 9:44

guchu wrote:
this.textbox1 = new system.windows.forms.textbox();
string a = textbox1.text,

A new textbox would be blank, so string a would be "", debug through your code.

I will not give you the code but go to the documentation[^] and check out the process class, specifically the start method, and search the forums a bit, you'll find your answer. You just have to research for it.

Also, I would look into the OpenFileDialog to pick your file, that way you have no restriction on the residual location of your excel files.

Check out the CodeProject forum Guidelines[^]

Re: reading an excel file

guchu27-May-09 10:00

guchu

27-May-09 10:00

i understand that u want me to learn the easier method but even using this one i am able to open the file if i specify the file name as "C:\....\a.xls" ... all i want to know is if i want to take this last part(a.xls) from the user since the file neways has to be on the desktop then how do i accomodate it in the code ... i have tried doing it using the + operator but it is not done this way as it seems as the compiler doesnt reads the remaining thing written outside "" ... i would be obliged if u can help ... i need it desperately

Re: reading an excel file

EliottA27-May-09 10:03

EliottA

27-May-09 10:03

You reset your textbox by doing Textbox1 = new System.Windows.Forms.Textbox();

if you take that out, you should be fine provided the file exists but your design is horrible, inefficient and there is a faster, prettier way of doing it.

Check out the CodeProject forum Guidelines[^]

Re: reading an excel file

guchu27-May-09 10:07

guchu

27-May-09 10:07

I will go through the documentation and redesign the program .... i will get back to u if i have any quaries regarding this ... as of now thank you very much for helping me out ....

Downloading .MP3 file

gmhanna26-May-09 4:27

gmhanna

26-May-09 4:27

Hi,

I'm trying to download a MP3 off the internet programatically. Using the method below, my MP3 player recognizes the ID3 tag, however it won't play. Anyone know how to properly download a MP3 file that will play?

StreamReader sr = new StreamReader(WebRequest.Create(strURL).GetResponse().GetResponseStream());
FileInfo     fi = new FileInfo(@"c:\news.mp3");
BinaryWriter bw = new BinaryWriter(fi.OpenWrite());

while (sr.Peek() != -1)
{
    btMP3 = (byte) sr.Read( );
    bw.Write(btMP3);
}

bw.Close();

Thank you,

Glenn

Re: Downloading .MP3 file

Luc Pattyn26-May-09 4:32

Luc Pattyn

26-May-09 4:32

Hi,

there is a WebClient.DownloadFile() method that downloads a file much easier and more efficient than your code would.

BTW: what would happen when for some reason the data isn't arriving in time so sr.Peek() can't see the next byte?

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.

connection string

Ahmed Khallaf26-May-09 4:19

Ahmed Khallaf

26-May-09 4:19

i made a chat program in c# and connect it to a local access database,
can i put this database on a server on the internet so can people connect to it by the program , if i can what is the connection string?
i used this connection string to connect to access database:
@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=FileName"

Re: connection string

EliottA26-May-09 4:25

EliottA

26-May-09 4:25

check out this site[^] it's the best thing for connection strings.

Check out the CodeProject forum Guidelines[^]

Re: connection string

tom57200726-May-09 4:26

tom572007

26-May-09 4:26

You will find all the possible connection stringd herehere

You will find in visual studio in the server explorer panel a property wich define your connection string...

regards

Re: connection string

sitowxh26-May-09 5:10

sitowxh

26-May-09 5:10

webservice

Re: connection string

Dave Kreskowiak26-May-09 7:44

Dave Kreskowiak

26-May-09 7:44

And what everybody isn't telling you is that Access is a FILE BASED, desktop database. The only way to get at that database, directly, is to expose your server's file share directly to the Internet. This is about the dumbest thing you can do. Your server will be a smoldering pile of scrap in less than 24 hours.

To insultate the server as much as possible so the idiot on the web won't destroy your server, you need to expose the methods that your chat app needs in a web service and have it do all the database work needed.

A guide to posting questions on CodeProject[^]

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

.config being overwritten

Programm3r26-May-09 4:04

Programm3r

26-May-09 4:04

Hi all,

I am making use of Data block of the Enterprise Library 4.1, the problem is that each time I rebuild my application, Visual Studio overwrites the config file.
The application cannot function without these settings. How can I avoid this annoying issue?
The configuration line in question:

configSections
section name="dataConfiguration" type="Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings, Microsoft.Practices.EnterpriseLibrary.Data....
configSections
dataConfiguration defaultDatabase="OraConnectionStr"

Thanks in advance.
Kind regards,

The only programmers that are better C# programmers, are those who look like this -> Green Alien | [Alien]

Programm3r
My Blog: ^_^

How to access the base registery from a thread?

Doria228626-May-09 3:58

Doria2286

26-May-09 3:58

I create a windows service where I implement the onStart() method, there i create i thread that opens a ServiceHost communication and write onto the base registery but it doesn't take effect, Idon't know how to give the thread the permission to write into it !

Re: How to access the base registery from a thread?

Eddy Vluggen26-May-09 6:24

Eddy Vluggen

26-May-09 6:24

Open your "Control Panel", and look for the "Administrative Tools". This has an applet called "Services". Find your service in the list (should be there if it's properly installed) and double-click on it. Go to the tabpage called "Log On".

Here you can specify the account that the service should run under, and whether or not it's allowed to interact with the desktop (for, say, displaying a notification icon)

Hope this helps Smile | :)

I are troll Smile | :)

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