|
I am trying to tidy it up a little. I didn't have these namespaces in, for example, beforehand:
Imports System.Data.OleDb.OleDbCommand
Imports System.Data.OleDb.OleDbDataReader
and the 'order' is OleDbConnection, an OleDbCommand, and an OleDbDataReader. The While/End While code should then read through the data, before closing OleDbDataReader, and then OleDbConnection.
That structure is now reflected in my own code.
The examples I have see around look a lot like this:
dr = myCommand.ExecuteReader()
While dr.Read()
'reading from the datareader
MessageBox.Show("colname1" & dr(0).ToString())
'displaying the data from the table
End While
dr.Close()
I probably need to use something like this
("colname1" &
dr(0).ToString()) from the example above, but I don't want the code to display anything - only to log me on.
As I said earlier, the code I initially posted doesn't actually 'read' the rows, does it?
|
|
|
|
|
Member 8761667 wrote: the code I initially posted doesn't actually 'read' the rows, does it?
No idea, you need to do some debugging to check it. I have tried to explain where the logic is wrong in your loop, but you seem to be looking elsewhere.
|
|
|
|
|
As I understand it, the logic should be to read the database using While and End While. In the database, where there are two columns called 'password' and 'strEmail' (the exact same IDs as for the two form fields), the code should check that the email variable (strEmailValue) entered in the email form field is the same as the entry in the database column whose name is strEmail.
(strEmail is the name of the database column AND the email text field in the form, whereas strEmailValue is the variable entered by the user in the form text field.)
If the entry in the database column is the same as the variable entered by the user, then it is true that strEmailValue has been found - hence strEmailFound = True.
Likewise, for password. The code should check that the password variable (passwordValue) entered in the password form field is the same as the entry in the database column whose name is password.
(password is the name of the database column AND the password text field in the form, whereas passwordValue is the variable entered by the user in the form text field.)
If the entry in the database column is the same as the variable entered by the user, then it is true that passwordValue has been found - hence passwordFound = True.
So, I now have:
While reader.Read
If strEmailValue = reader("strEmail") Then
strEmailFound = True
End If
If passwordValue = reader("password") Then
passwordFound = True
End While
Does the above make sense?
Thanks again.
|
|
|
|
|
Yes, that makes some sense. However, you only need a single variable to indicate that you have found the correct user record. Also, you should check the password inside the email test, to ensure you capture the two settings for a single user entry, something like:
bool userFound = false
While reader.Read
If strEmailValue = reader("strEmail") Then
If passwordValue = reader("password") Then
userFound = True
Exit While
End If
End If
End While
|
|
|
|
|
Hello Richard
Many thanks.
I will debug all the code again and give it a trial run.
Before my previous While/End While, I had:
Dim strEmailFound As Boolean = False
Dim passwordFound As Boolean = False
but if I use your
Dim userFound As Boolean = False
I can delete my two declarations because, as you say, 'you only need a single variable to indicate that you have found the correct user record'.
Does it matter which variable finds the record?
Thank again for all your help.
|
|
|
|
|
Member 8761667 wrote: Does it matter which variable finds the record?
No, but as I said before, you only need one variable, to tell when you have found the record that matches both userid and password.
|
|
|
|
|
|
Thanks for the links, Richard.
I have just taken a look at this page:
Secure Password Authentication Explained Simply[^]
which looks up-to-date (referring to SHA512 and RNGCrypto), and I have put your post into my favourites but, as I say, I will investigate the While/End While first.
|
|
|
|
|
Error:
Missing type map configuration or unsupported mapping.
Mapping types:
sp_selectall_Result -> Student1
MvcCRUD6.Models.sp_selectall_Result -> MvcCRUD6.Models.Student1
Destination path:
List`1[0]
Source value:
MvcCRUD6.Models.sp_selectall_Result
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: AutoMapper.AutoMapperMappingException: Missing type map configuration or unsupported mapping.
Controller Code:
public ActionResult Index()
{
Mapper.CreateMap<Student, Student1>();
var dbContext = new WorkTraningEntities();
StudentCRUD stud = new StudentCRUD();
var students = stud.SelectAll();
List<Student1> stud1 = Mapper.Map<List<Student1>>(students);
return View(stud1);
}
Index View:
@model IEnumerable<mvccrud6.models.student1>
@{
ViewBag.Title = "Index";
}
Index
@Html.ActionLink("Create New", "Create")
@foreach (var item in Model) {
}
@Html.DisplayNameFor(model => model.First_Name)
| @Html.DisplayNameFor(model => model.Middle_Name)
| @Html.DisplayNameFor(model => model.Last_Name)
| @Html.DisplayNameFor(model => model.Contact_No)
| @Html.DisplayNameFor(model => model.Email_ID)
| @Html.DisplayNameFor(model => model.Temp_Address)
| @Html.DisplayNameFor(model => model.Permanant_Address)
| @Html.DisplayNameFor(model => model.Country.CountryName)
| @Html.DisplayNameFor(model => model.State.StateName)
| @Html.DisplayNameFor(model => model.City.CityName)
| | @Html.DisplayFor(modelItem => item.First_Name)
| @Html.DisplayFor(modelItem => item.Middle_Name)
| @Html.DisplayFor(modelItem => item.Last_Name)
| @Html.DisplayFor(modelItem => item.Contact_No)
| @Html.DisplayFor(modelItem => item.Email_ID)
| @Html.DisplayFor(modelItem => item.Temp_Address)
| @Html.DisplayFor(modelItem => item.Permanant_Address)
| @Html.DisplayFor(modelItem => item.Country.CountryName)
| @Html.DisplayFor(modelItem => item.State.StateName)
| @Html.DisplayFor(modelItem => item.City.CityName)
| @Html.ActionLink("Edit", "Edit", new { id=item.StudentID }) |
@Html.ActionLink("Details", "Details", new { id=item.StudentID }) |
@Html.ActionLink("Delete", "Delete", new { id=item.StudentID })
|
|
|
|
|
|
Hello,
I’m planning to build a website using ASP.net. The members of this site should use a client like Skype. The client should support the following features:
·Audio Chat.
·Text chat and instant messaging.
·Desktop sharing
I do not know the best option to achieve that. Is there an existing library to develop this client? Or I should build the client from scratch? Shall I use SIP, XMPP or other protocols? Can I use Google for work or office 365?
Note: The expected number of users is 100’000 and later in future.
Thanks in advance
|
|
|
|
|
If you want a custom solution have a look at the SignalR framework.
Desktop sharing can be extremely sketchy (you're potentially sending IO command and control over public networks and have a serious possibility of breaking Confidentiality and Integrity) and unless you have a full Dev/QA team is completely not worth developing in any serious way.
Adobe connect does everything you're talking about and already scales; I'm sure there are other options out there as well.
"There are three kinds of lies: lies, damned lies and statistics."
- Benjamin Disraeli
|
|
|
|
|
|
When i am creating a custom control dynamically and add that control on Panel/ContentPlaceHolder and then i Submit the page, now delete all Dynamically Created Custom controls are deleted.
modified 2-May-16 8:15am.
|
|
|
|
|
Controls you create yourself are not automatically remembered, you have to re-add them on page_load or page_init.
|
|
|
|
|
But How to access Data from that control on Submit button click
|
|
|
|
|
|
Good Day All
i have a repeater control that i bind with 10 000 records and it handles it nicely and its defined like this
<table id="example" class="table table-striped table-bordered" cellspacing="0" width="100%">
<thead>
<tr>
<th>ID</th>
<th>Recipient</th>
<th>Possible Bank</th>
<th>Amount</th>
<th></th>
</tr>
</thead>
<tbody>
<asp:Repeater ID="rptDonationList" runat="server" OnItemCommand="rptDonationList_ItemCommand">
<ItemTemplate>
<tr>
<td style="width: 10%">
<%# Eval("DONATIONS_ID") %>
</td>
<td style="width: 30%">
<%# Eval("Name") %>
</td>
<td style="width: 30%">
<%# Eval("LU_BANKS_NAME") %>
</td>
<td style="width: 20%">R <%#string.Format("{0:n}",Eval("AMOUNT")).Replace(".00","") %>
</td>
<td style="width: 10%">
<asp:Button ID="btnDonate" Width="70" Height="29" CommandArgument='<%# Eval("AMOUNT") +"|"+Eval("RECEPIENT_USER_ID")+"|"+Eval("DONATIONS_ID")+"|"+Eval("RemainingDonationAmount") %>' CommandName="Donate" CausesValidation="false" runat="server" CssClass="btnred btn-danger" Text="Donate" /></td>
</tr>
</ItemTemplate>
</asp:Repeater>
</tbody>
</table>
When the Button Donate is clicked it fires the OnItemCommand event that is defined like this
<br />
protected void rptDonationList_ItemCommand(object source, RepeaterCommandEventArgs e)
{
if (e.CommandName == "Donate")
{
string[] data = e.CommandArgument.ToString().Split('|');
Session["PaymentAmount"] = data[0];
Session["PaymentforUserId"] = data[1];
Session["DonationId"] = data[2];
Session["RemainingDonationAmount"] = data[3];
Response.Redirect("/MakePayment.aspx",false);
}
}
The problem is when this above event is fired , the page at the bottom left corner shows a message on the status bar "Uploading 10%.." which makes the page to wait until 100% before it moves to another page. What exactly is it uploading as the code above just redirects to the next page.
Thanks
Vuyiswa Maseko,
Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code.
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vimalsoft.com
vuyiswa[at]vimalsoft.com
|
|
|
|
|
10,000 records on one page?! Do you seriously think anyone is going to look through that many records to find the one they want? 
If a user can look at and discard one record every second, it would take them almost three hours to look through your list. And that's assuming they don't make a mistake, miss the record they're looking for, and have to start again.
Also, since you're using WebForms, you're going to have an enormous ViewState, which is almost certainly why your page takes so long to load and to post back.
Split the data into pages of a reasonable size, and give the user tools to filter the list to find the record they want.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Hi Richard
Thanks for your reply. There is paging on the repeater and there is no perfomance issue on the repeater. The only thing that im asking is why does it say "Uploading..." where else in the itemcommand im just assigning some sessions and redirecting?
What i must also mention is that locally connected the online domain it has no issue.
Vuyiswa Maseko,
Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code.
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vimalsoft.com
vuyiswa[at]vimalsoft.com
|
|
|
|
|
1. Does the 'upload' happening before, or after the event raised? I think you do not hit the server side until the 'upload' is at 100%, so it somehow related to the postback...
2. Put a sniffer (Fiddler like) to see what actually passing on the lines...
3. how large the ViewState is?
4. It is browser specific? What browser?
Skipper: We'll fix it.
Alex: Fix it? How you gonna fix this?
Skipper: Grit, spit and a whole lotta duct tape.
|
|
|
|
|
The Problem has been resolved. This is a good lesson. The problem was that my web application was running in an https IIS server in which my application was using Bootstrap that has fonts which was outside my server with a http not https control. i removed and copied all the files to the local server. So it looked like the system was slow but it was not , there was no error it was just blocking the user from moving forward. i hope this helps someone else
Vuyiswa Maseko,
Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code.
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vimalsoft.com
vuyiswa[at]vimalsoft.com
|
|
|
|
|
Are you saying that mixed content (http/https) was blocking the pages? Browser should have to show a warning about that...
In any case the solution is to create protocol-less links (using cdn is a good thing and in most cases better than local copy)...
Skipper: We'll fix it.
Alex: Fix it? How you gonna fix this?
Skipper: Grit, spit and a whole lotta duct tape.
|
|
|
|
|
Yes i was even shocked when i saw this. The thing the page itself does not timeout or give an error the chrome developer toolbar showed me that the page is blocked due to the mixed content. After moving them locally it started moving like lightning fast.
Vuyiswa Maseko,
Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code.
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vimalsoft.com
vuyiswa[at]vimalsoft.com
|
|
|
|
|
How to use store procedure with Entity Framework using class..
and i want to pass that class object to Controller class ..pls help..if someone have any related tutorials please provide..
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
