Problems with no rows returning from Query and C#

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Ado
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - sqldataadapter, datacolumn rowstate Hello All, I use a dataadapter to fill a datatable from a sql server table. The datatable contains one column ROW_ID which is set as the PrimaryKey. The sql server table contains a single row and no new rows are added between refreshes. I refresh the datatable every 3 minutes using the dataadapter.fill method. The primary key prevents the same record being added but I'm confused as to why the fill method triggers the DataRowChangeEventArgs event with an action of type change and the datarow rowstate is set to modified. ? Thanks in advance hharry Tag: Problems with no rows returning from Query and C# Tag: 136825
  - 2
    - ASP .NET - Crystal Report Error Hi, I got the following error when I set the report source of the CrystalReportViewer, Can anyone please help me. Thanks...doug. Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim myreport As New rpt1() CrystalReportViewer1.ReportSource = myreport <== cause error End Class Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: CrystalDecisions.CrystalReports.Engine.FormattingException: Get page or get totaller failed Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [FormattingException: Get page or get totaller failed] .L(String , EngineExceptionErrorID ) .H(String , Int32 ) CrystalDecisions.CrystalReports.Engine.FormatEngine.GetPage(PageRequestConte xt reqContext) CrystalDecisions.ReportSource.LocalReportSourceBase.GetPage(PageRequestConte xt pageReqContext) CrystalDecisions.Web.ReportAgent.{(Boolean C) CrystalDecisions.Web.CrystalReportViewer.OnPreRender(EventArgs e) System.Web.UI.Control.PreRenderRecursiveInternal() System.Web.UI.Control.PreRenderRecursiveInternal() System.Web.UI.Control.PreRenderRecursiveInternal() System.Web.UI.Page.ProcessRequestMain() Tag: Problems with no rows returning from Query and C# Tag: 136811
  - 3
    - Best practice mapping sql-tables to .net objects I am quite new in programming an I have to develop an application (Project-Management-Software) with Visual Studio .NET 2005 and SQL Server 2005 (ADO.NET). My problem is how to map the sql-server table to the .NET Object/class! Does it make sense to use typed datasets or is it better to create a class with a variable (property) for each column of the table. Who has any experience in such affairs? Perhaps there is a sample application available on the web ... (database application - windows forms) Thanks aaapaul Tag: Problems with no rows returning from Query and C# Tag: 136807
  - 4
    - How to insert row in typed dataset I create a typed dataset by drag'n'drop in VS2005 (VB). I can use FillBy or GetDataBy methods to retrieve the record. The code is as follows: dataTable = tableAdapter.GetDataByCode(KeyFieldValue) MtrUnitBindingSource.DataSource = dataTable 'user edits the record 'press ok button to save MtrUnitBindingSource.EndEdit() tableAdapter.Update(dataTable) ==> it works perfectly in find/edit/update mode. Question: 1. I find difficulty in New/Insert mode. How to add a new row and do the insert to the database? 2. If in the view mode (only user views the record), how to set datatable to readonly? Benson VB2005 Tag: Problems with no rows returning from Query and C# Tag: 136806
  - 5
    - Recordset to DataTable Hi All, I am having the strangest and most frustrating time trying to load a recordset into a data table more than once. For some reason, when I execute the following code, the first messagebox displays a record count of 2 and a second call to it displays a count of 0. Why the inconsistent result. The recordset seems to be open and I even perform a MoveFirst, etc. Nothing works. Should it not consistently return a record count of 2 since I am executing the same code twice. The code is extremly simple, but for some reason, it seems as if the recordset object itself becomes invalid after the .Fill operation is complete. The only way I can find this is to perform my BuildDataSource (real world scenario involves connecting to a database, etc.) function which simply creates and returns an ADODB recordset. Any idea or help. Note: I reference the ADODB 2.7 InterOp library installed with VS 2005. Are there any specifications as to what the cursorlocation, cursor type, or connection open parameters. I've tried many combinations. Dim DataSource As ADODB.Recordset Dim DataTable As Data.DataTable DataSource = BuildDataSource() 'Builds test recordset with 2 records. DataTable = RecordsetToDataTable(DataSource) MessageBox.Show(DataTable.Rows.Count) ' Displays 2. Correct. DataTable = RecordsetToDataTable(DataSource) MessageBox.Show(DataTable.Rows.Count) ' Displays 0. Incorrect Public Function RecordsetToDataTable(ByVal recordset As ADODB.Recordset) As Data.DataTable Dim OleDbDataAdapter As Data.OleDb.OleDbDataAdapter Dim DataTable As Data.DataTable OleDbDataAdapter = New OleDb.OleDbDataAdapter DataTable = New Data.DataTable("Employees") OleDbDataAdapter.Fill(DataTable, recordset) Return DataTable End Function Public Function BuildDataSource() As ADODB.Recordset Dim NewDataSource As ADODB.Recordset NewDataSource = New ADODB.Recordset NewDataSource.Fields.Append("FirstName", ADODB.DataTypeEnum.adVariant, 100, ADODB.FieldAttributeEnum.adFldIsNullable NewDataSource.Fields.Append("LastName", ADODB.DataTypeEnum.adVariant, 100, ADODB.FieldAttributeEnum.adFldIsNullable NewDataSource.CursorLocation = ADODB.CursorLocationEnum.adUseClient NewDataSource.CursorType = ADODB.CursorTypeEnum.adOpenDynamic NewDataSource.Open(CursorType:=ADODB.CursorTypeEnum.adOpenStatic,LockType:=ADODB.LockTypeEnum.adLockOptimistic) NewDataSource.AddNew() NewDataSource.Fields("FirstName").Value = "Uncle" NewDataSource.Fields("LastName").Value = "Bob" NewDataSource.Update() NewDataSource.AddNew() NewDataSource.Fields("FirstName").Value = "Aunty" NewDataSource.Fields("LastName").Value = "Jane" NewDataSource.Update() Return NewDataSource End Function Tag: Problems with no rows returning from Query and C# Tag: 136799
  - 6
    - Update rows in dataset Hi I am a asp.net 2.0 newbie and I was thinking how to update rows in a dataset? How to find rows and update these rows manually? thanks E Tag: Problems with no rows returning from Query and C# Tag: 136793
  - 7
    - MI5 Persecution: Surveillance methods 5/8/95 (5787) From: Pamela Willoughby <pjw31@willouby.demon.co.uk> Newsgroups: uk.misc Date: Sat, 05 Aug 1995 18:08:32 GMT Organization: Myorganisation Lines: 15 Message-ID: <142297143wnr@willouby.demon.co.uk> >Hmmm, strange eh. >I mentioned all this goings on to my boyfriend, who works for the >British intelligence service, and he assures me this sort of thing >never goes on.. not ever...honest. >Though he said the name was familiar... it does go on, although it's an open question who does it. Some time ago there were press reports of an Army intelligence person called Jones who claimed Diana and Hewitt had been photographed in a compromising position... he said he'd been doing this as part of an Army unit which had previously operated in Northern Ireland. Then Hewitt said he'd been told the same thing by some Army people, and that they were threatening to release the tapes unless they curtailed their liaison... as per usual everyone denied everything, painted Jones as the "Jones twins" - not very original in how they deal with their perceived enemies, are they? You have to wonder how they manage to achieve this sort of surveillance though. Audio you can understand, it's possible to put a microphone through the wall, and apparently there exist devices which will retrieve sound from a laser beam bounced off a window - sounds sci-fi, but there's a well known surveillance electronics company in London which sells these things. But how would you get video out of a room, unless you had actual physical access in order to plant a device for pickup? We're not talking about looking in from afar, but an actual device within the room. You could either drill through the wall and shove a pickup through; or you could supply a trojan device with a hidden pickup inside; but most likely, you would have to physically break into your target room to plant a camera. That's not an infeasible option; all it means is having your target(s) watched to make sure they're not in the vicinity, then you negotiate any locks on the property and find a suitable receptacle for your device. The next question is how they defeat the usual methods of counter- surveillance. We had private detectives carry out a "sweep" of every room and the telephone line. They found nothing. That indicates at least four possibilities that I can think of; (this is all guesswork BTW, and probably fanciful guesswork at that!) 1) no bugs (pull the other one) 2) radio-transmitting devices which can be controlled from an external source, ie you can instruct them to switch off when you detect a counter-surveillance sweep taking place 3) hard-wired devices; probe microphones or whatever they're called, things you poke through the wall 4) passive surveillance devices; so you bounce laser or radio waves off a suitable reflecting surface (again, sounds far-fetched but such things may apparently exist). 5) there is a fifth possibility, that the PI's didn't detect an actual transmitting device; there are technologies specifically designed to avoid detection, eg frequency hopping and suchlike. But how much sophistication could you build in to a device which would have to be small enough to be physically concealable? I guess the real question is to find out who is ultimately behind these "goings on". And if the "great and good" (or the better known, at any rate) can't protect themselves, what hope is there for the rest of us? 5787 -- Posted via a free Usenet account from http://www.teranews.com Tag: Problems with no rows returning from Query and C# Tag: 136783
  - 8
    - MI5 Persecution: But why? 2/8/95 (4882) >Very unstructured, no proof whatsoever. So why should anyone >take it seriously? If I said to you, "my next door neighbour eats >babies", how much credibility would you attach to that? Well, cos it's true. I was hoping that someone "in the know" would appear and make some self-revealing comments, but that hasn't happened. Everyone's keeping quiet. What a pity. >>This is an agglomeration of articles and replies previously >>posted to Usenet, so it's a bit hard to read. This posting >>describes a campaign of character assassination initiated >Who's character is being assassinated? It isn't clear from the post. >Are we talking about Grenville Janner? I thought he was a spook >himself? He's certainly able to hold his own on the issue you cite. Mine, mainly. The reason for putting that episode at the top of the posting is that they tried to kill two birds with one stone at the Beck trial - they simultaneously put words into the mouth of their invented "witness" to smear Janner, and repeated exactly, word-for-word, stuff which had been said by and about me. That was the only occasion (the only one recognizable to me, anyway) when they went after another target at the same time. And it's quite lucky they did that - because it could give some pointers to who they might be. Presumably there are people still around who were involved in that trial, and know what happened. Beck might be dead, but the "witness" would still be around, as would Beck's solicitor. >>by a group of people or agency within the UK. Although >>they have never presented their identity, you can draw >>your own conclusions on that point. There aren't many >>people with the technical resources and contacts in >>society to make feasible the sort of deliberate attack >>on an individual which is described in this article. > >There aren't _any_ as far as I am aware. I'm afraid there are. >>The most disturbing part of the whole episode is the >>participation of British institutions and their members, fully >>comprehending what they do, in what is an act of attempted >>murder against a British citizen. > >The whole society, in fact. From the top to the bottom. They >wouldn't be trying to tell you to kill yourself by any chance, >would they? You got it. I'm a popular guy. >>After the trial Janner said that "now he knew what it felt like >>to be a victim of Beck's"; but, it wasn't Beck who set up the >>attempted character assassination on Janner; the fact that they >>took a side-swipe with their verbatim repetition shows >>where the real source is to be found. > >The newspapers? Well, your guess is as good as mine. But what newspaper would send a team after someone for five years? I don't think so, somehow. Of course they could, but it wouldn't be in their commercial interest. You'd have to look at a corporate entity which would indulge in activity of this type, and the nature of the contacts they have narrows down the search. >>The goons behind the molestation are lower than the paedophiles >>they use to convey their propaganda - they use the same >>strategy of covert abuse, but there is nobody to check their >>actions, or to bring these criminals to justice. > >Ummm.. Janner is a Barrister, a journalist who writes on a wide >variety of issues, and a long-standing Labour MP. If he's unjustly >smeared, he's more that capable of setting the record straight. Janner blamed Beck for the invention. He didn't say anything about it having any other origin. Even had he suspected any other source, he could hardly have pointed the finger without some evidence. >You say that the media is making similar allegations about you in >relation to this issue? So, you're accused of child abuse, amd >the allegation was reported in the media, I assume. I've been accused of many things although that wasn't one of them. Most of them have been yelled in my face by people on the street in London at some time or other. Bit difficult to misinterpret when that happens. >What exact;y are they saying about you? (Respond here please. I'm >leaving the UK tomorrow, so I can't read e-mail.) It changes with time. Every so often, they sing a new song; so at one point the allegation was homosexuality, at another is was low intelligence, then it degenerated into sexual abuse. <snip> >>They invaded my home with their bugs, they repeated what I >>was saying in the privacy of my home, and they laughed that it >>was "so funny", that I was impotent and could not even communicate >>what was going on. Who did this? Our friends on BBC television, >>our friends in ITN, last but not least our friends in Capital >>Radio in London and on Radio 1. > >How do you know this? Just from what you hear on the radio? I can't remember if this was mentioned in the "regular" posting, but on a few occasions they set me up with people nearby to talk about me, or more correctly, to talk about somebody who (in their minds) "resembles" me, with actually naming me. One such occasion was a coach trip to Europe in June 1992. The "set up" comprised a guy talking to a vacant giggling female about "this bloke", who was never named. Apparently "they" (also never named) "found somebody from his school", "they" "got" him at his house and at a neighbours, and at a B&B where their target was for one night. Apart from that, yeah, from "what I hear on the radio". And from what I see on TV. (I wouldn't be doing my job as a mentally ill person properly if the TV and radio weren't talking to me, now, would I?) >>Oh yeah, I can see it now. All of them banding together, in a united >>effort against one man. So ITN, the BBC, and Capital all decide to sit >>round the table and they come up with idea of breaking into someones >>house, putting bugs everywhere, listening in to his conversation, and >>shoving it out on the news everyday. > >But why would they do this? What possible reason would they have? But why get at anybody? Victimisation is the pastime practised against other people; as the scorpion said to the frog, "it's in my nature". >Are you aware that what you describe is also a common symptom of people >who are suffering from a psychiatric illness? Have you been to your >doctor and told him about this? Did he prescribe any medication? Have >you been taking it, or have you stopped? Yes, Yes, and Yes respectively. Still taking it. Doing quite well actually. >>This someone has nothing to do with >>politics, or business, or entertainment, just an ordinary Joe Bloggs who >>seems to be extremely paranoid. > >Usually a clinical symptom rather than proof of a conspiracy in such >matters. >>How did they do this? I'll give you an example. About a year ago, >>I was listening to Chris Tarrant (Capital Radio DJ among other >>pursuits) on his radio morning show, when he said, talking about >>someone he didn't identify, "you know this bloke? he says we're >>trying to kill him. We should be done for attempted manslaughter" >>which mirrored something I had said a day or two before. >>Now that got broadcast to the whole of London - if any recordings >>are kept of the shows then it'll be there. > >And this is supposed to mean... what? Chris Tarrant is in on this plot >to kill you? It sure sounds like a joke to me. When you start to get >ill, the mind often makes connections that seem logical and lucid to >you, but do not to the rest of the world. This is one of those connections. >They are usually known as delusions. This is the problem, and there doesn't seem to be any way around it. If a clearly sane person reported this persecution, you might believe him, but probably you'd tell him to go see a doctor to "verify his sanity". If someone with the illness of which you could argue these things to be symptomatic says these things, again, you might believe him, but it would be unlikely - the easiest route is the one you are taking in the above paragraph. The only way I can convince you of what I am saying is by giving precise details of what, when, how - and for most of that stuff is based solely on memory. To prove it would require an admission from somebody, or else hard proof in the shape of physical evidence such as tape recordings. Of course, I don't have that. >The idea of a "pattern", and the notion that if anyone could look >through your eyes they would see the same thing is very indicative of >the onset of a psychiatric illness. Schizophrenia and manic depression >have similar symptoms. I'm not trying to be disrespectful here. >This may be an illness and it can be managed by the use of medication. >If it _isn't_ treated, it can lead to terrible tragic consequences. I'm quite aware what the symptoms would be, and that the reality corresponds to those symptoms. But if anything, that is an argument which could convince you of the truth of what I'm saying. If they deliberately set out to simulate the symptoms of schizophrenia - in other words, if they know through observation that their target is either suffering from the illness, or is on the borderline and could be pushed in with an appropriate stimulus, then they can feel safe in what they do, since once you are registered as suffering from the illness, people will assign less credibility to assertions that persecution is based in reality. That this can happen, and people collude by silence, is absolutely horrifying. It is all the more horrifying that it can happen in a country such as Britain which has no history of repression. Perhaps its happening in the UK is due to the arrogant assumption of moral superiority on the part of those in the media and others involved - we won the last war and we can keep harping on about German and Japanese war crimes, so we can do whatever we like and we'll be right, up to and including destroying the lives of our citizens (as long as we're not caught doing it). >>That is the level it's at - basically they show they're listening >>to what you're saying at home, they show they're listening to you >>listening to them > >But why? And why you? Do you realize how much it would cost to keep >one person under continuous surveillance for five years? Think about >all the man/hours. Say they _just_ allocated a two man team and a >supervisor. OK., Supervisor's salary, say, £30,000 a year. Two men, >£20,000 a year each. But they'd need to work in shifts -- so it would >be six men at £20,000 (which with on-costs would work out at more like >£30,000 to the employer.) > >So, we're talking £30,000 x 6. £180,000. plus say, £40,000 for the >supervisor. £220,000. Then you've got the hardware involved. And >any transcription that needs doing. You don't think the 'Big Boss' >would listen to hours and hours of tapes, do you. > >So, all in all, you couldn't actually do the job for much less than >a quarter million a year. Over five years. What are you doing that makes >it worth the while of the state to spend over one and a quarter million >on you? Those are pretty much the sort of calculations that went through my head once I stopped to consider what it must be costing them to run this little operation. The partial answer is, there have been periods when the intensity has been greater, and times when little has happened. In fact, for much of 1993 and the first half of 1994, very little happened. Although I don't think that was for reasons of money - if they can tap into the taxpayer they're not going to be short of resources, are they? The more complete answer is in the enormity of what they're doing. When countries kill their own people, as a rule, they get found out and all hell breaks loose. This isn't some para shooting Irish teenagers in the back. This is something which permeates English society, which they are ALL responsible for, and which they cannot escape responsibility for. Relative to the cost to British pride of seeing their country humiliated for the persecution of their own defenceless citizens, isn't is worth the cost of four or five people to try to bring things to a close in the manner they would wish? To the government a million or two is quite honestly nothing - if they can convince themselves of the necessity of what they're doing, money is not going to be the limiting factor. >>What possible reason? I guess because they think it's amusing to do >>so. > >What? Spend a quarter mil. a year to amuse themselves? And why not >change every now and again? Why keep watching you? (Unless you _are_ >doing something, and I don't think you are, though you may have some >deep, dark secret in your past.) See the above. ============================================================= >>I'm going to try to rationalise what you're telling us. I can think of three >>possible explanations for what you are experiencing. >>Another possibility is that you are developing some kind of paranoia. There's >>no stigma attached to this; we're all paranoid to some extent, although >>perhaps not to the extent that a doctor would call us paranoid. I think >>paranoia is quite a straightforward explanation here - you really do believe >>that all these things are aimed at you; you see people everywhere trying to >>get at you. Logic suggests that this cannot really be the case. >I think the evidence leans towards this explanation myself. Why not >try soc.support.depression and see what some of the people there have >to say about this? Just to get some more perspective on your perspective, >so to speak? Sure, it "leans" towards it. But please at least admit there is a POSSIBILITY of it being very real. And once you've done that, can you come up with some thoughts on methods of proof? I may be missing something in my assessment - there may be a way of proving it, in the face of non- cooperation from the "players". 4882 -- Posted via a free Usenet account from http://www.teranews.com Tag: Problems with no rows returning from Query and C# Tag: 136781
  - 9
    - MI5 Persecution: Toronto Freenet supports free speech (357) Despite an orchestrated campaign of attempted censorship by UK-resident newsgroup readers, TFN did not bow to demands for a suppression of freedom of speech. TFN general policy on the matter is as follows; Draft Policy on Account Deactivations due to News Group Postings ================================================================ News group postings occasionally take the form of a message which goes against the "topic" of the conference. For example, a derogatory message about Canadians in the soc.culture.canada. Members of such news groups then may send a message to the system administrators asking that a user's account be terminated because of such posting. The Toronto Free-Net Board of Directors has taken the position that the only postings that will get a person's account terminated is material that is illegal under Canadian law. Otherwise, the Toronto Free-Net will not take any action. Freenet Executive Director Mike Anderson had this to say regarding the continued attempts of a minority of usenet participants to have my account on his system deactivated; The TFN's policy is not to take action against members unless they contravene the Criminal Code of Canada, or engage in practices such as forgery, attacks against other computer systems or mailbombing. Mr. Corley, while possibly being very annoying, has not contravened the TFN's policies. The TFN believes strongly in freedom of expression, while recognizing that the price for such freedom may be a high signal-to-noise ratio in Usenet. If Mr. Corley breaks the law, we will take action -- until then, he has the same rights as any TFN member to post to Usenet newsgroups. Actions such as mailbombing the TFN in protest will be met by strong complaints to the originating site's postmaster. The best defense against unwanted postings may be simply be to ignore them and deny the poster an audience. TFN Executive Director Toronto, Ont CANADA Personally, I find it gratifying that my contributions to usenet discussion are recognized as being conducive to a high signal-to-noise ratio by their quality and thoughtfulness. 357 -- Posted via a free Usenet account from http://www.teranews.com Tag: Problems with no rows returning from Query and C# Tag: 136771
  - 10
    - Open persisted ADODB recordset in ADO.Net DataSet The below code is what I put together to open a XML persisted ADODB 2.8 recordset in an ADO.Net v2 DataSet. My question is if the below code the best why to go about this. Thanks Dan Reber ADODB.Recordset rs = new ADODB.Recordset(); rs.Open(fileName, Type.Missing, CursorTypeEnum.adOpenStatic, LockTypeEnum.adLockBatchOptimistic, -1); try { DataSet myDataSet = new DataSet(); OleDbDataAdapter adapter = new OleDbDataAdapter(); adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey; int count = adapter.Fill(myDataSet, rs, "ADODB.RecordSet"); return myDataSet; } catch (Exception e) { Console.Write(e.ToString()); return null; } Tag: Problems with no rows returning from Query and C# Tag: 136770
  - 11
    - Security ideas for n-tier? We are working on a project where we are converting our client server application to a n-tier model to make it more scalable. The question I have here for the group is to see if I can get some ideas on how the security should be implemented for this kind of architecture. I am new to this n-tier world so I am looking for some guidance. Just to give you an idea, basically the plan is to split the existing thick client into three layers, a thin client (C# using .net), a middle tier consisting of business logic(C#. net) and SQL Server as the database. In addition to this we will have some web services which in turn will talk to the application server and then to the database. The web services will be written so that in the near future a web portal will be created which will use the web services to write and read data from the database. So basically we are anticipating data from the thin client which will primarily be the Customer Support representatives and data from end users from the web. My question is under this scenario what is the normal and standard practice for authentication? What methodology should be used for authenticating users to the thin client? Should each user be authenticated using the windows authentication or should that be custom security. How should the users coming from the web be authenticated. Once the user is logged on through thin client do we need any security when we do remoting to the business layer. How should the security at the database be implemented, we would like to audit all the changes on a user name basis. I have been reading quite a bit on security but I am still confused what approach would be the best under the above scenario. Any help in this regard will be greatly appreciated. If there is any white paper or website, or book that might help please feel free to suggest we are in a time crunch to get this project completed. Thanks Tag: Problems with no rows returning from Query and C# Tag: 136768
  - 12
    - DefaultView.RowFilter Hello all, I'm having a performance problem using the DataTable.DefaultView.RowFilter. When setting the filter to MyField = "Something" this takes about 12 seconds (this isn't the issue). Next if I change the filter to MyField In ('SomethingElse') it takes about 1 second (still not the issue), Next I set the filter to "". This takes about 5 seconds (still not the issue). Finally if I set the filter back to MyField = "Something" or MyField In ('SomethingElse') it takes like 30-45 seconds. This is the issue. My DataTable is bound to a single control but I remove the binding prior to changing the RowFilter and it doesn't make a difference. In a test app the 1st filter takes 12 seconds, the 2nd filter takes 468 ms, no filter takes 6 seconds and back to the 1st takes 453 ms. I cannot find a way to debug what it's doing in my actual app. I tried stepping into RowFilter = "....." but nothing happens (thought maybe there was an event I subscribed to and forgot) and as far as I can tell there are no other controls bound to this DataTable. Are there any tricks out there that may help me narrow this down? Thanks for any help, Joe Tag: Problems with no rows returning from Query and C# Tag: 136764
  - 13
    - Clear unchanged rows in a data table I have a unique situation and wondering if there's a different way of doing it. I have a strongly typed dataset for a disconnected environment. This dataset runs on a service so I want to clear the rows every now and then to keep memory usage to a minimum. But if dataset can't contact for the database for some reason, I want to be able to hold the records (because the service will still continue to collect data) and upload them later. Is there a way to clear the rows that are marked as unchanged. Here's my code... Private Function PopulateTable(ByRef dt As DataTable, ByVal sqlCmd As SqlCommand, ByVal payload() As String) Dim i As Integer Dim row As DataRow = dt.NewRow() Dim sqlDa As New SqlDataAdapter Try sqlDa.InsertCommand = sqlCmd row(0) = m_machineName For i = 1 To payload.Length - 1 If i > dt.Columns.Count - 1 Then Exit For If i = 1 Then row(i) = Convert.ToDateTime(payload(i - 1).Trim()) Else row(i) = payload(i - 1).Trim() End If Next Catch ex As Exception Debug.WriteLine("PopulateTable: " + ex.Message) Finally dt.Rows.Add(row) sqlDa.Update(dt) <--- Calls .AcceptChanges() method and marks rows as UnChanged If dt.Rows.Count > 1600 Then dt.Rows.Clear() <--- Want to clear unchanged rows End If sqlDa.Dispose() End Try End Function GetChanges returns a copy of the data table not a reference. If I have to iterate through rows I will but I was hoping for a better method. Tag: Problems with no rows returning from Query and C# Tag: 136763
  - 14
    - Simple ADO tasks Hi there, If someone could just run me through the tasks involved in this simple example I would be grateful. (using asp.net 2.0 and vb.net, sql server 2000 database) I start with an xml string, which I load into a dataset as a single table. This is a single column of unique id's. So far so good :) Now, I want to load an a full table into another (or the same?) dataset.. but limit the results to those keys held within my first table. Is it possible to do this as a query, or would I have to somehow use a mapping between the datasets/tables? If so how is this acheived? Cheers for any pointers or examples, Chris Tag: Problems with no rows returning from Query and C# Tag: 136754
  - 15
    - A transport-level error has occurred when sending the request to the server Hi All, We have a website build in ASP.NET 2.0 and we are receiving the following error: System.Data.SqlClient.SqlException: A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) At first we received this error at the localhost only, unfortunatelly it is popping up in the logs of the live server as well now. When we were searching for a sollution or a better explanation of what is happening here, we found loads of people with the same problem. Nobody seems to have an answer though. If you had this problem and found a sollution or if you know more about this error, please let us know! Thanks in advance! Kind regards, Robin Tag: Problems with no rows returning from Query and C# Tag: 136752
  - 16
    - Setting provider specific value - flushing MSAccess I have searched far too long for an answer to this riddle...and I know it's probably right in front of me. I have found articles using older versions of ADO that set Jet specific properties on the ADO connection object. In ADO.NET 2.0 the Connection does not have a Properties collection where I can set a key/value setting that is specific to the provider. Where is the equivalent in ADO.NET 2? Specifically I am trying what the articles call the "Jet OLEDB:Flush Transaction Timeout" as a way to disable the asynchronous "lazy write" that the Jet engine does by default. Kudos in advance to anyone that knows the answer. Dennis Tag: Problems with no rows returning from Query and C# Tag: 136740
  - 17
    - SqlDataSource with multiple data tables I'm attempting to work with SqlDataSource to pull values from a database and populate a form, which by itself is no problem. However, I'm trying to visualize how to also iterate through values on a joined table. My situation is that there is a form representing a Rule filled out mostly from values contained in one table, but that form also contains a ListBox that allows multiple selection which represents the locations this rule applies to. The rule can be applied to any, all or zero locations. I'd like to set this up such that when a Rule is retrieved, the Locations are retrieved in the same query (I know I can accomplish this with 2 separate SqlDataSources), and all values are populated at once. The problem I have is that a JOIN seems to just repeat the form data across all rows, when I really only need the Location ID. If I execute two SELECT statements within a single SqlDataSource without any relationships defined with the query, can I access both the returned tables and create those relationships in the code? I don't need the SqlDataSource's INSERT, UPDATE or DELETE commands for this function, as the work required for those is a bit more than can be handled automatically. But I would like to get this part working with minimal trips to the database, since it just seems unnecessary to execute these two queries independently. What is the best option for doing this? Revert back to DataSet's ability to store and retrieve multiple tables and the ability to create DataRelations? Thanks very much for your time. Simon Cartin Tag: Problems with no rows returning from Query and C# Tag: 136727
  - 18
    - Call SqlCommand.ExecuteReader inside another SqlCommand.ExecuteRea Hi; I need to call SqlCommand.ExecuteReader and then inside a while (reader.Read()) I need to call another SqlCommand.ExecuteReader. I need to do this because I have a FK:PK relationship and based on the FK read, then read the row in that related table - if the FK is not null. How can I do this? -- thanks - dave david_at_windward_dot_net http://www.windwardreports.com Cubicle Wars - http://www.windwardreports.com/film.htm Tag: Problems with no rows returning from Query and C# Tag: 136726
  - 19
    - VB Executable Finding Access Database When Shipped I've seen several posts in the archives regarding making your VB .NET application have a relative path connection string to an Access DB, but do not see a definite resolution to the matter. Here's what I'm trying to resolve: My VB 2003 .NET application connects and works just fine with an Access database located at c:\data.mdb. Now, I use a wizard for making an installer for my application and it places the data.mdb file in the installation directory without any problems. However, I'm always going to have a runtime error unless the data.mdb file is at c:\. I have to believe this issue has come up before and a pro can easily shed some light on how I can perhaps use a relative path in my connection string rather than an absolute. I sure appreciate the help. -Dan Tag: Problems with no rows returning from Query and C# Tag: 136719
  - 20
    - New Dot Net discussion forum Hi all Thanks to all of you for a good response on my site www.xcessdotnet.com/dotnetforum last 10 days there has been 12 new members and 45 new posts.. I wanted to contribute something to the dot net community and for this I set up this forum.. I welcome your suggestions and contribution to make my efforts successfull Regards Chris Tag: Problems with no rows returning from Query and C# Tag: 136702
  - 21
    - Get deleted rows from a datatable Hi all, I've a DataTable, and from my UI a such user deletes one or more rows from it, I wish to get the deleted rows from the DataTable. I have to perform a loop trough the deleted rows and invoke the Row.Accept changes method, but if I try something like this: dim rX as DataRow For Each rX in MyTable.Rows If rX.RowState=RowState.Deleted Then rX.AcceptChanges End If Next I get an execption: the collection is changed. When I invoke rX.AccepChanges method of a deleted rows, the row is removed from the .Rows collection of the datatable and the loop I'm performing fails. Tag: Problems with no rows returning from Query and C# Tag: 136697
  - 22
    - Transaction Hi, I am using transaction object with this code: connection.Open(); SqlCommand command = connection.CreateCommand(); SqlTransaction transaction; // Start a local transaction. transaction = connection.BeginTransaction("SampleTransaction"); // Must assign both transaction object and connection // to Command object for a pending local transaction command.Connection = connection; command.Transaction = transaction; // CallMehtod1( command); //- executing query 1 with command.ExecuteNonQuery(); // CallMehtod 2(command);//- executing query 2 with command.ExecuteNonQuery(); transaction.Commit(); My question is it possible to execute different queries with different method calls , and after commit the transaction like in the sample, rather than execute the queries in the same method within the transaction, will this transaction work well ? Leeor Tag: Problems with no rows returning from Query and C# Tag: 136692
  - 23
    - Convert Big5/GB code into iso-8859-1 into database through ADO.Net i am writing a function that can convert Big5/GB code into iso-8859-1 into database through ADO.Net in c# My database SQL server2005 if i write that string Value =3D Encoding.GetEncoding("iso-8859-1").GetString(Encoding.GetEncoding("big5").G= etBytes("=A4=A4=BB=C8=BB=C8=A6=E6=A4=A4=B4=C1=B3=F8=A7i")); =A4=A4=BB=C8=BB=C8=A6=E6=A4=A4=B4=C1=B3=F8=A7i <~ is the chinese input stri= ng in my db, i use the NJStar, i can see what the chinese input string i type but when i want to convert the gb to iso-8859-1 string Value =3D Encoding.GetEncoding("iso-8859-1").GetString(Encoding.GetEncoding("gb2312")= .GetBytes("=A4=A4=BB=C8=BB=C8=A6=E6=A4=A4=B4=C1=B3=F8=A7i")); some character cannot display out.. i donno why? can anyone help me? thx in addition, i try to convert the big5 to iso-8859-1 and then convert it back to big5, for english string, i can see write i type before, but for chinese, i cannot see what i type: File.WriteAllBytes(@"C:\abcde.html", Encoding.Convert(Encoding.GetEncoding("iso-8859-1"), Encoding.GetEncoding("big5"), Encoding.Convert(Encoding.GetEncoding("big5"), Encoding.GetEncoding("iso-8859-1"), Encoding.GetEncoding("big5").GetBytes("=A4=A4=BB=C8=BB=C8=A6=E6=A4=A4=B4=C1= =B3=F8=A7iabc")))); if anyone have any suggestion, i will very thx for u Tag: Problems with no rows returning from Query and C# Tag: 136691
  - 24
    - Connection state open even without a server or database? I test for a connection when I load a particular form, so as to prevent other more ghastly exceptions further into the logic. However, I've noticed that even with NO viable connection string, the connection object state shows open. Anyone see something I'm overlooking here? Here is the code: Dim strSQLServer As New SqlConnection(strConn) strSQLServer.Open() Debug.WriteLine(strConn.ToString()) Debug.WriteLine(strSQLServer.State.ToString()) Here is the output: data source=;initial catalog=;integrated security=SSPI; Open Tag: Problems with no rows returning from Query and C# Tag: 136682
  - 25
    - DataTable/DataSet extention Hi, Im using the VisualStudio 2005 designer to create typedDataSet (drag & drop from the service explorer). All the DataTables in the generated code inherit from System.Data.DataTable, I would like the dataTables to inherit from MyDataTable (a custom DataTable) instead. How can I do that without manually editing the generated code? Tag: Problems with no rows returning from Query and C# Tag: 136662
- Next
  - 1
    - Using ExecuteScalar on ,Net Framework 1.1 This is a multi-part message in MIME format. ------=_NextPart_000_00C5_01C73ED8.A6B50E10 Content-Type: text/plain; charset="iso-8859-8-i" Content-Transfer-Encoding: quoted-printable I am using ExecuteScalar, executing a stored procedure with two = commands: the first command is Select command,=20 and the second is Insert. Because of the Select command , The ExecuteScalar do not return an error = in case of the Insert(second command -see the stored pro. sample in the = bottom) failure. the stored procedure: CREATE PROCEDURE dbo.usp_UpdateOnline @Id as bigint, @source_file as nvarchar(50), AS declare @IsUpdate as int EXEC @IsUpdate =3D mysp_IsIDExist @Id SELECT @IsUpdate --From this point no error is returned to Execue Scalar INSERT=20 INTO online.dbo.T_all (Id, source_file , ) VALUES ( @Id ,@source_file ) GO please help Leeor ------=_NextPart_000_00C5_01C73ED8.A6B50E10 Content-Type: text/html; charset="iso-8859-8-i" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML dir=3Drtl><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-8-i"> <META content=3D"MSHTML 6.00.2800.1106" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY dir=3Dltr> <DIV><FONT face=3DArial size=3D2>I am using ExecuteScalar, executing a = stored=20 procedure with two commands:</FONT></DIV> <DIV><FONT face=3DArial size=3D2>the first command is = <STRONG>Select</STRONG>=20 command, </FONT></DIV> <DIV><FONT face=3DArial size=3D2>and the second is=20 <STRONG>Insert</STRONG>.</FONT></DIV> <DIV><FONT face=3DArial size=3D2>Because of = the <STRONG>Select</STRONG> command=20 , The ExecuteScalar do not return an error in case of the=20 <STRONG>Insert(second command -see the stored pro. sample in the=20 bottom)</STRONG> failure.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>the stored procedure:</FONT></DIV> <DIV><FONT face=3DArial size=3D2>CREATE PROCEDURE =20 dbo.usp_UpdateOnline</FONT></DIV> <DIV><FONT face=3DArial size=3D2>@Id as bigint,<BR>@source_file as=20 nvarchar(50),</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>AS<BR>declare @IsUpdate as int<BR>EXEC = @IsUpdate =3D=20 mysp_IsIDExist @Id</FONT></DIV> <DIV><FONT face=3DArial size=3D2>SELECT @IsUpdate</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2><STRONG>--From this point no error is = returned to=20 Execue Scalar<BR></STRONG>INSERT <BR> INTO = online.dbo.T_all<BR> =20 (Id,<BR>   source_file ,<BR>  )</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2> VALUES<BR> (  = @Id<BR>  =20 ,@source_file<BR>  )</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>GO<BR></FONT></DIV> <DIV><FONT face=3DArial size=3D2>please help</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Leeor</DIV></FONT></BODY></HTML> ------=_NextPart_000_00C5_01C73ED8.A6B50E10-- Tag: Problems with no rows returning from Query and C# Tag: 136654
  - 2
    - Help with INSERT statement. Hi I need to perform following querie in vb.net The queries are; NSERT INTO [destTbl] (field1, field2) SELECT srcTbl.field1, srcTbl.field2 FROM srcTbl WHERE (((srcTbl.entry_id) Not In (SELECT srcTbl.entry_id FROM [destTbl]))); In access I just run these query and job is done without any error in SQL View. What is the easiest way to execute this querie in ado.net/vb.net? Thanks Tag: Problems with no rows returning from Query and C# Tag: 136650
  - 3
    - Help with INSERT statement. Hi I need to perform following querie in vb.net The queries are; NSERT INTO [destTbl] (field1, field2) SELECT srcTbl.field1, srcTbl.field2 FROM srcTbl WHERE (((srcTbl.entry_id) Not In (SELECT srcTbl.entry_id FROM [destTbl]))); In access I just run these query and job is done without any error in SQL View. What is the easiest way to execute this querie in ado.net/vb.net? Thanks Tag: Problems with no rows returning from Query and C# Tag: 136649
  - 4
    - Stored Proc Params in TableAdapter In VS 2005, when configuring a table adapter to use stored procedures for Inserts, Updates, and Deletes, it appears you can only map each parameter to a column in the Select procedure's result set. Is it possible to specify a literal value for some of the parameters instead? Or would it be necessary to add the literal value to the result set of the Select procedure? Tag: Problems with no rows returning from Query and C# Tag: 136647
  - 5
    - Update/insert one table from another Hi I need to perform following querie in vb.net The queries are; NSERT INTO [destTbl] (field1, field2) SELECT srcTbl.field1, srcTbl.field2 FROM srcTbl WHERE (((srcTbl.entry_id) Not In (SELECT srcTbl.entry_id FROM [destTbl]))); In access I just run these query and job is done without any need for datadatpters etc. What is the easiest way to execute these two queries in ado.net/vb.net? Thanks Tag: Problems with no rows returning from Query and C# Tag: 136642
  - 6
    - MS SQL 2005 Configuration ??? Greetings, I'm fairly new to ASP.NET/ADO.NET and SQL. I worked out a few issues with the help of some nice folks here. Now, I'm starting a clean Web site project but am having trouble right off again. I'm trying to create a new database using MS SQL Server 2005. I entered localhost as the Server name, selected Use Windows Authentication, and entered a new name for my database. When I click OK, I get the following error: Microsoft Visual Studio An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) As far as I know, localhost does not indicate a remote connection. I eventually connected to a database previously with SQL Express Edition, so I'm guessing this might have to do with my SQL configuration. I'm using Visual Studio 2005 on a new C#/ASP.NET project. I'm running Windows XP Professional w/SP2. Sorry, but virtually every suggestion I get will probably need to include instructions on how to do--I'm quite new to this. Any help greatly appreciated! -- Jonathan Wood SoftCircuits Programming http://www.softcircuits.com Tag: Problems with no rows returning from Query and C# Tag: 136641
  - 7
    - Leftover Connections in Connection Pool (connection leak) This never happened before in .NET Framework 1.0 nor .NET Framework 1.1, but connection leak happens if you don't close the connection when you use SqlTransaction. I would like to share this information with the MS dev community. We had this issue of SQL Server performing very poorly while running our application. My colleague found out that connection leak was happening whenever the .NET code executed transactions. So I created a small console program that does a transaction like the following. Imports System.Data Imports System.Data.SqlClient Module Module1 Sub Main() Begin: Dim Conn As SqlConnection = GetConnection() Conn.Open() Dim Trans As SqlTransaction = Conn.BeginTransaction(IsolationLevel.ReadUncommitted) Dim Cmd As New SqlCommand("tblTest_ins", Trans.Connection, Trans) Cmd.CommandType = CommandType.StoredProcedure For i As Integer = 1 To 50 Console.WriteLine("Executing stored proc. (" & i.ToString() & ")") Dim parTestCol As New SqlParameter() With parTestCol .ParameterName = "@TestCol" .Direction = ParameterDirection.Input .SqlDbType = SqlDbType.NVarChar .Size = 50 .SqlValue = "TestValue " & DateTime.Now.ToString() End With Cmd.Parameters.Add(parTestCol) Cmd.ExecuteNonQuery() Cmd.Parameters.Clear() Next Trans.Commit() Console.WriteLine("Execution Completed") Dim Entry As ConsoleKeyInfo = Console.ReadKey() If Entry.Key = ConsoleKey.Y Then GoTo Begin Else Return End If End Sub Private Function GetConnection() As System.Data.SqlClient.SqlConnection Dim Conn As New SqlConnection("server=(local);database=Test;Pooling=true;user id=sa;password=whatever;Application Name=HelloConnPool;connection reset=true;") Return Conn End Function End Module I ran this code many times, and connection leak was happening. So I added Conn.Close() right after Trans.Commit(), then the leak was gone. Well, I could have done Trans.Connection.Close(), but the thing was that right after the transaction was committed, Connection property was null. So as we have a data layer that doesn't expose the underlying connection, we had to define a variable as SqlConnection and hold onto the reference to the connection from the transaction and the close it after commit. I hope I explained this issue well, but this never happened in .NET Framework 1.1. We converted our code from 1.1 to 2.0, and didn't change a thing, but this issue came out. I hope this will help people who experience the same kind of issue. If you have any question, please just post it here. Tag: Problems with no rows returning from Query and C# Tag: 136640
  - 8
    - Queries to an Access db from vs2005 Hello, I just have a form in which there's a textbox for queries. I need to use the SQL statements for an Access db, like this, which works fine in a SQL db: SELECT * FROM table WHERE name LIKE @name + '%' I just need to query the db to find names that start with letters I digit in the textbox. This query comes from dataset designer. If I use it in my Access db I get a syntax error from framework. Which is the Access equivalent? Thanks. Max Tag: Problems with no rows returning from Query and C# Tag: 136634
  - 9
    - Append Room numbers fields by Building Hello, I have a table as follows- BUILDING ROOM_NUMBER MAIN 100 MAIN 101 MAIN 102 SUB 200 SUB 202 The Resultset should be as follows- BUILDING SUMMARY_ROOMNUMBE MAIN 100,101,102 SUB 200,202 I know I need to use the group by clause but I dont know how to append the summary room number. Any help would be greatly appreaciated. Thanks. -jay Tag: Problems with no rows returning from Query and C# Tag: 136633
  - 10
    - Timeout error when inserting and reading from same table in sql server and .net Hi All, I have a headache with SQL Server and .net application which I hope you can help with. I have this trigger on my table 'tester' in sql server 2000. It calls the external program exetest CREATE TRIGGER testTrig ON [dbo].[tester] FOR INSERT, UPDATE AS exec master..xp_cmdShell 'C:\ExeTest.exe' I am calling the ExeTest.exe program which is supposed to read from the same table again and just display first. I am having a similar problem as this guy below( i.e updating and reading the same table. But there is no solution) http://groups.google.com/group/microsoft.public.dotnet.framework.adonet/browse_thread/thread/60921b45f9dc00e4/0494ca46ee4147bb?lnk=st&q=sql+server+.net+timeout+expired+sqldatareader&rnum=1#0494ca46ee4147bb Is there a way that I can achieve this? Even if it is long, I do not mind as long as there is no timeout. I have set the timeout to 5 minutes plus, and still got a timeout error. It seems the table is locked and cannot be selected from??? If you still reading, here is my code in the ExeTest.exe :) Sub Main() Dim sqlstring As String = "select * from tester" 'Dim connString1 As String = "Data Source=servername;Database=ProjectServer;UID=sa;pwd=pwd" Dim connString1 As String = "Data Source=localhost;Database=ProjectServer;Integrated Security=true" Dim conn As New SqlConnection conn = New SqlConnection(connString1) Try conn.Open() Dim cmd As New SqlCommand(sqlstring, conn) cmd.CommandTimeout = 40 Dim listA As SqlDataReader = cmd.ExecuteReader() While listA.Read Console.WriteLine(listA(1)) End While 'End If listA.Close() conn.Close() Catch ex As Exception Console.WriteLine("error : " + ex.Message) End Try End Sub Regards, Omar Tag: Problems with no rows returning from Query and C# Tag: 136628
  - 11
    - Timeout when reading and updating / inserting to same table Hi All, I have a headache with SQL Server and .net application which I hope you can help with. I have this trigger on my table 'tester' in sql server 2000. It calls the external program exetest CREATE TRIGGER testTrig ON [dbo].[tester] FOR INSERT, UPDATE AS exec master..xp_cmdShell 'C:\ExeTest.exe' I am calling the ExeTest.exe program which is supposed to read from the same table again and just display first. I am having a similar problem as this guy below( i.e updating and reading the same table. But there is no solution) http://groups.google.com/group/microsoft.public.dotnet.framework.adonet/browse_thread/thread/60921b45f9dc00e4/0494ca46ee4147bb?lnk=st&q=sql+server+.net+timeout+expired+sqldatareader&rnum=1#0494ca46ee4147bb Is there a way that I can achieve this? Even if it is long, I do not mind as long as there is no timeout. I have set the timeout to 5 minutes plus, and still got a timeout error. It seems the table is locked and cannot be selected from??? If you still reading, here is my code in the ExeTest.exe :) Sub Main() Dim sqlstring As String = "select * from tester" 'Dim connString1 As String = "Data Source=jktgrhxsapps1;Database=ProjectServer;UID=sa;pwd=ProjectServer" Dim connString1 As String = "Data Source=localhost;Database=ProjectServer;Integrated Security=true" Dim conn As New SqlConnection conn = New SqlConnection(connString1) Try conn.Open() Dim cmd As New SqlCommand(sqlstring, conn) cmd.CommandTimeout = 40 Dim listA As SqlDataReader = cmd.ExecuteReader() While listA.Read Console.WriteLine(listA(1)) End While 'End If listA.Close() conn.Close() Catch ex As Exception Console.WriteLine("error : " + ex.Message) End Try End Sub Regards, Omar Tag: Problems with no rows returning from Query and C# Tag: 136627
  - 12
    - DateTime Filter Expression Hi, is there anyway of selecting rows with a particular date but ignoring the time within a date time column? something like... DataTable.Select("DateTimeColumn".Date = '28/12/06') ? thanks in advance for any advice. Sharat Koya Tag: Problems with no rows returning from Query and C# Tag: 136617
  - 13
    - Adding new object to Typed Data Set and return the primary key Hi, I have started using Typed Data Sets with VS2005 and so far so good, however I am having a problem with adding a row to a data table and returning the new Primary Key value. My data set has been auto generated from a DB table and has an auto generated Primary Key for the ID field. I create the row using ProjectsDataTable.NewProjectsRow() However the code that returns this Project Row does not persist the data table as it is a method on my singleton object. Once the new row has been populated with data I call an update method on the singleton which then creates a new table adapter. My problem is how to add this orphaned row to the database and return the Primary Key that the database creates for it. I have tried many of the different methods that are created by default in the TypedDataSet however so far the only one that works is the TableAdapter.Insert() method and this does not return the primary key. Method 1: DataAdapter.Update(myProjectRow) // fails I guess because the row has no connected DataTable Method 2: newDataTable = DataAdapter.GetData(); // returns eg a data table containing 4 rows. newDataTable.ImportRow(myRow); // data table still contains 4 rows no error generated. DataAdapter.Update(newDataTable); // does nothing as there is nothing to update Please does anyone have any insight into this or do i have to go back to the good old way of manually executing the SQL or dumping my data singleton and manually creating and persisting the data table for the form that creates the new project ? Another strange thing is that the if i return a project from the singleton (which does not persist the data table) then call the same update method ( on the singleton which creates a new data adapter) the updates are commited. Is something strange with the primary key going on ? Sudo Code Snippet: public class DataObject { private static DataObject this_Data; public static DataObject getInstance() { if (this_Data == null) this_Data = new Data(); return this_Data; } public TypedDataObjectProject newProject() { Projects.ProjectsDataTable db_ProjectsTable; DataLayer.ProjectsTableAdapters.ProjectsTableAdapter db_TableAdapter = new com.acet4data.DataPro.DataLayer.ProjectsTableAdapters.ProjectsTableAdapter(); Projects.ProjectsDataTable db_ProjectsTable2 = db_TableAdapter.GetData(); return db_ProjectsTable2.NewProjectsRow(); } public TypedDataObjectProject getProject() { Projects.ProjectsRow db_Project; DataLayer.ProjectsTableAdapters.ProjectsTableAdapter db_ProjectAdapter = new DataLayer.ProjectsTableAdapters.ProjectsTableAdapter(); Projects.ProjectsDataTable db_ProjectTable2 = db_ProjectAdapter.GetData(); db_ProjectAdapter.Dispose(); return db_ProjectTable2[0]; } public int updateProject(Projects.ProjectsRow Project) { int int_Return = 0; DataLayer.ProjectsTableAdapters.ProjectsTableAdapter db_ProjectAdapter = new com.acet4data.DataPro.DataLayer.ProjectsTableAdapters.ProjectsTableAdapter(); db_ProjectAdapter.Update(Project); db_ProjectAdapter.Dispose(); } } This works: ob_Prog = DataObject.getInstance().getProject(); ob_Prog.Name = "new value"; DataObject.getInstance().updateProject(ob_Prog); This Fails not with error but no new row is added: ob_Prog = DataObject.getInstance().newProject(); ob_Prog.Name = "new value"; DataObject.getInstance().updateProject(ob_Prog); Many thanks in advance for you help. Nic Tag: Problems with no rows returning from Query and C# Tag: 136616
  - 14
    - Why can't the .NET Datagrid show datetime columns with time ? Hi, I am using .NET Framework 1.1 and VS.NET 2003 I am pulling a recordset from an ORACLE database into a Windows Forms form and displaying the data in a datagrid.. Trouble is, even though the data includes datetime fields, the datagrid absolutely refuses to display them at runtime in proper datetime format (just shows . I know the time information is there because I can export to csv and the time is in each field. I even got some code from Kelly in another thread to force datetime fields to be formatted properly like this: >>> CODE >>> Public Shared Sub Format(ByRef grd As DataGrid, ByRef dt As DataTable) Dim ts As New DataGridTableStyle() Dim tc As DataGridTextBoxColumn Dim dc As DataColumn For Each dc In dt.Columns tc = New DataGridTextBoxColumn() tc.MappingName = dc.ColumnName tc.HeaderText = tc.MappingName If dc.DataType Is GetType(System.DateTime) Then tc.Format = "MM/dd/yyyy hh:mm:ss" tc.Width = 125 End If ts.GridColumnStyles.Add(tc) Next grd.TableStyles.Clear() grd.TableStyles.Add(ts) grd.DataSource = Nothing grd.DataSource = dt <<< END CODE <<< Now, when I run this, several fields are identified as system.datetime and these get the special format. But nothing happens in the datagrid. Is there anything else I can do to show the time with the dates? thanks for any help or assistance Philip Tag: Problems with no rows returning from Query and C# Tag: 136611
  - 15
    - MSAccess DB and DataSets - help Hi, I have VS.net 2005 express and I have created a new project. I made a new folder and added and existing MS Access DB (Maintenance.mdb). VS.net happily went and created a DataSet class for me (MaintenanceDataSet). My question is: How do I load the data from the Access DB so I can access it from the application? Thank you in advance. Tag: Problems with no rows returning from Query and C# Tag: 136598
  - 16
    - Unicode and long data type I have an application where a limited amount of Unicode data is being inserted into a long data type field by an AIX program. I have written a dotnet program that copies the data from one domain to another with parameterized data. Everything works except for the Unicode data in the long field. My Characterset info is: NLS_CHARACTERSET US7ASCII NLS_NCHAR_CHARACTERSET AL16UTF16 Regional Settings are English (United States) A basic default U.S. installation of Windows. I do not have much control over the database. I have read that long data types do not support Unicode. Is there anyway I can insert Unicode data into a long data type from a dotnet program? Tag: Problems with no rows returning from Query and C# Tag: 136595
  - 17
    - dataset question Hi I am a newbie in ado.net 2005. Is it possible to do a Group By in a dataset? thanks E. Tag: Problems with no rows returning from Query and C# Tag: 136592
  - 18
    - Why can't I get the FormView control's Paging controls to show? I have tried everything I can think of, I have even tried copying examples from books and websites I have found, but every Formview control that I have tried to create does not show the Paging controls. The first record from the DataSource is displayed, but not the Paging controls. I have tried doing it with both automatically generated Paging controls as well as using the PagerTemplate, but neither one is displayed. What is the problem? Thanks. -- Nathan Sokalski njsokalski@hotmail.com http://www.nathansokalski.com/ Tag: Problems with no rows returning from Query and C# Tag: 136591
  - 19
    - Reader ordinal problem Hi I am getting the System.IndexOutOfRangeException was unhandled error on the last line of below code; Cmd = New OleDb.OleDbCommand("SELECT [Last Staff Update From Site] FROM [Update Control]", LocalConn) Reader = Cmd.ExecuteReader() Console.WriteLine("{0}", Reader.GetOrdinal("[Last Staff Update From Site]")) What is the problem and how can I fix it? Thanks Regards Tag: Problems with no rows returning from Query and C# Tag: 136588
  - 20
    - 36 Microsoft Certification Tutorials and Free Practice Exams 36 Microsoft Certification Tutorials and Free Practice Exams For complete Microsoft Certifications ebooks go to http://free-tech-ebooks.blogspot.com/search/label/Microsoft%20Certifications All the best !! Tag: Problems with no rows returning from Query and C# Tag: 136582
  - 21
    - Have alternative to CommandDataBuilder? I realize that Microsoft not intend to fix problems of Commandbuilder: +not deal with SQL calculated fields +not deal with Identity field to retrieve it and also cannot be inherit! there someone wrote Alternative? Tag: Problems with no rows returning from Query and C# Tag: 136577
  - 22
    - SqlCommand Parameters with SqlDbType and VarChar(MAX) If I have a field in MS SQL 2005 called "data" with type VarChar(MAX), how do I add a parameter using the syntax below if SqlDbType doesn't have a VarChar(MAX) type. If I use SqlDbType.VarChar will the value get truncated or is that what I should use? SqlCommand cmd = new SqlCommand(query, connection); cmd.Parameters.Add("@data", SqlDbType.VarChar).Value = largeTextData; Or am I supposed to use the size parameter? cmd.Parameters.Add("@data", SqlDbType.VarChar, 1000000).Value = largeTextData; Also how many characters does VarChar(MAX) hold? Tag: Problems with no rows returning from Query and C# Tag: 136575
  - 23
    - Accessing sql server behind proxy Hi My app is running on a windows 2000 server with isa 2000 installed. How can it access an external sql server (using its ip) from within the isa 2000 firewall/proxy via code? Thanks Regards Tag: Problems with no rows returning from Query and C# Tag: 136573
  - 24
    - HowTo Convert Array to Binary I have an array of an array of doubles and need to save this as a single byte array. Then save this byte array as a BLOB to an SQL 2005 database. Array allocation code shown below: Array myArray = Array.CreateInstance(System.Type.GetType("System.Double[]"), 3); Double[] dblArray1 = new double[4] { 23.56, 24.56, 25.56, 26.56 }; Double[] dblArray2 = new double[4] { 33.56, 34.56, 35.56, 36.56 }; Double[] dblArray3 = new double[4] { 43.56, 44.56, 45.56, 46.56 }; // Place above three double arrays in an myArray myArray.SetValue(dblArray1, 0); myArray.SetValue(dblArray2, 1); myArray.SetValue(dblArray3, 2); I have tried serialize the myArray object however the byte array is almost twice the length of the array of doubles: MemoryStream stream = new MemoryStream(); BinaryFormatter formatter = new BinaryFormatter(); formatter.Serialize(stream, dblArray1); BinaryReader reader = new BinaryReader(stream); reader.BaseStream.Position = 0; byte[] inputBytes = reader.ReadBytes((int)reader.BaseStream.Length); However the byte count of the byte array is almost doubled that of the array of doubles. inputBytes byte count is 175 should of been 96 bytes. Does anyone know a better way to save an Array of an Array of doubles to a byte array? Thanks in advance, Scott Tag: Problems with no rows returning from Query and C# Tag: 136571
  - 25
    - TransactionScope Questions Hi! I have a couple of questions about TransactionScope... What exactly is the scope of a transaction? Is it only connections that are created in the actual code block where the TransactionScope is defined, or is it all connections created on the same thread as the TransactionScope? What is the performance like using a TransactionScope object for multiple consequetive connections to a single database as compared to using a standard ADO.NET transaction object? I'm guessing it would be slower... but by how much? Thx! Tag: Problems with no rows returning from Query and C# Tag: 136569

I have code as follows

if((DataTable)read_union_database("retrieveSSN")).row[0][0] == DBNull.Value
{
orow[0] = ""
}
else{
orow[0] = ((Data
Table)read_union_database("retrieveSSN")).rows[0][0].ToString();
}

I keep getting the error "There is no row at position 0" and when I place
debug statements in the code it never goes to the If side of the statement.
The read_union_database is just a SQL query
that returns back the SSN of a member that matches a certain parameter. So
in this case obviously I don't have a match and therefore I don't have a row
being returned. What is the proper way in C# to check to see if that
returned?

Bill

Top

Re: Problems with no rows returning from Query and C# by Plamen

Plamen
Fri Jan 26 20:16:10 CST 2007

Hi Bill,

You can check the DataTable.Rows.Count property. If greater than 0 then you
have some rows returned, otherwise there are no rows.

Regards,

Plamen Ratchev
http://www.SQLStudio.com

Top

Re: Problems with no rows returning from Query and C# by Cor

Cor
Sun Jan 28 04:32:42 CST 2007

Bill,

Is there any reason that there should be a row at position 0 from orow.

I can not get this from the code that you show.

Cor

"Bill Gower" <billgower@charter.net> schreef in bericht
news:u4$IbObQHHA.3412@TK2MSFTNGP05.phx.gbl...
>I have code as follows
>
> if((DataTable)read_union_database("retrieveSSN")).row[0][0] ==
> DBNull.Value
> {
> orow[0] = ""
> }
> else{
> orow[0] = ((Data
> Table)read_union_database("retrieveSSN")).rows[0][0].ToString();
> }
>
>
> I keep getting the error "There is no row at position 0" and when I place
> debug statements in the code it never goes to the If side of the
> statement. The read_union_database is just a SQL query
> that returns back the SSN of a member that matches a certain parameter.
> So in this case obviously I don't have a match and therefore I don't have
> a row being returned. What is the proper way in C# to check to see if
> that returned?
>
> Bill
>
>

Top