I am working on an asp webform that pulls from an ODBC datasource then puts the data in an sql server. Once the data is in the sql server several queries pull data from it to provide information for a report.
This is an example of what I am talking about private void ODBCpdEmployeeAb()
{ [code].....
The first part gets the data from the ODBC connection and the next part stores it in an sql server table.
I have set the primary keys on my SQL server tables already but it just loads an error page now when the app runs due to duplicate id's
Is there a way to append the most recent data from the ODBC table to the sql server ?
I am working on an asp webform that pulls from an ODBC datasource then puts the data in an sql server. Once the data is in the sql server several queries pull data from it to provide information for a report.
This is an example of what I am talking about
private void ODBCpdEmployeeAb() { DataTable dt = new DataTable();
[Code]....
The first part gets the data from the ODBC connection and the next part stores it in an sql server table. The problem is I have these methods in the page load event of the webform so everytime it loads it just puts the exact same data in the sql server table which would then provide incorrect information on the report.
Is there a way to append the most recent data from the ODBC table to the sql server ?
my webserver is in the DMZ. The Database in the intranet. For connection from webserver to database the following entry is made in the odbc connection "TCPIP BCAST=NO;HOST=Intranet.Firma.local,Intranet_Spiegel.Firma.local,Intranet_Arbiter.Firma.local;PORT=2639}"
how to get this options in the connection strings working, or how i must modify the entitiy framework connection string to use the odbc entry?
I have been developing my ASP.NET web pages to access the SQL database locally on my personal computer while using a "SqlConnection", but to access my SQL database on a host server, I must use a "OdbcConnection". I am mostly using LINQ to access data with a DataClassesDataContext, but sometimes I must use ADO with SqlConnection and SqlCommand. What must I do to convert my C# code in order to access data with ODBC 3.51?
I have created a CSV file on the server and want to send it to the user using the following code:
Dim strPhysicalPath As String strPhysicalPath = Server.MapPath( "CSV/" & PathVirtual) Dim objFileInfo As System.IO.FileInfo = New System.IO.FileInfo(strPhysicalPath) Response.Clear() Response.ContentType = "application/vnd.ms-excel" Response.AddHeader("Content-Disposition", "attachment; filename=" & objFileInfo.Name) Response.AddHeader("Content-Length", objFileInfo.Length.ToString()) Response.WriteFile(strPhysicalPath) Response.Flush() Response.End()
This seems to work fine except when the downloaded file is viewed in Excell the html code behind the page from which it came is also appended to the file. Does anyone have any idea why it does this?
System.Data.Odbc.OdbcException: ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on '127.0.0.1' (10048)ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on '127.0.0.1' (10048)
what is the best way to append data onto a file download? I figure that i can make my own class that implements InputStream and just consolidates two input streams (the file first, my additional data to append second.) but is there an existing view class that i can use to just return an InputStream or will i have to roll my own view class as well?
Ive done it before, but cant recall and cant find the code..how can i append the current sites name ex. (http://www.mysite.com/) to a custom file name that im creating?
Im building a string that will contain the domain name like about plus my custom file name at the end like so
I want to create a function that will make a treeView out of link buttons. Then I want to tie all the link buttons to one click event. So each time the user does somethingI will append the users name to the current linkbuttons if the user clicks one of the link buttons a click event is raised and I can extract the text of that button.
Here is an example:
Nick ...user does something...now the link string says Nick > Jeff ...user does something...now the link string says Nick > Jeff > Charlie and so on.
Now I want to give the user the ability to click one of these link buttons (there are 3 in this example). If the user clicks one of the buttons a click event is raised and I can extract the name out of the text of teh link button.
is appending to body but js codes are always requesting some js files didn't load or some functions are below of the script. How can i append scripts that i generated dynamically to the bottom of body?
declare @stateQuery as nvarchar(200) if @stateid is null set @stateQuery='' if @stateid is not null set @stateQuery='and tbl_city.stateid ='+cast(@stateid as nvarchar(10)) set @length=(select top 1 len(dbo.Tbl_city.cityName) FROM dbo.tbl_city INNER JOIN tbl_cityinfonew ON dbo.tbl_city.cityId = tbl_cityinfonew.cityId where (tbl_cityinfonew.language =@language )+cast( @stateQuery as nvarchar(100)) order by tbl_cityinfonew.createdate desc)
When appending parameters to an ADODB.Command should the parameters add to the command text. When I get to the point where it sends to the database the command text of the adodb.command is "{ call PKG_WORKPLAN.ADD_PROJECT(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) }"
I then get a ORA-06502: PL/SQL: numeric or value error: character to number conversion error ORA-06512: at line 1 error. I think i may be getting it from the question mark.
Also is there any way to what sql is inserted if that isn't it.
I can't stand appending a concatenated string. Isn't that the purpose of using a stringbuilder? This is another developer's code and I am adding onto another part of it, but I want to change this too. Or should I just let still waters lie, as the saying goes?
How can I prevent Visual Studio from naming the classes for new pages that are in folders from being named with the folder name? Does this method not set "right" with anyone else?
I am developing a simple rating system for my employer's profile based web-app. Here is my problem:
The actual page is domain.com/review.aspx?user=username, but I use the url-rewrite module in IIS to use domain.com/username/review The page contains a repeater control that displays reviews for that username, as well as a form for people to create new reviewsWhen the form is submitted, asp.net re-appends the (hidden) querystring to the url on postback.The post-back url is now domian.com/username/review?user=username&review, causing the page to break if refreshed.
Is there any way to keep asp.net from re-appending the querystrings that are actually already present, but re-written with IIS
Live link <- submit a review, and then refresh the page (edit) by clicking in the address bar! Beautiful yellow error message.
I have 40 Drop Down Lists that I want to fill using an XML file. Based on what is in the XML file i will add an item to a specific Drop down list. I don't want to manually loop thorugh each control by name. the ids for all of the controls start with DDLSession and then they have a suffix such as A2 or B4. What I want to do in the C# Code is ads items dynamically to the control like this:
I'm new to asp.net. I have an exercise about datagridview.
Basically it's like this, I created a sql database in visual studio, added some tables and records. I added a gridview to my page and change the datasource to 1 of my tables. It displays every thing fine.
Now my exercise is, I need to add a new record to that table from a textbox control and button submit, and display in gridview after page reload.
I have developed an application which has a database [access] and i have a gridview which showsthe records from the database. Now i want the grid view to be updated with some additional recordswith out removing the exesting records.
I fear this has been beaten to death, but I'm still struggling with the problem of reading Excel files in my ASP.NET application that has recently been ported to Server 2008 and 64-bit.Many posts I find point to the existence of 64-bit Microsoft drivers here:here and here. My concern is the warnings I'm also reading about these not intended "As a replacement for the Jet OLEDB Provider in server-side applications" possibly for thread-safe reasons? This IS a server-side application and while Excel uploads aren't hundreds-of-times-a-day ocurrances, they will be done by customers.I know there are also commercial libraries available and while I'm opening to considering them I do worry about the 'revision chase' and not getting burned by them going belly-up (it has happened to us before).
that works fine. but while using MSaccess and the datatype for of some table is Memo than how could I use parameter for that i am using System.Data.Odbc. cos here it is easy to do SqlDbType.Nvarcha cos there is shows Nvarchar but not Memo
