I want to retrieve info from more than 1 table. I have tried to look into using the ViewModel but do not fully understand how to implement it. My Model is setup using ADO.Net framework.
View 1 RepliesI am trying to integrate my asp.net 4.0(non MVC) website with facebook. I want to retrive the authenticated user info.The samples listed in facebooksdk is based on MVC. i tried to implement it in my website, but getting errors. i am struck.If anyone implemented the facebook connect logic and retrieved the user information using facebook-c#-sdk, please help me how to do this.I tried the same using facebooktoolkit, and i am able to retrive the user info. but the toolkit is having issues with .net 4.0.
View 2 RepliesI'm trying to parse a HTML file to retrieve certain info in my asp.net app. I've looked at the html agility pack but found that also quite difficult. :-) As my HTML should be pretty standard I'm hoping regex is quick and easy. I need a regex that will look through the html file (which I've loaded into a string) and find the below line and take out the DATATOEXTRACT (which will be some sort of text, the name of a recipe in this case) so I can put it into a variable:
<span class="titleText1">DATATOEXTRACT:
</span>
I'm trying to build an asp.net application, where I have three tables.
tblRoute
tblHalte
tblHalteRoute
I want to insert a routeID into tblHalteRoute and for every routeID multiple halteID's
TblRoute has the needed fields (routeID(1) & allHaltes[halteID1,halteID2,halteID3])
--> so Every route has multiple Haltes that I can access by parsing the allHaltes field and using the IDS.
What I want to do is update tblHalteRoute like this
tblRoute.routeID(1), tblRoute.allHaltes(halteID1)
tblRoute.routeID(1), tblRoute.allHaltes(halteID2)
tblRoute.routeID(1), tblRoute.allHaltes(halteID3)
inserting these values into the tblHalteRoute .. I'm really not sure on where to look or how to start, I tried using SUBquerys with an Insert before a select, but no success.
I am Working on a ASP.net project(VB.net), i have a gridview to display names of "Patients". Each patient has a unique "labID",
I have stored the patients "diagnosis" information in seperate tables( stool,urine, blood etc)
what I need is to retrieve this info when I click on a patients name in gridview.
I have a master page with a form on it. It's a people search form. When the user clicks on the search button it goes to the search results page that uses the same master page. With the code below I get the info off the master of the current page. Howdo I grab that info from the first page?
Here's the code:
Master page:
< FORM id=formEmpSearch method=post action=~/About/peopleSearch.aspx runat="server">
< asp:TextBox style="WIDTH: 153px; HEIGHT: 12px" id=txtSearchName onfocus="this.value=''" runat="server" CssClass="searchBox">
Master Code Behind page:
Imports System
Imports System.Web.UI
Imports System.Web.UI.WebControls
Partial Class mstrIntranet
Inherits System.Web.UI.MasterPage
Public Property mSearchName()
Get
Return txtSearchName.tex
End Get
Set(ByVal value)
txtSearchName.text = value
End Set
End Property
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
txtSearchName.Text = "People Search"
End Sub End Class
Search Results Code Behind page:
Partial Class PeopleSearch2
Inherits System.Web.UI.Page
Public SearchName As String
Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim mpTextbox As TextBox
mpTextbox = CType(Master.FindControl("txtSearchName"), TextBox)
SearchName = mpTextbox.Text
Basically i deal with two tables.i have a table T1 of the following format:id company_name i need to read this data and create a table T2 as followsi wrote the following code. it worked fine for retrieving data and modification but fails to insert the modified data into the 2nd table.the error is, it does not recognise the value for @token
ArrayList dynarr=new ArrayList(); // global variable
protected void Button2_Click(object sender, EventArgs e)
{
int row = 1; int i;
string strcmd = null;
string Connection = "Data Source=....";
SqlConnection conn = new SqlConnection(Connection);
string str = "select company_name from T1 where ID=@ID";
[code]...
I have a site where users can save images together with a couple of info fields about the image. The images are stored as binary data in the same table as the rest of the image info. So far pretty standard.
Now, the users should be able to upload a document, describing the image in more detail, along with the rest of the image and its' info.
Size ~2MB per document.
My question is: Should I store this document (binary data) in the same table as the rest of the images or should I create a new table holding only the documents. There would of course be an id reference in the image table to the document in the document table.
I have a search function joining a couple of tables, including the image table, when searching for images. I need to know if there's a difference in efficiency between these two solutions.
I always fetch the document data separately but if I don't win anything in having the documents in a separate table I'll just put it with the rest of the image info.
I'm asking this since I don't really know how SQL Server handle tables when joing and searching in them.
I have about 10´000 users with a maximum of 10 images per user. (ASP.NET - SQL Server)
(I'm not asking if I should store documents in the database, but how ;)
Example:
columns in imageTable - id, title, dateAdded, image (binary data), document (binary data)
Searching for items from a specific user I would join the userTable and the imageTable and select title where image id equals user id.
So, will there be any difference in the performance if the document is in the imageTable or in an own table?
I need to display a table with various info (names, dates, serial numbers, notes). In addition, there is one field I need to be one of three specified values (Raise, Lower, Release). What view would be the best/easiest to implement which would let me add/edit/delete entries as well as provide a drop down option for the Raise, Lower, Release options?
View 3 RepliesI'm building an ASP.NET MVC 2 site where I'm currently implementing an OpenID sign-up form. Unfortunately, I'm foreseeing a possible security bug/vulnerability inside my architecture.
Here's how I want OpenID login to work:
User requests /Account/Login, Controller sends back OpenIDLogin View. User enters their OpenID into the View, then OpenID authorization takes place, and finally the OpenID is returned to the Controller.The Controller checks whether the OpenID is currently in use by a user in the system or not. If it is, the user is logged in to that account. If not, the registration process begins.
And now, the OpenID registration process:
The OpenID identifier, as well as any other information provided by the OpenID provider (such as email address or name), is put into my custom ViewModel and sent to my OpenIDRegistrationForm View.The RegistrationForm View stores the OpenID in a hidden field to make sure that it gets sent back to the Controller.The user fills in the RegistrationForm View and sends it back to the Controller.The Controller creates the user account and puts the OpenID into the database.
The bug that I see within my architecture is that a user could modify the hidden value in the RegistrationForm View. Thus, they could spoof their OpenID! I will make sure to add another round of checking to the final Registration Controller Action to make sure that the OpenID that is provided doesn't exist yet, but there is still a possibility for spoofing. Can my architecture be improved somehow? I don't want this to end badly...
One solution I'm considering is encrypting the OpenID before I send it to the View and then decrypting it when it reaches the Controller. Should I try this?
I have a simple store that I have created following the book "Pro ASP.Net MVC 2 Framework" and in this book there is one table in the db: product.
This table hold the product data (id, name, price, category, image)
There is a sqlrepository that returns a linq table object in the sqlrepository constructor like this:
[Code]....
I have a site where users can save images together with a couple of info fields about the image. The images are stored as binary data in the same table as the rest of the image info. So far pretty standard.
Now, the users should be able to upload a document, describing the image in more detail, along with the rest of the image and its' info. Size ~2MB per document.
My question is: Should I store this document (binary data) in the same table as the rest of the images or should I create a new table holding only the documents. There would of course be an id reference in the image table to the document in the document table.
I have a search function joining a couple of tables, including the image table, when searching for images. I need to know if there's a difference in efficiency between these two solutions. I always fetch the document data separately but if I don't win anything in having the documents in a separate table I'll just put it with the rest of the image info.
I'm asking this since I don't really know how SQL Server handle tables when joing and searching in them.
I have about 10´000 users with a maximum of 10 images per user. (ASP.NET - SQL Server) (I'm not asking if I should store documents in the database, but how ;)
Edit
Example 1:
columns in imageTable - id, title, dateAdded, image (binary data), document (binary data)
Searching for items from a specific user I would join the userTable and the imageTable and select title where image id equals user id.
So, will there be any difference in the performance if the document is in the imageTable or in an own table?
A user can have many addresses, but I want to retrieve the latest entry for the user
In sql I would do:
SELECT TOP 1 *
FROM UserAddress
WHERE userID = @userID
How can I create a criteria query with the same logic?
I store string using , (comma) now i want to retrieve data back from the comapre string in another with the price.
I store string like this a,b,c,d.
Now i want to retrive it like
name price
a 10
b 20
c 30
totla 60
using ms access databse and .net C#
i got a Food table and a Notification table. each Food has an expiry date. I wish to put all foods which are going to expired into the notification table. since user can create new food anytime, how can i update the Notifcation table once got any new food (but with near expiry date) added? and how to make sure the Notification table retrieve the nearly-expired food everytime (mayb update once everyday??)
View 1 RepliesI have two tables invoices and receipts
i have to show the alternate data of invoices and receipts in datagrid; condition is that
if Date column in INVOICE table matches with invoice columns in RECEIPTS table then the corresponding row of RECEIPTS table should come after INVOICES table row
if there is no match then INVOICES table next row will come, and
if there is match then then RECEIPTS TABLE row will appear
tables are below
INVOICES:
Date Sales Client Amount Paid Status Notes
03/27/2008 Chinmoy Panda ETA Prospect 100 SENT qwwert
04/30/2008 Amit Sharma ETA Prospect 1000 FROZEN
05/13/2008 Chinmoy Panda ETA Prospect 40000 SENT
[code]...
I had a problem for a long time but now wonder how I will solve this. Perheps it is easy.
I have a <table> with two <td>. This <table> resides inside a GridView, so I FindControl like below. Now I need to do a calculation of height that if MessageBox1 have a height that is less than 306, then I need the MessageBox2 to have the remaining height.
For example if MessageBox1 has the height of 206, then MessageBox2 need to have the height of 100.
I think my problem is how to convert the height of MessageBox1 correctly and set the remaining height to MessageBox2 ?
[Code]....
i want to retrieve latest 10 values from my table,i use sql server 2000.. how can i query my database?
View 4 RepliesI have created a dynamic table using user entered values for Rows and columns. After the table is created the data is populated on the table. I have a separate event that is clicked to retrieve this data, but I am not able to get this data upon postback.
I need to convert the table values (in int) to an array for further processing.
The coding language is C#3.0What is the most optimum method to retrieve all hashtable keys into string separated by a delimiter ","Is the for loop or the foreach loop the only option?
Update: the keys are already strings
I am retrieving user data from aspnet_user table from aspnetdb database but I also want to retrieve data (such as first name, last name, email, address etc) from aspnet_profile table. I am using dropdownlist which retrieves user names from the aspnet_user table.
retrieve user data from aspnet_profile instead?
My code is as followed:
[Code]....
[Code]....
How do I implement this session: (UserID is part of the login table)
Session["UserID"]="usrName";
Into this code?
using System;
using System.Data;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.Odbc;
using System.Data.SqlClient;
public partial class Default2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
Login1.Authenticate += Login1_Authenticate;
}
protected void Login1_Authenticate(object sender, AuthenticateEventArgs e)
{
//database connection string
OdbcConnection cn = new OdbcConnection("Driver={MySQL ODBC 3.51 Driver}; Server=localhost; Database=gymwebsite; User=x; Password=x; OPTION=3;");
cn.Open();
OdbcCommand cmd = new OdbcCommand("Select * from User where username=? and password=?", cn);
//Select the username and password from mysql database in login table
cmd.Parameters.Add("@username", OdbcType.VarChar);
cmd.Parameters["@username"].Value = this.Login1.UserName;
cmd.Parameters.Add("@password", OdbcType.VarChar);
cmd.Parameters["@password"].Value = this.Login1.Password;
//use asp login control to check username and password
cmd.Parameters.Add(new OdbcCommand("@UserID", 'id.int'));
OdbcDataReader dr = default(OdbcDataReader);
// Initialise a reader to read the rows from the login table.
// If row exists, the login is successful
dr = cmd.ExecuteReader();
int id = cmd.Parameters["@UserID"].Value;
Session["UserID"]="usrName";
if (dr.Read())
{
e.Authenticated = true;
Response.Redirect("UserProfileWall.aspx");
// Event Authenticate is true forward to user profile
}
}
}
I need to be able to retrieve the correct UserID when some one inputs there username and password upon login and then some how retrieve it on a new page something like this to retireve it but unsure?
string usrName = Convert.ToString(Session["UserID"]);
I just dont know how to add the first part, the session into my login code so I can some how store the UserID in my session but also retrieve the correct UserID from the submitted data that takes from my mysql login table.
I have a page where I would like to collect information about x number of users. I have a control where you enter in the number of users and based off of that number, I create a dynamic table with a row for each user. Each table row has textbox controls that I would like to retrieve the value from on postback. How can this be accomplished?
View 2 RepliesI have two sections of users data on my site, customers and employees, each one has a UserID that is FK to the UserID from aspnet_Users table.
I have a table that stores User messages
Looks Like This:
[URL]
It Has a FromUserID and ToUserID
Because Employees are Identified through EmployeeID and Customers are identified through CustomerID, I needed to use UserID's so Employees can leave messages for employees and Customers and Customers can leave messages to employees and other Customers 1-2 and 2-1
My Quandry is this, How Do I retrieve the information if the UserID might be a Customer or Might be an Employee, when the UserID could be from one of two tables
ie
How Would I Write?
SELECT wms.FromUserID, ed.FirstName, ed.LastName FROM ed INNER JOIN wms ON wms.FromUserID = ed.UserID
OR SELECT wms.FromUserID, cd.FirstName, cd.LastName FROM cd INNER JOIN wms ON wms.FromUserID = cd.UserID
How Do I Check to See? Do I Use IF EXISTS?
i'm new to membership. i have a table named contact, with a field, userId that must get its data from the membership users table. so when a user is created i have to get the userId from membership users table. how can i do that?
View 1 Replies