• .Net ADO's Today Newest Questions & Articles Featured

    • Navigateurl problem
    • Im having problem with accessing Links from the database.I got a link in my DB which isHttp://www.hotmail.com orHttp://www.nba.comIm using Datalist n wen i click on the link,instead of having it as the links up there, it shows mehttp://localhost:8080/default.aspx#http://www.hotmail.comdoes anyon
    • Set index in Gridview
    • Hi everyone,Could someone please tell me how to set the new index as the first row in Gridview?The issue that I am having is that I have a gridview, then I implemented a search featurethen when I type "g", I need to show on the gridview such that the first row containg the string that start with
    • Type Mismatch - Null a suspect
    • I'm getting the infamous Type Mismatch error. I have a hunch that it's likely the result of a Null value. This was a result of upgrading the db from MS Access to MS SQL. Sure, I can insert a empty string in the field and rid the error but I'd rather understand the flaw in my co
    • Displaying image from db to a repeater
    • Hi,Please help me to find a solution for displaying image in a repeater.I can insert image into the sql db in binary form.I want to display that image in a repeater according to the imageid selected using the select query.Waiting for the replyRegardsSabna S
    • Looping Through Directory inserting Files into a DataGrid
    • Hi Guys,I am currently looping through my images directory and it takes forever to show the images. So I want to loop through the directory, grab the files and insert them into a DataSet that can be bound to Paging Datalist.Is this possible? If so do you have any code? Or possible a tutorial?Tha
    • Findcontrol in a Datalist ?
    • HiI want to find a control (a TextBox id="BRO_Username") in a datalist and then set a parameter equal to the controls value. I'm using this in an update statement.But I cant seem to get the value? Here's the code I use to try and find the control's value:dbParam_bRO_Username.Value
    • FoxPro ... ODBC ... Help !
    • Yes I know Microsoft has provided provider for OleDB ... but still I must use ODBC to connect to a foxpro database file. The file is called clients.DBF The DSN created using Microsoft FoxPro VFP Driver (*.DBF). The DSN is called ClientDB. I am using following to connect to the ODBC source... ---
    • Oracle 10g Linked server
    • Hi all,I am trying to access an Oracle DB from SQL server. My environment:- Windows 2000- SQL 2005 Express- Oracle 10g & Client & Oracle Provider for OLD DB 10.2...I linked Oracle from within SQL Management studio. When I try to access Oracle tables I get the error "Cannot initialize the
    • Datagrid custom paging with MS Access
    • Hi thereI have a datagrid control with custom paging enabled - I'm using sql stored procedure that recieves parameters PageNumber and PageSize and returns the correct page viewed. This procedure uses temp tables and everything is working fine. Now I need to do the paging and with Access. Do
    • Mark specific dates in a gridview
    • HiIm making my first asp.net site and would really like to get some help with this problemI have conected my gridview to a Oracletable an have retrived a tabel, so far so good.The second columns is of a data type (long or short), I want the the date to be highlited or marked in some other way "*
    • How do i display a single record that shows data o...
    • How do i display a single record that shows data one record at a time using vb scripting. I know it in javascript it's something like this, but how do you do it in vb?</head><body bgcolor="lightblue"><h1 align="center">Editors by Record</h1name:XMLSPY 5, professional ed
    • DataList question ...
    • HiAssume we have adatalist that is populated from database and every item in it has an associatedID and we would place a check box under each item . Show me the technique of iterating through items in theDataList and finding out if any of them are selected and getting its associated ID. refer me
    • Image in Datagrid column more (need help)
    • Hi, I have a datatable that returns a field with value from 0 to 3. I need to update my datagrid using this field but instead of "displaying" the value, I need to display a bitmap. I suppose I have to use a imagelist for the bitmap, but I don't know how to configure my datagridstyle ? Btw,
    • field truncates after 255 chars
    • i am accessing a string value from an access db query that is longer than 255 chars. the problem: the field in the datareader only shows 255 chars. when i run the query in the access query window i get the entire string. the code is pretty simple: ... Dim cmd As New OleDbCommand( "sp_invoiceText
    • Problem with Gridview Controls value setting from child page
    • Hi,In the parent page I have the following<FooterTemplate><asp:TextBoxID="F_Desc"Runat="server"Width="100px"Text='<%# Bind("Resource_ID") %>'></asp:TextBox><br/><asp:HyperLinkID="HyperLink1"Runat="server"Font-Size="XX-Small"NavigateUrl="Javascript:PopUp
    • Using Oracle with ASP.net
    • I have been using ASP for a few years quite successfully and lately have been looking to upgrade to ASP.net for obvious reasons. My last challenge to prove that ASP.net will cover our needs is to link to an Oracle database, which is where I am having some difficulty. I am only using ASP.net (no
    • Dragging table onto blank aspx page from SQL Server fails where duplicate table name exists
    • I have two SQL Server 2000 databases (on the same server) each containing a table named "Well". When I drag the second one onto a blank aspx page the first (alphabetically) is linked into the page. Any ideas how to fix this? Thanks, Dave.
    • Creating a tped DataSet for dbase files - Parameters question
    • I have an ODBC connection to a folder where a few dbf files reside. In Visual Studio I'm trying to create a DataSet for this table ZIPS with the following fields: ZIP char PROV char CITY char The default Fill and GetData using a SELECT zip, prov, city FROM zips are created fine, no problem.
    • Price field being returned with 4 decimal places
    • as the title says, and i can't figure out why. I have set the attribute DataFormatString to {0:c}any ideas?
    • Timeout error from SqlDataReader even when ConnectionTimeout = 0
    • Hi everyone, I intermittently get a timeout error raised from a loop in which I am iterating through records with a SqlDataReader in order to build a Hashtable. The command object has its CommandTimeout property set to 0, so it should never 'time out', but every once in a while it will
    • I want edit whole grid on single button click...
    • I want edit whole grid on single button click
    • Using _be.mdb Files
    • I have a MS Access database where the Datatables are stored in a file named *_be.mdb (astrisk in place of actual name). It is just the Back End of the Access application. The front end containing all the forms, modules, and queries is stored in a file named *.mdb or *.mde. My problem is, wheneve
    • Export DataGrid to Excel...
    • How to export datagrid into a excel file ?I remember someone told me he can just right click on the datagrid and find an Export to Excel option, but I cannot find it...Can someone help ?:)
    • TableAdapter & Transactions
    • I saw a lot of people were having a problem with this and I found an elegent solution to this problem so I decided to post it. Use the following Example: --- private void BindingNavigator_OnSaveItemClick(object sender, EventArgs e) { OleDbConnection Connection = new OleDbConnection(Properties.Se
    • Dynamically display image from database
    • I have a webpage with a textbox1 and a button. User enters a number and clicks on the button and it will display the corresponding picture from the database.How do I code it in such a way that the code below takes that value of my textbox1 instead of a static image id number of 2?TIF<IMG SRC=
    • DB data into a custom list...
    • Hi, As I've decided to use my own custom collections to get data from my DB backend, to a web service, and then to my client frontend, I was wondering if there is a way to directly fill the objects of my collection without first having to load into a DataSet. Could I override the SqlDataAda
    • How to GROUP SELECT WITH some value & WITHOUT some other?
    • I have a table Customer =========== INT (Identity), Varchar(50), Varchar(50), Varchar(50) ============ ID, City, FirstName, LastName ================= 1 Brisbane Jon Smith 2 Brisbane Allan Parker 3 Sydney James Parker And now I try to find all City WITH customer named 'Paker' AND WITHO
    • Manipulating 2 fields in a datagrid
    • I would like to retrieve field1 and field2 from the datagrid. For each record in the datagrid, if field1 is blank, populate field1 with field2 and make field2 blank. Does anyone have a solution?
    • ASP.NET 2.0: Frustrated trying to populate a TextBox from a pop Calendar
    • I'm trying to populate a TextBox from a pop Calendar. I've tried several example to no avail.Can I update web controls across forms ? For example, can I updateEditTxtExpDate.Text in AddModifyOrder.aspx from Calendar.aspx across ?My Calendar button and textbox are : <inpu
    • Hi everyone :)I was making a very simple sort of l...
    • Hi everyone :)I was making a very simple sort of like a signup page just to experiment around with how to insert records into databases. It basically gets the values fromindex.aspx and sends it tosignup.aspx.The values get passed across nicely however, when it comes to inserting them into the da
    • »» Read More about ".Net ADO"...