Conditional compiling - what ends up in the exe file - C# Discussion Boards

nelsonpaixao1-Oct-08 13:33

1-Oct-08 13:33

I understand your code here,

in datagridview when i am processing null values i use ...=dbnull.value, like you used tablerow.isnull (never used that before d´ont know here) for a table, but like he is not sending data do a database or whatever table, he has to do string X = null, because he is setting a string not a Dgv or a table, string X = dbnull.value or string X = tablerow.isnull wouldn´t work.

You just forgot that or not noticed, its simply i know you know that, i make errors in really simply things all the time, makes me mad Mad | :mad:

nelsonpaixao@yahoo.com.br

trying to help & get help

DataSet Not Saving

Kevin Marois1-Oct-08 8:44

Kevin Marois

1-Oct-08 8:44

I have the dataset bound to textboxes on the form:

txtTitle.DataBindings.Add("Text", oDataSet, "ItemRow.Title");
txtCategory.DataBindings.Add("Text", oDataSet, "ItemRow.Category");
txtAuthor.DataBindings.Add("Text", oDataSet, "ItemRow.Author");
txtCatNo.DataBindings.Add("Text", oDataSet, "ItemRow.Catalogue_No");
txtIsbn.DataBindings.Add("Text", oDataSet, "ItemRow.Isbn");
txtPublisher.DataBindings.Add("Text", oDataSet, "ItemRow.Publisher");

In SaveChanges I then pass the oDataSet variable to this code in my Data Access class:

public bool UpdateDataSet(DataSet oDataSet, string sTableName)
{
	bool bRetVal = true;

	try
	{
		DataRow oRow = oDataSet.Tables[0].Rows[0];
		DataRowState state = oRow.RowState;                \\state = Unchanged

		oAdapter.Update(oDataSet, sTableName);
	}
	catch(SqlException e)
	{
		oException = e;
		bRetVal = false;
	}
	return bRetVal;
}

The DataAdapater is stored as oAdapter on the data access class. When I run this, it doesn't error, but it also doesn't save. Notice that the RowState is unchanged at this point.

I'm not sure what I'm missing here.

Everything makes sense in someone's mind

Re: DataSet Not Saving

Ennis Ray Lynch, Jr.1-Oct-08 9:35

Ennis Ray Lynch, Jr.

1-Oct-08 9:35

The insert and update commands need to be defined as well as verifying that the row state allows for an update. Personally, I do not use the Dataset for updates as it makes such a simple thing complicated.

Need software developed? Offering C# development all over the United States, ERL GLOBAL, Inc is the only call you will have to make.

Happiness in intelligent people is the rarest thing I know. -- Ernest Hemingway

Most of this sig is for Google, not ego.

Re: DataSet Not Saving

Kevin Marois1-Oct-08 10:26

Kevin Marois

1-Oct-08 10:26

Isn't that the purpose of the SqlCommandBuilder?

I have:

public DataSet ExecuteQuery(string sCommand, string sTableName)
{
	bool bError = false;
	DataSet oDataSet = new DataSet();
	DataSet oRetVal = null;

	SqlConnection oConn = GetConnection(false);

	oAdapter = new SqlDataAdapter(sCommand, oConn);
	
	SqlCommandBuilder oBuilder = new SqlCommandBuilder(oAdapter);

	try
	{
		oAdapter.Fill(oDataSet, sTableName);
	}
	catch(SqlException e)
	{
		oException = e;
		bError = true;
	}

	if(! bError)
	{
		oRetVal = oDataSet;
	}

	return oRetVal;
}

Everything makes sense in someone's mind

reporting of proc

NiloofarNoroozi1-Oct-08 8:32

NiloofarNoroozi

1-Oct-08 8:32

hi do you have any example that to report(crystalreport) from proc(sql server 2005)?
thanks a lot

Re: reporting of proc

Ennis Ray Lynch, Jr.1-Oct-08 10:16

Ennis Ray Lynch, Jr.

1-Oct-08 10:16

Yes, I have plenty. However, an example is not necessary. In the report creation wizard you can select ADO.NET as the report source, and then select a stored procedure from the list that appears. (If memory is failing me you may have to select ODBC source and not ADO.NET since I think ADO.NET is for datasets only)

Re: reporting of proc

NiloofarNoroozi1-Oct-08 19:38

NiloofarNoroozi

1-Oct-08 19:38

thanks for your answer
but i have problem about to send parameter to proc
please send me 1 or 2 example
i need it
thank you very much

Conditional compiling - what ends up in the exe file

Tim Holgerson1-Oct-08 7:38

Tim Holgerson

1-Oct-08 7:38

Hi,

I use conditional compiling via to block login dialogs while debuging.

#if DEBUG

       sSqlUserName = "me";
       sPwd = "123456";
       // login here with no dialog
               
#else

       // show login dialog

#endif

This work well and saves me typing my user name and password a thousand times.

However I was wondering if any of the code or strings inside the if #DEBUG make it into the exe when compiling the release version. If they do, I suppose one should make sure to remove the hard coded user name and password prior to releasing the app.

Anyone know how this works?

Thanks.

Tim

Re: Conditional compiling - what ends up in the exe file

User 66581-Oct-08 8:15

User 6658

1-Oct-08 8:15

They won't be compiled into the exe unlesss the DEBUG directive is defined.
You can also examine this using a free tool named .NET Reflector[^].

regards

modified 12-Sep-18 21:01pm.

Re: Conditional compiling - what ends up in the exe file

Ennis Ray Lynch, Jr.1-Oct-08 9:37

Ennis Ray Lynch, Jr.

1-Oct-08 9:37

With the bad habit of debug builds getting passed into production I would make your own preprocessor declaration and then add it to your personal projects build options.

Re: Conditional compiling - what ends up in the exe file

leppie1-Oct-08 20:04

leppie

1-Oct-08 20:04

And let that slip into production rather Roll eyes | :rolleyes:

xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008)
((lambda (x) `((lambda (x) ,x) ',x)) '`((lambda (x) ,x) ',x))

Re: Conditional compiling - what ends up in the exe file

Ennis Ray Lynch, Jr.2-Oct-08 2:27

Ennis Ray Lynch, Jr.

2-Oct-08 2:27

My build settings don't get checked in so ...

Re: Conditional compiling - what ends up in the exe file

leppie2-Oct-08 2:37

leppie

2-Oct-08 2:37

Ennis Ray Lynch, Jr. wrote:
My build settings don't get checked in so ...

Compilation directives are stored in the csproj file. I sure as hell hope you check that in, unless you some sadist bastid that let others create their own project files... Sigh | :sigh:

xacc.ide - now with TabsToSpaces support
IronScheme - 1.0 alpha 4a out now (29 May 2008)
((lambda (x) `((lambda (x) ,x) ',x)) '`((lambda (x) ,x) ',x))

Re: Conditional compiling - what ends up in the exe file

Ennis Ray Lynch, Jr.2-Oct-08 2:56

Ennis Ray Lynch, Jr.

2-Oct-08 2:56

You know me better than I know myself ...

Actually, I keep my local project file writable unless I am adding files and such because I don't like to check in settings like you said.

Creating Access DB Tables

Planker1-Oct-08 6:57

Planker

1-Oct-08 6:57

StringBuilder results = new StringBuilder();

//Create GPO Table
results.Append("Creating GPO Table");
DataTable GPOtable = new DataTable("Group Policy");
DataColumnCollection GPOCol = GPOtable.Columns;
GPOCol.Add("GUID", typeof(string)).Unique = true;
GPOCol.Add("Name", typeof(string));
GPOCol.Add("Domain", typeof(string));
GPOCol.Add("Created", typeof(DateTime));
GPOCol.Add("Modified", typeof(DateTime));
GPOCol.Add("Status", typeof(string));

// Set Primary Key
results.Append("Creating primary key");
GPOtable.PrimaryKey = new DataColumn[] { GPOCol["GUID"] };

//Add table to Dataset
results.Append("Saving new table to Database");
DataSet1.Tables.Add(GPOtable);

I am trying to save this new table to an access database, i have the database connection setup in my app.config and the dataset1 is the dataset to the DB

Is there something I am doing wrong in the code above?

Re: Creating Access DB Tables

Dave Kreskowiak1-Oct-08 11:04

Dave Kreskowiak

1-Oct-08 11:04

Yes, you can't do what you're code is describing. You cannot create tables and columns in a DataSet object and expect it to automatically create the appropriate tables and columns in the database. It doesn't work like that.

You have to generate and execute the appropriate SQL Statements against the database directly to do this. You cannot use a DataSet object to do it for you.

A guide to posting questions on CodeProject[^]

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

preventing system standby/hibernate from within Winforms app

Neophyte301-Oct-08 5:50

Neophyte30

1-Oct-08 5:50

I have developed a winforms app running on Windows XP on a Wyseterm S90, which needs to be running constantly to register cardswipes from a remote device (connected via serial over cat5) and display on a remote monitor (vga over cat5). Everything runs sweetly up until the point that the S90 terminal decides that as it hasn't had a mouse movement or keypress recently, and flips the monitor into standby. So far I have:
Checked the power management and screensaver settings - both set to permanently on Cry | :((

Checked the group policy for the account logged into the device Cry | :((

Added some code to "jiggle" the mouse by a pixel every other second, via both Cursor.Position and OnMouseMove Cry | :((

Nothing seems to persuade the device to stay awake, and I'm almost out of letters to assign to my cunning plans. Can anyone suggest any more alternatives? Is there a SystemEvents event that I can catch and/or trigger to keep the little blighter alive?

Thanks in advance,

Al

Re: preventing system standby/hibernate from within Winforms app

DaveyM691-Oct-08 6:05

DaveyM69

1-Oct-08 6:05

The last two posts on this page[^] may help.

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)

Re: preventing system standby/hibernate from within Winforms app

Neophyte302-Oct-08 0:31

Neophyte30

2-Oct-08 0:31

Thanks for this Dave - it definitely seems to be pointing in the right direction.

list of remote printers

arkiboys1-Oct-08 4:38

arkiboys

1-Oct-08 4:38

I have added shared remote printers to a machine as follows:
printer1 on printserver
printer2 on printserver
printer3 on printserver
...

There is also a local shared printer on this machine.
i.e. printerLocalA

I am not sure why my code does not read the list of the remote printers. It only reads the printers that are local i.e. PrinterLocalA.
This is what I am using and it seems the code is correct but there is something wrong with the way the printers are added I think.
Do you agree?
Any solutions please?

using system.printing;
PrintServer myPrintServer = new PrintServer(@"\\" + txtServerName.Text.Trim());

// List the print server's queues
PrintQueueCollection myPrintQueues = myPrintServer.GetPrintQueues();
foreach (PrintQueue pq in myPrintQueues)
{
comboBox3.Items.Add(pq.Name);
}

Thanks

dataTable save as excel programatically

michael_jhons1-Oct-08 4:26

michael_jhons

1-Oct-08 4:26

hello everybody

i have a function that save my datatable to an excel file:

int columnIndex = 0;
Microsoft.Office.Interop.Excel.ApplicationClass excel = new Microsoft.Office.Interop.Excel.ApplicationClass();
excel.Application.Workbooks.Add(true);
foreach (DataColumn dc in dataSet.Tables[1].Columns)
{
    columnIndex++;
    excel.Cells.ColumnWidth = 25;
    excel.Cells[1, columnIndex] = dc.ColumnName;
}

int rowIndex = 0;
foreach (DataRow dr in dataSet.Tables[1].Rows)
{
    rowIndex++;
    columnIndex = 0;
    foreach (DataColumn dc in dataSet.Tables[1].Columns)
    {
        columnIndex++;
        excel.Cells[rowIndex + 1, columnIndex] = dr[dc.ColumnName];
    }

}


excel.Save(@"C:\SomeName.xls");

what is going on is that a pop up window ask me "if i need to save my excel sheet', if i agree both files are saved one in c:/someName.xls and another for the pop up window. i don't want the pop up to be displayed i just need to save programatically my datatable.
i'm new in excel things please any help

kind regards

Re: dataTable save as excel programatically

Wendelius1-Oct-08 4:37

Wendelius

1-Oct-08 4:37

If I remember correctly, you must set the Saved property of a workbook to true. Save method doesn't automatically mark the workbook as saved.

The need to optimize rises from a bad design

Re: dataTable save as excel programatically

michael_jhons1-Oct-08 5:04

michael_jhons

1-Oct-08 5:04

dear Mika,
thank you for your answer
i aklready added to my code :

excel.ThisWorkbook.Saved = true;

it gave me an error "0x800A03EC"...get.thisWorkbooks()...

please could you help me how to set this property to true.

best regards

Re: dataTable save as excel programatically

michael_jhons1-Oct-08 5:23

michael_jhons

1-Oct-08 5:23

i'm sorry it was ActiveWorkbook.Saved not thisWorkbook.saved, now it's working fine thank you for your advise

Re: dataTable save as excel programatically

Wendelius2-Oct-08 4:19

Wendelius

2-Oct-08 4:19

No problem, glad you got it solved Smile | :)

The need to optimize rises from a bad design

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