WebNewbie
Last Activity: Aug 15 '07, 12:36 AM
Joined: Jul 24 '07
Location:
-
Granting write access to a file
I have selected the Security tab, account, advance and find now tabs in user group pane, "Machine Name/ ASP.NET", and selected Add and the permission of choice. I restarted VS 2003 and asp.net, but it still does not work. Please tell me how to resolve this, I've already tried other user accounts but to no avail.. -
Paging using Mysql Stored Proc
Hi, I am new to using mysql and there isn't any tutorials online on that shows how to create mysql stored procedure for paging purposes. Thus, I read tutorials on creating stored proc that were written for use with SQL Server. I just need to be shown how to convert the syntax to one that is compatible with MySQL. The following is the stored proc written for SQL Server, please show me how to convert to a MySQL compatible syntax. Thank you in advance... -
Declaring variables in MySQL
Hi, when declaring a variable in MySQL, must I use the @ symbol as the starting character of my variable name? I've looked at some tutorials on creating functions in MySQL and it didn't seem like @ was used for variable naming. I just wanted to be sure, thank you in advance for your help. -
Columns and Fields are the same?
Hi, please clear up something thats been confusing me regarding a database. Are database columns the same as database fields, if so why are there two ways to drop them? For example to delete a field the syntax is DELETE from [table name] where [field name] = 'whatever';, and to delete a column the syntax is alter table [table name] drop column [column name]; If they are same why are there two ways to do the same thing? Thanks for your help. -
Stored Procedure
Hi, when the select statement is used directly in the codebehind of an ASP.NET page it looks something like this.
DBCommand = New OdbcCommand("SE LECT CarID, Model From CarsTB where Make = '" & Manufacturers.I tems(i).Text & "'", DBConn)
If I want to use a stored procedure to do exactly the same as the line above, what would the syntax be? How to I keep DBConn which is a variable of type, since... -
How to use Paging with Response.Write()
Hi, suppose my select statement returns more than one record and I use Response.Write( ) to write the data retrieved from the database. How do I implement Paging where I can tell how many results per page I want to display? Thank you in advance for your help. -
Codebehind
Hi, normally when you drag a control from the toolbox to the form, code for that control will automatically be generated in the codebehind. For an unknown reason when I drag the Label control on to the form that did not happen. Would you please help me fix this problem? Thank you in advance for your help. -
If your still interested in having your problem solved PM. -
If your still interested in having your problem solved PM me at souriya_s@yahoo .com. (souriya_s just in case you didn't see the underscore)Leave a comment:
-
Hi, if you're still using VB.NET 1.1 there is a book called
Beginning VB.NET 1.1 Databases From Novice to Professional.
This book is a very good book in my opinion and it does an excellent job of explaining how to create database driven applications using VB.NET. I don't know if there is one for VB.NET 2005 by the same authors but you can google it. Hope that helps.Leave a comment:
-
Hi, try this link, the tutorial is written in C# but you can convert it to VB.NET if you need to. Hope that helps.
http://www.codeproject .com/aspnet/combobox.aspLeave a comment:
-
Hi, try the link below, it is written in C# . If you want to convert it to VB.NET go to the link below it. Hope that helps.
http://www.codetoad.com/asp.net/aspnetcontrols12.asp
Convert C# to VB.NET
http://www.developerfusion.co.uk/uti...sharptovb.aspx...Leave a comment:
-
Object reference not set to an instance of object
Hi, the exception "Object reference not set to an instance of an object", was thrown when I run my code.
[code=vbnet]
Dim DBConn As OdbcConnection
Dim DBCommand As OdbcDataAdapter
Dim i As Integer
Dim DS As New DataSet
For i = 0 To CarNames.Items. Count - 1
If CarNames.Items( i).Selected... -
Hi, thanks for responding, that was an error I have fixed already and that line is now
Me.ListBox2.Dat aValueField = "Resumes"
Also the select statement has been changed to
("SELECT ResumesID,Resum es FROM contenttbl where Professions = '" & ListBox2.Items( i).Text & "'")
Unfortunately the changes didn't help.Can you tell me how to edit my post,? I'm new here...Leave a comment:
-
How to display text files from a database
Hi, please help I've been wrestling with this for a very long time and its not working. I'm trying to display text files from a database when someone selects one or more list items of my listbox. The list box contains names of various professions. The database I'm accessing contains Resumes field, Professions field, and ResumesID field. When a user selects one or more list items, the profession in the Professions field that match the text of the...
No activity results to display
Leave a comment: