I wrote a console application that queries all data from a table in MS Access (I know, but I inherited it) to a SQL table. It runs every morning as a scheduled task. The fields between the two tables are not identical. Currently I select all data from the MS Access table, loop through the dataset and insert each row into the SQL table. I also write a quick log file in the process. It works, but it's not fast. I would appreciate any ideas that you may have to improve the process.
Is there a fast way to get the scheme, host, port (only if not 80) and application path in ASP.NET?As far as I know, I need to assemble the following pieces:
Request.Url.Scheme Request.Url.SchemeDelimiter Request.Url.Authority (although that will probably always include the port even when it's 80) Request.ApplicationPath
A web site has just been created with VB as the programming langage and contains only a couple of short webforms. What would be the simplest and quickest way to change it from VB to C#?
Let's imagine you have an asp.net page in front of you full of input elements, user controls and panels etc. And you are asked to modify a specific textBox and you do not know where that textBox stands in your project. Most of the time I use FireBug and try to see the Id of that element but it is not the best way all the time. So, What is the fastest way you believe that can be used to locate the source file that houses a specific html element in your web project?
i am trying to export gridview into dataset using Datatable but if u used "Microsoft.Office.Interop.Excel" the datatable showing me sum error. is there any other way to export gridview in dataset???
I am trying to implement ajax auto complete control using a standard webservice. inside webservice a table adapter is called which will return a dataTable containing a single column. this table adapter uses a stored procedure with following script
I am setting up a web ap where I need to take a value from a forms input box and populate an asp:textbox. I've tried several javascript solutions that haven't worked. I assume this is because an input box is run on the page and th asp:textbox is run at theBasically I have some code (that took forever to find ) that takes the values from the url ex.www.mysite.com?value=thisand places it into an input box so I can do some other things to the value. but I need to automaticly copy this value into an asp:textbox to use for a gridview lookup.The code is written in javascript. so if anyone knows how I can copy the value from javascript variable to the asp:textbox that would be the best.
how I can transfer the text from the txtText1 Textbox to the txtText2 one when I press the btnCopy button, but preferably in the codebehind so that I can change the text before actually copying?
I'm creating a new solution to print a grid of my system. I think that is the best solotion, but....I need to copy some TemplateFields between two gridviews, but on the DataBind of the new grid, trows the error "the databind method like eval() only called on context control templatefield". I have Eval() instructions and I can't remove it!.Follows the exactly code:
writing a web-based application; I would like to do this in such a way that:All transactions go through a web services API (something like http://api.myapplication.com) so that customers can work with their data the same way that we do / everything they can do through our provided web interface they can also do programmaticallyA class library serves as a data layer (SQL + Entity Framework), for a couple of design reasons not related to this questionProblem is, if I choose not to expose the Entity Framework objects through the web service, it's a lot of work to re-create "API" versions of the Entity Framework objects and then write all the "proxy" code to copy properties back and forth.What's the best practice here? Suck it up and create an API model class for each object, or just use the Entity Framework versions?Any shortcuts here from those of you who have been down this road and dealt with versioning / backwards compatibility, other headaches?Edit: After feedback, what makes more sense may be:Data/Service Layer - DLL used by public web interface directly as well as the Web Services APIWeb Services API - almost an exact replica of the Service Layer methods / objects, with API-specific objects and proxy code
I've got a Gridview which has a datasource to a particular database.
I've got a DetailsView which has a datasource to a table in another database.
when I select a Gridview row, I need to populate a field in the DetailsView with the Primary Key field (showing in the Gridview) from the Gridview.
Can this be done (if so, how?)?
Also (but not as important) :
If there's no field related in the second table, I'd like it to come up in Insert Mode - if there is a field related, I need it to come up in Edit mode
