Posts by Letscode

Is userID declared as a primary key?(In order for it to have an index)
R U using somekind of a stored procedure to get the values?

Machi,
Tell us the exact error you are getting and tell us the version of IIS too.

I guess it should be something like this
" Error while trying to run project: Unable to start debugging on the web server........"

Do this step by step.

Create a database.
a. Create the necessary tables and populate all the values belonging to that table(Library details).
b. Create two tables, one for Registering the username and password and other for storing the users details and name it UsertableDetails..(Its up to you how to design the database)

This is the link to registration page.
http://www.daniweb.com/tutorials/tutorial23605.html

and this is the link to authentication page
http://www.daniweb.com/techtalkforums/thread19303.html

c.Now what ever values you want to retrieve for a particular user, retrieve it from UsertableDetails.

You should be fine.

I got a link that answers my questions:
http://www.controlav.com/bphelper/bpbound.asp?product=7.1&code=m

:D Well you mistook recreate the application keyword. It basically means what you just did. Create a new project and add these files to it. Or what I usually do is delete the Solution file and rebuild the project. It works fine.

Redo the whole project from scratch, Boy I not a mad man. :mrgreen: :mrgreen:

I'm not sure of what U are asking.
Well I guess your question is
how to show the status of the user or his details?

If thats your question then the most effective way will be to use a Database and provide a Login authentication and get the user information from the database.

Did it answer your question?

Thats because VS.NET is BAD. Dont play with it. LOL Jus kidding

I think there should be some problem with your Machine Debug Manager. Visual Studio.NET uses a service called Machine Debug Manager (MDM.EXE) to do debugging. Its an external and Privilege service.
It screws up sometimes and most of the problem created by this service will be solved if you recreate the application or sometimes restart the whole application (Worse case).

Hey noman,

You can do this real easy in MySQL. Use the LIMIT and OFFSET keyword. Thats it you are done.

But in MSSQL there is no LIMIT and OFFSET function. Unfortunately there is no other in-build clause provided in MS SQL to do this.But the same feature can be achieved in MS SQL with a little trick.

Suppose you want to write a query to return values from 6 - 8 (6,7,8) ,this can be achieved by TOP clause in MSSQL.

This is very simple,
Results 6-8 would be the first 3 rows of a TOP 3 statement, with a nested query with a TOP 8 statement in the opposite order.

Consider the employees table in NorthWind database,

This query will fetch you rows from 6-8(6,7,8).

SELECT * FROM 	(SELECT TOP 3 * 
		FROM 	(SELECT TOP 8 * 
			FROM [Employees] 
			ORDER BY [EmployeeID]  ASC) AS tbl1 
		ORDER BY EmployeeID DESC) AS tbl2 
ORDER by EmployeeID ASC

Note:
1. Use the Alias tbl1,tbl2
2. Tweak the ORDER BY for complex results.

INSERT INTO test
(SELECT [Customer Id] 
FROM   [Customers])

Works fine.

English-->Grammer

what script did you run?
Are you getting a Blank page or an Error Page?

Can you show us your script?

I'm trying to populate a table from a sub-query.

CREATE TABLE test
(
ID int
)


INSERT INTO test
VALUES (SELECT [Customer Id] 
FROM   [Customers])

QUESTION:
I know you can do this in ORACLE but Is something like this possible in T-SQL.

I can also write something like this in SQL which achieves the same result but I will lose the datatype,

SELECT [Customer Id] 
INTO test
FROM   [Customers]

Any suggestions is greatly appreciated.

What you are saying is when a tech executive signs in and logs out, her session is not expiring.
If the user has a page opened then the session will not expire unless you logout.
When the page closes then the session state variable will automatically expire.

Even if the session did not expire like what your saying,your session variable should be replaced by the existing value for the input user.Check whether your user input gets replaced in the session variable.

What kind of Authen mode are you using?

What Browser are you using?

Morbid --> Diseased

Thanks,
I wont try that on my DOS.Did that long time ago?Had a bad exp with DEL *.* :)

I'm researching on COM now.

Any ideas on how to add these BAT files or COM files to Sytem Startup.
I know you can add it to the Sytem Registry but I'm not sure of the details?
Is there any other way like creating an EXE to store these files to System registry to load them on Start up.

I want to store this Bat file on system Startup,so that when I log onto Windows,It will clean TEMP and Other files.

PS: I'm not trying to create an Adware here. :)

Thanks for your suggestions.
I did quick research on Creating a Batch file and Commands in it.

This code will do the JOB.

@ECHO OFF
del /q C:\TEMP\*.*

my main problems currently are not beeing able to update my members in the DB and I can't verifi credit card info.

so far I was able only to read from my DB not write to it.

In your Project under the File Sales,

I found out these code,

this.oleDbInsertCommand1.CommandText = "INSERT INTO tblSales(CountSale, Date_sale, Sale_Cus_Code, Sale_movie_code) VALUES" +
				[B]" (?, ?, ?, ?)"[/B];

And the Parameter assigning is given something like this,

this.oleDbInsertCommand1.Parameters.Add[B](new System.Data.OleDb.OleDbParameter("CountSale", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "CountSale", System.Data.DataRowVersion.Current, null));[/B]
			this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Date_sale", System.Data.OleDb.OleDbType.DBDate, 0, "Date_sale"));
			this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Sale_Cus_Code", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "Sale_Cus_Code", System.Data.DataRowVersion.Current, null));
			this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Sale_movie_code", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "Sale_movie_code", System.Data.DataRowVersion.Current, null));

Problems
1.I dont see where the parameter is declared.
2.I dont see where the parameter is Assigned.

Can you verify that?

Hello,
I'm trying to create somekind of a process that will allow me to delete files in TEMP folder.

Its bascially a shortcut from desktop.When you click that you can delete files in TEMP directory.

Thanks

war --> Death

What do you want to do with the code?

Whats your next step? Can you be specific what you are asking for?

Then use anchoring and Docking.

Read Articles
http://www.c-sharpcorner.com/winforms/AnchDocInWinFormsGAG.asp
http://www.developerfusion.co.uk/show/4375/5/

Use CSS style sheets.That is the best way to handle different screen resolution.Load different style sheet for each screen resolution.

1.Make sure your SMTP server path is correct.
2.This may be absurd but check your Bulk folder.Often the mail you send goes to the Bulk folder.
3.Paste your code,if you still arent able to solve the issue.

Use a Javascript,
Cuz this runs in the client browser.
Check out this code..

var Days = new Array('Sunday','Monday','Tuesday','Wednesday',
	'Thursday','Friday','Saturday');

var today = new Date();
var Year = takeYear(today);
var Month = leadingZero(today.getMonth()+1);
var DayName = Days[today.getDay()];
var Day = leadingZero(today.getDate());
var Hours = leadingZero(today.getHours());
var Minutes = leadingZero(today.getMinutes());
var Seconds = leadingZero(today.getSeconds());

function takeYear(theDate)
{
	x = theDate.getYear();
	var y = x % 100;
	y += (y < 38) ? 2000 : 1900;
	return y;
}

function leadingZero(nr)
{
	if (nr < 10) nr = "0" + nr;
	return nr;
}

I got it from this URL

Your code is working on the server side ,so thats the reason Y you are getting date on the server.

For you code to work on the client side,You gotta code that in Javascript that runs in the client browser.

If you are using SQL server 2000,Try debugging using the Query analyzer.

Check this website,
http://www.15seconds.com/issue/050106.htm

Also check your Datatype,Make sure you are sending the same datatype to update the database.

Check your code,
I assume Policy Number is an Integer in your Database but you are sending a string.

Try this,
Convert.ToInt32("" + VariableName + "")

Thank you for helping me with this! :cheesy:

I seem late to respond that it because i try to let as much soak in as i can.. This to string is really bothering me... I have paper taped up on my walls with different defenitions and it still is not completely soaking in.. My main concern here is that i know when hte .Tostring is used,, it enables a representation of the current object to be accessed,, HERE is the question... Where is it held until it is used??? .Tostring,, (to where???) at run time does the string go directly to the object that will utilize its value?,.,

I know these are small patatos; however, i am in need to get a better understanding about this..

I am missing something some where..

Erik...

Hmm.I'm not sure what you are asking.
The .Tostring is a property which converts the values in the DataReader to a string.

Thats It.Its just a property.Even if you remove the Tostring property your code will work.

Only thing to be noted is you'll have to keep track of dataType of the values which you are accessing in the DataReader if you remove the ToString Property.

check out this Forum,
Not sure whether that helps you.

http://www.daniweb.com/techtalkforums/thread27607.html

Einstein's Birthday-->party

You can use SQL server 2000 or Oracle. I use SQL server 2000 in my office.I'm not sure about Oracle.

I would suggest you to go for ArcGIS server.You can use a database that can hold spatial information on a particular feature.

Hope it helps

ArcGIS Server is a server-based deployment of the ArcObjects component library (including extensions). This new product is for developers who want to build shared server applications that contain advanced GIS capabilities in both a client/server environment and a Web services environment. ArcObjects provides the source of the serverside functionality.

More online at http://www.esri.com/software/arcgis/arcgisserver/ with downloadable literature at http://www.esri.com/software/arcgis/arcgisserver/about/literature.html

In contrast, ArcIMS is ESRI's Internet solution for the publishing of maps, data, and metadata. Its goal is to deliver data to many users on the Web. ArcIMS is designed for high throughput, high-performance mapping, metadata services, data streaming, and a variety of focused functions over the Internet (via XML, HTTP, etc.). ArcIMS is aimed toward developers looking for a traditional way to serve maps on the Internet and also build custom Internet solutions

More online at http://www.esri.com/software/arcgis/arcims/ with downloadable literature at http://www.esri.com/software/arcgis/arcims/about/literature.html

There is a table at the bottom of http://www.esri.com/software/arcgis/arcgisserver/about/overview.html that outlines major differences in functionality.

Also Visit www.esri.com for more details and there is a forum there where you can post.

What kind of softwares do you have?
Since you are using the softwares produced by ESRI ,I'm assuming you are using ArcIMS or ArcGIS server?

No you dont actually need Authentication to clear the cache.If you use authentication you can have better control on your application.

For your application ,
Just add this code to the page load.

Response.Buffer = True
        Response.ExpiresAbsolute = Now().Subtract(New TimeSpan(1, 0, 0, 0))
        Response.Expires = 0
        Response.CacheControl = "no-cache"

What happens is It prevents the page from being cached.so that the page will be loaded as a new page rather than taking values from the cache.

Are you using any Authentication?
Do you want to expire the cookies?

I'm glad you solved the issue.

Can you post your Javascript code for the Image,Datagrid and your server script code for datagrid.

R U dynamically creating an Image control inside a datagrid.

Read this article to find out the differences between ASP.NET and ASP.
It clearly explains the differences from programmers stand point.

Differences between ASP and ASP.NET

Hope it helps

Completed this problem.

What I did was Display a Please wait Image on the left frame when the user checks the dropdownlist and in right frame on the page unload property,when every processing is over i called a javascript function in the left frame to hide the Please wait image.Javascript can save you from alot of mess.

Just thought of posting this so that if somebody else has the similar problem they can use this workaround.

Your First question,

In your code when you write ----> While dreader.Read()
ddlCompanyName.Items.Add(New ListItem(dreader(0).ToString()))
End While <-------------

I'll explain you what this code does.

While dreader.Read()
                ddlCompanyName.Items.Add(New ListItem(dreader(0).ToString()))
            End While

In the database,if there is only one value to be populated you can use something like this

ddlCompanyName.Items.Add(New ListItem(dreader(0).ToString()))

But in our database there are more than one value to be populated inside the DropDownlist,

For example say,

CompanyA
CompanyB
CompanyC
CompanyD

Say you wanna populate these four values into the database,
your first step will be to use a DataReader to store these four values into the database.

Once you execute this code,

dreader = cmdcounty.ExecuteReader()

CompanyA
CompanyB
CompanyC
CompanyD

All the four Company values will be store into the DataReader.

Then if you use this code,

ddlCompanyName.Items.Add(New ListItem(dreader(0).ToString()))

Only the value CompanyA will be populated into the DropDownlist.

But you need the four values to be populated into the DropDownlist.

So you write somekind of a loop,

While dreader.Read()
                ddlCompanyName.Items.Add(New ListItem(dreader(0).ToString()))
            End While

What this code does is that it reads the DataReader,
1.checks whether Datareader has any values.

2.If there are any values then the second line in the code will be executed,

ddlCompanyName.Items.Add(New ListItem(dreader(0).ToString()))

This code creates a NEW ITEMLIST and then populates the value from the dataReader into the DropDownlist,

3.Since its a while loop it …

No problem

Same here.8-10 hours at work and 4 hours at home.

But you gotta really take care of you Spine.Sitting in front of your computer improperly can lead to a lot of difficulties in the future.

Everybody in this forum,Please check out this site on how to sit properly in front of your computer.This will surely help you someday

http://www.spine-health.com/topics/cd/ergo/ergo05.html

Also check out this Image on protecting your Spine cord,

http://www.est.or.th/documnet/backpain/spine_care.jpg

Hope it helps

Thanks Jagdish,
That really helped.I'm sure a method like that will certainly solve this issue.

Download the .NET framework servicepack 1,

http://www.microsoft.com/downloads/details.aspx?familyid=A8F5654F-088E-40B2-BBDB-A83353618B38&displaylang=en

I wonder Y webstudio doesnt interest you.It certainly has a lot of features.
Surely you'll have to pay after 30 days of Trial.

Madhu,
Its a pain when your client says "My website must be compatible with all the Browser",
"Well thats easy to say but Are you the one who is coding it."

The same HTML code which works well in IE6.0 wont work exactly the same Mozilla.

Check out this link http://www.howtocreate.co.uk/tutorials/index.php?tut=0&part=16 which talks about obtaining the window size in different browsers.

Being a .NET developer you'll be faced with a lot of incompatibility issues with Mozilla,Netscape,IE.

In Netscape,If you use Frameset and reference the next frameset with a query string ,its a pain since in Netscape the tags will be opened as a new window.But there is an option available in the browser properties to disable it.

Styles will also give you a headache.

Read this Blog,
http://west-wind.com/weblog/posts/188.aspx

I'm not sure what to advice you for browser incompatibility,The only thing I can say is what ever issues you face you can solve it.There is always a work around.

Hi All,
I have specific requirement in web development.
I am Programmer Analyst in .Net, would like to know the difference between Firefox and IE6.0.
Some of the Javascript will not execute in Firefox !!
Does any one have better idea about this !!.

Thanks and with regards,

Madhusudhan.H.K.

I dont have a VB script code.
You can do that in Javascript.Put this inside the Button Onclick event.

if(confirm('Are you sure you wanna delete'))
		var A = window.location("Originalpage.aspx?delete=Yes");
		else  var B = window.location("Originalpage.aspx?delete=No");

You can use a Query String and invoke a delete function.

Hope it helps

If it was me,
I would add these
1.Encryption on passwords in the Database
2.Use crystal reports,Just to get a hang of it.
3.Write a SP for any one of the process.
4.Provide a Datagrid with Editing features.

Hope it helps

The HTML View was rather misleading when people say client script is written in Javacript and HTML.

YES you are right tgeer.The HTML view present in VS is NOT client side scripting.

My apologies for typing something wrong,Thats not my intension.

The HTML view has an HTML format BUT its not exactly the client side code.

ASP.NET generates the client side code for that current project. .

ASP.Net also does some fancy stuff like adding an hidden form field to a WebForm, called "__VIEWSTATE" to maintain state.

ASP and ASP.NET is a whole different language.ASP.NET has much more flexibility than ASP with its Object Oriented Prog.
I prefer ASP.NET to be much easier if you use a database like SQL server 2000.
The same can be achieved in ASP too but it demands a lot of work.
And also I see that you are a student,if you use ASP.NET (whose demand is more than ASP) it will be very useful for your Career.