I wanna create a ASP.NET c# file named "DBconnect.aspx" where I will provide all my MYSQL database settings. I would like to import these settings without re-entering database details to another page.
Of course have to mention the namespace with Public class but I do need to sample syntax to make this.
I am trying to import the SQL file provided by Elmah into my application, and I don't want to import it into the development machine I use. I want to make it a .mdf file so it can be easily transported to my host. I was wondering if there is a way to do this?
View 7 RepliesI have an assignment which is to import mpp file into database via ASP.NET (C#).
View 2 RepliesI am using VB.Net/ASP.Net 2008 and I have a solution with 3 projects:
1. DAL
2. BLL
3. MainWebProject
anyways because it's a Web Application Project (not a web project) I had to set it up so I could access the Profile using Imports System.Web.Profile in the MainWebProj but I can only access the profile in that project.
anyways I need to access the Profile in the DAL also, and I figure since I can import the Profile in my MainWebProj there must be a way to also import that into the sister project, DAL.
My Issue: I can import a class in Project A but not Project B. Is there import syntax so I can also import the namespace in Proj B?
I have been trying to overcome the well know issue of importing a csv file, nut ignoring the comma's within the quotes. Not every field has quotes, and not every record has comma's withing the quotes. After spending ages looking at various samples and arguments, Im still baffled. I have below a qiuck sample of a file ( we can not change the file at all ) , what i want to get out of it, and the the procedure i am currently working with. Can anyone show and explain how to modify my sub to get the desired results
"Smith, John", "125 My Street ","MY1 25Q", 135.00
"Jones,Fred","Flat 1, 139 Hight Street", "UB8 8UU",798.00
(0) Smith,John
(1) 125 My Street
(2) MY1 25Q
(3) 135.00
(0) Jones,Fred
(1) Flat 1, 139 Hight Street
(2) UB8 8UU
(3) 798.00
[Code]....
I have been searching for some information on how to import my xml file into a series of tables using a mapping file (schema).
View 2 Repliesthis is me once again moving around data access. my problem now hide in the import process of an excel file that would be inserted into sql db.
the problem is the excel file may be updated or changed and i have to periodically import it and perform the process but I still cant check or compare between the two Data Source (excel, sql) as I violate the entity integrity (PK)
i found a kind of stupid approach that each time i want to import the file i will empty the table then re-insert the data, but at this step a new problem raise that other tables are !engaged! with it ... so i will violate the referential integrity (FK)
i looking for solution to compare between two sources for each tuple / row, ignore the existing one and insert the new
[Code]....
i am facing the error
The Microsoft Jet database engine could not find the object 'MyDataFile$'. Make sure the object exists and that you spell its name and the path name correctly.
below is my code, i am exporting my excel sheet in HTML format. in case of importing i am facing the above mentioned error.
[code]...
I facing a problem when I upload a file from my side while the application is running in server.
The error shows below:
'C:Excel FilesStaff Directory1.xlsx' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
I am trying to import a csv file but unable to split the line string correctly.
DIM fields() as String = line.split(",")
Where the sample data is as below
1,"khdaf",2,"hello,world,hi","2154",5412
1,"khdaf",3,"hello,hi","2154",5412
Issue is that when i split first line it gives me array of eight(08) whereas actual columns are six (06)
I am importing a comma seperated, single quote delimited file based off of client specifications. The only problem is now the client is sending apostophes in the file and is throwing off the single quote delimiter.
For Example:
'FirstName','LastName'
'John','O'Grady'
I need to figure out somehow to escape or replace that character before it goes into my OLE dataset import and then handle it before it hits my SQL table. Here is my current process flow:
Save the file to the App_Data using a FileUpload control Build a schema.ini for the ' delimeter Import into a dataset using Microsoft Jet OLE Use a for loop to pick out the fields that I need and build an insert into SQL I was trying to replace the ' with an underscore but then ended up replacing the whole file instead of just the one in the name.
I am trying to import excel sheet, got an error like "
The Microsoft Jet database engine cannot open the file ''. It is already opened exclusively by another user, or you need permission to view its data"
I have given all necessary permissions but no luck..
am importing a text file database in my sql server database in asp.net c#.but i cannot fetch the column name from .txt file which contains a numeric data now what to do?
View 1 Repliesi want to get list of contacts when user enters his yahoo or msn alike emails. Application is build in ASP.NET with 3.5 framework. Solution i've found on this site does not work or require framework 4.0. I don't need solution which costs money or not personally tested by you ones.
View 1 RepliesI've got a simple (inline) ASPX page that is ouputting XML.
I want to import this XML into Excel 2007 using Data | From Other Sources | From XML Data Import.
If I specify the URL for my APSX page Excel opens the result into the Text Import Wizard :(
If I open my URL directly from Notepad, save the content to a file and import that into Excel, its correctly treating is a Xml. why Excel is treating the result as text when is comes from a Url?
Heres the code from the ASPX Page
<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Xml" %>
[Code]....
Is there some simple way I am missing to import an Excel worksheet into a datatable using an OleDBConnection and change what row the header is located on? I have HDR=YES in my connection string and that works great when header is on row 1 but the header is actually going to need to be on row 3. I am using the following CommandText:
SELECT [headercol1name], [headercol2name], [headercol3name] FROM [sheetname]
I have imports.aspx with an ASP:FileUpload function.In my code-behind I have this:
SEPTA_DSTableAdapters.ServiceTBLTableAdapter sta = new SEPTA_DSTableAdapters.ServiceTBLTableAdapter();
SEPTA_DSTableAdapters.RoutesTBLTableAdapter rta = new SEPTA_DSTableAdapters.RoutesTBLTableAdapter();
protected void Page_Load(object sender, EventArgs e)
[code]...
I have a form that allows a user to import a spreadsheet. This spreadsheet is generally static when it comes to column headers, but now the users want to be able to include an optional column (called Notes). My code crashes when I try to read the column from the spreadsheet if it doesn't exist.
[code]...
I have a asp.net website and i need to import address books from yahoo, msn and aol. I have already done gmail import by downloading the google contacts api. But i cannot find the same for yahoo,msn and aol. does anyone know if there's a single dll avilable that can do this? or any other way is fine.
View 1 RepliesI have been asked to create import functionality in my application. I am getting an excel worksheet as input. The worksheet has column headers followed by data. The users want to simply select an xls file from their system, click upload and the tool deletes the table in the database and adds this new data.
I thought the best way would be too bring the data into a datatable object and do a foeach for every row in the datatable insert row by row into the db. My question is what can anyone give me code to open an excel file, know what line the data starts on in the file, and import the data into a datable object?
Is there any deficiency performance if import a lot of name space in Web.config or in every single cs file while it's not necessary to be in all classes ?
View 1 RepliesIs there a way wherein I could import data from multiple sheets of an excel file?
View 2 RepliesI am getting the error while importing the dbf files to access database.It giving "External table is not in the expected format"
View 4 RepliesI've taken over the development of a website for a friend of mine. The original site manager used SiteFinity CMS, and hosted at winhost.com. I'm not changing this, but I wanted to create a local VS2010 project of the site that currently is hosted at winhost.com. How do I go about this? I have exported the site to a ZIP file through the IIS manager, but now my problem is getting that site into VS2010 blank C# Web project successfully. I've primarily worked with Dreamweaver to do site management before this is my first VS2010 site.
View 1 RepliesI have an issue while importing the data froma customized gridview to an excel sheet .It prompts me to save the excel sheet and excel sheet is getting saved on my machine but while opening the excel sheet I am getting an error as follows and it opens as blank.Could some one tell me what the issue is.I have given the complete code to import excel sheet and error while I open it as well. In-addition to this suprisingly another issue too I have encountered when I am trying to export.
While I am trying import by clicking on Import only the datas in the CurrentPage is getting exported and remaining datas are not..I mean ..If my GridView shows 50 records at a time only these records are getting imported and remaning records are not
public static void ExportToExcel(DataTable dtFull)
{
string fileName = string.Empty;
OpenFileDialog fileDlg = new OpenFileDialog();
fileDlg.DefaultExt = "xls";
fileDlg.Filter = "Excel files (*.xls)|*.xls";
fileDlg.CheckFileExists = false;
// fileDlg.
fileDlg.Title = "Choose XLS";
if (fileDlg.ShowDialog() == DialogResult.Cancel)
return;
fileName = fileDlg.FileName;
try
{
if(System.IO.File.Exists(fileName))
{
FileStream fs = System.IO.File.OpenRead(fileName);
fs.Close();
}
}
catch
{....................