Re: problem in migrating from asp to asp.net 1.x - ASP.NET Discussion Boards

Re: problem in migrating from asp to asp.net 1.x [modified]

divyesh143229-Jun-07 3:09

29-Jun-07 3:09

in asp .net there will be two files of a particular page. one is aspx i.e. design that contains html and asp tags will be there and another is aspx.vb or aspx.cs (code behind file) depending upon your language selection.

you have to declare all your variables and objects in that code behind file that contains the logic of your page and it also handles events of the controls.

you want to access adodb that you need to add reference of it. right click on solution explorer and click on add references and select your particular reference now you need to imports (vb) or using (c#) that adodb name space in your code behind file and you can access all its classes.

-- modified at 9:22 Friday 29th June, 2007

Re: problem in migrating from asp to asp.net 1.x

Not Active29-Jun-07 3:23

Not Active

29-Jun-07 3:23

divyesh1432 wrote:
you have to declare all your variables and objects in that code behind file that contains the logic of your page and it also handles events of the controls.

Not true. The code-behind file is not required. Using tag < you can have your code in the presentation file. Not recommended, but still possible.

<div class="ForumSig"><hr>only two letters away from being an asset</div>

Re: problem in migrating from asp to asp.net 1.x

Narendra Mohan29-Jun-07 4:18

Narendra Mohan

29-Jun-07 4:18

Hi,

I am very much thankful to your reply.
We have included ADODB to the reference but still it is Showing same Error.
Below is Our Migrated code:

<%@ Import namespace="ADODB" %>
<%@ page language="VB" aspcompat="true"%>

<%
Dim gi_LoginOptional As Object
Dim displayHeader As Object
Dim cmd As ADODB.Command
Dim con4 As ADODB.Connection
Dim rs1 As ADODB.Recordset
Dim g_IsLoggedIn As Boolean
Dim displayFooter() As Object
Dim i As Integer
Dim g_HasLoggedIn As Boolean
Dim rs2 As ADODB.Recordset
Dim writeOneOption As Object
Dim MemberOpen() As Object
Dim loginURL As String
Dim headAdd As String
%>
<%
'temp send everyone to homepage, per joey. -rmesard 23-apr-2007
'response.Redirect "content.asp?from=index"
'response.end

con4 = New ADODB.Connection
rs1 = New ADODB.Recordset
rs2 = New ADODB.Recordset
cmd = New ADODB.Command

%>

It si Showing the Error As

Compilation Error
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: BC30002: Type 'ADODB.Command' is not defined.

Source Error:

Line 9: Dim gi_LoginOptional As Object
Line 10: Dim displayHeader As Object
Line 11: Dim cmd As ADODB.Command
Line 12: Dim con4 As ADODB.Connection
Line 13: Dim rs1 As ADODB.Recordset

Source File: http://localhost/wlb2003/index.aspx Line: 11

Thanks and Regards
Narendra

Re: problem in migrating from asp to asp.net 1.x

Narendra Mohan29-Jun-07 5:45

Narendra Mohan

29-Jun-07 5:45

Re: problem in migrating from asp to asp.net 1.x

Not Active29-Jun-07 3:17

Not Active

29-Jun-07 3:17

Because of the many differences between classic ASP and ASP.NET the general advise is to not migrate an application. You will get better results by redesigning and recoding. Sounds like a harsh method, yet the benefits of better code, increased performance and greater extensibility is worth it.

IMO also there is no point in going from ASP to ASP.NET 1.x, you might as well jump to 2.0

only two letters away from being an asset

Re: problem in migrating from asp to asp.net 1.x

Narendra Mohan29-Jun-07 4:05

Narendra Mohan

29-Jun-07 4:05

Hi,
We have included adodb reference in asp.net 1.1 but still we are having the same problem.what to do.Thanks for your help.

Thanks & regards
Narendra

Re: problem in migrating from asp to asp.net 1.x

Not Active29-Jun-07 4:25

Not Active

29-Jun-07 4:25

Read my message, don't migrate.

only two letters away from being an asset

Re: problem in migrating from asp to asp.net 1.x

doWhileSomething29-Jun-07 14:39

doWhileSomething

29-Jun-07 14:39

Narendra Mohan wrote:
<%
Dim gi_LoginOptional As Object
Dim displayHeader As Object
Dim cmd As ADODB.Command
Dim con4 As ADODB.Connection
Dim rs1 As ADODB.Recordset
Dim g_IsLoggedIn As Boolean
Dim displayFooter() As Object
Dim i As Integer
Dim g_HasLoggedIn As Boolean
Dim rs2 As ADODB.Recordset
Dim writeOneOption As Object
Dim MemberOpen() As Object
Dim loginURL As String
Dim headAdd As String
%>

Your going to want to make at the very least a simple connection class and do away with any includes for connection objects.

Some of the above code (the ones I can make out) would then be re-written something like this:

Dim cmd As New SqlCommand
Dim con4 As New SqlConnection
Dim rs1 As SqlDataReader

Assuming your using MSSQL for a DB, otherwise you will need to use Oracle, MySql or OLEDB for Access.

You don't need to write a connection class, you could write it out manually each time, but this is not a good practice and will make managing things more complex in the log run.

Hope this helps.

My Personal Site

Font Problem

divyesh143229-Jun-07 2:49

divyesh1432

29-Jun-07 2:49

hello,

i have a problem that i am using a particular font and it is not installed on client's machine.

does client must installed particular font? or there is another solution.

thank you

Re: Font Problem

cschuman29-Jun-07 9:53

cschuman

29-Jun-07 9:53

You have two options:

1.) Make the text you are displaying an image (this is a problem if you are showing dynamic text).

2.) Install the font on the clients machine.

Lifetime of an object in ASP.NET

www.Developerof.NET29-Jun-07 2:42

www.Developerof.NET

29-Jun-07 2:42

Hi all,

Are all objects created in asp .net transient or persistant???
ie if i write SqlConnection sqlConnection=new SqlConnection(.....) 100 times, does this imply that 100 different objects are created or a single object is overwritten???

Re: Lifetime of an object in ASP.NET

Sylvester george29-Jun-07 2:52

Sylvester george

29-Jun-07 2:52

if you repeat this statement

sam werch wrote:
SqlConnection sqlConnection=new SqlConnection(.....)

for 100 times the code will not compile

if you write

SqlConnection sqlConnection = new SqlConnection(.....);

sqlConnection = new SqlConnection(.....);
sqlConnection = new SqlConnection(.....);
sqlConnection = new SqlConnection(.....);

for 100 times

it will create only one object
but the memory will be refred 100 times
and 100 times insatcne will be generated

and its really a coding HORRoR

Regards,
Sylvester G

Re: Lifetime of an object in ASP.NET

www.Developerof.NET29-Jun-07 3:05

www.Developerof.NET

29-Jun-07 3:05

Suppose i close the connections every time i instantite it, will it dispose off the connection?

Re: Lifetime of an object in ASP.NET

Not Active29-Jun-07 3:12

Not Active

29-Jun-07 3:12

The object will be disposed but because of connection pooling the connection itself may remain open.

http://www.15seconds.com/issue/040830.htm[^]

only two letters away from being an asset

Re: Lifetime of an object in ASP.NET

www.Developerof.NET29-Jun-07 3:35

www.Developerof.NET

29-Jun-07 3:35

Thanks 4 giving ur precious time Rose | [Rose]

Biztalk, pls, answer. pls. I have created a flatfile schema

indian14329-Jun-07 2:27

indian143

29-Jun-07 2:27

Sir,
I am very new to Biztalk server development env. I have created a flatfile schema. When I say Validate Schema its giving all the records in the flatfile and they are correct. But when I say genenrate instance it is showing only dummy record, that too only one.
What I want to do is I have a flat file and that flat file data I want to process in some functoids in Biztalk maps. But its not giving what result I want pls. help me. Thank you.

Regards,
Aleem.

S/W Engineer
Akebono Soft Technologies
aleem_abdul@akebonosoft.com.

Re: Biztalk, pls, answer. pls. I have created a flatfile schema

Not Active29-Jun-07 2:36

Not Active

29-Jun-07 2:36

Stop cross posting and someone may answer you. This has nothing to do with ASP.NET

only two letters away from being an asset

incorrect syntax error...,

Member 387988129-Jun-07 2:20

Member 3879881

29-Jun-07 2:20

in my button click event i am filling the datas from my stored procedure to datagrid...,
But i am getting error like...,
Incorrect syntax near ','
And its showing error place at

mysqldataadapter.fill(mydataset,"st") place...,
This is my code...,

mySqlDataAdapter = New SqlDataAdapter("Magview" & Val(ddEmpid.SelectedItem.Value) & "," & Val(ddlMonth.SelectedItem.Value) & "," & Val(ddlYears.SelectedItem.Value) & "", sqlconn)

myDataSet = New DataSet

mySqlDataAdapter.Fill(myDataSet, "st")
DataGrid1.DataSource = myDataSet
DataGrid1.DataBind()
mySqlDataAdapter.Dispose()
myDataSet.Dispose()
sqlconn.Close()

And this is my stored procedure:

CREATE PROCEDURE MagView
(
@EId as int,
@months as tinyint,
@years as smallint
)
As
begin

select hra as hra1,'hra' AS magc
from tblmonthsalary
where hra <> 0 and Eid=@Eid and Smonth=@months and SYear=@Years
UNION
select ca as hra1, 'Ca' AS magc
from tblmonthsalary
where ca <> 0 and Eid=@Eid and Smonth=@months and SYear=@Years
UNION
select ota as hra1, 'ota' AS magc
from tblmonthsalary
where ota <> 0 and Eid=@Eid and Smonth=@months and SYear=@Years
UNION
select sha as hra1, 'sha' AS magc
from tblmonthsalary
where sha <> 0 and Eid=@Eid and Smonth=@months and SYear=@Years
union
select al as hra1,'al' AS magc
from tblmonthsalary
where al <> 0 and Eid=@Eid and Smonth=@months and SYear=@Years
UNION
select alp as hra1, 'alp' AS magc
from tblmonthsalary
where alp <> 0 and Eid=@Eid and Smonth=@months and SYear=@Years

end
GO

Plz solve my probs...,

Regards,
Magi

Re: incorrect syntax error...,

kubben29-Jun-07 2:25

kubben

29-Jun-07 2:25

The Fill method doesn't have any over loads that match what you are trying to do. Why are you putting , "st" after the myDataSet? It should probably be just myDataSet) nothing else.

Ben

Re: incorrect syntax error...,

Member 387988129-Jun-07 2:28

Member 3879881

29-Jun-07 2:28

If i remove "st" aslo its giving same error...,
See i have attached my stored procedure too in my pre msg...,
Hlp me...,

Regards,
Magi

Re: incorrect syntax error...,

kubben29-Jun-07 2:31

kubben

29-Jun-07 2:31

Well, looking at your code:
("Magview" & Val(ddEmpid.SelectedItem.Value) & "," & Val(ddlMonth.SelectedItem.Value) & "," & Val(ddlYears.SelectedItem.Value) & "",

Would probably translate to:
MagviewValuefromDropdown,MonthSelected,YearSelected

So I am guessing you need a space after Magview

So your code probably should be:
("Magview " & Val(ddEmpid.SelectedItem.Value) & "," & Val(ddlMonth.SelectedItem.Value) & "," & Val(ddlYears.SelectedItem.Value) & "",

Ben

Re: incorrect syntax error...,

Member 387988129-Jun-07 2:37

Member 3879881

29-Jun-07 2:37

Hey yar how i forget to give the space on there...,
Ya want to give space on ther...,
Anyway thanks to spend ur time with me...,
keep in touch,

Regards,
Magi

Re: incorrect syntax error...,

doWhileSomething29-Jun-07 14:53

doWhileSomething

29-Jun-07 14:53

The additional parameters when filling the dataset are optional, the second paramater is for the table name. It could be the identical name of the table your pulling from, or just an alias so you can reference it later (assuming you have more than one in your dataset).

This is likely where the error is comming from:

mySqlDataAdapter = New SqlDataAdapter("Magview" & Val(ddEmpid.SelectedItem.Value) & "," & Val(ddlMonth.SelectedItem.Value) & "," & Val(ddlYears.SelectedItem.Value) & "", sqlconn)

The data adapter has two optional parameters you can use when you create the NEW instance of it.
Commandtext(string) and an sql connection object.

Your parameters broken down look like this:
("Magview" & Val(ddEmpid.SelectedItem.Value)
& ","
& Val(ddlMonth.SelectedItem.Value) &
"," &
Val(ddlYears.SelectedItem.Value) & "",

sqlconn

The first one is what throws me off a bit, you have a fixed string and concatenating that with what should be a numeric value. (kind of sloppy code Frown | :(

)) If it is a string, then you need to wrap it with single quotes. The last piece of your string appends a double quote, not sure why, but it doesnt match anything else.

If these are parameters that you are trying to feed a SPROC, then this too is still wrong.

Can you explain what it is your trying to do?

My Personal Site

Identifier Expected Error

vijay_8329-Jun-07 2:01

vijay_83

29-Jun-07 2:01

this is my code in which i get an error as "Identifier Expected in line:

private const SecretSalt = "H3#@*ALMLLlk31q4l1ncL#@...";

_____________________________________________________________________________

private void Page_Load(object sender, System.EventArgs e)
{
lnkToB.NavigateUrl = CreateTamperProofURL("TamperProofURLs.B.aspx", "NonTamperProof=1", "TP1=Scott&TP2=27");
}

//The secret salt...
private const SecretSalt = "H3#@*ALMLLlk31q4l1ncL#@...";

public string CreateTamperProofURL(string url, string nonTamperProofParams, string tamperProofParams)
{
string tpURL = url;
if (nonTamperProofParams.Length > 0 || tamperProofParams.Length > 0)
{
url // ERROR: Unknown assignment operator ConcatString
;
}

//Add on the tamper & non-tamper proof parameters, if any
if (nonTamperProofParams.Length > 0)
{
url // ERROR: Unknown assignment operator ConcatString
;

if (tamperProofParams.Length > 0) url // ERROR: Unknown assignment operator ConcatString
;
}

if (tamperProofParams.Length > 0) url // ERROR: Unknown assignment operator ConcatString
;

//Add on the tamper-proof digest, if needed
if (tamperProofParams.Length > 0)
{
url // ERROR: Unknown assignment operator ConcatString
;
}

return url;
}

public string GetDigest(string tamperProofParams)
{
string Digest = string.Empty;
string input = string.Concat(SecretSalt, tamperProofParams, SecretSalt);

//The array of bytes that will contain the encrypted value of input
byte[] hashedDataBytes;

//The encoder class used to convert strPlainText to an array of bytes
System.Text.UTF8Encoding encoder = new System.Text.UTF8Encoding();

//Create an instance of the MD5CryptoServiceProvider class
System.Security.Cryptography.MD5CryptoServiceProvider md5Hasher = new System.Security.Cryptography.MD5CryptoServiceProvider();

//Call ComputeHash, passing in the plain-text string as an array of bytes
//The return value is the encrypted value, as an array of bytes
hashedDataBytes = md5Hasher.ComputeHash(encoder.GetBytes(input));

//Base-64 Encode the results and strip off ending '==', if it exists
Digest = Convert.ToBase64String(hashedDataBytes).TrimEnd("=".ToCharArray());

return Digest;
}
In which case do i get that error. pls do help me in solving it.

Regards
Vijay.

Re: Identifier Expected Error

Vasudevan Deepak Kumar29-Jun-07 2:10

Vasudevan Deepak Kumar

29-Jun-07 2:10

vijay_83 wrote:
private const SecretSalt = "H3#@*ALMLLlk31q4l1ncL#@...";

Can you try @"H3#@*ALMLLlk31q4l1ncL#@...";?

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

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