Bellow is my SQL syntax
[code]....
I want to create a XML file on my project's App_Data folder.This XML use as the source file of my AspxMenu.I know how to bind XML data to AspxMenu but i dont know how to create XML file .I want to save this table information as a XML file on my App_Data folder.how to save table information as a XML file.
I am creating the user ,using asp.net + C#.there is the form (UI) who collects the information and send data to Business layer. now, while collecting the information from UI I want to also save the image of user, at file system in application domain.There is function in the business layer as SaveImage, which returns the path where it is saving. Scenario:1) Save image first and then save other information in DB.
View 4 RepliesIs it possible to upload and Save Excel file as blob in Sql table through web application?
I do not need to query excel file, just be able to upload and download excel file as is.
am a newbie to programming so please bare with me!I introduced a file upload control on one of my pages. There is a button click event for the upload which triggers not only the upload but also an insert into a table in my database.Every aspect of the button click event for this upload is working as expected; however I do have a couple of queries because the results are not quite as I would like them. I am using asp.net 3.5 and C# in code behind page.
I have a simple table with 3 columns in my database: Username, PhotoTitle and PhotoUrl. In the button click event I grab the PhotoUrl like such -string photoUrl = FileUpload1.PostedFile.Filename; (I am using the photo url from my images folder in the application to show photos in Gridviews etc. I prefer this to storing the actual image in the database for the moment until i am a bit more experienced since i don't know much about varbinary dbtype.). When the button is clicked for the upload, the details of the photo are saved in the database table, but it's the full path of the file on my laptop which is store (C:/Documents/.../filename.jpg) opposed to "Filename.jpg" for example, which i obviously would prefer because in the application photos are displayed using the"~/images/Filename.jpg" path. How can I save the file name with the extension alone in my table (without the full path)?
The second problem is basically regarding the actual photos being uploaded. They are"saved as" inside folder for the solution as anticipated, but only on the laptop harddrive, which means that I have to manually drag each photo uploaded into the images folder within Solution Explorer, from a Windows Explorer window, in order to be able to display them in Gridviews etc (with the "~/images/Filename.jpg" call in the .aspx code). This is not acceptable of course since the site users would expect to see their photo after the upload, and they would not be able to drag the file into the ~/images/ folder. How can I get round this second slight problem; i.e. is there a way to upload photos directly in the folder so that they show directly on the solution explorer?I hope my explanations of those two little problems I have didn't confuse you all?
actually my need is that, after uploading a doc file I want to save this doc file's text to database table, with the help of asp fileupload control. actually in real I dont want to save this whole file anywhere, but I just need the text to save in databse.
View 2 RepliesI want to save three images path in table also upload images in folder,how it is possible?[Using ajax file upload control]table columns are imagepath1,imagepath2,imagepath3. URL....
HTML
<asp:AjaxFileUpload ID="AjaxFileUpload1" runat="server" AllowedFileTypes="jpg,jpeg,png,gif"
MaximumNumberOfFiles="3" OnUploadComplete="File_Upload"
Width="500px" />
 C#
protected void File_Upload(object sender, AjaxFileUploadEventArgs e)
[code]....
I have three table in my database they are ...
                            1. Category
                           2. Forum
                           3. Topic
I need to above three table information into a single table ...
What is the best way to insert and retrieve images like :
In the database in binary form retrieve it with imagehandler, or
In the database by saving the path of the folder of the images and retrieve it, or
by saving the images directly to the folder and retrieve it...
I am trying to create Modal Web Form to get information and save in the database. when I submit the Modal form, it give me "
The name 'sNewNotes ' does not exist in the current context" message. I am not able to save data. How do I accomplish this?
Following is the Modal Dialogue Html and codebehind code
I have not been able to save any profile information? All the tutorials seem straightforward but nothing works.
[Code]....
[Code]....
If I am using the default profile provider, why won't this work?
I'm using the ASP.NET membership framework in my ASP.NET application. I'd like to save a few extra pieces of information in the cookie so that when I need it, I don't have to go back to the database. I want to save user's email address, full name and time zone.How do I save this information in the cookie?
View 1 RepliesIam building a website and i need to store somehow some informations that i will use in the whole site depending of the user type logged in.
Example:
1) User XPTO logs in
2) Query DataBase to see where he belongs
3) Store those 2 or 3 fields that i will get in Database in a persistent way to use it in the whole site.
Whats the best practices to do this?
I´m building a website and i need to store somehow some informations that i will use in the whole site depending of the user type logged in.3) Store those 2 or 3 fields that i will get in Database in a persistent way to use it in the whole site.My question is: Whats the best practices to do this?
View 1 RepliesI need a program with asp.ne that would connect to the computer user (client) and hardware information Show to me then save to db.
View 1 Replies[URL]above url contain a html table.I want to save this table value on XML and also want to save this table value on database MS2008.How to save html table values on database
View 3 Repliescan we save pdf document without save,view,cancel dialogue box in asp.net..
View 1 Repliesi have place some .txt files in my web application root directory. now i want to open a popup on button click with save button so that client can save this file on his/her PC. also can we auto set the path??? mean client jst press save button and file automatically stored his "D:\Foldersample.txt".
View 1 RepliesI m very new in VS (ASP.NET) and using C# in code behind file. I want to define global variables to use in whole application. EXAMPLE
I want to save some information in LOGIN Page and display it in other pages line UserName or AccessRights etc.
Is there anyway to do this without using Cookies and Seassion ?
My Asp.Net calls a SQL sproc and returns a XML file as a string. This is what I need to do:
- save that string into memory (as a file);
- pop up a dialog box asking the user which path he would like to save the file;
Any samples out there...how do I achieve this task in Asp.Net C#?
How can I retrieve file information (size of file) before it is uploaded to the webserver?
I would like to create a multi file upload. I have it working in JQuery but I would like to know the size of the files to set a limition by summing up the total the file sizes together.
Which table does contain information about web parts?
For example: if I minimize web part zone and I again connect to my web application (even after server restart) this web part zone still will be minimized.
In which table this information is stored?
In my application I am using the aspnetdb membership for authorizing users. I created a new table UserProfiles that will hold their profile information. The UserID is linked to aspnet_users UserID with a foreign key. One of the columns in the table represent CompanyID (int). I want to be able to restrict logged in users to only see records from their company based on the CompanyID. There can be more than one user with the same CompanyID to the UserID would not work. I can restrict their access by UsedID to only see records they created by using code behind:
[Code]....
and my select statement is:
[Code]....
How would be the best way to restrict the selected data to UserProfiles.CompanyID?
i am developing a web application i want to save a file using save file dialog box pls give me code insted of links
View 2 RepliesNeed to Populate Gridview on Each Tab with Informationfrom same table but with Different Columns
The tabs are Like-Personal,Proffesional of particular's employee from same table
now my gridview will contain various functionality for editing and updating etc. so..what procedure should i follow..?
binding gridview everytime on each active tab changed but that will cause a postback.
any other or better solution with Update Panel..?
here is my Page Source
[Code]....
My Page Code
Class File
[Code]....
Default Page Code
[Code]....
I am using asp.net 3.5 and Oracle Providers for membership and roles. Now, using CreateUserWizard i can make user register here but for storing custom information like First name, last name, address etc. i am using couple of custom oracle tables instead of Oracle Profile Provider. In this case, i am using the USERID field which is of GUID type as primary key. Now, my problem is that i dont know how to draw information from my custom oracle tables for those users who are currently logged in. I have searched a lot in this forum and elsewhere where there are many topics relating to it but i failed to follow any of them. So, i would request you to kindly guide me to solve the issue. Oracle Membership
Table(ORA_ASPNET_USERS) USERID=xxxxxxxxxxxxxxx(some guid value) Username=abc and so on.. My Custom Table(UserProfile): USERID RAW(16), --> referenced to USERID field of ORA_ASPNET_USERS table fname varchar2(20) lname varchar2(20) I've the profiles of username "abc" having some userid stored in Userprofile table So, how can i fetch data from UserProfile table for the user "abc" when he is logged in?