ASP.NET

23-Apr-06 12:24

hey and sorry

just i need to know how i can catch error in asp.net

i hope that you understand me Frown | :(

and thanks anyway

DADAX

Re: error in asp.net

gyokusei23-Apr-06 15:37

gyokusei

23-Apr-06 15:37

Using "try catch" block:

try {
    // do something
}
catch( Exception ex ) {
    // do something if an error in try block occurs 
}

Re: error in asp.net

dadax_8523-Apr-06 22:48

23-Apr-06 22:48

but the code is write in the file.asp
coz i create datasource and formview and the command of add is writen in ASP
so if i write try catch in the code VB or C# it's didn't worked

i hope that you understand me

DADAX

Stored Procedures

LAYEEQ AHMED KHAN22-Apr-06 23:44

LAYEEQ AHMED KHAN

22-Apr-06 23:44

Hi laks here,i want some help regarding stored procedures usage,how we can use stored procedure in ASP.net,plz explain me with example D'Oh! | :doh:

CWIZO22-Apr-06 23:47

CWIZO

22-Apr-06 23:47

Stored procedures have nothing to do with ASP.NET directly.
Stored procedures are stored on a databse server, and you can call them from .NET using ADO.NET

--------------------------------------------------------
My development blog
Q:What does the derived class in C# tell to it's parent?
A:All your base are belong to us!

dadax_8523-Apr-06 0:23

23-Apr-06 0:23

hey i'll give you an example asp.net ( VB.net ) for executing a stored procedure in sql server 2005 but it same in another database
1) the stored procedures to add record and take the paramters from textboxes
the code for stored procedures in sql is :
create PROCEDURE SP1

(
@ID bigint ,
@Name nvarchar(50),
@Description nvarchar(500),
@ProjectID bigint

)

AS
INSERT INTO [TBASE].[dbo].[TaskType]
([ID]
,[Name]
,[Description]
,[ProjectID])
VALUES
(@ID ,@Name,@Description,@ProjectID)

RETURN

2) to execute this stored procedures from asp.net
Imports System
Imports System.Data
Imports System.Data.OleDb

Dim con As New OleDbConnection("Provider=SQLNCLI.1;Data Source=DADAX\DADAX;Integrated Security=SSPI;Initial Catalog=TBase")
con.Open()
Dim MyCommand As New OleDbCommand()
MyCommand.Connection = con
Dim proc As String
proc = "EXEC SP1 " & TextBox1.Text & ",'" & TextBox2.Text & "','" & TextBox3.Text & "'," & TextBox4.Text
MyCommand.CommandText = proc
MyCommand.ExecuteReader()

I wish that help you

DADAX

Colin Angus Mackay23-Apr-06 3:10

Colin Angus Mackay

23-Apr-06 3:10

dadax_85 wrote:
OleDbConnection

Why are you using OleDb to connect to a SQL Server. Why not use a SqlConnection?

dadax_85 wrote:
proc = "EXEC SP1 " & TextBox1.Text & ",'" & TextBox2.Text & "','" & TextBox3.Text & "'," & TextBox4.Text

This is a security nightmare. You are advising people down the route to a SQL Injection Attack. Don't do this! See: SQL Injection Attacks and Tips on How To Prevent Them[^]

"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog

dadax_8523-Apr-06 12:32

23-Apr-06 12:32

sorry !!!!!!!!!!!1

DADAX

dadax_8523-Apr-06 12:37

23-Apr-06 12:37

Dim con As New SqlConnection("Data Source=eyetech\sqlexpress;Initial Catalog=TBase;Integrated Security=True" providerName="System.Data.SqlClient" )
Dim MyCommand As New SqlCommand
con.Open()
MyCommand.Connection = con
Dim proc As String
proc = "EXEC SP1 " & TextBox1.Text & ",'" & TextBox2.Text & "','" & TextBox3.Text & "'," & TextBox4.Text
MyCommand.CommandText = proc
MyCommand.ExecuteReader()

DADAX

I can't retrive image to an image box plz help

gyokusei23-Apr-06 15:54

gyokusei

23-Apr-06 15:54

dadax_85 wrote:
proc = "EXEC SP1 " & TextBox1.Text & ",'" & TextBox2.Text & "','" & TextBox3.Text & "'," & TextBox4.Text

very dangerous!

using these code instead:

[C#]

SqlCommand cmd = new SqlCommand("SP1", con);
cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.Add("@ID", TextBox1.Text);
cmd.Parameters.Add("@Name", TextBox2.Text);
cmd.Parameters.Add("@Decription", TextBox3.Text);
cmd.Parameters.Add("@ProjectID", TextBox4.Text);

cmd.ExecuteNonQuery();

-- modified at 21:55 Sunday 23rd April, 2006

mredaghaly22-Apr-06 21:58

mredaghaly

22-Apr-06 21:58

hi all
i want to retrive an image from database in an imagebox, when the image appear it appear in another page so plz help me to retrive it in an image box .

thanks

-- modified at 3:59 Sunday 23rd April, 2006

RichardGrimmer22-Apr-06 22:15

RichardGrimmer

22-Apr-06 22:15

To show an image in an IB, just set the "ImageSrc" property.

What do you mean by "appear in another page", and show some source code and can help

"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox

mredaghaly22-Apr-06 23:29

mredaghaly

22-Apr-06 23:29

hi that's the code to retrive the image from a Ms-sql databse

===================================================
Dim stream As MemoryStream = New MemoryStream()
Try

connection.Open()
cmd = New SqlCommand("select img_name from Product_image where imageID='16'", connection)
Dim image() As Byte = CType(cmd.ExecuteScalar(), Byte())
stream.Write(image, 0, image.Length)
Dim bitmap As Bitmap = New Bitmap(stream)
Response.ContentType = "image/gif"

Bitmap.Save(Response.OutputStream, ImageFormat.Gif)

Finally
connection.Close()
stream.Close()
End Try
============================================================

the problem that i can't retrive this image in an image box it retrives in another page and i want it to appear in the same page in an image box

thanks

RichardGrimmer23-Apr-06 0:05

RichardGrimmer

23-Apr-06 0:05

OK - looks like what is happening is that you're just writing the bitmap to the response stream....so essentially, what you're seeing is that the browser is "redirected" to a page with just the image on?

In order to show the image in the image box, you'd need to do something like imageBox1.ImageSrc=Bitmap

Google can help further... Smile | :)

"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox

mredaghaly23-Apr-06 0:18

mredaghaly

23-Apr-06 0:18

the problem that i use asp.net 2.0 and i didn't found anything image1.imgsrc, and that what i search for, so if you know a function like this tell me. i also search on google and code project but i didn't find anything untill now

thanks

minhpc_bk23-Apr-06 2:38

Re: Editting Fields in DetailsView control, change field from textbox --> dropdownlist

23-Apr-06 2:38

Hi there,
You can place your sample code to read the image data from DB in a web page, say ShowImage.aspx, then in the web page containing the Image control, you can simply specify the ShowImage.aspx in the ImageUrl property of the Image control.

minhpc_bk23-Apr-06 2:38

page_load on content pages

23-Apr-06 2:38

Hi there,
You can declare the dropdownlist in the the TemplateField of the DetailsView control, and simply use an additional datasource control to use with the dropdownlist. You can see an example[^] here to see how to customize the DetailsView control.

webservice nightmare

g00fyman22-Apr-06 17:44

g00fyman

22-Apr-06 17:44

hi all,

i currently have a webservice that relies on a file version object. Well before i realised the System.Version class existed i created my own. my webservice worked fine, then i found system.version and deleted my class so i could use .net lib.

now i cannot get rid of the Version class from within the reference.cs files that are generated. i have changed any variables to Version to System.Version (all input params local vars) and i still get the Version class generated.

if i manually delete the Version class from the Reference.cs classes it works to the point where it has to send the Version object to the webservice. A version object with version #1.1.1.1 appears to the webservice as 0.0. i assume because it is using my old Version reference, which has nothing in it at all.

how can i get rid of this version reference so it just uses the .net lib Version class?

kind regards,
g00fy

2hdass22-Apr-06 15:26

2hdass

22-Apr-06 15:26

I have just converted my page to use a master page. On the master page i have a page_load method that displays something. But onthe slaves pages, i also have a page_load method that displays other things. I find that page_load method will not work br run on slave pages. What can i do to make these methods run?

-- modified at 22:01 Saturday 22nd April, 2006

CWIZO22-Apr-06 23:49

CWIZO

22-Apr-06 23:49

I have used MasterPages, and my Page_Load events on content pages are fiering just fine.

Could you provide more information. Why are you assuming your methods are not called?

--------------------------------------------------------
My development blog
Q:What does the derived class in C# tell to it's parent?
A:All your base are belong to us!

minhpc_bk23-Apr-06 2:36

23-Apr-06 2:36

Hi there,
When working with the Master Pages, you should remember the sequence in which the events of the master page and content page occur, the Page_Load of the Master page happens after the Page_Load of the content page, you can read more about this in MSDN[^]

2hdass23-Apr-06 10:15

2hdass

23-Apr-06 10:15

In my master page, I have a contentplaceholder, which lets the content page insert the correct controls.

The master page has its own page_load, which populates some of the stuff on the page.

My content page has a page_load as well. It programmaticlly adds control to the content place holder in the master page.

But it doesnt seem to work

In the master page i have a lavel called lblerr
I tried to put this code in the content page to see if it shows up properly
lblerr.Text="blah blah black sheep"
but it doesnt work, it seems like that the page_load for the content page never ran

How do i solve this?!@#!

-- modified at 16:15 Sunday 23rd April, 2006

minhpc_bk23-Apr-06 15:55

23-Apr-06 15:55

Without seeing your sample code, it's quite hard to diagnose your issue, anyway the link below might give you a hint:

Working with ASP.NET Master Pages Programmatically [^]

include aspx file

dadax_8522-Apr-06 12:11