ado.net

相关标签：javascript jquery android 多少钱 iPhone

boolean value in case statement in sql query

I am using case statement in select query some thing like this. Select col1, col2, isActive = case when col3 = \'abc\' then 1else0 end, col4[详细]

2023-04-03 20:52 分类：问答
convert boolean value to SortOrder enum value

i am reading boolean value (value would either 1 or 0) using data reader in ADO.NET from a table and want to type cast value to SortOrder (http://msdn.microsoft.com/en-us/library/dscy145f.aspx).[详细]

2023-04-03 13:37 分类：问答
How to create a C# class whose attributes are rows in a database table with ADO.NET?

Is it possible? Please note I am not usin开发者_运维问答g LINQ nor Entity Framework.You could also check out Dapper-Dot-Net - a very lightweight and very capable \"micro ORM\" which - incidentally -[详细]

2023-04-03 06:47 分类：问答
Check to see if 2 datatable have same schema

I want to make sure that 2 Ado.net datatables h开发者_StackOverflowave the same schema: number of columns + col types etc. How can this be done?[详细]

2023-04-02 22:42 分类：问答
How to copy DataGridView contents to Dataset?

i\'m not good with ADO.NET so used the following code that i got from Internet but i get the error \"There is no row at position 0.\" @ the marked line(*)[详细]

2023-04-02 15:19 分类：问答
SQL + Cyrillic support + Parameterized Query + Multiple Choice

I have this code so far: string userInput = Textbox1.text; string query = \"SELECT * FROM Books WHERE BookName = @Title\";[详细]

2023-04-02 11:54 分类：问答
Getting value from a DataSet into a variable

I have the following method which returns dataset. I am using .NET 2.0 DataSet ds = GetAllRecords(); I want to get values from each column for a particular row and bind it to a variable.[详细]

2023-04-02 05:22 分类：问答
How to get the Affected Records in VB.net 2010 with SQL?

I\'m trying to get the Affected Records but it always give me -1 Here is my code: cmd.CommandText = \"SELECT * FROM persons\"[详细]

2023-04-02 05:07 分类：问答
TSQL: Updating multiple columns not working?? (ASP.NET C#)

I have this stored procedure CREATE PROCEDURE spEditInfo @username nvarchar(64), @password nvarchar(64),[详细]

2023-04-02 01:34 分类：问答
SSIS Script transformation error using ADO.NET

I\'m getting an error that states Incorrect syntax near \')\'. when executing my SSIS package. The error is being thrown by a Script transformation component in the DFT. From what I can tell it is bei[详细]

2023-04-02 01:15 分类：问答