First Web Service - ASP.NET Discussion Boards

Hey if ur prob is not solved the check this post

http://opexsolution.com/forum/viewtopic.php?f=15&t=41&p=123#p123[^]

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

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

Are you talking about mailto: feature?

Yes, I got the solution. Thanks a lot.

Use mailto[^]

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

Thanks dude. its working now.

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

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#)

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

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

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"

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

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.

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

SQL syntax error.

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

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

line no 10 in your javascript....

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

% is missing......

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

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.

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.

See This[^]

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

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

Viral
My Site

Save Our Tigers

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

..Go Green..