Home » Category » ADO

ADO

• Deleting last row in grid view

• I have a delete icon for every row in my grid. If a user deletes the last row in grid view the whole grid disappears. I cant add rows because the input fields were within the grid. I can use the rowdeleted event to prevent some action but I can't prevent the delete command. Please help...
• Fri, 03 Sep 2010 06:49:00 GMT | 297 bytes | Answers (2)

• How can a datatable be written to a new SQL Server table?

• I am struggling with ado.net within an asp.net project. I want to import an Excel spreadsheet and write it to a temporary table on a SQL Server from where it can be manipulated. I can import the Excel file to a dataset successfully but cannot move the data to the SQL Server. My attempts have bee...
• Fri, 03 Sep 2010 06:49:00 GMT | 4,320 bytes | Answers (7)

• Gridview result not updated with objectdatasource

• Hi!Good Day!I have a problem that I can't find the correct answer.I have a Gridview control that depends on the objectdatasource in which the objectdatasource calls a select method to populate the GridView. I have a criteria to filter the output but everytime I click the button the Gridview...
• Fri, 03 Sep 2010 04:49:00 GMT | 23,013 bytes | Answers (1)

• problem with displaying new row

• Hello, My problem must be very simple to solve, but I havennt found the answer yet, so any help is appreciated. I have a form with bound controls, mostly textboxes, to an access database. When I fill the dataset the datatable which is used in the binding correctly populates the controls on the f...
• Fri, 03 Sep 2010 04:49:00 GMT | 1,251 bytes | Answers (1)

• Change Date format at runtime?

• I have a datagrid that is set to autogenerate columns I know that column 0 is a datetime. I just want it to show the date not the time. I have added a OnItemDatabound event. Here is the code : If e.Item.ItemType = ListItemType.Item Or _ e.Item.ItemType = ListItemType.AlternatingItem Then Me.Data...
• Fri, 03 Sep 2010 03:49:00 GMT | 672 bytes | Answers (1)

• insert into a table using DataSet

• I'm trying to insert a row into a table using a DataSet, and having no luck. Here's what I have so far: DataSet ds = new DataSet(); SqlDataAdapter sda; XmlSerializer ser = new XmlSerializer(typeof(myClass)); StringWriter sw = new StringWriter(); ser.Serialize(sw, newdata); StringReader sr = ...
• Fri, 03 Sep 2010 03:49:00 GMT | 1,043 bytes | Answers (3)

• Accessing Oracle 8.1.7 from Windows 2003

• Hi there,Forgive me if the questions are stupid - I'm new to the Oracle world.I need to get data from an Oracle 8.1.7 server (which is on a Windows 2000 server) into SQL Server 2000 residing on WIndows Server 2003. I plan to do it using SQL Server packages.With the help of an Oracle consult...
• Fri, 03 Sep 2010 03:49:00 GMT | 956 bytes | Answers (1)

• Displaying records in groups

• Hello,I currently have a datasource that returns two columns, one is a make and the other is the name of the item. I want to be able to just display the make once as a heading, then show all the items for that make. Before moving the next.I really want to do this from one datasource rather than...
• Fri, 03 Sep 2010 02:49:00 GMT | 537 bytes

• How Can I Separate Data in a Template Column?

• Long time lurker and I've found most of what I need, but this one is a little different and I haven't been able to find any answers. If someone can give me some sample code (vb) or point me in the right direction, I'd be greatful!The problem I have is I have a template column in a...
• Fri, 03 Sep 2010 02:49:00 GMT | 1,389 bytes | Answers (1)

• HyperLink in GridView

• Here is the code... <ItemTemplate><asp:HyperLinkrunat=serverToolTip="Click Here To See Information About This Driver"Target="_blank"NavigateURL='<%# Eval("web_page") %>'Text='<%# Eval("full_name") %>'></asp:HyperLink></ItemTemplate>web_page...
• Thu, 02 Sep 2010 23:49:00 GMT | 2,205 bytes | Answers (2)

• Loading Specific Parts of Model Metadata Into an ObjectContext

• Loading an ObjectContext with an entire model's metadata is a costly operation.NHibernate allows me to explicitly add specific pieces of metadata into its object context. I deeply appreciate this feature since it allows me to significantly truncate the time and resources needed to instantiate ...
• Thu, 02 Sep 2010 20:49:00 GMT | 484 bytes | Answers (4)

• Messages deleted?

• Hi guys, Is anybody else seeing deleted messages (or not seing the messages that there should be)? -- Miha Markic - RightHand .NET consulting & development miha at rthand com www.rthand.com...
• Thu, 02 Sep 2010 19:49:00 GMT | 221 bytes | Answers (3)

• Addition (sum) Numbers in Textboxes in a Repeater

• I have 3 repeaters on a page and the number of rows in the 3rd repeater is dynamic, based on a selection from the drop down listbox.How do I get the total to update without hitting the submit button? Is there a Javascript I can use or something with Ajax (which is new to me)?I want the total to...
• Thu, 02 Sep 2010 17:49:00 GMT | 468 bytes | Answers (1)

• Weird DataBinder problem!

• Hi...Can anyone tell me whats wroing with this part of the code?<asp:HyperLink Runat="server"Text='<%#DataBinder.Eval(Container.DataItem,"name")%>'NavigateUrl='Profile.aspx?id=<%#DataBinder.Eval (Container.DataItem,"idNum")%>'></asp:HyperLinkthe first par...
• Thu, 02 Sep 2010 16:49:00 GMT | 594 bytes | Answers (3)

• Print REPORT

• <p>hi</p><p>friends</p><p>i hv to genrate some report for this if i m using Crystal Report then in print privew half page is comming .now i</p><p>want to know can i genrate reports by using datagrid? if yes .then plz give me idea hw sud i use it if some code is needed thn plz send me this also.</p>...
• Thu, 02 Sep 2010 16:49:00 GMT | 300 bytes

• error: "there is already an open datareader associated with this connection

• Hello.Thank you for your help.I'm writing Win app using C#, the .NET is ver 1.1In the app, there are timers, that when they elapse, they perform select query against MySql db.I get the above error when trying to fetch dataset using data adapter. da.Fill(ds)In order to solve it I tried:1.To put ...
• Thu, 02 Sep 2010 14:49:00 GMT | 4,678 bytes | Answers (4)

• GridView editing issues

• Hi all - I haven't done Gridviews in a while and I'm trying to create a form which can use the edit functionality. I used some samples to create my gridview dynamically because in my current case this is a must since I won't know what type of data is coming to me. Here is my problem...
• Thu, 02 Sep 2010 14:49:00 GMT | 14,109 bytes | Answers (3)

• Value was either too large or too small for an Int32.

• What is the meaning of below errorI have one form and inserting 4 values into Access data base using follow command************************************************************************Dim InsertCmd As String = "INSERT INTO registerationTable ([userName],[password],eMail,telephoneNumber,mobil...
• Thu, 02 Sep 2010 13:49:00 GMT | 2,281 bytes | Answers (1)

• HasRow?

• Is there any features / function in odbc.net which can determine whether a query return any rows or not? I remember I once saw it elsewhere (I couldnt recall now) and I'm not sure whether the HasRow exist or not. If yes how do I use it?Thanks!...
• Thu, 02 Sep 2010 11:49:00 GMT | 253 bytes

• Oracle Connection Error

• Edited by SomeNewKid. Please post code between<code> and</code> tags.Also removed login credentials from code sample.this code give error "unable to load dll(oci.dll) in ASP.NET (Web form) but it is working in VB.Net (Windows Form).Please guide me regarding this Error.========Code===...
• Thu, 02 Sep 2010 11:49:00 GMT | 2,951 bytes | Answers (1)