ASP.NET Discussion Boards

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

developerit14-May-10 1:03

14-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

How to Display Outlook E-mail Box

cheguri13-May-10 23:12

cheguri

13-May-10 23:12

Dear all,
I am developing small application ASP.NET and C#. When I click on a name, then an outlook express should be opened to send e-mail to that Name. For this name, I need to assign E-Mail ID Internally. Please tell me, how to do this... Thanks in advance.

Regards,
Cheguri

Re: How to Display Outlook E-mail Box

saini arun14-May-10 1:17

saini arun

14-May-10 1:17

Are you talking about mailto: feature?

Re: How to Display Outlook E-mail Box

cheguri14-May-10 1:42

cheguri

14-May-10 1:42

Yes, I got the solution. Thanks a lot.

Re: How to Display Outlook E-mail Box

Not Active14-May-10 1:19

Not Active

14-May-10 1:19

Use mailto[^]

I know the language. I've read a book. - _Madmatt

Re: How to Display Outlook E-mail Box

cheguri14-May-10 1:42

cheguri

14-May-10 1:42

Thanks dude. its working now.

First Web Service

Learner52013-May-10 23:08

Learner520

13-May-10 23:08

Hi Everybody,

I am using web services first time. Only for my understanding I have used very simple functionality: Addition of two numbers and population of a dropdown list. My questions are
1- when I used "Namespace" It raised an error that 'error BC30002: Type 'First Web Service' is not defined.'
later I commented out namespace it is working fine. any tip how to sortout this error.

2- Basically I play all the time with database (binding and manipulating data with controls )and desperate to use WCF and web services. Is this any better/helpful to use in the same way I have use in the FirstWebService.
why I am asking this because I can perform the same functionality using simple classes. I dont see any difference or I am confusing myself.

any help will be appreciated.

FirstWebService code:

Imports System.Web
Imports System.Web.Services
Imports System.Web.Services.Protocols
Imports Microsoft.VisualBasic
Imports System.Data
Imports System.Data.SqlClient
Imports App_Code.DB
Imports App_Code.Web

'Namespace App_Code.Web

' To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line.
'<System.Web.Script.Services.ScriptService()> _
<WebService(Namespace:="http://tempuri.org/")> _
<WebServiceBinding(ConformsTo:=WsiProfiles.BasicProfile1_1)> _
<Global.Microsoft.VisualBasic.CompilerServices.DesignerGenerated()> _
Public Class FirstWebService
Inherits System.Web.Services.WebService

Dim dbeng As DBEngine
Dim lEBStruct As EBStruct

Public Sub New()
dbeng = New DBEngine
dbeng.YourDBName = ConnectionSource.DBName.PupilVoice
End Sub

Private _YGid As Integer
Private _YGDesc As String

Public Property YGId() As Integer
Get
Return _YGid
End Get
Set(ByVal value As Integer)
_YGid = value
End Set
End Property

Public Property YGDesc() As String
Get
Return _YGDesc
End Get
Set(ByVal value As String)
_YGDesc = value
End Set
End Property

<WebMethod()> _
Public Function HelloWorld() As String
Return "Hello Mathematician"
End Function

<WebMethod()> _
Public Function AddTwoIntegers(ByVal dig1 As Integer, ByVal dig2 As Integer) As String
Return Convert.ToString("<br/>you entered teri tou two digits: " & dig1 & " and " & dig2 & ". Sum of two digits is " & dig1 + dig2)
End Function

<WebMethod()> _
Public Function YearGroup_GetAll() As EBStruct
Dim lcmd As New SqlCommand
Dim dbeng1 As New DBEngine
lcmd.CommandType = CommandType.StoredProcedure
lcmd.CommandText = "YearGroup_GetAll"
lEBStruct = dbeng.GetDataTable(lcmd)
Return lEBStruct
End Function
End Class
'End Namespace

API for Paypal Intigration with Asp.net,C#

Ratnesh N Bharos13-May-10 21:45

Ratnesh N Bharos

13-May-10 21:45

I want to know the direct API's for paypal intigration in my asp.net application. Please help me ?

Thanks for your reply

Regards

Ratnesh Nirmal Bharos
( Web Developer Asp.net, C#)

Re: API for Paypal Intigration with Asp.net,C#

Peace ON13-May-10 22:26

Peace ON

13-May-10 22:26

http://weblogs.asp.net/wim/archive/2006/01/27/436664.aspx[^]

Introduction to PayPal for C# - ASP.NET developers[^]

Hope this will help!

Jinal Desai - LIVE
Experience is mother of sage....

Re: API for Paypal Intigration with Asp.net,C#

raju melveetilpurayil14-May-10 9:42

raju melveetilpurayil

14-May-10 9:42

https://cms.paypal.com/us/cgi-bin/?cmd=_render-content&content_ID=developer/howto_api_paymentspro[^]
Check this link it will help you to integrate PayPal.

Raju.M

How to deploy web application in FTP Server ???

JC.KaNNaN13-May-10 21:36

JC.KaNNaN

13-May-10 21:36

HI,

I have develped one small application in asp.net with ajax..
How to deploy web application in FTP Server..
locally perfactly working.But Remote server only problem..

And also im facing one problem..Is it possible to Having morethan one web config file in FTP????

Yours,
KaNNaN

-----------------------------------------------------------------
"Success is When Ur Signature Becomes An Autograph"

Bind Child table data on View field- MVC ASP.Net

tassadaque13-May-10 19:40

tassadaque

13-May-10 19:40

I am new to MVC i have a very basic question. Hope you will bear it.
I have two tables Contact and Addresses. Addresses is the child table of Contact. When i create view for Contact. i also want to get addresses for user as many as user wants. For contact table i bind the textbox and add validation like this

<%= Html.TextBoxFor(model => model.ContactName) %>
<%= Html.ValidationMessageFor(model => model.ContactName) %>

Now my question is that how can i bind address field on create view screen.

Regards Tassadaque

page expire problem

souravghosh1813-May-10 19:18

souravghosh18

13-May-10 19:18

Hi all,
I have got a problem in my application.I am executing a query which is quite lengthy.Some times i got a problem page time out expire.Can any one help me how to overcome this problem.
i have used
command.Timeout and connectTimeout and pooling in connection string.
But still it is not working.

Re: page expire problem

Viral Upadhyay13-May-10 19:39

Viral Upadhyay

13-May-10 19:39

I m not sure it will help but,
try to increase execution time of your page
like

<httpRuntime
    executionTimeout="3600"
  />

hope this help

Viral
My Site

Save Our Tigers

Re: page expire problem

suwangsoft14-May-10 2:30

suwangsoft

14-May-10 2:30

SQL syntax error.

javascript expected ')'

chartierpw13-May-10 18:03

chartierpw

13-May-10 18:03

I get an javascript expected ')' error on the code below:

function toggle()
{
if (document.getElementById("<%= RadioButtonList_Liability.ClientID %>").value == "Yes")
{
document.getElementById("<%= Label_Liability.ClientID %>").style.visibility = "inherit";
}
else
{
document.getElementById("<= Label_Liability.ClientID %>).style.visibility = "hidden";
}
)

for the life of me, I don't see anything wrong ....

Re: javascript expected ')'

chartierpw13-May-10 18:10

chartierpw

13-May-10 18:10

Never mind, now that I see it in this editor I see the paren is wrong ... sigh ...

Re: javascript expected ')'

adkalavadia13-May-10 18:12

adkalavadia

13-May-10 18:12

line no 10 in your javascript....

document.getElementById("<= Label_Liability.ClientID %>).style.visibility = "hidden";

% is missing......

!- F - R - I - E - N - D - S -!

Re: javascript expected ')'

Dinesh Mani13-May-10 19:25

Dinesh Mani

13-May-10 19:25

Couple of things that I see is missing/wrong...

1.

document.getElementById("<= Label_Liability.ClientID %>).style.visibility = "hidden";

should be

document.getElementById("<%= Label_Liability.ClientID %>").style.visibility = "hidden";

2. I see one extra ")" at the end of the javascript block... Line 12.

Suggestion -
Always use single quote ['] with javascript.

how i add a pictures in the database & how to connect to sql server with formview and gridview using c#

ihbos13-May-10 17:30

ihbos

13-May-10 17:30

Salam
I've problem to add a picture to database sqlserver,what's the simple solution to this and how can i use the table which it has pictures with formview and this is the example that's i mist have,and thanks to ALL.
SALAM.

Re: how i add a pictures in the database & how to connect to sql server with formview and gridview using c#

nagendrathecoder14-May-10 0:15

nagendrathecoder

14-May-10 0:15

See This[^]

Redirect fails

Dot-Net-Dev13-May-10 17:19

Dot-Net-Dev

13-May-10 17:19

Hi,
I am working with the HTTP Post method to log the user into my framework. I have done everything required for it, but when I run the page it does not redirect to the Page given in URL. What I am doing wrong?

Thanks

Re: Redirect fails

Viral Upadhyay13-May-10 18:19

Viral Upadhyay

13-May-10 18:19

friend you need to give more information for solving your problem. Wink | ;)

Viral
My Site

Save Our Tigers

Re: Redirect fails

Ankur^\m/13-May-10 18:22

Ankur^\m/

13-May-10 18:22

Without seeing your code it is not possible to say where you are wrong. Add the relevant code snippet to your question.

..Go Green..

Re: Redirect fails

Dot-Net-Dev13-May-10 19:48

Dot-Net-Dev

13-May-10 19:48

Here is my code:

string strResponse;
string strPost;

protected void Page_Load(object sender, EventArgs e)
{
strPost = "txtUserName=abc&txtPassword=123";

UTF8Encoding objUTFEncode = new UTF8Encoding();
byte[] arrRequest = null;
Stream objStreamReq;
StreamReader objStreamRes;
HttpWebRequest objHttpRequest;
HttpWebResponse objHttpResponse;
Uri objUri = new Uri("http://www.mysite.com");

objHttpRequest = HttpWebRequest.Create(objUri) as HttpWebRequest;
objHttpRequest.KeepAlive = false;
objHttpRequest.Method = "POST";

objHttpRequest.ContentType = "application/x-www-form-urlencoded";
arrRequest = objUTFEncode.GetBytes(strPost);
objHttpRequest.ContentLength = arrRequest.Length;
objStreamReq = objHttpRequest.GetRequestStream();
objStreamReq.Write(arrRequest, 0, arrRequest.Length);
objStreamReq.Close();

CookieContainer cookieContainer = new CookieContainer();
objHttpRequest.CookieContainer = cookieContainer;

//Get response

objHttpResponse = objHttpRequest.GetResponse() as HttpWebResponse;
objStreamRes = new StreamReader(objHttpResponse.GetResponseStream(), Encoding.ASCII);

strResponse = objStreamRes.ReadToEnd();
objStreamRes.Close();
}

Last Visit: 31-Dec-99 18:00 Last Update: 4-May-24 6:01

Refresh

ᐊ Prev 1...919 920 921 922923924 925 926 927 928 Next ᐅ

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