Didn't know that I have to define the columns in the code behind again.
Ofcourse you have to, these are columns of GridView, you has to define colums of DataTable then only you can create a DataRow.
I have a better suggestion.
Stop what you are doing, read a book first which will explain you about databindings with GridView or search and read some article(you'll find many on this site itself). I am sure, you don't have much knowledge about this.
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.
- 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.
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.
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.
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.
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.
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).
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.
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.
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??
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?