Application Error help plz.... - C# Discussion Boards

Re: How to insert data into a GridView from the textboxes

Nopo19-Oct-09 22:16

Nopo

19-Oct-09 22:16

Thanks a lot. For more info I'll acquire in ASP.Net forum.

SSIS

Iain Wiseman19-Oct-09 20:37

Iain Wiseman

19-Oct-09 20:37

Hi all,

Hope this is in the correct forum. I have an issue with some work I am involved in. We have a flat file we are loading into an MSSQL database which is failing on the insert because the original flat file contains suspect data. Invalid dates or values etc. We are using SSIS to load this data. Can someone tell me if it is possible to exception these records easily.

requirements are
- to identify the number of records with the problem
- to identify these records
- to manage the issues which error

I am a project manager and do not want the wool pulled over my eyes. I am familar with C# and SQL server but have only seen SSIS over a shoulder of a developer.

I believe this would be a simple change and would be a matter of minutes to resolve. I am currently being led to believe it is hard.

Thanks all

Re: SSIS

J4amieC19-Oct-09 21:48

J4amieC

19-Oct-09 21:48

Its not really the right forum, this is for question to do with C# coding.

Happy to answer your question though.

Iain Wiseman wrote:
I believe this would be a simple change and would be a matter of minutes to resolve

NOTHING takes minutes to resolve - you should know that as a PM. Development, testing, deployment, bugfixing - a time estimate should take all of this (and more) into account.

Anything to do with SSIS is a royal PITA, nothing is quick and easy.

My best suggestion for this problem is to bulk load your text file into an empty table, and do the data clensing thereafter. All this can be achived easily with SSIS, but certainly not in a matter of minutes.

Re: SSIS

Iain Wiseman19-Oct-09 22:15

Iain Wiseman

19-Oct-09 22:15

Hi,

Thanks for replying. So you are saying that you cannot ignore errors easily in SSIS and count them. I C++ or java or C# this would be a try, carch cout which is a matter of minutes. I had hoped that microsoft would have made this easier.

Iain

Re: SSIS

J4amieC19-Oct-09 22:33

J4amieC

19-Oct-09 22:33

Iain Wiseman wrote:
Thanks for replying. So you are saying that you cannot ignore errors easily in SSIS and count them

Not knowing how your SSIS package is constructed makes answering this harder.

For a Data Flow task (which is the most likely thing you're using), you can often pipe errored rows to a separate file.

Its still not "minutes" work though Wink | ;)

Re: SSIS

Mycroft Holmes19-Oct-09 22:50

Mycroft Holmes

19-Oct-09 22:50

Jamie is correct, this will be a PITA to accomplish in SSIS. Anything that does the transform is bloody difficult, trapping the error rows would be a nightmare. SSIS and Biztalk are an attempt to dumb down the ETL layer so power users can do it - they FAILED.

I load my data into a table of varchar columns, the bulk copy does not care what the data is like then. I then use a stored proc to do the transorms. It is MUCH easier to manipulate the data in TSQL or C# than in SSIS.

Re: SSIS

Iain Wiseman20-Oct-09 0:14

Iain Wiseman

20-Oct-09 0:14

Thanks all,

I come from an open source background and want to treat my colleagues who use microsoft fairly. All I want is the number of records in error and possible which they are. I assume that once you have a package to load them theat error reporting was easy. Reading this SSIS does not provide this easily. With oracle PLSQL this would simply be looking at a return code and doing something. I will ask the developer how to proceed.

Application Error help plz....

JollyMansArt19-Oct-09 19:50

JollyMansArt

19-Oct-09 19:50

This works on the development machine but after installing on another workstation the application errors.

Please help/

See the end of this message for details on invoking 
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.IndexOutOfRangeException: Index was outside the bounds of the array.
   at PeerAssistLoader.StandardProcedures.NET_AuthenticatedMailSend(String mailFrom, String[] mailTo, String[] mailCC, String Subject, String MessageBody, String smtpHost, Int32 smtpPort, String smtpNETAuthUser, String smtpNETAuthPassword)
   at PeerAssistLoader.frmConfigurationMgr.SendEmail(String AlertType, String Subject, String MessageBody)
   at PeerAssistLoader.frmConfigurationMgr.btnUpdateAssistUsers_Click(Object sender, EventArgs e)
   at System.Windows.Forms.Control.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ButtonBase.WndProc(Message& m)
   at System.Windows.Forms.Button.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v2.0.50727/mscorlib.dll
----------------------------------------
PeerAssistLoader
    Assembly Version: 1.16.31.434
    Win32 Version: 1.9.23.417
    CodeBase: file://CALAPP/PeerAssistLoader/PeerAssistLoader.exe
----------------------------------------
System.Windows.Forms
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Configuration
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Data
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_64/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
Microsoft.ReportViewer.WinForms
    Assembly Version: 9.0.0.0
    Win32 Version: 9.0.30729.1
    CodeBase: file://CALAPP/PeerAssistLoader/Microsoft.ReportViewer.WinForms.DLL
----------------------------------------
Microsoft.ReportViewer.Common
    Assembly Version: 9.0.0.0
    Win32 Version: 9.0.30729.1
    CodeBase: file://CALAPP/PeerAssistLoader/Microsoft.ReportViewer.Common.DLL
----------------------------------------
System.Data.DataSetExtensions
    Assembly Version: 3.5.0.0
    Win32 Version: 3.5.30729.4926 built by: NetFXw7
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Data.DataSetExtensions/3.5.0.0__b77a5c561934e089/System.Data.DataSetExtensions.dll
----------------------------------------
System.Core
    Assembly Version: 3.5.0.0
    Win32 Version: 3.5.30729.4926 built by: NetFXw7
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Core/3.5.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
System.Transactions
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_64/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
System.EnterpriseServices
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_64/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------
System.DirectoryServices
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.DirectoryServices/2.0.0.0__b03f5f7f11d50a3a/System.DirectoryServices.dll
----------------------------------------
System.Web.Services
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Web.Services/2.0.0.0__b03f5f7f11d50a3a/System.Web.Services.dll
----------------------------------------
System.Web
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_64/System.Web/2.0.0.0__b03f5f7f11d50a3a/System.Web.dll
----------------------------------------
Microsoft.ReportViewer.ProcessingObjectModel
    Assembly Version: 9.0.0.0
    Win32 Version: 9.0.21022.8
    CodeBase: file://CALAPP/PeerAssistLoader/Microsoft.ReportViewer.ProcessingObjectModel.DLL
----------------------------------------
expression_host_b75c906bcd1143d69b962f2790f3bfac
    Assembly Version: 10.8.30729.1
    Win32 Version: 9.0.30729.1
    CodeBase: file://CALAPP/PeerAssistLoader/Microsoft.ReportViewer.Common.dll
----------------------------------------
Microsoft.VisualBasic
    Assembly Version: 8.0.0.0
    Win32 Version: 8.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualBasic/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
    <system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

Re: Application Error help plz....

JollyMansArt19-Oct-09 20:07

JollyMansArt

19-Oct-09 20:07

Figured it out I was being dumb. I forgot to account for an array not being populated yet.

how to do Right Alignment?

muhammad_umair19-Oct-09 19:48

muhammad_umair

19-Oct-09 19:48

Hi, i am making an application in which the label keeps scrolling up. The problem i have is i want to do right alignment so that i get "." in a sequence like

Basket...........
ball................
keyboard.......

can anyone help me with this please!!

i have tried this, but it isn't working for me,

for (int u = textBox1.Length; u = 40 ; u++)
{
strDotsBuilder.Append(".");
}

Re: how to do Right Alignment? [modified]

Calla19-Oct-09 20:40

Calla

19-Oct-09 20:40

You should check your for loop again.
int u = textBox1.Length; u = 40
should probably be
int u = textBox1.Length; u < 40

[EDIT]
Actually, your code shouldn't even compile. Did you do a typo here on CP?
[/EDIT]

modified on Tuesday, October 20, 2009 2:57 AM

Re: how to do Right Alignment?

Luc Pattyn20-Oct-09 2:01

Luc Pattyn

20-Oct-09 2:01

The only way I know to do that successfully is by selecting a monospaced font such as "Courier New", then append filler characters (for which string.PadRight is useful).

Smile | :)

Luc Pattyn

I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages

Local announcement (Antwerp region): Lange Wapper? 59.24% waren verstandig genoeg om NEEN te stemmen; bye bye viaduct.

Hiding content in an email message - Pls help

nirmalsat19-Oct-09 19:09

nirmalsat

19-Oct-09 19:09

Hi,
I am currrently workin on something where in i would like to hide some content in an email which i would retrieve later after the mail has been sent . I would need to get this hidden content at the recieving end.
Could anyone help me out with this.. I am using c# with framework 3.5 to create the email message.

Thanks in advance

Re: Hiding content in an email message - Pls help

Christian Graus19-Oct-09 19:28

Christian Graus

19-Oct-09 19:28

Pretty much impossible. Unless you hide it in an image or something, some sort of attached file that needs a third party program to extract the info.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Re: Hiding content in an email message - Pls help

carlecomm20-Oct-09 21:07

carlecomm

20-Oct-09 21:07

Hi,

I think you can use a hidden img and set its src to some page that you have.

When the email is opened, the action can transfer the data to your web page.

In that page you can deal with the data and save it anywhere you want.

modified 27-May-14 5:27am.

[Solved]Customize calendar control

Ishqalways19-Oct-09 18:54

Ishqalways

19-Oct-09 18:54

Hi..

i would like to add a calendar in my windows application form.
i have added some dates as special in a table.
i would like to display that dates as bold or in different color when that particular month is selected.
can any one help me to customize the calendar??

should i need to create a user control???
If yes, which property i have to set to display the dates as bold??

thanks in advance

Re: Customize calendar control

Christian Graus19-Oct-09 18:58

Christian Graus

19-Oct-09 18:58

Ishqalways wrote:
should i need to create a user control???

I expect so.

Ishqalways wrote:
If yes, which property i have to set to display the dates as bold??

The Bold property on the label class would be a good guess.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Re: Customize calendar control

Russ-T19-Oct-09 19:52

Russ-T

19-Oct-09 19:52

Ishqalways wrote:
i would like to display that dates as bold or in different color when that particular month is selected.
can any one help me to customize the calendar??

The standard MonthCalendar control has a property called BoldedDates. Just pass it an array of the DateTime's you need in bold and it'll take care of the rest.

Here's a link with some more info:
http://msdn.microsoft.com/en-us/library/system.windows.forms.monthcalendar.boldeddates.aspx[^]

Hope that helps! Smile | :)

How to set the image field data to some cell of Excel?

mctramp16819-Oct-09 15:25

mctramp168

19-Oct-09 15:25

There is a image field in the table, and I save the picture into this field, now I use below code, how to set the value of the Tables[0].Rows[0][0] to one cell of Excel sheet?

string strCon = "Data Source=0;Initial Catalog=dbtest;Persist Security Info=True;User ID=sa;Password=ok";
SqlDataAdapter m_da = new SqlDataAdapter("select fa from G_Control", strCon);
DataSet ds = new DataSet();
m_da.Fill(ds);

Thanks in advance!

Re: How to set the image field data to some cell of Excel?

mctramp16820-Oct-09 14:06

mctramp168

20-Oct-09 14:06

who can help me on it ?many thanks!

SharePoint Search in Document

W4Rl0CK4719-Oct-09 13:56

W4Rl0CK47

19-Oct-09 13:56

Hi,

Can anyone advise me on how to search within a SharePoint document?

I've seen several examples of how to use a keyword or SQL search but having tried the code out, I only seem to be able to match against metadata such as the document's title, and various columns, such as keywords (of course). I thought that SharePoint MOSS 2007 would allow me to search the content of a document if I wished. Am I mistaken? Can anyone suggest a way of searching within a SharePoint document?

Re: SharePoint Search in Document

Not Active19-Oct-09 14:32

Not Active

19-Oct-09 14:32

Bug Me Not wrote:
Can anyone suggest a way of searching within a SharePoint document?

The first thing I'd do is search within the SharePoint forum

only two letters away from being an asset

code behind

auriva19-Oct-09 13:45

auriva

19-Oct-09 13:45

Hi i m new in C#.i want to know how to write code behind the next and continue buttons.pls reply me soon.coz code project.com is a platform that guides everyone.
regards Smile | :)

Re: code behind

Christian Graus19-Oct-09 14:15

Christian Graus

19-Oct-09 14:15

We love to help people, but sometimes, it's not really possible. The term 'code behind' relates to ASP.NET, and this is not the ASP.NET forum. Are you writing a web site. What continue and next buttons are you talking about ? Are you using a specific control that includes these buttons ?

If you don't know that we need this sort of info, then you probably would do better to buy a book and read it, but odds are good you're at work, in a job you're incapable of doing, and posting here because you want us to fill the gaps for you. We can't do that, based on the info you provided.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Re: code behind

EliottA19-Oct-09 14:30

EliottA

19-Oct-09 14:30

+5 for saying 'odd's are', we don't need another thread like in the VB forum...

Check out the CodeProject forum Guidelines[^]
The original soapbox 1.0 is back![^]

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