I've pretty much gotten the hang of importing data from a database onto a website using asp.net, now I want to do the reverse.I want a site that the user logs into and makes 4 different selections from 4 drop-down lists and those choices are recorded onto the database. I've worked out the log in part (it was actually really easy...) but I wanted to know a good source to learn about exporting data.
I am trying to insert data from excel file into sql server database table. which is working fine.. But when i tried it in table which has primaryKey As Autonumber and date as getdate(). its not inserting values in rows?
View 10 Replieshow to import data from notepad to sql database.
View 1 Repliesi am developing an appilication using asp.net 3.5 with c#.net and SqlServer 2005 as backend databse.
in my application i have to import the data from excel file to database. the fields in excel file and fields in databse table are same. i just want to import all data to that database table.
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 am getting the error while importing the dbf files to access database.It giving "External table is not in the expected format"
View 4 Replies i am currently working on importing excel sheets into my database.
SqlBulkCopy seems to be working fine, when i whole import the data over.
But i can't do automated validation (i.e. checking for identical data in the database & etc, i am stuck!) i can import the excel sheet data a line at a time , and perform automated validation check on them.
My prob Is I have Excel files in my folder i need to Store the Records into Database Table. iam using VS.2005,c#.net,Asp.net ,Mysql 5.0
View 1 RepliesI'am developing a commercial website using visual studio.net 2005 and sql server 2005, where i have to import contacts from microsoft outlook 2003 into my web application, so i have searched a code, but it is a console application where it displays the contacts in the command prompt, but i have to retrieve it to my database application in an asp.net application becoz im working in asp.net2.0
the code which i have used to retrive the contacts from the outlook as a console application is follows,
Imports System.Reflection
Imports Outlook
Module Module1
Sub Main()
Dim oApp As New Outlook.ApplicationClass
oApp.AnswerWizard.ClearFileList()
oApp.ActiveWindow()
Dim oContacts As Outlook.MAPIFolder = DirectCast(oApp.Application.ActiveExplorer().Session.GetDefaultFolder(Outlook.OlDefaultFolders.olFolderContacts), Outlook.MAPIFolder)
For Each oContact As Outlook.ContactItem In oContacts.Items
Dim FN As String = oContact.FirstName
Dim MN As String = oContact.MobileTelephoneNumber
Console.WriteLine(FN)
Console.WriteLine(MN)
Next
Console.ReadLine()
I've used mvc for a few weeks now, and just realized that my controller constructor is invoked on every action, and that's where a model is typically instantiated in the examples I've seen, so the model never lives beyond one request. I have older third party db and it seems that some judicious in-memory state management would make sense in my intra-net app. It seems like a true classic mvc app ( non-web oriented) would allow for retention of model instances in-memory (one fundamental repository behavior is in-memory collection - re: M.Fowler). I am not able to use Entity Framework, and a little curious if it does some caching instead of always immediately persisting to db, thereby providing that repository behavior. Do I have to save my model instance to the ole Session / TempData object to retain it in memory across *numerous* controller actions? Or does this implementation absolutely require some other mechanism like NHibernate? Seems like just keeping something
View 1 RepliesThis may be due to a lack of understanding of what's going on under the hood or simply a lack of understanding of threading in general. When a user logins I need to run some tasks that call web services to update data in my system. Since the services could take a considerable amount of time I thread the entire process. However, even though I think I'm running the whole series of tasks in a thread separate from my application, my application waits until the called function is finished before it proceeds.
WindowsIdentity identity = WindowsIdentity.GetCurrent();
Manager manager = (Manager)Session["Manager"];
ThreadPool.QueueUserWorkItem(new SafeWaitCallback().Call(identity, delegate(object noCallBack)
{
manager.RunAccountUpdater(identity);
}));
The application hangs until the function "RunAccountUpdater" is finished and the callback occurs. What am I doing wrong/not understanding?
I am battling a strange error. I have a form, formA, that has a modal popup extender to show a panel containing a gridview. One of the columns on the gridview is a link button that launch a new form, formB, in a new window (ie. the link contains target=_blank).
The code runs as expected. That is, the modal popup displays the grid and clicking the hyperlink launches the page in a separate window. When you close the new page's window, as expected formA is still displaying the modal popup. If you close this modal popup it goes away as expected. Now, the wierd part. If you click on a control on FormA that causes a postback, the load event fires, but the postback event (ex button_click) handler is never called. The app is essentially hung. The only way to regain control is kill the application. This hang only occurs if you click on the hyperlink. If you just open and close the modal popup there are no problems.
I've created a new web application in Visual Studio 2008. Then I added a button, and in the Button1_Click event I put a redirect statement to a website. This is the only code I've added to the default app. But when I run this application on my development server and click on the button, a browser window opens and then permanently hangs without showing the page content.This is a simplified version of a problem I'm having in another app. I can't get past this. Why does this resonse.redirect statement cause the browser (I'm using IE8 and Windows Vista) to hang?
Protected
Sub Button1_Click(ByVal
sender As
Object,
ByVal e
As EventArgs)
Handles Button1.Click
Me.Response.Redirect("http://www.microsoft.com")
End
Sub
I'm hoping someone else has experienced this and has some suggestions. The actual dcms process goes pretty quickly, but in between projects it hangs after printing: Building: XXX.YYY.ZZZ (Debug) After a few minutes (been 10 so far on this current run), it jumps to:
Performing main compilation...
/Library/Frameworks/Mono.framework/Versions/2.10.1/bin/dmcs /noconfig "/...
Build complete -- 0 errors, 0 warnings
Building: XXX.YYY.ZZZ (Debug)
Then hangs again for another few minutes. This is a sln file with 29 csproj projects in it that was originally created in Visual Studio 2010. I'm wondering if there is a better way to set this up - potentially a native MD file format?
I've been writing an app using the awesome new Razor view engine and for the most part, things have been great.
One issue I keep running into, however, is that if I should happen to write invalid code, such as referencing a null property or even a non existent property, rather than throwing an error, something happens in the background that causes the browser to wait and wait and wait and if I do not cancel the browser's request quick enough, IIS will simply hang.
It seems as if it enters some sort of loop. CPU usage goes up (though not terribly high) and restarting IIS via either GUI or iisreset command seems to take abnormally long (presumably while it waits for the process to safely shutdown).
This also happens for other invalid code scenarios such as failing to close a code block with a closing brace.
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 need to populate a database (SQL Server) with some data from a templated excel document.Here are some approaches:
A) User upload a file.xls or file.csv that the server reads, checks and updates the database (cons:the uploaded file might be too big. file.* needs to be in correct format)
B) User downloads a tool.exe to read and upload file.xls (cons: maintenance of the tool.exe)
C) Use of a web service in excel? (don't know how to do it) but
this article might give you a hint
Which one is the best to use? Are there any others?
I developing a application in Asp.net3.5(C#) and Sql server2005, my problem is that i have to Import data from diffrent-2 data sources like MS Access, Oracle, ODBC, XML to my Data base(in Sql server) using C# code. I don't know any thing about importing data from these data sources.
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
{....................
I have a table with 100 records. I need to import extra 50 records in the same table. So from 101 to 150 records should insert the data which is present in excel Simply I want to import 50 records from Excel to Table without disturbing the first 100 records.
View 5 Repliesi am following article in aspsnippets to upload excel file ,it is working fine for 2007 format of excel but displaying error "External table is not in the expected format." for 2003 format
<add name = "Excel03ConString" connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties='Excel 8.0;HDR=YES'"/>
<add name= "Excel07+ConString" connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties='Excel 12.0;HDR=YES'"/>
string extension = Path.GetExtension(FileUpload1.PostedFile.FileName);
string conString = string.Empty;
[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 need to send some parameters to an external website using the <asp:HiddenField /> controls and also at the same time, submit data to a sql server database. The part for submitting the data to the database is working, but I need to try to get the parameters from the hiddenfields to also be passed through. I thought all I had to do is create the hidden fields and in the code behind, set the values from the textboxes that the user would fill out.
My source code is below:
[code]...
What am I missing? The hidden fields are losing their value before posting to the external website. I've looked everywhere to see why this won't work.
Ive created a web site using VS2008 ASP.net and connected to a Firebird Database.
I have a page that has a GridView(added at design time) and have connected to a table at runtime.
[Code]....
All good as the table contents are displayed at 10 rows per page. Ive set the Property AllowSorting to True. Has anyone got examples on how to code the sorting? Ive had a look round the net but all the examples Ive tried dont work.