I have a situation where images are already uploaded in a folder. Now I dont need to upload image from client PC just select from list of images retrieved through File.IO and transfer selected one to database. Any ready script available?? Similary I need to retrieve stored image from database and display in image control..
View 3 RepliesI used below code for uploading image with  fileupload control
string path = Server.MapPath(".") + "../image/estate/image";
string filename = System.IO.Path.GetFileName(fup3.PostedFile.FileName);
string[] validext = { ".jpg"};
string ext = System.IO.Path.GetExtension(fup3.PostedFile.FileName);
if (Array.IndexOf(validext, ext.ToLower()) < 0)
{
Label21.Text = "insert .jpg format";
[code]....
I want if users don't select any image from fileupload control in database it save this image name  'default.jpg'
I have a class which implements IHttpHandler that is designed to handle image resize requests. It handles Urls like so [URL] Currently the handler looks for myimg.jpg on disk, cuts a 100x100 thumbnail (if it isn't already present) and redirects the client to the thumbnail like so Response.RedirectPermanent("/some/virtualPath/to/thumbnail.jpg");
This has been working great, but I would like to avoid forcing the client to issue a second HTTP request. Is it safe to do the following? Server.Transfer("/some/virtualPath/to/thumbnail.jpg") All the MSDN documentation talks about using Server.Transfer() to redirect to an aspx page, so I'm not sure if this is the right thing to do or not.
I have to insert default image into databse..when no image is selected from fileupload control.. Here is code...not working for default image...
if (FileUpload1.HasFile){string FileName = System.IO.Path.GetFileName(FileUpload1.PostedFile.FileName);
FileUpload1.SaveAs(Server.MapPath("~/UPLOADEDFILES/" + FileName));
feedBack.Attachments.Add(new Attachment(FileUpload1.PostedFile.InputStream, FileName));
} else {
string filename="~/images/"+ "sun.gif";filename.pPropertyImage = filename;FileUpload1.SaveAs(MapPath(filename));}
[URL] .... In that tutorial temporary DataTable used to maintain the list selected rows or records and then use the DataTable to bind the secondary GridView. What I'd like to do is;
I'm using the IfUserIsInRole function and when I get the users Identity and name I'm prepopulating the gvSelected GridView with data (only people associated with that user) on page load. When I try to add none prepopulated people from the gvAll GridView to the gvSelected GridView all the origional prepopulated rows from the gvselected GridView are over written.
How can I prevent this from happening?
i am creating a print view using checkboxes that a customer uses to select which items they wish to print. I am having difficulty transfering the selected gridview items to another page. I was using crosspage post.
View 2 RepliesI have used a image handler to display image which works fine... My problem is how can v pass the image using sessions on different pages. I have an image control in master page and fileupload control on the content page.... bt m not able to implement sessions for images as image can't be store to string.
View 1 RepliesThis is the class file im using to export the datagrid to excel sheet. Problem is i cant able to transfer the image from gridview to excel sheet using this code. What are the modifications i can do for the below code to export the image.
public class ExcelReport
{
# region Export to excel
/// <summary>
/// Function for Export html report to Excel sheet
/// </summary>
/// <param name="fileName">File name</param>
/// <param name="gv">Gridview</param>
///
public void ExportToExcel(string fileName, GridView gv)
{
try
{
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", fileName));
HttpContext.Current.Response.ContentType = "application/ms-excel";
using (StringWriter sw = new StringWriter())
{
using (HtmlTextWriter htw = new HtmlTextWriter(sw))
{
Table table = new Table();
if (gv.HeaderRow != null)
{
//gv.HeaderRow.CssClass = "GridviewStyle";
// gv.HeaderRow.Font.Bold = true;
PrepareControlForExport(gv.HeaderRow);
table.Rows.Add(gv.HeaderRow);
}......................................
I have some data which is in mySQL, i am not familier with mySQL, i would like to transfer all the data from MySQL to SQL Server database,
View 11 RepliesFor a school assignment I need to transfer excisting data from an acces database, to a new sql database.
I'm not allowed to use datasources, I may only use ADO.net objects.(data adapter, command, connection, ...)
Is it a good idea to start transfering the data in the 'while' loop? Could anyone show me how I can connect to my SQLDB, and transfer the selected table?
[Code]....
I want to transfer gridview record to another gridview. Actually I have placed a checkbox column in 1st gridview. Now what I want that when i select the checkbox of any row the related row transfer to 2nd gridview and when I deselect it that row it returns to its previous position in 1st gridview. All these things I want to do using Javascript.
View 1 RepliesTwo ListBox Items  Compare and  Distinct  Values  Insert  Into  Third  ListBox
View 1 RepliesI have this code
private void BindSecondaryGrid()
{
DataTable dt = (DataTable)ViewState["SelectedRecords1"];
gridview3.DataSource = dt;
gridview3.DataBind();
}
The selected records from the gridview2 are saved there ViewState["SelectedRecords1"].The columns are id, name, quantity, total. Then these records are saved in gridview3 with
gridview3.DataSource = dt;
gridview3.DataBind();
Now i would like to get these values from gridview3 and store them in a table in my database with same columns of course.Is there a way to do that?
How To get Datalist Checkbox  Select Item To The Another Datalist  on click CheckBoxÂ
Code Like
<form id="form1" runat="server">
<div>
<h2 style="background-color: #CCC; font-size: 16px; font-family: Arial, Helvetica, sans-serif; font-weight: 400;" class="heading">Brand</h2>
<asp:DataList ID="DataList5" runat="server" Style="font-weight: 700; color: #CC33FF; background-color: #66FFCC;" Height="100px" Width="122px">
<ItemTemplate>
[code]....
My file path in which I have stored image will be like this "C:Documents and SettingssureshDesktopRegIR_NEWRegIRinDebug....Images8-Q-IMG.jpg".
This file path will be diaplayed in Gridview and I have made "Auto Generate Select Button - True" in Gridview.
Is it possible to get the image in image control by using this file path on the click of "SELECT" option in gridview.
My running this application on a remote server.
im trying to transfer my database from local machine to server, im using the publish to provider wizard in visual web developer to generate a scrip, im then using the generated script on the serever database.
[Code]....
I have an SQL 2008 DB and I need to transfer the structure and the data to an off site, off network database. I need to somehow create a physical file that represents the structure and data within the db that can be loaded in another instance of SQL Server 2008.
View 1 RepliesI have a form in which data data is entered. Thsi date is filled to a gridview. I want to transfer all the datas in gridview to a table in the database .Please help
View 9 RepliesI have filed image type varbinary
I want upload image and show then with click button save
store in db
I know this might sound like a simple quesiton, but I am having problems allowing me to upload images along with other information (name, image, biography, wbsite links) to a sql server database, as well as showing images from the database using a drop list control feature. I am using [URL] for hosintg. VB language.
View 2 Replieshow to retrieve database image to the image control?
in the database, i have a column in database that store the url for the images. and how am i going to retrieve it to the form?
[Code]....
the "dtrSelect["Food_Pic].ToString()" is the url for the image.
this is my code in page
<asp:DataList ID="DDLC" runat="server">
<ItemTemplate>
<div id="Dmainart">
<div id="Dart1_12">
<div id="Dart1_I1"><asp:Image ID="asp:Image" runat="server" CssClass="TPH" ImageUrl='<%#Eval("image","image/house/article/image/{0}")%>' Width="90px" Height="64px"/>
[code]...
i want if there wasnot any image in image column in database this div <div id="Dart1_I1"> display="none".
This code retrieve image from SQL database i want to add code if image is not exist retrieve another image in null valueÂ
protected void Page_Load(object sender, EventArgs e) {
if (!IsPostBack) {
string connectionString = WebConfigurationManager.ConnectionStrings["conString"].ConnectionString;
SqlConnection con = new SqlConnection(connectionString);
[Code] ....
how can i store image into database and view it in grid view?
View 3 RepliesI am working on a website, using C# with a SQL backend. I'm using the Varbinary data type to store my images because the Image data type is eventually going away. I got the images into the DB and can pull them back out to display on the website. My question is how can I put the images from the DB into an Image control on the website? The images will be different sizes, so I need to keep them confined in one space on the site. I also need to randomly display the images, one at a time, on the website. The user needs to be able to hit the Next button to see the next image when they are ready. The user will only view the images, not make any changes and send data back to the DB.
Since the image will be confined within the image control, how can I allow the user to click on the image and open in a new window? The image needs to be bigger to allow the user to see more detail. Or would it be easier to allow the user to zoom in on the image within the current window?I am using VWD Express, C# 2010 Express & SQL 2005 Express.