|
I agree with you, it's not a good idea, but my problem still remains. Do you have any other suggestions?
David Manuel Pires
|
|
|
|
|
I've solved it.
The problem was in the order i was adding the parameters to the OleDbCommand, I wasn't doing it in the same order they where in the UPDATE statement.
So I change the code from:
ublic Sub altpass(ByVal inNome As String, ByVal inPass As String, ByVal inNovPass As String)
Dim comAltPass As New OleDbCommand("UPDATE [Utilizadores] SET [Password]=@NovPass WHERE [Nome]=@Nome AND [Password]=@Pass")
With comAltPass
.Connection = getConexao()
.Connection.Open()
.Parameters.Add(New OleDbParameter("@Nome", inNome))
.Parameters.Add(New OleDbParameter("@Pass", inPass))
.Parameters.Add(New OleDbParameter("@NovPass", inNovPass))
.ExecuteNonQuery()
End With
End Sub
to:
Public Sub altpass(ByVal inNome As String, ByVal inPass As String, ByVal inNovPass As String)
Dim comAltPass As New OleDbCommand("UPDATE [Utilizadores] SET [Password]=@NovPass WHERE [Nome]=@Nome AND [Password]=@Pass")
With comAltPass
.Connection = getConexao()
.Connection.Open()
.Parameters.Add(New OleDbParameter("@NovPass", inNovPass))
.Parameters.Add(New OleDbParameter("@Nome", inNome))
.Parameters.Add(New OleDbParameter("@Pass", inPass))
.ExecuteNonQuery()
End With
End Sub
And it works just fine.
Anyway, I want to thank all of those who spent time trying to help me.
David Manuel Pires
|
|
|
|
|
Hello!
I have a collection with objects that are instances of the same class. The user can create and delete objects, so, the number of objects when the settings are saved is not the same. Moreover, the name of each object, which is also its SettigsKey, is given by the user. The setting values of all existing objects are saved correctly in the user.config file. Knowing a SettingsKey, I can retrieve the settings values from the user.config file and create the object. I would like to create objects for all “SettingsKeys” saved in the user.config file when the application starts.
So, How can I retrieve all the SettingsKey saved in the user.config file?
And, when the user deletes one object, how can I delete the settings values of the deleted object from the user.config file?
Thanks any help.
Umbelino
University of Minho, Portugal
|
|
|
|
|
You're really going to have a tough time doing this. Every user get's their own copy of the user.config file. The users settings are not all sotred in a single copy of the file. The user.config settings that you refer to are stored in the profile of each user. Normally, under the path:
C:\Documents and Settings\userId\Application Data\companyName\appName_evidenceType_evidenceHash\version\user.config
The users, unless an Administrator, cannot see inside the profile folder of another user, and therefore, cannot see the settings another user has defined.
|
|
|
|
|
Yes, I now all this. I am using My.Settings object to store and retrieve application settings and end-user preferences. The settings are stored in two files, app.config file and user.config file (for each user), which is stored in: “C:\Documents and Settings\<username>\Local Settings\Application Data”. When we have multiple instances of the same class they share the same settings class. We can solve this problem by using the SettingsKey property from the System.Configuration.ApplicationSettingsBase Class to define multiple sets of settings. You can see this here, "http://www.code-magazine.com/articleprint.aspx?quickid=0607031&printmode=true[^]". So, in this case, I would like to retrieve all the SettingsKey saved in the user.config file and, when the user deletes one object, I would like to delete the settings values of the deleted object from the user.config file.
Thanks one more time.
Umbelino
|
|
|
|
|
OleDbConnection ConVerify;
OleDbCommand CmdVerify;
OleDbDataReader DtrVerify;
string StrVerify;
ConVerify = new OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=Jigsaw.mdb");
ConVerify.Open();
StrVerify ="Select * From staff";
CmdVerify = new OleDbCommand(StrVerify,ConVerify);
DtrVerify =CmdVerify.ExecuteReader();
string checkuser="";
while(DtrVerify.Read())
{
if (txtusername.Text == Convert.ToString(DtrVerify["staff_username"]))
{
if(txtpassword.Text == Convert.ToString(DtrVerify["staff_password"]))
{
Session["username"]=DtrVerify["staff_username"];
Session["password"]=DtrVerify["staff_password"];
Server.Transfer("mainStaff.aspx");
}else
{
Response.Write("window.alert('Invalid Password! Please Try Again.');<"+"/SCRIPT>");
Server.Transfer("staffLogin.aspx");
}
}
checkuser="Failed";
}
if (checkuser=="Failed")
{
Response.Write("<SCRIPT lanquage='JScript'>window.alert('Invalid Username! Please Try Again.');<"+"/SCRIPT>");
Server.Transfer("staffLogin.aspx");
}
ConVerify.Close();
<div class="ForumSig">Life is up and down
Nevertheless,never give up hope and be confident to yourself</div>
|
|
|
|
|
|
Dim ConVerify As OleDbConnection
Dim CmdVerify As OleDbCommand
Dim DtrVerify As OleDbDataReader
Dim StrVerify As String
ConVerify = New OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=Jigsaw.mdb")
ConVerify.Open()
StrVerify = "Select * From staff"
CmdVerify = New OleDbCommand(StrVerify, ConVerify)
DtrVerify = CmdVerify.ExecuteReader()
Dim checkuser As String = ""
While DtrVerify.Read()
If txtusername.Text = Convert.ToString(DtrVerify("staff_username")) Then
If txtpassword.Text = Convert.ToString(DtrVerify("staff_password")) Then
Session("username") = DtrVerify("staff_username")
Session("password") = DtrVerify("staff_password")
Server.Transfer("mainStaff.aspx")
Else
Response.Write("<SCRIPT lanquage='JScript'>window.alert('Invalid Password! Please Try Again.');<" + "/SCRIPT>")
Server.Transfer("staffLogin.aspx")
End If
End If
checkuser = "Failed"
End While
If checkuser = "Failed" Then
Response.Write("<SCRIPT lanquage='JScript'>window.alert('Invalid Username! Please Try Again.');<" + "/SCRIPT>")
Server.Transfer("staffLogin.aspx")
End If
ConVerify.Close()
AliAmjad(MCP)
|
|
|
|
|
I got a question here..
If Im using sql server 2005 database..
would da OleDb can be used and the code stil the same except the connection string?
Im js a beginner.
Thanks a lot
Life is up and down
Nevertheless,never give up hope and be confident to yourself
|
|
|
|
|
I have tried the code but I got a runtime error as belo
"Error 2 Type 'System.Data.SqlClient.SqlDataReader' has no constructors. C:\Documents and Settings\user\My Documents\Visual Studio 2005\Projects\CinemaTicketing\CinemaTicketing\MainPage.vb 39 13 CinemaTicketing"
What does it mean by no instructor??
Life is up and down
Nevertheless,never give up hope and be confident to yourself
|
|
|
|
|
kc_renji wrote: What does it mean by no instructor?
Read the error message again. It's talking about a constructor, not an instructor.
You can't create an SqlDataReader object by using the new keyword, as there is no public constructor that can be use for that. A data reader is created using the command object by calling the ExecuteReader method.
---
"Anything that is in the world when you're born is normal and ordinary and is just a natural part of the way the world works. Anything that's invented between when you're fifteen and thirty-five is new and exciting and revolutionary and you can probably get a career in it. Anything invented after you're thirty-five is against the natural order of things."
-- Douglas Adams
|
|
|
|
|
Thanks.I have corrected it.
Life is up and down
Nevertheless,never give up hope and be confident to yourself
|
|
|
|
|
There are converters on the web that will do this for you. None of them are perfect, but they can get pretty close.
Really, what you posted is very easy to convert. All you have to do is look at any of the code samples on MSDN and they'll show you a piece of VB.NET and the equivilent C# code. Just look at the patterns of each line and you'll see that the majority of code converts quite easily.
|
|
|
|
|
Dave Kreskowiak wrote: There are converters on the web that will do this for you.
Yes it is. I sense the OP is just being lazy ( he ought to learn C# if he doesn't know it )...
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
|
|
|
|
|
i am using vb.net to create an application for maintenance of records for a company.i am using ms access as db and am also using datagrid to view the data from the db.
i have used a primary key in all the tables..
how do i check if a record having the same values in all the fields except the primary key(of course) is being entered twice or more?
i am new to .net and urgently need help..
god bless........
-- modified at 11:26 Friday 26th October, 2007
|
|
|
|
|
anniie wrote: i have used a primary key in all the tables
On which column you have assigned the Primary key. What is exactly the structure of your Table.
AliAmjad(MCP)
|
|
|
|
|
You would have to perform an SQL SELECT query on the table looking for a record with all those fields set already. If you get anything other than 0 records back, either something went wrong in the search, or there is already a record with those details in it.
|
|
|
|
|
thx 4 the reply to both of you..
Also,..Dave..can you elaborate on the SQL SELECT query please..?
ie could you give an example?
i think that this might help..
i have a table emp_pc (with pc_no as PK) in which all the PC's assigned to the employees are maintained..
suppose that i assigned PC001 to EMP1..how do i avoid entering another record in which PC001 is assigned to EMP1?
-- modified at 9:07 Saturday 27th October, 2007
god bless
|
|
|
|
|
There isn't enough information to write the statement. Do you have two tables holding data?? Is there a relationship between them?? What do the tables' schemas look like?? What columns are these two pieces of information in (PC001 and EMP1)??
|
|
|
|
|
I'm going to go out on a limb and assume that you have three tables:
emp:
emp_no - PK
emp_name
etc.
pc:
pc_no - PK
etc.
emp_pc:
emp_no - FK to emp.emp_no
pc_no - FK to pc.pc_no, unique
The primary key on emp_pc would be (emp_no, pc_no), you would also create a unique index on pc_no (because a pc can only be assigned to one employee)
Cheers,
Jason Lepack
|
|
|
|
|
I need to read 4 hexadecimal chars from a textbox and put them into a Uint
how can I do that?
BiG RaLpH
|
|
|
|
|
Don't cross post in multiple forums. It's unecessary and make it difficult for people to collaborate on an answer.
|
|
|
|
|
i have been messing with vb for about 3 months now and i am trying to find the code to where you can click browse and you can search you pc for the file you want then it loads the file to a datagrid, i have tried my own code and alot of others form the net but all give build errors and i cant seen to fix them.
can someone please link me to or tell me the cod that allows you to search for certain files and load them to a data grid.
-Chris
|
|
|
|
|
FreakNikon wrote: have been messing with vb for about 3 months now and i am trying to find the code to where you can click browse and you can search you pc for the file you want then it loads the file to a datagrid
What kind of file you are trying to display in the Datagrid? Datagrid is for displaying the records from a database. You can use Dataset for this purpose. Or you can also display a CSV file in the datagrid.
AliAmjad(MCP)
|
|
|
|
|
well lets say im trying to load a text fie into a datagrid. what would i put to load the file into the datagrid
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
