Tagged Questions
0
votes
3answers
18 views
Updating Entity Framework Model after adding a field to a previous look up only table
To better illustrate the problem :
I have a table called Action with key AID and I have a table called Requirement with RID.
Previously I had a lookup table that simply held an AID and an RID.
This ...
0
votes
0answers
10 views
ASP .NET connection string for a LoginID created using a self-signed certificate
I created a certificate in SSMS (Sql Server 2008) using
CREATE CERTIFICATE testcert
ENCRYPTION BY PASSWORD = 'pwd for testcert'
WITH SUBJECT = 'Test Certificate',EXPIRY_DATE = '12/31/2015'
then ...
0
votes
1answer
46 views
Retrieve value from ListView
I need to retrieve some value from my ListView, which is bound with SQL to Order by Price ASC
Requirement :
Counts of total rows in the list
Minimum Price and Seller Name, who has minimum price ...
0
votes
2answers
20 views
Bulding Menu with asp.net using the Database
I have an table in database and I need create Menu in my project using this database.
How I create this with asp.net c#? I need transform this line "N:\A\B\C" in menu style Tree View. But this menu ...
0
votes
2answers
55 views
Creating Search Function in asp.net
I am trying to make search function in my web application.
Basically, i have one text box and one button.
Also i have listbox to render the search results.
I am using follwing query on access which ...
0
votes
0answers
12 views
Can I simply import aspnet_membership table to a new SQL instance that will keep usernames and passwords in tact?
I did see a similar post on this, but it didn't specifically say whether or not the hashed passwords and usernames would remain in tact.
The situation is that I rebuilt our eCommerce platform on a ...
0
votes
2answers
27 views
filter gridview based on dropdownlist selected value
Im trying to do a exercise filter GridView based on selected value in DropDownList.
I have a list of names in dropdownlist and when i click in the name i want that information of persons appears in ...
0
votes
2answers
20 views
storing data in a xml format file
I m trying to build a function that will retrieve 'some' SQL data from multiple tables, and store it in a file in the XML format.
If I do it with C#, is it as simple as:-
SQL statement,
retrieve ...
1
vote
1answer
58 views
Getting regular expression from database
I Have my regex in a SQL Database
for example: ^[A-Z Ñ\s\.\,\\"\%]+$
Then, i get it with a SQL Reader
sql.Reader["Regular_Expression"].ToString()
But, that return the following: "^[A-Z ...
0
votes
6answers
71 views
Passing strings in Sql query from C#
I Have a sql query as below:
Select CatId
From tbl_T2H_Category
Where Category IN ('Category3', 'Category4', 'Category6')
Now what i want is the values inside IN clause should be added ...
1
vote
3answers
83 views
Insert data within multiple tables in SQL Server 2008
I have 3 different tables in my database as below;
Table 1:
ResourceID | ResourceTitle| ResourceCategory
Table 2:
DocumentID| DocName | DocSize
Table 3:
ResourceID | DocumentID
Now I want ...
1
vote
5answers
1k views
Not able to set is Identity key as Yes in SQL Server
I just not created a new database with 2 tables in it. In a table, I have set a column as a primary key and trying to change its properties i.e. setting is Identity to YES, but am not able to do so.
...
1
vote
1answer
9k views
bind radio button list to column in gridview
I have radio button list in a gridview that needs to be bound to a column. If the value in a column is 0, the first radio button is selected, if 1, the other is selected.
This is the code, some of ...
20
votes
3answers
8k views
Connect to AS400 using .NET
I am trying to build a .NET web application using SQL to query AS400 database. This is my first time encountering the AS400.
What do I have to install on my machine (or the AS400 server) in order to ...
13
votes
4answers
7k views
Distributed transaction completed. Either enlist this session in a new transaction or the NULL transaction
Just curious if anyone else has got this particular error and know how to solve it?
The scenario is as follow...
We have an ASP.NET web application using Enterprise Library running on Windows Server ...
