Click here to Skip to main content
15,886,137 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: I developed a tool, word convert chm, welcome evaluation Pin
R. Giskard Reventlov14-May-10 3:29
R. Giskard Reventlov14-May-10 3:29 
AnswerRe: I developed a tool, word convert chm, welcome evaluation Pin
suwangsoft14-May-10 4:10
suwangsoft14-May-10 4:10 
AnswerRe: I developed a tool, word convert chm, welcome evaluation Pin
suwangsoft14-May-10 4:14
suwangsoft14-May-10 4:14 
QuestionSystem.Data.SqlClient.SqlException: SQL Server Internal Error. Text manager cannot continue with current statement. Pin
developerit14-May-10 1:06
developerit14-May-10 1:06 
AnswerRe: System.Data.SqlClient.SqlException: SQL Server Internal Error. Text manager cannot continue with current statement. Pin
Brij14-May-10 1:08
mentorBrij14-May-10 1:08 
GeneralRe: System.Data.SqlClient.SqlException: SQL Server Internal Error. Text manager cannot continue with current statement. Pin
developerit14-May-10 22:27
developerit14-May-10 22:27 
AnswerRe: System.Data.SqlClient.SqlException: SQL Server Internal Error. Text manager cannot continue with current statement. Pin
Tej Aj18-May-10 1:32
Tej Aj18-May-10 1:32 
QuestionSystem.Data.SqlClient.SqlException: SQL Server Internal Error. Text manager cannot continue with current statement. Pin
developerit14-May-10 1:03
developerit14-May-10 1:03 
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Safa"].ConnectionString);    string branchid = "";    protected void Page_Load(object sender, EventArgs e)    {      branchid= Session["branchid"].ToString();        if (IsPostBack == false)        {      Image1.ImageUrl = "left1.ashx?BranchId=" + branchid;      Image2.ImageUrl = "left1old.ashx?BranchId=" + branchid;              } protected void Button1_Click(object sender, EventArgs e)    {// update code        SqlCommand cmdupdate = new SqlCommand("left1update", con);        cmdupdate.CommandType = CommandType.StoredProcedure;        con.Open();        cmdupdate.Parameters.AddWithValue("@BranchId", branchid);        if ( FileUpload1.HasFile)        {            FileInfo left1info = new FileInfo(  FileUpload1.PostedFile.FileName.Trim());            byte[] left1content = new byte[left1info.Length];            FileStream left1stream = left1info.OpenRead();            left1stream.Read(left1content, 0, left1content.Length);            left1stream.Close();           cmdupdate.Parameters.AddWithValue("@imgleft1",left1content); } cmdupdate.Parameters.AddWithValue("@notel1",txtnotes.Text);        if(cmdupdate.ExecuteNonQuery()!=0)        {        Functions.ShowAlertMessage("Updated.....");        txtnotes.Text = "";        System.Threading.Thread.Sleep(2000);        Image1.ImageUrl = "left1.ashx?BranchId=" + Session["branchid"].ToString();        Image2.ImageUrl = "left1old.ashx?BranchId=" + Session["branchid"].ToString();                }        


procedure iam using

create procedure left1update(@BranchId nvarchar(50),@imgleft1 image, @notel1 nvarchar(200))
as
update tblImages set imgleft1old= CONVERT( image,imgleft1)
,imgleft1=@imgleft1 ,notel1=@notel1 where (BranchId=@BranchId)


GO

when iam clicking the button my current image should store in imgleft1old field and the newly browse one should store in imgleft1 field

but it giving error
System.Data.SqlClient.SqlException: SQL Server Internal Error. Text manager cannot continue with current statement.



can you correct my code which helps me
QuestionHow to Display Outlook E-mail Box Pin
cheguri13-May-10 23:12
cheguri13-May-10 23:12 
AnswerRe: How to Display Outlook E-mail Box Pin
saini arun14-May-10 1:17
saini arun14-May-10 1:17 
GeneralRe: How to Display Outlook E-mail Box Pin
cheguri14-May-10 1:42
cheguri14-May-10 1:42 
AnswerRe: How to Display Outlook E-mail Box Pin
Not Active14-May-10 1:19
mentorNot Active14-May-10 1:19 
GeneralRe: How to Display Outlook E-mail Box Pin
cheguri14-May-10 1:42
cheguri14-May-10 1:42 
QuestionFirst Web Service Pin
Learner52013-May-10 23:08
Learner52013-May-10 23:08 
QuestionAPI for Paypal Intigration with Asp.net,C# Pin
Ratnesh N Bharos13-May-10 21:45
Ratnesh N Bharos13-May-10 21:45 
AnswerRe: API for Paypal Intigration with Asp.net,C# Pin
Peace ON13-May-10 22:26
Peace ON13-May-10 22:26 
AnswerRe: API for Paypal Intigration with Asp.net,C# Pin
raju melveetilpurayil14-May-10 9:42
professionalraju melveetilpurayil14-May-10 9:42 
QuestionHow to deploy web application in FTP Server ??? Pin
JC.KaNNaN13-May-10 21:36
JC.KaNNaN13-May-10 21:36 
QuestionBind Child table data on View field- MVC ASP.Net Pin
tassadaque13-May-10 19:40
tassadaque13-May-10 19:40 
Questionpage expire problem Pin
souravghosh1813-May-10 19:18
souravghosh1813-May-10 19:18 
AnswerRe: page expire problem Pin
Viral Upadhyay13-May-10 19:39
Viral Upadhyay13-May-10 19:39 
AnswerRe: page expire problem Pin
suwangsoft14-May-10 2:30
suwangsoft14-May-10 2:30 
Questionjavascript expected ')' Pin
chartierpw13-May-10 18:03
chartierpw13-May-10 18:03 
AnswerRe: javascript expected ')' Pin
chartierpw13-May-10 18:10
chartierpw13-May-10 18:10 
AnswerRe: javascript expected ')' Pin
adkalavadia13-May-10 18:12
adkalavadia13-May-10 18:12 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.