ASP.NET

Arindam Tewary8-Mar-07 18:41

8-Mar-07 18:41

Dear jithbiz0033,
1. Why dont you use percent for your LAYOUT tables ...
2. Or else ..
a)You must have different stylesheet classes pre-defined for your applications and add all stylesheet FILES in your application.

b)Then using some javascript you have to catch screen resolution and apply defferent stylesheet class dynamically to your HTML control.

Thanks,
Arindam D Tewary

jithbiz003312-Mar-07 2:04

jithbiz0033

12-Mar-07 2:04

Hi,
I am not able to get my desired resolution.Any other options available.How to catch screen resolution using Javascript?

Thanks,
jith

Arindam Tewary12-Mar-07 1:40

12-Mar-07 1:40

You can get screen resolution by

alert('Your resolution is :width :'+screen.width+' Height'+screen.height);

Get the current screen resolution and instruct your application to use a specific css file.
As an example: If you have a css file names sample1024.css that can be used once you detect the screen resolution is 1024.

Hope it will be helpfull to you.

Thanks,
Arindam D Tewary

jithbiz003321-Mar-07 18:51

jithbiz0033

21-Mar-07 18:51

Hi Arindam,

Thanks. For the response.I sorted out my error using dreamweaver.The error was in the script tag.I closed the script using.But it preferred the type
<script lang=" " src=" "> .

Thanks Cool | :cool:

Jith

Arindam Tewary24-Mar-07 20:52

connecting DB using ODBC in Windows Service

24-Mar-07 20:52

Dear jithbiz0033,
Cool | :cool:

Thanks,
Arindam D Tewary

ramyasangeet8-Mar-07 17:05

ramyasangeet

8-Mar-07 17:05

hi all,

I am workingin a windows where i need to insert data into the Db using ODBC connection.I used stored procedure to insert data.

here is the code

EventType,Eventdate,vehicle I declared correctly and getting correct values also

System.Data.Odbc.OdbcCommand Emp = new System.Data.Odbc.OdbcCommand("DBO.INSRTEVNT", mycon);<br />
 addEmp.CommandType = CommandType.StoredProcedure;<br />
<br />
                    <br />
 Emp.Parameters.Add("@EventType", System.Data.Odbc.OdbcType.Int).Value = EventType;<br />
Emp.Parameters.Add("@EventTime",System.Data.Odbc.OdbcType.DateTime).Value <br />
= EventDateTime;<br />
Emp.Parameters.Add("@Vehi", System.Data.Odbc.OdbcType.VarChar).Value = Vehicle;<br />
                                        <br />
 Emp.ExecuteNonQuery();

but when i execute the code,the data are not inserting and throwing exception.
here it is

ExceptionSystem.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure or function 'DBO.INSRTEVNT' expects parameter '@EventType', which was not supplied.
but I passed correct data only..

Plz give me suggestions to resolve the problem.

Thanks in advance.

cheers

sangeet

Re: connecting DB using ODBC in Windows Service

Member 38798818-Mar-07 17:34

Member 3879881

8-Mar-07 17:34

Try this code if ur getting that 3 value in textbox like this otherwise based on ur input change the id name...,
Dim strInsertproc As String
strInsertproc = "INSRTEVNT'" & txteventype.text & "','" & txteventtime.Text & "','" & txtvehi.text & "'"
sqlcmd = New SqlCommand(strInsertproc, sqlconn)
sqlcmd.Connection.Open()
sqlcmd.ExecuteNonQuery()
sqlcmd.Connection.Close()
sqlcmd.Dispose()

lblMsg.Text = "Record Inserted............"

Magesh

Re: connecting DB using ODBC in Windows Service

Sandeep Kumar8-Mar-07 19:00

Sandeep Kumar

8-Mar-07 19:00

hi try to add parameters in the following way

Emp.Parameters.Add(New System.Data.Odbc.OdbcParameter("@EventType", System.Data.Odbc.OdbcType.Int));
Emp.Parameters("@EventType").Value = EventType;

Emp.Parameters.Add(New System.Data.Odbc.OdbcParameter("@EventTime",System.Data.Odbc.OdbcType.DateTime));
Emp.Parameters("@EventTime").Value = EventDateTime;

Emp.Parameters.Add(New System.Data.Odbc.OdbcParameter("@Vehi", System.Data.Odbc.OdbcType.VarChar, 100));
Emp.Parameters("@Vehi").Value = Vehicle;

Emp.ExecuteNonQuery();

Re: connecting DB using ODBC in Windows Service

ramyasangeet8-Mar-07 20:07

ramyasangeet

8-Mar-07 20:07

thanks for ur reply ..

i tired the code.
but still am getting the same error.

ExceptionSystem.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure or function 'INSRTEVNT' expects parameter '@EventType', which was not supplied.

plz give me suggestions

cheers

sangeet

Update Panel & Validation

Jagga_Jatt8-Mar-07 17:01

Jagga_Jatt

8-Mar-07 17:01

I am using a text box within the update panel - context
But, I am not being able to validate it using the regularexpression validator.

any Ideas ?

Thank you

another help here

blitz2bleach8-Mar-07 16:22

blitz2bleach

8-Mar-07 16:22

Hello There again i guess, can you help me w/ this.i look for some example of validating a username and password in a

database on the internet..well looking for some tutorial instead,i found one and copy it, i follow the instruction, but i

dont get it..maybe im a slowlearner,there are instrcution that i dont get it..

here are the instructions

Pre-Code Setup:
1. Create a New ASP.NET Web Application. I called mine NorthLogin2
2. Rename the default aspx Webform to Login or Index or something more descriptive. I called mine Login2.aspx
3. Assuming you are in Visual Studio.Net right click on this form in the Solution Explorer and Select Set as Start Page.
4. Find your Northwind.mdb file (The classic Northwind Database in Access)
Under Tools, Options, Tables/Queries Tab select Run Permissions as Owner's
5. Create a new table for login requirements. I called mine tblUser
Columns U_id (autonumber), U_Name (text), and U_Password (text with Input Mask of Password)
6. Create Query (i.e. Stored Procedure) to validate login(s). I called mine sp_ValidateUser
In the SQL Designview the code for that query is
SELECT COUNT(*) AS Num_of_User
FROM tblUser
WHERE (((tblUser.U_Name)=[@UserName]) AND ((tblUser.U_Password)=[@Password]));
This query counts the number of users that it retrieves which matches the where clause. The @UserName and @Password are the

values passed in to the query from the Webform.
7. Close database, because you can not access it while it is open.

-----------END

--->in the ff. instruction i already done the instruction # 1-5..im confused about #6..would you help me with that..coz

there are no instruction, i dont know how to put COUNT* on the query at MS ACcess,i tried to create in a "Create Query in

Design View" but where should i found COUNT(*)??im not that expert in MS Access and SQL..

-->what does API mean?.

-->well theres another one...along with the tutorial is said that "This is sample code for a ASP.Net Login page (using Visual

Basic.Net code behind) with OleDB connection to an Access Database using ADO.Net."..it means whenevr you bulid or creating

asp.net with database access does it means that im also creating a Access database at ADO.net??

-->ok here is another one(sorry if im going to ask all the confusing question inside my head)..im also want to create a

"Forum" web application that i will include in our website project...our team leader(only at our project)also my classm8 said

that i have to used a "control panel" to done it..i dont know what she means??would someone give me an idea what "Control

Panel" is or a hint to start a 'FOrum Web Application" or what shoud the best web control to used in this application..

-->if i will ask my team leader to explain it to me well she will get angry if she found out that in our project there are

still no development that im trying to connect to the database, also trying to figure out how to validate password and

username name in a database(well to tell you that in our group,im responsible in coding asp,net)..

-->for those who always help me thank you..i know that im some kind of stupid, i may used my common sense,but i dont still

get it..Im just new at programming asp.net...

-->once again thank you for reading this thread..hope you can give me advice..becuase i dont know what to do..

Im tired thingking

Re: another help here

linpihong8-Mar-07 19:02

linpihong

8-Mar-07 19:02

write the sql query in your login page's code behind file, then use oledb to connect the access database and execute the query

Re: another help here

Arindam Tewary8-Mar-07 19:03

From Crystal Report, I'm getting some error message..

8-Mar-07 19:03

Dear blitz2bleach,
1. Regarding your Count(*) problem : Just check your MS access editor or what you say MS access Quesry designer you can get the Count function somewhere in Function(s)

2. API is nothing but Application Programming Interface. Just method and properties of class that you can use while developing an appliation.

Thanks,
Arindam D Tewary

JoinTTT8-Mar-07 16:09

JoinTTT

8-Mar-07 16:09

When I run my simple project, I am getting this message below.

"The report you requested requires further information."

What does it mean? If you know, please share it with me!!!

Keep battling!

Re: From Crystal Report, I'm getting some error message..

Member 38798818-Mar-07 17:26

Member 3879881

8-Mar-07 17:26

I think ur connecting 2 two tables and display the o/p,
so,regarding that,u need some other field also want to tell in that display query...,

Magesh

setting sessions from a database query

jake williamson8-Mar-07 15:52

8-Mar-07 15:52

1st post so go easy!

coding: aspx web pages in vb.net 2.0
database: sql server express

i would like to set session variable values from a database query and i cant find out how to do it!

the page flow would be something like this:

1) query database using 'SELECT userID, firstName, lastName FROM users WHERE userID = 1'

2) if data is returned:

create userID, firstName and lastName sessions from the database values for those columns.

3) if no data is returned

tell the user an error has occurred.

4) finally display the session values or the error message on the page.

i can find thousands of tutorials on how to bind data to controls (GridView, DataList, Repeater etc) but none telling me how to query the database and set sessions, cookies or page variables...

if anyone can shed some light on this, it'd be great!

thanks out there,

jake

jake williamson8-Mar-07 17:48

8-Mar-07 17:48

i've made a bit of progress with this problem.

this works, but i'm *pretty* sure that it's not the right way to do it.

this code 'loops' through all the database returns but in my example, there should be only one row returned.

i also cant figure out how to do a (this is in english not code):

if (dataSet is empty) Then<br />
<br />
	set a error message<br />
<br />
Else<br />
<br />
	create the sessions<br />
<br />
End If

hmmm, tricky.

this is the code i've put together:

Dim conn As SqlConnection = [con string here]<br />
Dim dsProjects As DataSet = New DataSet()<br />
Dim cmd As SqlDataAdapter = New SqlDataAdapter("SELECT userID, firstName, lastName FROM users WHERE userID = 1", conn)<br />
<br />
cmd.Fill(dsProjects, "tblProjects")<br />
<br />
Dim dr As DataRow<br />
Dim dt As DataTable = dsProjects.Tables("tblProjects")<br />
<br />
For Each dr In dt.Rows<br />
<br />
	Session("clientID") = dr("clientID")<br />
	Session("clientID") = dr("firstName")<br />
	Session("clientID") = dr("lastName")<br />
<br />
Next

what do you reckon out there? am i going about this the right or wrong way?!

cheers,

jake

RichardGrimmer9-Mar-07 4:25

RichardGrimmer

9-Mar-07 4:25

That's pretty much how I'd do it too, with a couple of points to note...

Firstly, I tend not to use raw SQL in my code, for a variety of reasons....I would use a stored proc in the DB to get the data using a sqlCommand Object

Secondly, theere seems to be a little bit of redundency going on - instead of....

Dim dr As DataRow
Dim dt As DataTable = dsProjects.Tables("tblProjects")

For Each dr In dt.Rows

Session("clientID") = dr("clientID")
Session("clientID") = dr("firstName")
Session("clientID") = dr("lastName")

Next

you know that you're only going to return 1 or zero rows, so the loop is not necessary....so it would become

Dim dr As DataRow
Dim dt As DataTable = dsProjects.Tables("tblProjects")
dr = dt.Rows[0]

Session("clientID") = dr("clientID")
Session("clientID") = dr("firstName")
Session("clientID") = dr("lastName")

which could be further simplified to...

Session("clientId") = dt.Rows[0]["clientId"]
Session("firstName") = dt.Rows[0]["firstName"]
Session("lastName") = dt.Rows[0]["lastName"]

Another alternative would be to take advantage of the fact that session stores objects just fine - so if you wanted to, you could store the DataRow itself, and pull the values out when needed using somehting like :

Session ["theDataRow"] = myDataRow;
.
.
.
DataRow dr = (DataRow)Session["theDataRow"];

it's swings and roundabouts really!

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

jake williamson9-Mar-07 18:25

9-Mar-07 18:25

hi richard,

thank you for your post, it's really helped me out! as you say, it's swings and roundabouts; there's never a '100% this is the only way you do it' solution with programming and it's always good to get a 2nd opinion to make sure your heading in the right direction.

i agree with using stored procedures instead of inline sql but for forum posts, i usually type it out to avoid confusion with column names etc (also handy when someone spots a blunder in the sql!).

everything is now working, the only thing i've left to solve is this:

i currently show the session values back to the page in text box's. as all my asp code in a 'code behind' file, i can response.write a message (or bind it to a label) back if no data is returned sort of like this:

If (dt.Rows.Count = 0) Then
Response.Write("no data returned")
End If

but what i cant figure out is how to not show the text boxs on the page, just the message? i know i could do the same if statement on the page, but that means not using the code behind file which i'm very keen on.

back to google for a bit me thinks!

thanks again for your help,

jake

RichardGrimmer9-Mar-07 22:37

RichardGrimmer

9-Mar-07 22:37

I think I get what you mean...

The usual way that I show and hide different content is by using divs. If I follow you correctly, I'd set my page up something like

<table>
<tr>
<td>
<div id="divSuccess" style="width:100%; height:100%; display:none">
<asp:TextBox.........>
<asp:TextBox.........>
</div>
<div id="difFailure" style="width:100%; height:100%; display:none">
<asp:label...........>
</div>
</td>
</tr>
</table>

Then I'd use client scripting and document.getElementById() to set the display to "inline" for the div I wanted to show. If you were determined to do something on the server side, then you could either add a runat=server to the divs and manipulate their styles, or alternatively (and IIRC) an <asp:panel> exposes a Visible property, and renders as a div anyway Smile | :)

If you wanted a simpler method, you could of course just manipulate the visible property of the label and textboxes directly - I just like doing it with divs to keep the markup nice and clear, and so that if you encounter a divSuccess.style.display = 'inline' then it's easier to get what's going on quickly.

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

jake williamson11-Mar-07 20:53