I'm still new to SQL. Is it a general rule amongst programmers to make sure every table has a primary key?
View Complete Post
MSDN Magazine June 2004
Dealing with error handling between T-SQL and a calling application, evaluating when a field's value has changed, and creating auditing tables in SQL ServerT are all common issues that developers must tackle.
MSDN Magazine April 2004
Delegates, new in Visual Basic .NET, are type-safe, object-oriented references to methods. By using delegates, you make your methods accessible to others and therefore more extensible. This article provides an introduction to delegates, their benefits, and how they are used.Here the author shows you how to declare, create, and use delegates to invoke instance and shared methods at run time, and how to implement delegates as properties. He then goes on to provide examples of how delegates are used for callback functionality and explains the relationship between delegates and events. Finally, the article provides a glimpse at how delegates are implemented in intermediate language code by the Visual Basic .NET compiler.
MSDN Magazine February 2003
i'm trying to add new database source to an data flow task, but it fails when i'm trying to select DB table.
Could not retrieve the table information for the connection manager '....\.....'.
Field token out of range. (Microsoft Visual Studio)
Only way to select a table is write a table name to an parameter "OpenRowset"...
Before i have installed visual studio 2010 for .net development. Maybe this is an issue source?
Using SQL Server2008R2
Let's say you have N tables, and you want to write CRUD as per table not in an OO fashio.
How many WCF services are required?
is it near 5 * N (C,U,D, R and List with different criteria)?
Or would you have 1 service that takes care of all the CRUD?
What would be the interface (parameters) passed to such a service.
The number does not really matter, in fact the only thing I care about is the architecture.
If you are not able to provide detailed answers, please point me to where I can learn more about this.
I need some help very urgent. I need create
a table with Textboxes dynamically according to the database table.Example:
we have different articles in a database like cars, jewelery, boats.
The data related to these articles is different in the tables. I have to
show that data in a textboxes and let the user change those data and
update. I can do the update and reading the data from database. But the
problems is for each item the no.of columns and rows will differ.
My task is I need to get the data according to the use selection in
the table with textboxes. I dont know which container (gridview,
formview or etc) will suites for my requirement. please send me any
sample code or any tutorial related to this. I am in real need guys.. I really appriciate your help.
Note: showing the data in a table should be a constraint. Because I should show data row wise (each row contains 3 textboxes and 3 labels (DB table column names))
I can create a drop down menu using a range of cells as follows:
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
.IgnoreBlank = True
.InCellDropdown = True
.InputTitle = ""
.ErrorTitle = ""
.InputMessage = ""
.ErrorMessage = ""
.ShowInput = True
.ShowError = True
I would like to create the drop down with a range of cells using variables. For instance, in the line which contains $G$2:$G$10, I would like to substitute something like range(cells(1,2),cells(x,2)) to allow me to change the length of the menu depending
on how much data has been entered. Does anyone know how I can do this?