-
upload images problem
hello glad to be here,
i have a upload images tutoiral that i got from here
http://geekswithblogs.net/dotNETvinz...n-asp.net.aspx
but i can not get it to work, it is slightly tweaked for me.
errors i am getting are:
------ Build started: Project: C:\WebSite4\, Configuration: Debug Any CPU ------
Validating Web Site
Building directory '/WebSite4/'.
C:\WebSite4\Default.aspx.cs(35,9): error CS0246: The type or namespace name 'SqlConnection' could not be found (are you missing a using directive or an assembly reference?)
C:\WebSite4\Default.aspx.cs(35,34): error CS0246: The type or namespace name 'SqlConnection' could not be found (are you missing a using directive or an assembly reference?)
C:\WebSite4\Default.aspx.cs(42,13): error CS0246: The type or namespace name 'SqlCommand' could not be found (are you missing a using directive or an assembly reference?)
C:\WebSite4\Default.aspx.cs(42,34): error CS0246: The type or namespace name 'SqlCommand' could not be found (are you missing a using directive or an assembly reference?)
C:\WebSite4\Default.aspx.cs(43,13): error CS0246: The type or namespace name 'SqlParameter' could not be found (are you missing a using directive or an assembly reference?)
C:\WebSite4\Default.aspx.cs(43,40): error CS0246: The type or namespace name 'SqlParameter' could not be found (are you missing a using directive or an assembly reference?)
C:\WebSite4\Default.aspx.cs(46,28): error CS0246: The type or namespace name 'SqlParameter' could not be found (are you missing a using directive or an assembly reference?)
C:\WebSite4\Default.aspx.cs(46,49): error CS0103: The name 'SqlDbType' does not exist in the current context
C:\WebSite4\Default.aspx.cs(47,28): error CS0246: The type or namespace name 'SqlParameter' could not be found (are you missing a using directive or an assembly reference?)
C:\WebSite4\Default.aspx.cs(47,50): error CS0103: The name 'SqlDbType' does not exist in the current context
C:\WebSite4\Default.aspx.cs(48,28): error CS0246: The type or namespace name 'SqlParameter' could not be found (are you missing a using directive or an assembly reference?)
C:\WebSite4\Default.aspx.cs(48,53): error CS0103: The name 'SqlDbType' does not exist in the current context
C:\WebSite4\Default.aspx.cs(49,28): error CS0246: The type or namespace name 'SqlParameter' could not be found (are you missing a using directive or an assembly reference?)
C:\WebSite4\Default.aspx.cs(49,53): error CS0103: The name 'SqlDbType' does not exist in the current context
C:\WebSite4\Default.aspx.cs(61,31): error CS0103: The name 'CommandType' does not exist in the current context
Validation Complete
========== Build: 0 succeeded or up-to-date, 1 failed, 0 skipped ==========
<b>Default.aspx</b>
<code>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
Browse Image:<br />
<br />
<asp:FileUpload ID="FileUpload1" runat="server" />
<br />
<br />
<asp:Button ID="Button1" runat="server" Text="Save" Width="79px" />
</div>
</form>
</body>
</html>
</code>
<b>Default.aspx.cs</b>
<code>
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class _Default : System.Web.UI.Page
{
private void StartUpLoad()
{
//get the image file that was posted (binary format)
byte[] theImage = new byte[FileUpload1.PostedFile.ContentLength];
HttpPostedFile Image = FileUpload1.PostedFile;
Image.InputStream.Read(theImage, 0, (int)FileUpload1.PostedFile.ContentLength);
int length = theImage.Length; //get the length of the image
string fileName = FileUpload1.FileName.ToString(); //get the file name of the posted image
string type = FileUpload1.PostedFile.ContentType; //get the type of the posted image
int size = FileUpload1.PostedFile.ContentLength; //get the size in bytes that
if (FileUpload1.PostedFile != null && FileUpload1.PostedFile.FileName != "")
{
//Call the method to execute Insertion of data to the Database
ExecuteInsert(theImage, type, size, fileName, length);
Response.Write("Save Successfully!");
}
}
public string GetConnectionString()
{
//sets the connection string from your web config file "ConnString" is the name of your Connection String
return System.Configuration.ConfigurationManager.ConnectionStrings["MyConsString"].ConnectionString;
}
private void ExecuteInsert(byte[] Image, string Type, Int64 Size, string Name, int length)
{
SqlConnection conn = new SqlConnection(GetConnectionString());
string sql = "INSERT INTO TblImages (Image, ImageType, ImageSize, ImageName) VALUES "
+ " (@img,@type,@imgsize,@imgname)";
try
{
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
SqlParameter[] param = new SqlParameter[4];
//param[0] = new SqlParameter("@id", SqlDbType.Int, 20);
param[0] = new SqlParameter("@img", SqlDbType.Image, length);
param[1] = new SqlParameter("@type", SqlDbType.NVarChar, 50);
param[2] = new SqlParameter("@imgsize", SqlDbType.BigInt, 9999);
param[3] = new SqlParameter("@imgname", SqlDbType.NVarChar, 50);
param[0].Value = Image;
param[1].Value = Type;
param[2].Value = Size;
param[3].Value = Name;
for (int i = 0; i < param.Length; i++)
{
cmd.Parameters.Add(param[i]);
}
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
}
catch (System.Data.SqlClient.SqlException ex)
{
string msg = "Insert Error:";
msg += ex.Message;
throw new Exception(msg);
}
finally
{
conn.Close();
}
}
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
StartUpLoad();
}
}
</code>
<b>web.config</b>
<code>
<connectionStrings>
<add name="MyConsString" connectionString="ZONE777\SQLS;Initial" Catalog="newDB;Integrated" Security="True;"
providerName="System.Data.SqlClient" />
</connectionStrings>
</code>
i have tried a whoel bunch of these tutorials and i have not got only one to work but then
the display did not work.
if any one know of a tutorial that show how to store just the path of the image and then
store and display them with asp.net, I would greatly appreciate it.
thanks,
craig
