using vb.net and sql server 2005.I am creating a windows service and querying another type of db (not sql server) and storing the results in a dataReader.Once I have all the records what is the best and most efficient way to do sql inserts?
View 4 RepliesCan we import System.Data.SqlServerCe namesapce to web application?
I tried to add The SqlServerCe namespace from AddReference dialog but it didnt show.
And I have tried to install compact framework 3.5 but it still the same not show.
My requirements are
Login to the website and then create a database[.sdf] on the mobile device. Then connect to the .sdf file to retrieve info and display on my webpage.
The window mobile device is running on Window CE 5.0 OS. And I'm using MS Visual Studio 2005.
I'm looking to build a user control where the user should be able to select N number of files for upload using the same "file/explorer" dialog/control. Currently, the FileUpload control enables a user to select only one file for upload. I have seen examples where people have modified this, so that uploaded files are stored in a list to provide a "mass upload" functionality. However, the user can select only one file at a time. This is NOT what I want, the user should be able to select multiple files at a time, or select a folder with which I should be able to upload all the children images. Is there any way I can do this or has someone done this already and i'm somehow missing it?
View 10 RepliesThe website is over half way done and the functionality for the blog is (except for adding posts) is already implemented and working correctlyI have a SQLExpress 2008 backendBlog posts are rendered on the page with full HTML markup within a label control.
All of the above is done and working. Though I am essentially new to creating websites with ASP.NET, CSS and SQL, I am sure that I could simply carry on and make a login page with some controls that would allow me to add records (blog posts) directly to the database on the host server. However, I am fearful of doing this because I know that malicious code can be passed in this way. Also, because of my lack of knowledge, the only way that I know of to pass the code from a control to the database is to disable validation for the page the control is on. Without a doubt I do not want to do that.
So what are my options for getting blog posts into the database? Is it safest for me to fully create the post in html and update a copy of the database that resides on my local machine? If I do it this way, how can I merge the records from the database on the local machine with the records on the remote server?
If I create a new EDMX model and then I import a function, then I can see my function generated in the Designer. If I perform the same process but I add a T4 template (for Self-Tracking Entities) then I loose the function definition, although TT file has code adding a region named "Function Imports". Is this a bug or am I performing something wrong?
View 1 RepliesI get the following error in my imports statemnt Namespace or type specified in the Imports doesn't contain any public member or cannot be found. Make sure the namespace or the type is defined and contains at least one public member. Make sure the alias name doesn't contain other aliases. I did add the required dll's in the References tab in Project Designer in Visual Studio also added it in imported namspaces, but i still get the error what should i do?
View 2 RepliesMy client needs to be able to perform a mass email mailout of a newsletter (just once a month). Does anyone know of any resources I can use to code this ? Its on a hosted server and im using C#. I have found one example that sends the email aynchronously, but for some reason the emails just dont get sent. I have used the same code for sending an individual email, but it wont go when sent synchronously. Heres the code im currently using
[Code]....
Ive stepped through the code on my development machine and Ive confirmed that the SendEmail Method is being executed and I have used the sendmail method to send an individual email (which works). When I deploy the code to a hosted environment, the emails dont get sent.
I hear its not a good idea to use your asp.net site to do mass emails, resources etc
Hows GMAIL for this operation, what do you do ?
my website comes from a .net 20 config and am now on 4.0
For this line: Imports AjaxControlToolkit
I get this error: "namespace of type specified in the Imports 'AjaxControlToolkit"
I could remove that line, were it not that it also says this line: Private _questions As CascadingDropDownNameValue
error: Type 'CascadingDropDownNameValue' is not defined.
My web.config has been upgraded, I have placed the latest ajaxcontroltoolkit.dll in my bin folder...what more can I do?
I'm using Microsoft .NET Framework 3.5 to create a web service with VB.NET. I'm using a Stored Procedure in SQL Server 2008 so that SQL can insert all the data that I'm passing. The problem is that in one of the servicse I need to pass around 10,000 records and it's not very efficient to run the stored procedure 10,000 times.
I read that there is a way in which you can pass an XML file with all data to the Stored Procedure but I'm not sure if that's the most efficient way. Also I couldn't make the code work, I don't know if I have to pass the XML as a String. I'm asking for help with a method in which I can pass a lots of records to the stored procedure once and then the same instance of the Stored procedure can process all the records in a loop
i'm trying to send mass email to all my users. But i cannot send too many email at a time because I would be treated as spam or blacklisted, not just by my own isp, maybe the user's server too.So, initially i was thinking to write a loop and loop through the list of emails and send out batch by batch. But this would require my website to be stay opened until it finish.so, any better suggestion? i'm using my own server to relay the message before sending it out. is there email queining feature in my own mail server?
View 8 RepliesI have a customer database of 100,00,000 records stored in a sql db.I need to send mass emails to those customers everyday at a particular time.I want to use thread pool to achive it.
View 3 RepliesI need to test the counts shown in SSRS report. The report reads the counts from one of the tables.
I need to verify the counts shown in the report. For this I need to insert bulk records in the table (with different userid, datetime, etc).
How can I do this? I really don't want to do this manually.
I was wandering if I can make this faster. I am taking records out of Oracle and putting them into a SQL Server. btw, I am inserting into the Identity column
[Code]....
the application which i created is a web application which doesnt need much of a database,so i am just using the sql express free version which allows 4 gb of data,to avoid disasters iw ould like to delete records which are very old like,1 month,2 months old etc,how can i do this periodically should i do this on client side or the server side...
what id there are 100000 records and if we put this in page load or some method,it could take some time to delete,which i dont want..... how i can automate this process at the server side only
Would it be possible to creae a web form that will take an Excel sheet of email address or SQL Server Database and mass email to these people through a web form? If so, does anyone have or know some step by step instruction on how to do this?
View 19 RepliesI have data in database and that database is in the ip address .this ip address includes the data when i run the application it will give me all records but after the publish it will show me less data.
View 1 Repliesi try to use select statement to select records within a week from orderdate. like,
"select * from order where orderdate <= DATEADD(day,7,orderdate)";
correct me if wrong.
When i am inserting my data i am getting this error
An explicit value for the identity column in table 'emp' can only be specified when a column list is used and IDENTITY_INSERT is ON.
i have set Identitty specification and is identity of the table as yes so i am getting this problem whenevr i set it to no i am not getting any error,can anyone explain me why i am getting this error??
i want to read specific records form a table for example(tb)
if the field cosnsist of 100 record and i want to read form 70 to 80 what is the query for this but with out using ID field in the query
Here is my situation: I use the SqlCommond to update some records in the SQL Server in a ASP.NET web site. Users can choose which records they want to update. Sometimes they may choose 40 or 60 records to update at a time.Is there any good way to do it? I do not want to do like it
foreach(string ID in List)
{
Update here
}
I am having the table which contains Name,DOB From this i have to retrive the records of those who are celebrating their birthday is lie between today and coming 7 days. here is my query,
SELECT Profile.Name,
GetProfile.DOB,
FROM Profile
WHERE
Month(DOB)
=
Month(GetDate())
And
Day(DOB)
BETWEEN
Day(GetDate())
AND
Day(DATEADD(Day,6,
[Code]....
I have faced the peculiar case in Sql server's Inner join. I have 2 tablesFor example:Table Name: A and B I have shown the below code.
Select
* From A
Inner
Join B
ON A.JobCode
=B.JobLookupID
This select statement return 500000 records but both table did not have that much recordsI have shown the Records in every table:A=19396 and B= 25366 records.How it will return more then 5 lakh records in above select statemenet?. Please let me know if any one faced this issue earlier?
I have a SQL Server database, and I select some rows, how to know the number of records I select ?
View 6 RepliesI have 20 records in the datatable and i try to insert this records in a database, i want towrite begintransactions , and if all the records correct , i need to commit otherwise i need to rollback.how to do this?
View 2 Replies