I have a method that uses Microsofts Data Block to get me a value from the database. This returns a DataSet. I use this kind of data as string a lot using the following:
ds.Tables[0].Rows[0].ItemArray.ToString()
The problem is: I do not want a string now. I need a int, because the value is a int which I have to increase with one and then return back to a tring again to put in a disabled textbox.
I just need to know how to get from a DataSet to an int or from a String to an int.
I am pulling 40 records from a MS Access database, and displaying them in an .asp page.. The majority of times, there are no records to display in the last 10-15 records, so they show up as a blank space on my web page, pushing the rest of the content further down.Is there any way that I can elliminate this?
I have a DataGrid which has checkbox columns. The data source is a run-time created data set that I store in a session so I can rebind it during postbacks. I don't have a database or xml file, etc.if it's possible to edit a dataset directly? So when I click on a checkbox it will change the value in the dataset and store it back into session? If this is not possible how can I use arrays or vectors to temporary store my checkbox statuses? I guess it's not possible to have one DataGrid have more than one datasource
Am putting a web front end over an existing SQL application, creatind a ado recordset which is to be displayed in a table on the screen, however when the page runs the recordset returns correctly however only the first two columns have data in, the remaining columns in the table are blank.
Have to use both an sqlview and base sql select statements for the recordsource both the same result. I know it is not a permission problem as I can run the query in sql with the same credentials ok.
I have a DataGrid which has checkbox columns. The data source is a run-time created data set that I store in a session so I can rebind it during postbacks. I don't have a database or xml file, etc.
I am wondering if it's possible to edit a dataset directly? So when I click on a checkbox it will change the value in the dataset and store it back into session? If this is not possible how can I use arrays or vectors to temporary store my checkbox statuses? I guess it's not possible to have one DataGrid have more than one datasource.
i need to use the returned value from a database in my code. it is not to be displayed on a aspx page. I can connect to a database and return the one value i want using SQL SELECT.....FROM.....WHERE...... condition. this is returned as a dataset.
Is there anyway i can return this value from the database as its real value as there is only 1 record? If not how can i retrieve this 1 value and use it in my code? Do i need to loop through the dataset and return it as a string? I want to retrieve 4 values from 4 difference database tables and them up in my code and then return the total value to a different database table.
I have a web interface where the user types in ID's one at a time. After an ID is typed in, a button is clicked and the button click event has code that does a query and returns a data reader and then appends the data to a dataset that is built in the Page_Load code in the if(!isPostBack) block.
When I try to add a row in the button click event code I get an error saying that "Object reference not set to an instance of an object". I'm saving the dataset in a Session object and then restoring it in the else clause of the if(!isPostBack) block. I've pasted code below, please help. I'm relatively new at asp.net development but have lots of asp and ado experience. Code:
I have two tables: one table forms the header columns and the other table is in an iframe returning the results of an sql query. The query works fien and returns the appropriate data but the rendering of the columns in the top table does notmatch those in the iframe table, even though they are supposed to be the same width!!
The iframe table has a scroll bar and the data returned sizes each column cell dependant on the amount of data returned regardless if i stipulate a set width!!
As you can imagine this is visually poor as the table columns are not correct for both tables!!
I have an insert record form that posts fine to a db which automatically creates an ID how could I get the next page to do a preview using the ID just created by the DB to go to the right record?
I have a .asp page which lists a date, then a bunch of record lines for data that falls within that date, then the next date and it's bunch of data record lines. e.g.
Ship Date: 04/06/04
Data xxxxxxxxxxxxxxxxxxxxx Data xxxxxxxxxxxxxxxxxxxxx Data xxxxxxxxxxxxxxxxxxxxx Data xxxxxxxxxxxxxxxxxxxxx
Ship Date: 11/07/04
Data xxxxxxxxxxxxxxxxxxxxx Data xxxxxxxxxxxxxxxxxxxxx Data xxxxxxxxxxxxxxxxxxxxx
What I want is:
Ship Date: 04/06/04
1: Data xxxxxxxxxxxxxxxxxxxxx 2: Data xxxxxxxxxxxxxxxxxxxxx 3: Data xxxxxxxxxxxxxxxxxxxxx 4: Data xxxxxxxxxxxxxxxxxxxxx
Ship Date: 11/07/04
1: Data xxxxxxxxxxxxxxxxxxxxx 2: Data xxxxxxxxxxxxxxxxxxxxx 3: Data xxxxxxxxxxxxxxxxxxxxx
How can I get these numbers printed againsts the records ?
I want to download record set from my SQL database as csv format but in ZIP file .I can download as a csv file now ..But i can't put that in zip file and download.
how to deal with multiple recordsets on the same page? It's gotta be something small and clear so I could understand. Somewhere I've read that multiple recordsets are not allowed when using Microsoft Access Database?
I am looking to have some sort of SQL Trigger maybe? I have a field called 'dateActivated' and 'isActive'I'm looking to somehow say when dateActivated + 6 months then set isActive = false. I want this to be automatic. I am using ASP/VBScript if this somehow matters.
I have a form on an asp page which is used to add additional users to the DB, i.e. adding a UserID (PK on table), Password & Email.
The companies are allowed a max of 3 users. If the company only has the default 1 user and wishes to add another 1 or 2, then the form displays the current user details, not in text boxes as this is not an adit data form. The additional user/s can be entered into 1/2 rows of text boxes, user 2 & 3.
If they decide to add 2 new users, how do I add the additional 2 records to my db table on submit ? Code:
i am tryin to run a search on a db and am using a like statement which works fine but i want to select what it finds and also the next 9 records any idea on how to do this
Is there any way to change the following code so that when it's the second last record in the set it doesn't put UNION ALL at the end? Basically, is there a way of saying:
if SecondLastRecord then
I don't know how many records there will be, so I can't count down from 7 or anything.
Every time I try to ADD a new record from my asp page to SQL table, I got this error:
Microsoft OLE DB Provider for SQL Server (0x80040E2F) Violation of PRIMARY KEY constraint 'PK_Cancelled_Classes'. Cannot insert duplicate key in object 'Cancelled_Classes'
I had a problem that happen once only but i do not want it to repeat again. It happen when i retrieve data from my database. The process can't complete and show error 14, Out of string space. I suspect the recordset object had reach it limit that why it generate that error message but what can i do to prevent this from happening
I have a siple script where I add a new row in a table which has also a autonumber field. Adding the new row I am trying to get this value of the autonumber field and put it in session, but can not seem to figure out how. I tryed to open a new recordset and pull it out but does not find the record I just added.
The only database connection I have ever made using ASP is to an SQL2000 Server. I was just wondering if someone could provide me with a nice simple script opening a connection and recordset to a MySQL database and providing a valid connection string.
Trying to learn a little asp and am trying to have my form (when the submit button is pressed) put the value in a field in my database. it worked the first time, I typed in the word testing and clicked submit.
now whatever I put in there it creates a new field with the word submit. Can someone tell me what I'm doing wrong here? I'm positive there's something wrong with my code here. Code:
If Request("submit")="Submit Questions" Then Set questionsubmission=connectionToDatabase.Execute("INSERT INTO kitchen_questions(questions) VALUES('" & database_select("questions") & "')") End If
I'm looping through a record set and want to treat the first record differently. I've got a counter that I check to determine if its the first iteration through the loop, but I was wondering if there is recordset property that would indicate the record's position in the record set.
i need to use the same record set in my page twice. some optimization issue [img]images/smilies/biggrin.gif[/img][img]images/smilies/biggrin.gif[/img]. i have arecord set like this
Code:
set newsrs=createOBject("ADODB.recordSet" ) newsrs.Open newssql,cnn,3,3 and i wanna use this twice in the same page Code: do while not newsrs.eof newsrs.movenext loop can any body tell me how? coz when i do it the second isnot working [img]images/smilies/rolleyes.gif[/img]
I didnt know what to title this, so please bear with me. Trying to learn a little asp and am trying to have my form when the submit button is pressed put the value in a field in my database.
it worked the first time, I typed in the word testing and clicked submit. now whatever I put in there it creates a new field with the word submit. Can someone tell me what I'm doing wrong here? I'm positive there's something wrong with my code here.
Code:
If Request("submit")="Submit Questions" Then Set questionsubmission=connectionToDatabase.Execute("INSERT INTO kitchen_questions(questions) VALUES('" & database_select("questions") & "')") End If
i use access database and made add record page and it is added on the database then i made another page to add on another table on the same database it is not working i donot know why,and the problem from me or from the server setting???
iam having problem ,relating to update a column in Access file in ASP 'Change' is column name , rs is recordset object ,and i want to update the values in 'Change' column by return values from a function .Iam using vb script in asp
rs ("Change").value = function() this is generating error, and won't work