Lets say I have a variable 'userid', I want to select from aspnet_Membership AND aspnet_AccountProfile tables. They both have the column userid, I just want to be able to make a statement like SELECT * FROM aspnet_AccountProfile, aspnet_Membership WHERE UserId=@UserId and it gets the records with the matching user id for BOTH tables. how do I do this?
View 5 Replies
I want to do execute a LINQ query, and I have the name of the table to query stored in a variable:
string tableName = "SomeTable";
DataContext db = new DataContext();
var vResult = from t in db.tableName where t.Id = ....
ok need advice in how to pull data onto an aspx page from this site
[URL]
from this file [URL]
How can I link to this..in asp.net 2.0
My wishes
1) link to this data in may aspx page so that it refresh when ever some one loads the page ( yes I will cache the page for say 300 seconds)
2) then read the aspx page this data is on and save each item to a SQL table. So keep that in mind when thinking of (1)
I have a recruitment portal that people can use to advertise and search for jobs.I would like the recruiters to be able to add a small javascript snippet to their personal websites, that will list jobs on my site. how can i go about this?I have webservices set up so the javascript can just call that, but i also need the result to be formatted and placed inline.This should work in a simular way to google adsense.
View 1 RepliesI am using bulk insert concept to export the data from dat file to tables(Two tables). I am using the temporary table for to do the calculation and insertion to two tables. My problem is whenever I selecting the temp table data after the execution of bulk insertion , the order is changing .I need to get the order as it is in file order(csv,dat,txt).
View 5 RepliesWhich is the best platform to create a gadget that pulls data from a database.
View 8 RepliesHow i can pull data from excel sheet into my webpage
i have an excel sheet on which some data is there. i want to display my data into my webpage how i do this
I am trying to pull data from my populated javascript table. How do I pull the value from a javascript row? I am using
for (var i = 0; i < rowCount; i++) {
var row = table.rows[i];
//This is where I am having trouble
var chkboxIndicator = row.cells[0].childNodes[1];
alert(chkboxIndicator);
//
if (chkboxIndicator == indicator && Checkbox.checked == false) {
table.deleteRow(i);
rowCount--;
i--;
}
}
which has an alert message of "undefined". I tried .value and .text as well and no progress. How do I get the text from the childNodes?
I am currently developing a web site for our Student Council so members can check in and view the work they've done, sign up for tasks, etc. They will authenticate using their username provided by the school district's AD servers. How can I make it so that only their data shows up when they use their username?
Authentication method:
[Code]....
I need to "massage" the data a little during OnRowDataBound. When I used DataTable as my data source for my GridView, I could do the following:
[Code]....
How do I grab the row data if I'm getting it from List<Product>?
I need to pull the first 2 alpha characters out of any data that is entered. What is the recommended best practice for this ?
View 7 Repliespull some data from this grid view, and then update all pulled grid view data value to tableTwo.Update tableTwo set uit = Grieview.NewSid where con = 'Gridview.pid' and unid = 'Girdview.Gid' + 'Gridview.Tid'
I've been working on this function, basically it's an order page. When the user presses the "Order" button, I would like the data to write to a SQL DB. This is what I have:
Protected Sub btnOrder_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnOrder.Click
For Each row As GridViewRow In GridView1.Rows
Dim Owner As String = DirectCast(row.FindControl("lblOwner"), Label).Text
Dim Item_Num As String = DirectCast(row.FindControl("lblItem_Num"), Label).Text
Dim Lot_Num As String = DirectCast(row.FindControl("lblLot_Num"), Label).Text
[Code]....
I can't get these "Dim Owner As String = DirectCast(row.FindControl("lblOwner"), Label).Text" to compile. I think because this is looking for template fields and my gridview is filled in on the fly so they are bound fields. Does anyone know how to get the text out of a bound field?
Is there away to get data (like phone number or read text file) from android using aspx when page is loading?
Like parameters with android user load page ?
I have an existing windows .net application that has an access database as the backend.
I want to place the access database on a web server and it was suggested that I create a web service in order to communicate with the database.
I've been looking at some tutorials but am still confused about the basic config needed. Here's some questions I have:
1) Does the web service need to be created inside my current project by right clicking on the solution and choosing to add a new web site...and then selecting web service?
2) If it's set up like this, what files do I place onto the web server?
3) Where does the database reside? Do I need to place the database inside the web server that I create?
4) My current project has existing sql that gets data and I'm uncertain how to re-write in order to retreive the data. e.g. which part goes into the client and which part goes to web service pages? here's an example of a procedure that currently exists...I'm getting data to populate a dropdown:
[code]....
How would you pull only the current month data from SQL?
View 9 RepliesI have a table in my databse with int's nvarchar's datetimes and money
I am trying to pull this data out to use in program and putting nvarchar as a string money as a decimal but what do i need to use for the date cheers
I have been banging my head against this problem for a bit and I think I am stuck. I would like to pull data from a Database to populate a list of possible "clients" to select from on one side. Then using what has been clicked load the client specific data into a tab container on the opposite side. I plan on doing lazy tab loading so I am not sure if that matters. I am really stuck and any help or guidance anyone could give would be greatly appreciated! I understand the basics of data loading and of tab containers, but i am unsure of what to do. I am coding this in C#. Example Mock Interface This is where the data list would be and I want to be able to select something here And update the Tab Panel control here based on the selection from the left side via querying the database.
View 3 RepliesI need to pull the data from DB and fill the view model, is there any better way to do this? Currently I'm doing something like this.
ViewModel vm = new ViewModel();
var recentBill = context.Money.Take(10);
foreach (var r in recnetBill)
{
vm.lst.Add(r);
}
Nested GridView Control returns "Object variable or With block variable not set" when outer GridView returns rows.
The Nested GridView Control works as long as the outer GridView returns rows, the following code works: [Code]....
Object variable or With block variable not set.
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: System.NullReferenceException: Object variable or With block variable not set.
Source Error:
Line 118: If e.Row.RowType = DataControlRowType.DataRow Then
Line 119: Dim myStatus_ID As SqlDataSource = CType(e.Row.FindControl("sqlDeviceStatusAssign"), SqlDataSource)
Line 120: If Not e.Row.DataItem("Status_ID") Is Nothing Then
Line 121: myStatus_ID.SelectParameters(0).DefaultValue = e.Row.DataItem("Status_ID")
Line 122: End If
I have tried checking for IsDbNull and checking to see if a label exists in a given row. This code *If Not e.Row.DataItem("Status_ID") Is Nothing Then* appears to do nothing.Same with the following:
*Dim localLblItemReference As Label = CType(e.Row.FindControl("lblItemReference"), Label)
*If Not localLblItemReference Is Nothing Then
******************************************************************************************
To further clarify my question above, I am looking for a method to detect e.Row.DataItem("Status_ID") is nothing/null due to the outer GridView returning 0 results in a query.I have a (Outer) GridView Control with another GridView Control inside of a template field with it's associated SqlDataSource control.
In the "Protected Sub GridViewReport_RowCreated", I provide the Select Parameter for the associated SqlDataSource with the DataItem row value.When the (Outer) GridView Control does not return any rows, the "e.Row.DataItem("Status_ID")" throws a:
Exception Details: System.NullReferenceException: Object variable or With block variable not set.
I am using three listviews on a page ... the first is always populated ... the other two are sometimes populated I want to total amounts and counts from all three ... so I set up steps in the DataBound events works great when all three listviews are populated the error "Object Variable or With block variable not set." occurs when LV2 or LV3 is not populated I've tried testing DataItem ... Is Nothing but get the failure on the If test instead
View 3 RepliesI have a question, and I don't really know what forum this would pertain to, so I'll ask it here. I'm looking to build a website application that uses data stored in a SQL Server database. But I want to be able to constantly pull data from a source 24/7 (all the time). Obviously a typical website application, unless a user is browsing it, won't be active and running.
How could I go about this? Would this technically be using a "service"? Would that always be running and allow me to programmatically pull data constantly throughout the day?
I have an C# ASP application I am writing that needs to have the capability to import a generated excel or a comma delineated sheet each day. A clerk will have this job each morning so it doesn't need to be automated. My problem in trying to understand the solution to this is that the 1 sheet contains loan information, including customer information all in the same sheet. I would like to send certain columns to update information in the loan table and send other information to update the customer table. I need it to create relationships when new loans appear in the spreadsheet.
View 1 Repliesi have a table that hold players statistics, this table going to be the biggest table of my DB, it will contain millions of records, i will frequently have to pull records (usually sum them up) from that table, what will be the best way to go, should i use SP to pull the records or should i pull all the records i need individually and sum it as i wish using the LINQ technology?
View 8 RepliesI am working on an auto trade website. On the page where Ad list gets displayed, I plan to display the number of Ad for different categories: for example, for location: I will display something like "Vancouver (50), Richmond (12), Surrey (20)". For vehicle make, the following will be shown "Honda (20), Ford(12), VW (24)".
I am not sure if I should pull ALL the ad from the db into a List first, bind one page of the result to gridview control, and then compute stats for each category using Linq. if course I will limit the number of rows pulled from the db using some kind of condition - maybe set the MAX # of rows to be returned as 500.
My major concern is - is this going to be a memory hog?
