XML Includes in C# code - C# Discussion Boards

Re: how to handle exported function from c++ in C# [modified]

stancrm4-Jul-06 23:26

stancrm

4-Jul-06 23:26

Try using IntPtr:

[DllImport("testcpp2.dll"]
private static extern void parseFile(IntPtr pFile);

using(FileStream fStream = new FileStream("test.bin", FileMode.Open))
{
	parseFile(fStream.Handle);
}

and if it still not working, try to write a extra function for bridging between parseFile(FILE* file) and parseFile(string filename).

Something like this:

void parseFileWithFilename(string filename)
{
   // ... use this filename for getting FILE*
}

Then in C# you can give only the filename in string. It is easier.

Re: how to handle exported function from c++ in C#

engsrini5-Jul-06 0:21

engsrini

5-Jul-06 0:21

by Luking @ the funtion name, i concluded that you are trying to parse the file. for that you can write your own funtion in C# right? Lot of samples are there in google.

finding dynamic IP of running client

pawanmishraji4-Jul-06 21:48

pawanmishraji

4-Jul-06 21:48

dear friends,

please send me code to create a program which can display dynamic IP's of all the running client.

regards.

Pawan Mishra
MCA, MCP.NET, MCAD.NET

Re: finding dynamic IP of running client

Guffa5-Jul-06 0:55

Guffa

5-Jul-06 0:55

Is this the same question as in your thread in the .NET Framework board?

---
b { font-weight: normal; }

Generating a Typed DataSet from an XSD-file in VS 2005

anderslundsgard4-Jul-06 21:11

anderslundsgard

4-Jul-06 21:11

How do I create a DataSet from an XSD file. I’ve read about some “Generate DataSet” option in Visual Studio but I cant find it.
Does it exist external tools for this too?

_____________________________

...and justice for all

APe

Re: Generating a Typed DataSet from an XSD-file in VS 2005

DIMPLE_R4-Jul-06 21:44

DIMPLE_R

4-Jul-06 21:44

See if this helps..

http://hacks.oreilly.com/pub/h/5157
http://aspnet.4guysfromrolla.com/articles/020806-1.aspx

Office 2007 Toolbar Ribbon

cecildt4-Jul-06 20:56

cecildt

4-Jul-06 20:56

hi,

Does anybody know where to get C# source code to create the fancy Office 2007 Toolbar Ribbon with the big round button?

XML Includes in C# code

urbane.tiger4-Jul-06 20:50

urbane.tiger

4-Jul-06 20:50

I want to use the <include> XML directive to drag in how to use doumentation in to my code so that it ends up in in the Object Browser and Intellisense. I've had no problems doing that, but there is one thing that concerns me. I put the XML in an existing XML file, that already has XML data that's needed by the designer class. The XML <include> directive requires that I specify a file path, is there some way I can symbolise the file path -ideally I'd like to use the resource name <namespace>.<classname>.Resources.XMLData.

DataGrid to Excel in Windows app.

SysJey4-Jul-06 20:33

SysJey

4-Jul-06 20:33

I have seen the guidelines(Code project - before 2 days) to export the data from datagrid to excel sheet in Web application. How to make up the same operation in windows application.

Jey

Re: DataGrid to Excel in Windows app.

Chetan Ranpariya4-Jul-06 21:11

Chetan Ranpariya

4-Jul-06 21:11

You can use the csv concept.

SqlConnection cn ;

SqlCommand cmd ;

string filename ;

SqlDataReader dr ;

System.Text.StringBuilder sb ;

private void Button1_Click(object sender, System.EventArgs e)

{

cn=newSqlConnection("server=localhost;uid=sa;pwd=;database=northwind");

filename = "products.csv";

cmd = new SqlCommand("select * from products ", cn);

cmd.Connection.Open();

dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);

sb = new System.Text.StringBuilder();

//For field Names

for(int i = 0 ;i< = dr.FieldCount - 1;i++)

{

if( i < (dr.FieldCount - 1) )

{

sb.Append("\t" + dr.GetName(i) + "\t" + ",");

}

else

{

sb.Append("\t" + dr.GetName(i) + "\t" + "\n");

}

}

//For field Values

while( dr.Read())

{

for(int i = 0 ;i<= dr.FieldCount - 1;i++)

{

if( i < (dr.FieldCount - 1) )

{

sb.Append("\t" + dr.GetValue(i) + "\t" + ",");

}

else

{

sb.Append("\t" + dr.GetValue(i) + "\t" + "\n");

}

}

}

dr.Close();

cn.Close();

Response.ContentType = "Application/x-msexcel";

Response.AddHeader ("content-disposition", "attachment; filename=" + filename ) ;

//Write the file directly to the HTTP output stream.

Response.Write(sb.ToString());

Response.End();

}

/****************************************************************************

private void btExport_Click(object sender, EventArgs e)
{
string strTemp = String.Empty;

dst = new DataSet();
dst.Tables.Add("UserTable");
string strConnection = "Data Source=QUEST03;Initial Catalog=UserDatabase;User ID=hari; Password=shriji;";
SqlConnection conn = new SqlConnection(strConnection);
conn.Open();
SqlCommand cmd = new SqlCommand("Select * From UserTable",conn);
SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
System.Text.StringBuilder sb = new System.Text.StringBuilder();
using (StreamWriter sw = new StreamWriter("E:/Hari/Problem_Import_Export/Problem1/test.csv"))
{
for (int i = 0; i <= dr.FieldCount - 1; i++)
{
if (i < (dr.FieldCount - 1))
{
sb.Append("\t" + dr.GetName(i) + "\t" + ",");
strTemp = strTemp + "\t" + dr.GetName(i) + "\t" + ",";
}
else
{
sb.Append("\t" + dr.GetName(i) + "\t" + "\n");
strTemp = strTemp + "\t" + dr.GetName(i) + "\t" + "\n";
}
}
sw.WriteLine(strTemp);

//For field Values
strTemp = String.Empty;
while (dr.Read())
{
for (int i = 0; i <= dr.FieldCount - 1; i++)
{
if (i < (dr.FieldCount - 1))
{
sb.Append("\t" + dr.GetValue(i) + "\t" + ",");
strTemp = strTemp + "\t" + dr.GetValue(i) + "\t" + ",";
}
else
{
sb.Append("\t" + dr.GetValue(i) + "\t" + "\n");
strTemp = strTemp + "\t" + dr.GetValue(i) + "\t" + "\n";
}
}
sw.WriteLine(strTemp);
}
}
dr.Close();
conn.Close();

MessageBox.Show("Data Is Imported Successfully...Test.txt File is Created.");
}

Re: DataGrid to Excel in Windows app.

Azoli5-Jul-06 20:25

Azoli

5-Jul-06 20:25

using System;
using System.IO;
using System.Data;
using System.Windows.Forms;

namespace AzoControls.MyDataExport
{
public class AzoDataExportToXLS
{
private int rowCount = 0;
private int sheetCount = 1;
private System.IO.StreamWriter excelDoc;
const string endExcelXML = "";
const string startExcelXML = "<xml version="">\r\n<workbook "="" +
="" "xmlns="\"urn:schemas-microsoft-com:office:spreadsheet\"\r\n"" xmlns Blush | :O

="\"urn:schemas-microsoft-com:office:office\"\r\n" "xmlns:x="\"urn:schemas-" microsoft-com:office:"="" "excel\"\r\n="" xmlns:ss="\"urn:schemas-microsoft-com:"" "office:spreadsheet\"="">\r\n <styles>\r\n " +
"\r\n " +
"<Alignment ss:Vertical=\"Bottom\"/>\r\n <Borders/>" +
"\r\n <Font/>\r\n <Interior/>\r\n <NumberFormat/>" +
"\r\n <Protection/>\r\n \r\n " +
"\r\n <Font " +
"x:Family=\"Swiss\" ss:Bold=\"1\"/>\r\n \r\n " +
"\r\n <NumberFormat" +
" ss:Format=\"@\"/>\r\n \r\n \r\n <NumberFormat " +
"ss:Format=\"0.00\"/>\r\n \r\n " +
"\r\n <NumberFormat " +
"ss:Format=\"0\"/>\r\n \r\n \r\n <NumberFormat " +
"ss:Format=\"dd/mm/yyyy;@\"/>\r\n \r\n " +
"\r\n ";

private DataTable dtXLS;
private DataRow drXLS;

public AzoDataExportToXLS(DataTable parTableName)
{
//Parameter DataTable Object
this.dtXLS = parTableName;
}

public void ExportToXLS()
{
try
{
string strFileName = "File001";
SaveFileDialog saveDlg = new SaveFileDialog();
saveDlg.InitialDirectory = Path.GetDirectoryName(strFileName);
saveDlg.FileName = Path.GetFileNameWithoutExtension(strFileName);
saveDlg.AddExtension = true;
saveDlg.Filter = "Windows Excel (*.xls)|*.xls";
if (saveDlg.ShowDialog() == DialogResult.OK)
{
try
{
this.exportToExcel(saveDlg.FileName.ToString());
//this.WriteDataToXLS(saveDlg.FileName.ToString());
}
catch (Exception exc)
{
MessageBox.Show(exc.Message);
return;
}
}
}
catch (Exception Ex)
{
MessageBox.Show(Ex.Message.ToString());
}
}
private void exportToExcel(string fileName)
{
excelDoc = new System.IO.StreamWriter(fileName);
excelDoc.Write(startExcelXML);
excelDoc.Write("<worksheet ss:name="\"DataPages"" +="" sheetcount.tostring().trim()="" "\"="">");
excelDoc.Write("");
excelDoc.Write("<row>");

for (int ic = 0; ic <= dtXLS.Columns.Count-1; ic++)
{
excelDoc.Write("<cell ss:styleid="\"BoldColumn\"">");
excelDoc.Write(dtXLS.Columns[ic].Caption.ToString());
excelDoc.Write("");
}
excelDoc.Write("");

for (int x = 0; x <= dtXLS.Rows.Count-1; x++)
{
rowCount++;
drXLS = dtXLS.Rows[x];
//if row > 64000 new page
if (rowCount == 64000)
{
rowCount = 0;
sheetCount++;
excelDoc.Write("

");
excelDoc.Write(" ");
excelDoc.Write("<worksheet ss:name="\"Sheet"" +="" sheetcount="" "\"="">");
excelDoc.Write("");
}
excelDoc.Write("<row>"); //ID=" + rowCount + "

for (int y = 0; y < this.dtXLS.Columns.Count; y++)
{
System.Type cellType;
cellType = drXLS[y].GetType();

switch (cellType.ToString())
{
case "System.String":
string XLSParameter = drXLS[y].ToString();
XLSParameter = XLSParameter.Trim();
XLSParameter = XLSParameter.Replace("&", "&");
XLSParameter = XLSParameter.Replace(">", ">");
XLSParameter = XLSParameter.Replace("<", "<");
excelDoc.Write("<cell ss:styleid="\"StringLiteral\"">" +
"");
excelDoc.Write(XLSParameter);
excelDoc.Write("");
break;
case "System.DateTime":
DateTime XMLDate = (DateTime)drXLS[y];
string XMLDatetoString = ""; //Excel Converted Date
XMLDatetoString = XMLDate.Year.ToString() +
"-" +
(XMLDate.Month < 10 ? "0" +
XMLDate.Month.ToString() : XMLDate.Month.ToString()) +
"-" +
(XMLDate.Day < 10 ? "0" +
XMLDate.Day.ToString() : XMLDate.Day.ToString()) +
"T" +
(XMLDate.Hour < 10 ? "0" +
XMLDate.Hour.ToString() : XMLDate.Hour.ToString()) +
":" +
(XMLDate.Minute < 10 ? "0" +
XMLDate.Minute.ToString() : XMLDate.Minute.ToString()) +
":" +
(XMLDate.Second < 10 ? "0" +
XMLDate.Second.ToString() : XMLDate.Second.ToString()) +
".000";
excelDoc.Write("<cell ss:styleid="\"DateLiteral\"">" +
"");
excelDoc.Write(XMLDatetoString);
excelDoc.Write("");
break;
case "System.Boolean":
excelDoc.Write("<cell ss:styleid="\"StringLiteral\"">" +
"");

excelDoc.Write(drXLS[y].ToString());
excelDoc.Write("");
break;
case "System.Int16":
case "System.Int32":
case "System.Int64":
case "System.Byte":
excelDoc.Write("<cell ss:styleid="\"Integer\"">" +
"");

excelDoc.Write(drXLS[y].ToString());
excelDoc.Write("");
break;
case "System.Decimal":
excelDoc.Write("<cell ss:styleid="\"Decimal\"">" +
"");

excelDoc.Write(drXLS[y].ToString());
excelDoc.Write("");
break;
case "System.Double":
excelDoc.Write("<cell ss:styleid="\"Decimal\"">" +
"");

excelDoc.Write(drXLS[y].ToString());
excelDoc.Write("");
break;
case "System.DBNull":
excelDoc.Write("<cell ss:styleid="\"StringLiteral\"">" +
"");
excelDoc.Write("");
excelDoc.Write("");
break;
default:
throw (new Exception(cellType.ToString() + " not handled."));
}
}
excelDoc.Write("");
}
excelDoc.Write("

");
excelDoc.Write(" ");
excelDoc.Write(endExcelXML);
excelDoc.Close();
}
}
}

grandy

Re: DataGrid to Excel in Windows app.

Azoli5-Jul-06 20:48

Azoli

5-Jul-06 20:48

private void ExportData(string parType)
{
if (parType.ToUpper() == "XLS")
{
//Parse DataTable

AzoControls.MyDataExport.AzoDataExportToXLS ExportXLS = new AzoControls.MyDataExport.AzoDataExportToXLS(table);
ExportXLS.ExportToXLS();
}
}

grandy

Display UI controls in Datagrid cell (Its urget pls)

Kais4U4-Jul-06 20:11

Kais4U

4-Jul-06 20:11

Hi,

I need to display different UI controls based on the row in the same column. for eg.
DataGridCell(row1,col1) should have a combo box,
DataGridCell(row2,col1) should have a Textbox,
DataGridCell(row3,col1) should have a multiline Textbox,
DataGridCell(row4,col1) should have a Date Picker

I can placed the respective controls when ever user select the perticular cell. Now i need the controls to be visible all the time not only on selection.

Can anyone help me out in resolving this problem? I have a customized class which inherits the DataGridTextBoxColumn.

Regards,
Kais

Serialization with different Class-Versions

Tomerland4-Jul-06 20:09

Tomerland

4-Jul-06 20:09

Dear gurus,

I am de/serializing objects with Serializers (e.g. XmlSerializer). It works just fine.

But each time if I add any attribute to my classes which I serialize (let's say I update my class to a new version) , then the appropriate serializer is not able to deserialize my classes. This behaviour is clear to me of course.

But how can I improve this behaviour?

My Idea with deserializing is the following:
1) Extend the class which has to be de/serialized with a version-info-tag
2) Before deserializing, read the version-info first from file
3) Dependent on this version, decide which Version of the class to use for deserialization
4) Read the file (deserialize) now with the right class-version

Can somebody help me with this topic?

Thanks a lot in advance

-- modified at 3:59 Wednesday 5th July, 2006

Debug ActiveX control from C# application [modified]

Maddie from Dartford4-Jul-06 19:58

Maddie from Dartford

4-Jul-06 19:58

Hello,

I am using MFC - ActiveX control in C# based windows application.
I am not able to debug the control with the C# application while it is possible with the MFC applcation.

I want to call a function on buttton click event of windows application.
The function is in ActiveX control.

I have given the path of the exe in control also enabled the Unmanaged debugging in Windows application, but when i start debug it doesn't populate the exe, instead it comes out and ready for debug again.

Is it possible to do so if yes then HOW.

Thanks.

Byee..

Gajesh
Pune(India

-- modified at 8:04 Wednesday 5th July, 2006

How to apply certain commands during installation [modified]

Kamran Younus4-Jul-06 19:32

Kamran Younus

4-Jul-06 19:32

I want to apply certain commands on the asseblies after they will be placed in the GAC during installation.e-g Tlbexp Assembly1.dll or regasm Assembly1.dll.
Currently i am running the Setup from batch file that starts the setup.Now the Setup will install the assemblies on to the GAC and also copies them into the installation path.
But this is not a good pocedure to accomplish the task.
Is there any good alternative?
Regards
Kamran

Kamran

-- modified at 1:34 Wednesday 5th July, 2006

3 Tier Architecture Code

bml36224-Jul-06 19:12

bml3622

4-Jul-06 19:12

I need to code my application in 3 tier.
But i dont have exact idea what to do.
I know the concept well, but dont understand how should i proceed.
Can anyone help me,
it would be better if you can give me some code samples.(ofcource Dummy)

Happy coding

Re: 3 Tier Architecture Code

Praveen Nayak4-Jul-06 22:14

Praveen Nayak

4-Jul-06 22:14

Just googling for it can give you some good links showing the concept. Anyway, try this codeproject article itself. The architecture is all there.

http://www.codeproject.com/csharp/three_tier_architecture.asp

There has to be more to life than just this

Clickety Police

Colin Angus Mackay4-Jul-06 22:20

Colin Angus Mackay

4-Jul-06 22:20

Praveen Nayak wrote:
http://www.codeproject.com/csharp/three_tier_architecture.asp

Scottish Developers events:
* .NET debugging, tracing and instrumentation by Duncan Edwards Jones and Code Coverage in .NET by Craig Murphy
* Developer Day Scotland: are you interested in speaking or attending?
My: Website | Blog

Purpose of boxing and unboxing?

Anthony Potts4-Jul-06 18:14

Anthony Potts

4-Jul-06 18:14

Okay, so I'm very new to C# (and to programming in general for that matter), but I've come across this idea of boxing and unboxing that seems completely odd. In my understanding, it is a shell game of sorts between a referenced type and a value type. It seems to me that this might save in resources, and that it is similar to casting in C, but it is unclear to me. If anyone could give a reason as to why someone would want to use this technique, I would be very grateful.

"If you really want something in this life, you have to work for it. Now, quiet! They're about to announce the lottery numbers..."
- Homer Simpson

Re: Purpose of boxing and unboxing?

Guffa4-Jul-06 19:02

Guffa

4-Jul-06 19:02

You can cast anything to the type Object, and back again. This is frequently used when a method takes parameters that can be any data type. For instance the String.Format method:

string s = string.Format("{0}{1}{2}", "The answer is ", 42, ".");

What really happens here is that the method takes an array of objects:

object[] temp = new object[] {(object)"The answer is ", (object)42, (object)"."};<br />
string s = string.Format("{0}{1}{2}", temp);

The strings already are objects, so they can be casted without boxing. For the integer value, though, a new object is created on the heap and the value is copied into the object.

---
b { font-weight: normal; }

How to register .NET assembly

Duong Tien Nam4-Jul-06 17:30

Duong Tien Nam

4-Jul-06 17:30

I want to register a .NET assembly as a library, so that any program can import it. As easy as you do with "using System;" how can I do that?
Thank for you help.

Re: How to register .NET assembly

S. Senthil Kumar4-Jul-06 19:18

S. Senthil Kumar

4-Jul-06 19:18

You can add the assembly to the GAC[^] (Global Assembly Cache). That way, the clients of the library can all share the same assembly, instead of each one having a copy in its application directory. Have a look at gacutil[^], which is a utility in the SDK that allows you to add/remove assemblies from the GAC.

Regards
Senthil
_____________________________
My Blog | My Articles | WinMacro

multiselection of month calendar

toink toink4-Jul-06 15:59

toink toink

4-Jul-06 15:59

i used the month calendar from the article "ANOTHER MONTH CALENDAR" by Patrick Bohman.

got some questions regarding the control:

1.

the flow of my project is to select a date, give its corresponding datecode(holiday, special holiday or regular day) then select another date.

everytime i choose a another date after the first one, seems i couldn't get the right date selected. i used the DaySelected method. and gets the clicked date by

string[] m_daysSelected = e.Days;

but seems i couldn't get the right days.

how do i do that?

and by the way, i have to remember all the selected dates plus its other corresponding data before i get to save the entire selection of the year.

is that possible?

2.

i have a combo box consisting of different years.
each year has different formatted dates.

how do i copy the formatted dates of the entire year that chosen from the combo box to the recent year?

thanks a lot.

Re: multiselection of month calendar

mav.northwind4-Jul-06 19:46

mav.northwind

4-Jul-06 19:46

Then why don't you ask your question in the comments section of the article itself? That would be the right place.

Regards,
mav

--
Black holes are the places where god divided by 0...

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