Re: how to Read folder contents - C# Discussion Boards

Reading Numeric and AlphaNumeric Values from Excel

meeram39512-Aug-07 20:10

12-Aug-07 20:10

Hi

I have an Excel sheet, has 4 columns. In the first column there is an industry code, which contains both numeric and alphanumeric chararcters. I'm not able to read the values to the dataset if the value is alphabets. For eg. if the value is 1,2,3,4 etc.. it will read. But if the value is 1a, 2b, 3e, 4d etc. then it will read as null. Anybody has any solution for these? Any help would be great. I'll post my code below:

OleDbCommand MyCommand;
OleDbConnection MyConnection;

MyConnection = new OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;data source=C:\\Projects\\LiquidCreditChains\\CreditCurveMapping.xls;Extended Properties=Excel 8.0;");

if (MyConnection.State != ConnectionState.Closed)
MyConnection.Close();
else
MyConnection.Open();

DataTable dtSector = new DataTable("SectorChains");
objds.Tables.Add(dtSector);

DataColumn dc1 = new DataColumn("Indust_Code");
dc1.DataType = System.Type.GetType("System.String");
dtSector.Columns.Add(dc1);
DataColumn dc2 = new DataColumn("Indust_Number");
dc2.DataType = System.Type.GetType("System.Int64");
dtSector.Columns.Add(dc2);
DataColumn dc3 = new DataColumn("MappingDescription");
dc3.DataType = System.Type.GetType("System.String");
dtSector.Columns.Add(dc3);
DataColumn dc4 = new DataColumn("SubDescription");
dc4.DataType = System.Type.GetType("System.String");
dtSector.Columns.Add(dc4);
DataColumn dc5 = new DataColumn("Mapping_Curve");
dc5.DataType = System.Type.GetType("System.String");
dtSector.Columns.Add(dc5);

MyCommand = new OleDbCommand("select * from [Sheet1$]", MyConnection);
OleDbDataReader dr1 = MyCommand.ExecuteReader();

while (dr1.Read())
{

DataRow newChainRow = objds.Tables[0].NewRow();

newChainRow["Indust_Code"] = dr1[0].ToString();
newChainRow["Indust_Number"]=dr1[1].ToString();
newChainRow["MappingDescription"] = dr1[2].ToString();
newChainRow["SubDescription"]= dr1[3].ToString();
newChainRow["Mapping_Curve"] = dr1[4].ToString();
objds.Tables[0].Rows.Add(newChainRow);
}

Any help in this regard would be great!!

Thanks

Meeram395

Re: Reading Numeric and AlphaNumeric Values from Excel

travlos718-Mar-09 6:14

travlos7

18-Mar-09 6:14

you can find the answer in the following link.... i hope that it helps
http://www.pcreview.co.uk/forums/thread-1240790.php[^]

Re: Reading Numeric and AlphaNumeric Values from Excel

InfoBridgeSolutions17-Aug-10 19:30

InfoBridgeSolutions

17-Aug-10 19:30

Please check the code at http://chetanwarade.wordpress.com/2010/08/18/read-excel-with-ado-net/[^]

Datagrid paging-c# windows application

hemchandars12-Aug-07 20:06

hemchandars

12-Aug-07 20:06

Hi to everybody

I have DB as dat file.I've paging concept works fine.Problem is when i delete or edit or add records, it is showing the first page on data grid( if i have 50 records-per page 20).I need if the record no 45 is updated OR deleted it has to show the current page i.e., 3rd page.I have not used connection string.Plz help me thanks in advance. Smile | :)

Re: Datagrid paging-c# windows application

Jax_qqq12-Aug-07 21:41

Jax_qqq

12-Aug-07 21:41

Hi,

As per my understanding after every edit or add you must be binding your grid somewhere and i think you are not setting its current page index...

Hope it will work...

Thanks

~Anuj~

Re: Datagrid paging-c# windows application

hemchandars13-Aug-07 1:03

hemchandars

13-Aug-07 1:03

i have not used connection string.I've used .dat file as DB, READING AND WRITING DATAS IN TMP TABLE.If anyone has code sample it will be more helpful.Thanks in advance.

how to Read folder contents [modified]

salmonraju12-Aug-07 20:05

salmonraju

12-Aug-07 20:05

Hi,

I am creating a windows application,that contains a folder,with 5 files. how to programaticlly get the names of all the files in that folder(getting names of all the contents of that folder)

Say folder name is "MyXMLFolder" .It contains elemnts as
-Customer.xml
-Employee.Xml
-Bank.xml

I want c# coding to get all the names of the files in "MyXMLFolder" folder

-- modified at 2:13 Monday 13th August, 2007

Re: how to Read folder contents

Michael Sync12-Aug-07 20:18

Michael Sync

12-Aug-07 20:18

DirectoryInfo dir = new DirectoryInfo(@"F:\MyFolder");<br />
FileInfo[] files = dir.GetFiles("*.*");<br />
<br />
Foreach(FileInfo f in files )<br />
{<br />
  Console.WriteLine("Name is : {0}", f.Name);<br />
  Console.WriteLine("Length of the file is : {0}", f.Length);<br />
  Console.WriteLine("Creation time is : {0}", f.CreationTime);<br />
  Console.WriteLine("Attributes of the file are : {0}",<br />
                     f.Attributes.ToString());<br />
}

Ref:

Working with Files in C#[^]

File Information using C#[^]

Hope it helps.

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Why vote? Plz Read it here. Thank you.

Re: how to Read folder contents

salmonraju12-Aug-07 21:02

salmonraju

12-Aug-07 21:02

Thank you, for detailed description,
working

Re: how to Read folder contents

tker12-Aug-07 20:29

tker

12-Aug-07 20:29

Hi,

You need to use the System.IO namespace. The following code will get you all files in a folder as strings in a string array, including the folder path:

string[] files = Directory.GetFiles(@"c:\MyXMLFolder");

Everything you will need to work with files can be found in System.IO.

Regards,

Toby

Re: how to Read folder contents

salmonraju12-Aug-07 21:01

salmonraju

12-Aug-07 21:01

Thank you ,It is working

crystal reports

monuSaini12-Aug-07 19:58

monuSaini

12-Aug-07 19:58

Hello Friends,

I had generated the crystal report.I want to change the connection string but I am unable to do so . Actually their are two database one is testing database and other is live database. So I need to change the connection string.

But I am unable to do so.

Regards,

rahul saini

Re: crystal reports

Imranlogi12-Aug-07 20:33

Imranlogi

12-Aug-07 20:33

Open your crystal report and on the left hand side you will find Field Explorer, under that you will find Database Fields, right click on that and click on Database Expert and the Database Expert Dialog box will open from there choose Project Data or Create New Connection, according to your need.
Thanks

Imran

Re: crystal reports

monuSaini12-Aug-07 20:49

monuSaini

12-Aug-07 20:49

Hello Imran,

If I choose new connection then all the feilds that i had drag from the previous table will delete.

Regards,

rahul saini

Re: crystal reports

Imranlogi12-Aug-07 21:18

Imranlogi

12-Aug-07 21:18

Ya the feilds will get deleted, do one thing what ever feilds you have dragged earlier, select all the feilds and copy it and when u create new report just paste all the feilds as it is, hope this may help.
Thanks

Imran

Re: crystal reports

monuSaini12-Aug-07 21:27

monuSaini

12-Aug-07 21:27

But Imran I had aroung 10 to 15 reports.
How is it possible to edit every time.

Is their any other sollution , through coding.

Regards,

rahul saini

Re: crystal reports

Imranlogi12-Aug-07 23:06

Imranlogi

12-Aug-07 23:06

I think u must have written some class where u have defined the connection string, change the connection string from there first, what ever new connection string you want. Now in report section u might be using Crystal Report Viewer, so in that Form Load write code like this, according to your table name and class name.
I hope this will help you.

private void CreateReport()
{
this.datcMarketData.getdatafrmdatabase();
JobMarketReport report = new JobMarketReport();
report.SetDataSource(datcMarketData.dSet);
crystalReportViewer1.ReportSource = report;
}

Thanks

Imran

Object reference problem in a windows application.

Janu_M12-Aug-07 19:23

Janu_M

12-Aug-07 19:23

Hi I am developing an windows application in C#.Net(2003).
My form has some textboxes, button and a datagrid. The functionality of the application is in a DLL.
The functionality is like this.
Enter input parameters in text boxes (one parameter belongs to time)
Click Start Button ==> the control goes to the DLL. based up on the time it has to perform the functionality.(suppose for example if we give 4 hours)

After completing a specific period (for example say 1hour) we have to enter a row in the data grid. THis action is done from the form.

For this i am using a timer in the form, on the elapsed time i am entering a row to the data grid by using a datatable.

Also notice one thing, I am using notify icon to show my application in system tray when it is minimized. If the addition of row is done when the form is in the minimized state, if i double click on the icon in the system tray then it is giving an exception "Object reference is not set" from the code in the notify icon Click. In this i am using a statement
this.ShowInTaskbar = true;

when the form is in normal state, adding a row to grid is happening correctly but the form is not responding after performing this action.

Any one please help me.
Thanks in Advance

Thanks and Regards
Ramu

C# DataGridView - Deleting a new Row

shubhabratam12-Aug-07 17:59

shubhabratam

12-Aug-07 17:59

Hi -
I try add a new row in DataGridView. But when I try to delete that it says "Uncommitted new row cannot be deleted". Does anyone know how to commit to add a new row? ANy help is appreciated.

Thanks
SHubho

Re: C# DataGridView - Deleting a new Row

Michael Sync12-Aug-07 18:09

Michael Sync

12-Aug-07 18:09

shubhabratam wrote:
I try add a new row in DataGridView. But when I try to delete that it says "Uncommitted new row cannot be deleted". Does anyone know how to commit to add a new row? ANy help is appreciated.

I think you may need to call Update() method or EndEdit() method of DataGridView..

For example ~

myDataGridView.EndEdit();

OR

myDataGridView.Update();

Hope it helps.

Re: C# DataGridView - Deleting a new Row

Imranlogi12-Aug-07 20:40

Imranlogi

12-Aug-07 20:40

I think u need to update the table. try this code, it is with respect to text boxes, accordingly you can try with datagrid.

string update = "Update JobEvaluationPlanData set Plan_id='" +
TxtPlanId.Text + "' ,Com_Fact='"
+ this.TxtCompFact.Text + "' ,Com_Fact_Def='"
+ this.TxtCompFactDef.Text + "' ,CF='"
+ this.TxtFactor.Text + "' where Plan_id= '" + this.TxtPlanId.Text + "'";

if (
this.TxtPlanId.Text != "" &&
this.TxtCompFact.Text != "" &&
this.TxtCompFactDef.Text != "" &&
this.TxtFactor.Text != "")
{
OleDbCommand command = new OleDbCommand(update, datcJobEvaluationPlanData.con);
datcJobEvaluationPlanData.dAdapter4.UpdateCommand = command;
//do the update
datcJobEvaluationPlanData.dAdapter4.UpdateCommand.ExecuteNonQuery();
MessageBox.Show("Record Updated...");
RefreshData();
}

Thanks

Imran

Re: C# DataGridView - Deleting a new Row

shubhabratam12-Aug-07 20:53

shubhabratam

12-Aug-07 20:53

I am using a DataGridView Control. I want to add a row which is just added to the Grid.

Re: C# DataGridView - Deleting a new Row

Imranlogi12-Aug-07 21:13

Imranlogi

12-Aug-07 21:13

I have used this code to add data to the table with respect to Text Boxes, u can try this for Datagrid with some changes.

string strInsert;
strInsert = "insert into JobEvaluationPlanData" +
"(Plan_Id, Com_Fact, Com_Fact_Def, CF)"
+ "values('" + this.TxtPlanId.Text + "','"
+ this.TxtCompFact.Text + "','" + this.TxtCompFactDef.Text + "','"
+ this.TxtFactor.Text + "')";

if (
this.TxtPlanId.Text != "" &&
this.TxtCompFact.Text != "" &&
this.TxtCompFactDef.Text != "" &&
this.TxtFactor.Text != "")
{

OleDbCommand command = new OleDbCommand(strInsert, datcJobEvaluationPlanData.con);
datcJobEvaluationPlanData.dAdapter4.InsertCommand = command;
//Do the Insert
datcJobEvaluationPlanData.dAdapter4.InsertCommand.ExecuteNonQuery();
MessageBox.Show("New Record Added...");
RefreshData();
TxtPlanId.ReadOnly = true;

}

Thanks

Imran

After passing file name in PrintQueue.AddJob(_,_,) folder is getting locked

gvisgr812-Aug-07 17:53

gvisgr8

12-Aug-07 17:53

Hello ,
I am having a problem in this issue,
I am trying to print a XPS document by passin job name and file path to

PrintQueue.AddJob(jobname,filename,false)

now job is getting queued and printed but the folder where the file is which i am printing is getting locked(i.e I am not able to delete the folder) even if i am deleting the file inside it.

Who am I?
Do you know me.... OMG | :OMG:

How to synchronize between GridView and DataTable?

Michael Sync12-Aug-07 17:42

Michael Sync

12-Aug-07 17:42

Hello,

There are one Editable Gridview in my winform. This GridView is binded with DataTable. After making some changes in GridView, I want to update the DataTable that is binded to GridView.

I have tried with Grid.Update() and DataTable.AcceptChanges();. but it doesn't work.

So, How to synchronize between GridView and DataTable? OR how can I update the DataTable from DataGrid?

Thanks in advance.

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

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