I want to select all the customers from "customers" table from a specific country. I write the following query but it is not working. why?
select *
From customers
where country = @country;[code]....
i'm trying to to create a simple string array with data retrieved from a select statement(SELECT firstname FROM customers , for ex.)
View 6 RepliesI have the following query, the relationship is mutiple pictures per dog and multiple dogs per registered User. the query below will return dogs that belong to users that have not expired. the problem is that some users have many dogs and other users only have one dog listed, the query below will return a record for every dog. What I would like to do is return a random dog per user and only one dog per user each time the query executes. therefore if I have 10 users and 50 dogs I would like my quesry to only return 10 dogs one beloinging to each user, and the next time the quesry executes it would be nice if it once again return 10 dogs but a different 10 dogs 1/per user where it was able..
[Code]....
[code]...
This query works perfectly on the query analyser.
But when configuring the Table adapter ,I try executing the query and i get 0 rows affected.
What could I be getting wrong in this case.
NB:Existing GalleryID has been supplied.
What is the best practice to apply different themes to different customers with asp.net.
View 4 RepliesJust looking for recommendations, we have a need to supply a chat-room for our customers. It will be small-mid scale usage, has anyone purchased any products recently that they recommend? Open to bundled, open-source, or SaaS implementations.
View 2 RepliesI've written a ASP.NET app that I hope to sell to businesses, I could host the trial but it's designed to connect to the customers data so customers will certainly want to install it to do a successful evaluation.
I've never produced anything commercial before so I'm looking for advice on how best to limit the trial, a 30 day trial seems most common, do you simply rely on the clock of the PC/Server they install it on? keep in mind this is ASP.NET app so will be installed on their web server.
I need to write a stored procedure to schedule a job that will send automatic email to customers based on some condition as follows:
1. I have two tables. One table is table1 like the following:
Name Date1 Date2 Date3 Rahim, Khan 29'10 30'11 25'08 Karim,Abedin 12'10 28'11 26'09 Fahad, Alam 26'10 12'11 25'10 Another Table is table 2 like the following:
Name Email Rahim,Khan rahim@yahoo.com Karim,Abedin karim@yahoo.com Fahad, Alam falam@yahoo.com In table 1 the date format is in format where 30'11 mean work week is 30 and 11 means last two digits of the year.
2. Now , I need to write a stored procedure that will check :
a) What is current work week and current year?
b) It will then determine the difference between the current work week (now 37) and work week mentioned in date (Date1, Date2 and Date3) columns from table1 and if for current year(it's 2010) at least one difference in each row is>=8 then it should send an automatic email to the corresponding email address of Name column using the relation between Table1 and table2. For example: For first record in Table1 the three difference is: 37-29=8, 37-30=7 and 37-25=12. There are two differences >=8, but only first difference is for year 2010 and third one is not for current year. But, since at least one difference in this row satisfies condition (That means >=8 for year 2010)hence email message should be sent to the address rahim@yahoo.com using relation of table1 and table2.
I know how to set a schedule job in SQL mail but I need this stored procedure to run this job on daily basis.
how best to allow a user to create their own URL? Say I have a domain like, www.mydomain.com, and I want the user to be able to create a custom ending to the URL like www.mydomain.com/companyname . Then when the URL is hit it will load the data for that company. Is this done via ASP.NET MVC routing? Any other ideas? I don't want to have to do any manual setup of site after user names it - like IIS changes or routing config file changes.
View 2 Repliesi have the following select staement which deosnt work, can anyone advise me whats wrong with it:
string _name = ddl_Name.SelectedValue.ToString();
string cmd =
"SELECT ID, Telephone FROM User_List WHERE Name = '' + _name;
i keep getting an invalid column name error? and i know the syntax next to _name isnt correct. how are the single quotes meant to go?
I am working on building a custom form builder module for our customers ... and wondering if you know any good .NET code base references for this module.
Requirements:
Customer should be able to add a form field(radio button, text box, dropdown menu) and customize the values real time.
ing to show customers and their order totals. There are a few joins involved since the order items quantity and price come from 2 different tables. Here is the query:
select DISTINCT
c.custnumber
ordertotal = convert(money, (SUM(c.quantity) * d.Price))
from custOrders c
left join purchaseorders p on p.cust_code = c.cust_code and p.purchno = c.ponumber
left join purchasedetail
[code]...
In My application , i have different plans1)Free2)Personal(Monthly, Yearly)Now my problem is 1)Want to send email to all the customers in which plan is going to be expired in one week , on the day of expiration andafter expiration to re2)After expiration i have to set the record status to deactive
View 3 RepliesThe project, once done, will provide a "portal" into a limited portion of the client's database. All clients are using a SQL database, but various server software products are involved (MSSQL, MySQL, and others).
My question, however, has more to do with the "look and feel" of the finished product. We want to be able to integrate our 'portal' easily into the client's websites and have it look as seamless as possible. Obviously, placements of logos, etc. -- but also colors, fonts, etc.
Client sites tend to be simplistic in design. We envision the customer placing a link to our site from theirs, and our site will be running on IIS on their server. At least that's the plan.
The goal right now would be to make as much of this "parameter driven" as possible, so that a lot of the install can be accomplished through some simple settings, isolated in one or two files such that at installation time we can tweak those settings and be up-and-running in a short period of time with a site that integrates reasonably well with the customer's.
But I'm uncertain as to whether there is a better approach. Obviously, we could try to redesign our site with each install with the basic design of the customer's, but this would be cost-prohibitive in some situations. So, I'm thinking about a "second best" alternative that may be adequate in most circumstances.
I'm sending automatically emails when customers buy products on my ecommerce portal.
But, send pages by emails, at least in my server, using asp.net is too slow.
So, I want to send emails automattically, but using SERVER PROCESSING (Server Side). Did you get my point?
The customer won't see the sending process. But in background, directly on the server, the email is being sending.
I need to create the web-site updater for existing customers.In which I also need to update the database
View 1 RepliesI am currently developing a solution in which the user logs in once and can work on multiple customers at the same time on my site.I've looked at all possible solutions involving sessionid having stored the customerid, to launching a new browser session so i could have multiple sessions for one users etc. I also looked at using cookieless sessions.But the all fail because it's not a simple solution and in my opinion a simple solution is most of the time a good and predictable solution.
Therefore i came up with the idea to use url rewriting(i've seen this used in other applications). When the user opens a customer, i would like to start his url as follows "~/Customers/xxxxxxx/*.aspx" where xxxxxx represents the customerid. and *.aspx represents a complete subset of pages of my site. This would allow me to use a simple technique to use multiple user sessions within a single asp.net session.
Now coming to my problem, I have never done some url rewriting, therefore my questions:
- Is this possible.
- Can i protect all the pages that need a customerid as input(come to think of it, if no customerid in the querystring, redirect to a selection screen would be sufficient).
- How do i adopt all urls used in a sitemap etc in a structured way.
suppose we've created a web app for our customers.
how to prevent to access web page code (aspx code or behind code) for our customers ?
how to implement security and licensing information for web apps ?
i have a website which has 3 modules admin part,employee part and customer part . so when the admin login he has to see the number of customers logged in and the duration etc excluding employee and admin
View 4 RepliesI'm implementing a BLL layer and have a few questions. First, in my DAL, there is a contacts table, the select method is a sql query against a sql server 2000 database. The preview data returns everyting as expected. The query is
[Code]....
The BLL method is built like so
[Code]....
When using the BLL method to a gridview, the results of the subquery are not displayed. There are also other methods, each having a different where clause for ContactRole_ID and each is having the same issue of not displaying the subquery reult in the gridview. No error, but no data is displayed for the subquery either. Here is the templatefield of the gridview
[Code]....
Another item that is causing an error is in trying to update a record. Here is the DAL update method
[Code]....
And the BLL update method
[Code]....
The error says i have extra parameters, but have no clue where the extra parameters are being picked up. The error isObjectDataSource 'odsContacts' could not find a non-generic method 'UpdateContact' that has parameters: _ContactID, _Active, _ContactName, _Office, _VirtualOffice, _Pager, _Fax, _Home, _Cellular, _Email, _ContactRole_ID, Active, ContactRole_ID, ContactName, Office, Email, VirtualOffice, Pager, FAX, Home, Cellular.And the objectdatasource
[Code]....
Do you know where could come from my issue. In deed every time i create an user "customers" I always have to active it in asp.net configuration.
View 2 RepliesI want to make domain lookup. I have found some examples on internet, make some tuning and it works well. :) The problem is "Regex.Replace(objSR.ReadToEnd()" get to my a full information about domain and so on, but all information I don't need, I only need the one line which starts with "Status", because other information is not needed for most off simple customers... I guess that it possible to solve this issue with "Readline()", but I can't understand how. Maybe,
Protected Sub btn_Click(ByVal sender As Object, ByVal eArgs As EventArgs)
Try
Dim objTCPC As New TcpClient(Request.Form("WhoisServer") & ".whois-servers.net", 43)
[code]...
i have one dropdownlist in the gridview. i have to load that dropdownlist when that page is loaded. dropdownlist should contain the country list from country table
View 7 Replieshow can i select a record from A table and insert into B table using linq?
View 2 RepliesAnyone know how to write a select statement to where it returns results that have a specific character count? I want to return all results that have 5 characters.
View 1 Replies
