Dear All,
upload file using stored procedure
design:
<form id="form1" runat="server">
<div>
<table class="style1">
<tr>
<td>
Name</td>
<td>
<asp:TextBox ID="TextBox1" runat="server">
</td>
</tr>
<tr>
<td>
Upload File</td>
<td>
<asp:FileUpload ID="FileUpload1" runat="server" />
</td>
</tr>
<tr>
<td>
</td>
<td>
<asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="Button" />
</td>
</tr>
</table>
</div>
</form>
code:
protected void Button1_Click(object sender, EventArgs e)
{
int userId = 0;
string constr = ConfigurationManager.ConnectionStrings["connectionstring"].ConnectionString;
using(SqlConnection con=new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("SP_Uploadfile"))
{
using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
{
string strdata = @"~\data\" + FileUpload1.FileName;
FileUpload1.PostedFile.SaveAs(Server.MapPath(strdata));
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Name", TextBox1.Text);
cmd.Parameters.AddWithValue("@Uploaddata", FileUpload1.FileBytes);
cmd.Connection = con;
con.Open();
userId = Convert.ToInt32(cmd.ExecuteScalar());
con.Close();
}
}
string message = string.Empty;
switch (userId)
{
default: message = "upload successfully";
break;
}
ClientScript.RegisterStartupScript(GetType(), "alert", "alert('" + message + "');", true);
}
}
here uploading file in this code data not inserted any mistakes please reply me and any examples please
Stored Procedure added
USE [Place]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
Create PROCEDURE [dbo].[SP_Uploadfile]
@Name VARCHAR(50),
@Uploaddata varchar(max)
AS
BEGIN
INSERT INTO [Uploadfile]
([Name],
[Uploaddata])
VALUES
(@Name,
@Uploaddata)
SELECT SCOPE_IDENTITY()
END