Tagged Questions
0
votes
0answers
7 views
ORA-12705: Cannot access NLS data files or invalid environment specified - only appears on host server, localhost OK
I'm getting the above error when I run my application on the remote host server. It runs fine on my localhost IIS...I've read one fix is to rename NLS_LANG in the server registry but it's there on my ...
0
votes
1answer
48 views
How do I create a 3 week rotating schedule from SQL data? - EDITED
I am in the process of building an application for a cafeteria that uses a 3 week rotating menu. Here is the DB structure in a nutshell:
Foodnum(int - PK - auto incrementing field)
FoodName(nvarchar ...
0
votes
0answers
22 views
Model-First Entity Framework: using Enums or default values for Entity using Designer (.NET 4.0)
I have started learning Entity Framework recently and not sure what to search for this task.
I have an Entity called EstimatedEffort with property Status which can be Active, Inactive, TBD. Now ...
4
votes
1answer
75 views
connecting to an SQL Server database
I've recently started programming asp.net with C# (using VS2008) and I wrote my first web application that connects to a database. First version worked ok but now there are some problems once I modify ...
0
votes
0answers
11 views
sql connection error with website through xbap
I have a WPF XBAP application that is hosted in IIS on one server and the database it connects to is on another server. This works fine and can connect to the database no problem. I have also hosted ...
0
votes
0answers
17 views
CRUD operations on Grid inside TabStrip Does not work
I have an telerik Radstip inside which upon a click of one tab...a telerik grid is populated. Upon the initial load grid appears perfectly fine...but any other operation on grid...like refresh, ...
-1
votes
0answers
17 views
Asp.net Membership Provider issue with connection string ApplicationServices
I have created a web site in ASP.net 4.0 (Visual studio 2010) and SQL 2008.
I moved my website to production server (On server I have sql 2005 and Visual Sutdio 2005)
Now In login page on Login ...
0
votes
1answer
46 views
Retrieve decoded binary image from SQL and insert into PDF via iTextsharp asp.net c#
I have store a binary coded image into my SQL database. This binary coded image has another file named MemberReportImage1 which is there to decode the binary image. I'm able to display out the image ...
0
votes
2answers
37 views
Logging parameterized SQL query with parameters included
I have a couple of functions that take a SQL query (parameters already added) and run it against the database. When the SQL query fails, I'd like to log the complete query, parameters included, in ...
0
votes
1answer
30 views
3rd Party Data Explorer for .Net [closed]
I'm developing an engine in ASP.net where a user can connect to their database (SQL server, Oracle, ODBC) etc. I'd like to have the ability for a database browser similar to what you see in many ...
0
votes
2answers
42 views
how to insert data in 1 table and update another table in a sql database using linq
I have a save button that will add new data in my 'IncidentActions' table and at the same time update 3 columns in my 'Incident' table.
How would i go about doing this
Here is a the C# code i am ...
1
vote
1answer
28 views
ASP FileUpload suddenly not working
So my fileupload function had been working for awhile but all of a sudden it had stopped working and the problem remained even after I tested it in a new project and reverted to the older version of ...
0
votes
0answers
32 views
DataRowView Error Object reference not set to an instance of an object
i am trying to make a profile page for my users in my website where they can edit theie profiles.i have used this code but its not working
ASPX page
Welcome
,
<br ...
1
vote
3answers
66 views
Insert record into transaction table for each column value change of my user table in SQL
I have a user table with data
User_Name
User_Address
User_Gender
and so on..
Now my transaction table contains fields like:
Trans_Id
Trans_User_Field
Trans_Previuos_Data
Trans_Add_Date
Now in ...
3
votes
4answers
131 views
LINQ fastest way to update lots of records (>2m)
I have this loop:
using(var db = new MainContext())
{
var q = db.tblInternalURLs;
foreach (var rec in q)
{
db.ExecuteCommand("UPDATE tblInternalURLS SET hash = '" + ...
