|
I'm prototyping my first MVC application, it's a simple forum. I've done part of the domain model and I'm trying to figure out how to do something that's pretty basic in SQL alone, but I can't figure it out in my application. Here are my Entities:
[Table...
Started by Dzejms on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Now I'm assuming your User table and your Forums table both have) select f;
You should have another Entity class (probably should be internal) that mirrors your PK/FK relationships....
AllowedForums table in the database.
|
|
I have an Access database that I inherited and am trying to add some search functionality to it. This is simply a database that holds patient records such as name, address, phone etc. What I want to do is search by last name and have the rest of the form...
Started by Jim on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
If you can edit your access database (see @raj's comments), you might then be able-a-database-in-microsoft....
Questions/1407940/ms-access-passing-parameters-from-one-access-form-to-another
http://stackoverflow.com functionality.
|
|
I have a GridView being populated from a non-SQL database that we use internally. One of those fields is a stockroom location. (Example: AAA, AAB, AAC, etc.)
In another database (SQL) I keep a list of all stockrooms and give them a weight. The weight ...
Started by Gary the Llama on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Use your data access code to retrieve the information and populate be to;
Make a class that has all the information you need from the non-sql database and the column.
You need from the sql database.
|
Ask your Facebook Friends
|
Quick summary: I have a Rails app that is a personal checklist / to-do list. Basically, you can log in and manage your to-do list.
My Question: When a user creates a new account, I want to populate their checklist with 20-30 default to-do items. I know...
Started by jerzy on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
It's already a one liner if you want it to be:
@new_user.checklist from a file, or store in your class, or wherever....
A Rails Fixture is used to populate test-data for unit tests ; Dont think it's meant to be used to be as verbose as suggested.
|
|
In a Rails application, I need a table in my database to contain constant data.
This table content is not intended to change for the moment but I do not want to put the content in the code, to be able to change it whenever needed.
I tried filling this...
Started by Vincent Robert on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Use the db:seed rake task another migration to remove the old seed data and load the new one instead, which may be non be loading this populate....
Intialization data from "seed" yml files (one for each model) into the database.
|
|
I have this requirement and since im new to vb.net dont really have much of idea how to do this. I have 20 checkboxes with dropdowns and textbox with it. the example is -
table tr td checkbox -- textbox -- dropdownlist /td /tr tr td chk1 txtbox1 ddl1 ...
Started by redr on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Another example on using.
Here is an example
Here is another example
And here is an example on how to lay out the CheckboxList
EDIT: OK.
You can use the CheckBoxList and bind it to your data .
|
|
In my SQL Server backend for my app, I want to create history tables for a bunch of my key tables, which will track a history of changes to the rows.
My entire application uses Stored Procedures, there is no embedded SQL. The only connection to the database...
Started by pearcewg on
, 9 posts
by 9 people.
Answer Snippets (Read the full thread at stackoverflow):
It's good for security, resilient to failure modes like people forgetting to add code to update the history... .
CDC is an ability to record changes to table data into another table without writing in the history table.
Can help.
|
|
I have to leave in a DataTable only records with dates currently not present in the database.
So I read all existing dates using the stored procedure (is it correct?):
SELECT DISTINCT CAST(S.[date] AS DATE) -- original date is DATETIME2(0) FROM ... WHERE...
Started by abatishchev on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
This using one single LINQ query?
Here is my version of custom datarow comparer:
public class harder to read, but nevertheless, it is "one query."
Having said this, none of these examples really)
Hopefully one of these answers your....
|
|
Hi folks
I have a situation where i have 20 Access databases. Each has the same 15 tables, but with different data. (The name and schema is identical for each table across the 20 databases).
I want to make a new database with the same structure, and populate...
Started by Max Williams on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
2) generate a select that selects all rows and columns for each table to change all primary....
DB20 and your "final" database key values from DB1, DB2, ...
To make it shorter I'll call your 20 databases like DB1, DB2, ..
Statement.
|
|
I have the following SQL query:
SELECT * FROM table WHERE field_1 <> field_2
Which is the best index structure to use, to keep this query efficient: two indexes on field_1 and field_2 or a single index which includes both fields?
EDIT: The database...
Started by Enrico Detoma on
, 7 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
Make sureI imagine this may depend....
However, the only way to find out is to populate a table with dummy data and try it out.
This would imply that a single index across both columns is likely to be best .
one index per table.
|
