I'm using a DataReader to display informations stored in a table. I created Two button to go to next record and to go back. In VB6 I used this code :
While Not Recordset1.EOF
Recordset1.MoveNext
End While
In ASP.NET I didn't find a way to do like it, because DataReader hasn't the EOF property.
EDIT :
While Not Recordset1.BOF
Recordset1.MovePrevious
End While
How can I convert this last code (VB6) to ASP.NET?
I'm having trouble with something that is (or should be) fairly straight-forward.
I have a recursive method that traverses an XML file, writing out the element tag names and values.
This is a snippet from the XML file:
[code]
<root>
<all_companies>
<company_group company_group_ID_attr="1">
<company_group_name>Cleaning</company_group_name>
<company_group_ID>1</company_group_ID>
<company company_ID_attr="2">
<name>Bloomburg</name>
<company_ID>2</company_ID>
<Address>blah blah blah</Address>
<employee_refs>
<employee_ref>4</employee_ref>
</employee_refs>
</company>
<company company_ID_attr="4">
<name>Morris</name>
<company_ID>4</company_ID>
<Address>blah blah blah</Address>
<employee_refs>
<employee_ref>3</employee_ref>
<employee_ref>1</employee_ref>
</employee_refs>
</company>
<company company_ID_attr="7">
<name>Ajax</name>
<company_ID>7</company_ID>
<Address>blah blah blah</Address>
<employee_refs>
<employee_ref>4</employee_ref>
<employee_ref>2</employee_ref>
</employee_refs>
</company>
</company_group>
</all_companies>
</root>
[/code]
I use the following XPath expression to access the first <company group> tag:
"root[1]/all_companies[1]/company_group[1]"
On the first call to the recursive method ("swrite_for_select_certain_stuff"),I see with the debugger that I reach the <company_group_name> tag. A recursive call at that point takes me to the text node within the tag ("Cleaning"), but it is a text type node (not an element), so it returns without writing anything to the output stream.
On return from that second call, things go wrong. The Iterator within the while loop returns false for the MoveNext method, when it should have moved to the <company_group_ID> tag (or so I think it should).
Am I missing something here?
OS is Win XP, and .NET is version 4.0.
My code is as follows:
[Code]....
I have created an asp.net web page that allows one to query a SQL Database and returns a recordset in a bound gridview. My question is how can I provide a means for the authorized webpage user to print the recordset out, in like a cvs text file? I need to be able to allow her to choose her printer, like in a regular print dialog box, and then to print the whole recordset, not just the page she's on.
View 3 RepliesIt may not suitable forum to post this.I'm a ASP.NET developer, I'm just doing a small corrections in a site developed in classic asp.i want to know how to idendify whether the Recordset has records or not? like in asp.net we use dt.Rows.Count In Classic ASP?
View 9 RepliesI've tried to do my homework on this...
I'm migrating a site from classic asp to asp.net 4.0
Before I rework all the code, I wanted to get clarification that the way i think my database code should be updated is fairly correct. (I'm using SQLClient objects)
First, when old code would use forward only recordsets or access single record/value, I'm fairly sure i'd use SqlCommand and SqlDataReader. That is pretty straightforward.
Now, when my old code navigates a recordset (movePrevious, find, etc.)... I believe the way to go is with SqlDataAdapter and DataTable to retrieve the data and DataView to filter/find/navigate the data.
I'n looking to do a quick migration... i don't want to get too bogged down in the new entity framework... so - just trying to stick with similar objects/logic.
I know this is one of those questions that doesn't really have a right/wrong answer... and I think that is part of my problem in finding an answer - there are so many.
I gather from what I have read that the VB6 adodb.recordset is not the best way to work with database tables in VB NET
I have a program created in VB6 that I would like to upgrade or re-write in VB NET
What I am finding difficult to understand or find is the answer to what I use in place of the VB6 adodb.recordset
I have found the code to make DATASET and OleDbDataAdapter and can open an Access or SQL table
But what I do not find or follow is how you move through the rows of a table
With the adodb.recordset you could Do While Not EOF and MoveNext
What is the equivalent to that in VB NET without using adodb.recordset?
based on the code below how can I tell if the recordset returned is empty and if the grid is emptyIf data is empty how can I tell data.Count(); and data.RecordCount(); generate errorsHow can I tell if the grid is empty, has no rows or if the rowcount = 0
var db = Database.Open("StarterSite");
var sqlQ = "SELECT * FROM table1 ORDER BY Name";
var data = db.Query(sqlQ);
var grid1 = new webgrid(data);
grid1.gethtml();
new to asp.net and mvc, sorry if the question sounds dumb. I currently have a model (a Linq type) that get data from a table. I use this model to do a Linq qery and display all records in a listing table.I would like to do exactly the same but using a SQL command/query rather than Linq as I'm much more confortable with "standart" SQL. I now need to join tables and return specific columns with custom names as some columns have the same name in the join of my query.If you have another idea (create a stored procedure to be in control of the SQL and then use Linq to call it, for example), I'm open to sugestions.In the view, I loop all records doing: foreach (var item in Model) {}Not sure if this could be important o note
View 2 RepliesI have run into the issue on DataSet.WriteXml method. Apparently, if any row in a column in the DataSet has a null value, the entire column/rows will not write out in the xml file using the method DataSet.WriteXml. So, as terrible as that bug is, I need to send the data another way. Does anyone have any thoughts?
Here's a stored procedure I created that uses another stored procedure inside it to return a value:
[Code]....
Note the 'exec dirinfo.dbo.d_searchempbyname @TicketSubName' part. That stored procedure will return a single record. What I need is to get a single column from that recordset (in this case, the email address of the employee), and store that value in a variable.
Hi. On my webpage, I have a listview that has a field called BookId. I also have a Detailsview with an ID field. When I add a new record on the listview, I would like to populate the BookID from the Id on my detailsview (there is a one to many relationship between the 2 ids).
View 1 RepliesWe have a fairly large system involving multiple applications running on Windows, written in .NET. These include a number of web applications using ASP.NET.
We have a number of unrelated web applications written in LAMP - Linux/Apache/MySQL/Php.
The greatest advantage we've seen in ASP.NET is the ease with which code can be shared between web applications, win-form applications, windows console applications, and windows services. We have signficant code in .NET assemblies that are shared across all of these environments.
Apache/Php has some significant advantages over ASP.NET as a web programming environment, but if there is anything in it that is equivalent to .NET when it comes to integrating code that is shared across non-web applications, I'm unaware of it.
What's the equivalent of PHP's $_FILES variable in C#? Or at least something that accesses the files in the same way. I've got an upload form that I can't change and need to find out how to get at these files.
View 3 RepliesWhat is the .Net equivalent of a JSP page?
View 4 RepliesI am making an Asp.Net application which does the following on the client computer:
Establish a Connection. Check client's cpu usage to see if it is idle or not.If the client is idle it starts executing a c application.While executing the script if client starts doing something (also checked by monitoring his cpu usage) stop signal is sent. Start signal is again sent to the client if he is back to his idle position. If the client is Ubuntu, I use ssh and execute what I want to.What is the way of doing this in Windows without the root access?
Can you let me know the equivalent of C/C++ #define in asp.net?
View 5 RepliesWhat is the equivalent to function mid in ASP page?
View 2 RepliesI have some code I would like to execute very early in the lifecycle of a call to an ASMX function. For our ASPX pages, this code is in the Page_Init() function on a base class, from which all our ASPX pages inherit.
Is there an ASMX equivalent to the ASPX's Page_Init() function?
Better yet, is there an ASMX lifecycle diagram like the ASPX one? http://msdn.microsoft.com/en-us/library/ms178472.aspx
If there is an ASMX equivalent to Page_Init(), I assume I can implement code in a common base class, from which all my ASMX classes can inherit, correct?
I have been using this tag ActionLink().Replace in asp.net mvc 1.0:
<li><%= Html.ActionLink("_place_", "Index", "Home").Replace("_place_", "<div id='homeOff'></div>") %></li>
I upgraded the project to mvc 2.0 and now this .replace() does not work any more. I was looking for equivalent code for this.
I use T4MVC inside my asp mvc projects, mostly because it's brilliant. Is there an equivalent for asp webforms?
View 2 RepliesCan anybody tell me what the LINQ equivalent of this SQL would be?
[Code]....
But it returns none of the records that are returned by the SQL.
I want to know what is equivalent to Page Error() in MVC which we use to have in simple asp.net, which is called when any invalid character is there in the input string.
I donot want to use [ValidateInput(false)] option for this. which I can handle invalid characters in the input.
I am looking for an alternative of these two functions in asp.net/c#.
if(function_exists('foo'))
{
$returned = foo($bar);
}
if(class_exists('foo'))
{
$fooclass = new foo($bar);
}
We've been using IScriptControl to tie javascript objects to our UserControls and ServerControls, and it's worked fine.The problem is that ASP.NET seems to provide no method to tie a javascript object to a Page. Up to now, we've been putting plain functions in the global namespace, but I am developing a serious allergy to that practice.It'd be easy enough to wrap our functions into a javascript class, and to include the javascript file on the page, but how to instantiate the object, how to reference it from callback events, and how to pass data to it from the code-behind, I haven't figured out.Or rather, the methods we've been using up to now (hidden fields, emitted javascript strings, etc.
View 1 RepliesI can't see a reason why we couldn't do the same thing Heroku does for an ASP.NET website.
View 3 Replies