C# is a general-purpose, managed, garbage-collected, object-oriented programming language created by Microsoft.

learn more… | top users | synonyms

0
votes
0answers
12 views

script task sssis file extension is missing?

Hi I have problem with script task C# I create I have to prefix log file with date but my problem is not adding file extension log file is log_yyyy_MM_dd without extension I want ti extension log ...
0
votes
0answers
24 views

SQLDependency equivalent for MySQL [migrated]

I want to implement a real time update on my ASP.net project, so i tried to implement the long poling mechanism and Comet. var isPolling = 0; function longPolling() { isPolling++; $.ajax({ ...
0
votes
0answers
15 views

At what point does the MongoDB C# driver open a connection? [migrated]

I'm having a problem with lots of connections being opened to the mongo db. The readme on the Github page for the C# driver gives the following code: using MongoDB.Bson; using MongoDB.Driver; var ...
1
vote
1answer
59 views

Finding parameter names for binding stored procedure parameters

For unit testing purposes I am attempting to call the DBMS_OUTPUT.PUT_LINE procedure from c# using parameters that are bound by name. Since this DBMS_OUTPUT package seems to be a standard on Oracle ...
3
votes
1answer
111 views

“A severe error occurred” - Login Failed (but only occasionally)

I'm using a C# application to execute a query against SQL Server. Here's the relavent portion of an exception I'm encountering once every twenty-four hours or so: System.Data.SqlClient.SqlException ...
2
votes
1answer
53 views

MongoDB ReplicaSet reconfig when primary and majority don't exist

http://docs.mongodb.org/manual/tutorial/reconfigure-replica-set-with-unavailable-members/ Is there anyway to reconfigure a replica set in the event the primary as well as a majority of the servers ...
0
votes
0answers
12 views

Is it possible to restore only tables/constraints from database backup?

For circumstances beyond my control (permissions/bureaucracy), I'm unable to use SSIS or Scheduler Agent to create an automated, scheduled production database backup and development database restore. ...
0
votes
2answers
415 views

SQL Server 2012 - Insufficient memory to continue the execution of the program. (mscorlib)

I have a sql file, which is up to 180 Mb. When I try to open and execute it on Microsoft SQL Server Managment Studio 2012, I am getting this error. . What do do ? I researched on Google. And there ...
-4
votes
1answer
55 views

How to run mssql server dependent application to mysql workbench [closed]

I am very new in mysql workbench. I have created an application in c# which uses sql server 2008 r2 database. Now i have migrated my database on mysql workbench. i want to run my application now. My ...
0
votes
2answers
135 views

can we transfer sql database backup from one server to another server directly?

I want to transfer sql database from one server to another server directly, instead taking back up of that database and copy that back up in another server and then restore it. Please tell me, Is ...
-1
votes
1answer
101 views

Using C# need to drop all tables in mySQL database beginning with prefix

I have found this question answered but not specifically for C#. The answer seems to be to execute the following statements tailored to my specific database. However, I can't figure out how to use ...
1
vote
2answers
938 views

Trying to connect to PostgreSQL with Entity Framework via Npgsql and C#

So, I'm new to databases and only have done a little with PostgreSQL before. I have C# (visual studio 2012) and have downloaded the Entity framework (6). I have also downloaded the latest Npgsql data ...
0
votes
0answers
22 views

Searching ObservableCollection's items in a string

i am trying to search an observablecollection's items in a string. I try as in the below code. for (int j = 0; j < DBControl.Instance.SelectLanguagesFromDatabase().Count; j++) { if ( ...
1
vote
0answers
34 views

Selecting aggregated string from database

I have a table in my database consisting of one column which is NewLanguage(varchar). I insert new languages to the table and I want to select the rows of the table and assign them to a string ...
1
vote
2answers
31 views

Garbage DB Objects Cleansing

How do I find in use db objects from all application pages is there any tool or trick I can use, just like we do search in Visual studio for an object in entire solution
0
votes
0answers
49 views

Print Order wise in c#

Below, I attached coding and Screen shot, i get print preview output red block of 321 order but, i want 123 red block order. kindly solve my problem 1.NAME Block 2.AGE Block 3.ADDRESS Block, ...
1
vote
0answers
88 views

Transfer an Advantage Database's Schema/Data to a PostgreSQL Platform Using C# Program

I am currently in the process of writing a .NET program with C# to transfer a database on a Sybase/Advantage 9.1 platform to a PostgreSQL 9.3.4 platform. I am doing this transfer in two stages - ...
0
votes
1answer
46 views

How to deploy case-insensitive embedded firebird database?

I'm trying to find out how to create CI firebird embedded database. I've found (here) that there are some character sets each of them has one or many collations. So, UTF8 has UCS_BASIC, UNICODE and ...
0
votes
0answers
42 views

Correct way of saving information to a database

I am making a website where people can register/login and upload files (text only) and other people can view them. I have the file upload feature which upload the file to a folder and it automatically ...
1
vote
0answers
190 views

Best practice - SQL Schema to store Timerecords for a Time and Attendance module

I'm starting a time and attendance module in C# and SQL. There will be many time rules depending on every shift. For example: Shift 7:00 - 14:00 for Administratives: 15 min grace time, but if ...
0
votes
1answer
89 views

Database analysis

I have database which that store the sold products in Orders Table and another table called Transaction to set the time and the total price for the individual order ,my question is: How to combined ...
0
votes
0answers
71 views

How to allow CodeFirst migrations to make schema changes against a replicated database

Running any migration that alters existing replicated tables fails with the following error: You can only specify the READPAST lock in the READ COMMITTED or REPEATABLE READ isolation levels. ...
0
votes
0answers
131 views

How to increase application performance with Centralised SQL Server [closed]

I’m trying to get my head around to make better way to increase the performance of my application System based on single SQL Server with 50 clients tablets pc(its connected to local wireless). my ...
0
votes
0answers
372 views

Transaction Time out error C#

Database Type : SQL server 2008 R2 Issue description: There are two machines. One is server machine(OS- Windows server Enterprise) another one is client machine(OS- Windows 7 professional). In Both ...
0
votes
1answer
87 views

remote connection to mysql

have two machine PC#1 with db mysql and appache and PC#2 with a c# form try to connect to this db here is my connection string used in PC#2: SERVER=My_public_ip;PORT=3306;DATABASE = my_test; UID = ...
2
votes
1answer
255 views

Best Practices for Creating and Deleting Records in MYSQL

I'm fairly new to working with databases, but I've currently have a webCrawler that I've written in C# using MYSQL database. The crawler is frequently writing and deleting records from the database ...
0
votes
0answers
59 views

Caching data with MySQL and asp.net 2.0

I want to cache frequently used data. Is there simplest way to do this with asp.net itself? I am using framework 2.0. If i do this with MySQL technique how about innodb?? will this allow me to cache ...
0
votes
2answers
641 views

c# Backup sql server database, error Operating system error 5(Access is denied.)

I have been trying to backup an sql server database, and I understand that this error is in regards to drive write protection. I am at the end of my rope with this, as nothing that I have found online ...
1
vote
1answer
771 views

Best Format to Bulk INSERT/UPDATE Data to SQL SERVER using C# [closed]

Can anyone tell me what is best way to bulk insert/update data to SQL SERVER 2012 using C#? I have an excel file which I am passing as TVP(table value parameter) to a SP. But this is little bit ...
1
vote
1answer
52 views

Is there a public repo where I can contribute to the MySQL .NET connector?

We have found ourselves making some performance and scale improvements for the MySQL .NET driver from here http://dev.mysql.com/downloads/connector/net/ We know where to get the source in a ZIP ...
2
votes
1answer
77 views

What is happening with locks in my database?

I'm having some problems on my database. At any given time, I'm trying to execute an update with five records on my table, but this table is locked and I get a time out executing the query. I ...
-1
votes
2answers
6k views

Converting varbinary data to varchar in SQL (Just like converting bytearray to string using Encoding.Default.GetString in c#)

I need an urgent help to fix some data conversion issue in SQL server 2008. I got some requirement change on storing the data. Without much care I converted existing varbinary data to varchar in SQL ...
0
votes
0answers
138 views

Publishing SQL Server in mdf format onto GoDaddy SQL Server admin [closed]

I have created a website with a database in .mdf format. I successfully uploaded my website and created a database in GoDaddy windows hosting. Can anyone tell me how to publish a locally created ...
1
vote
1answer
438 views

LOAD DATA INFILE fatal error encountered

I use this query for loading sql data from my pc to localhost mysql database.(version 5.0.10 working witj XAMPP) The query is as below: cmd = new MySqlCommand("LOAD DATA LOCAL INFILE '" + filename + ...
1
vote
1answer
206 views

Can geography datatype Lat/Long properties be returned using a view in SQL Server 2008?

Hopefully the question is fairly self-explanatory. I've been ferreting through the, what appears to be quite minimal/poor microsoft documentation regarding both views and geography datatypes in the ...
0
votes
2answers
102 views

Migrating DB issues

I need to migrate an old database's data to a new database with a new design. One major problem for me is that the old database uses nvarchar type as the primary key in its table for some reason. In ...
0
votes
1answer
149 views

can't connect to postgresql with md5 [closed]

I can connect to db with trust, but it is not letting me to connect with md5. It says : "password authentication failed for user "postgres"" Here what I have in pg_hba.config host all all ...
0
votes
1answer
255 views

Need C# Sql Server Project Set Up Guide [closed]

I am creating a window application on c# .net and Sql Server 2008 R2. I will give the setup of this application to my client but I am little bit confuse about SQL Server Database. How the database is ...
0
votes
0answers
290 views

Snapshot transaction throws random conflict. Should I choose something else? [closed]

I've got a problem with my transaction. Currently it runs in IsolationLevel.Snapshot. The action it does, can take some time depending on the amount of data, it has to import. What it does: Create ...
1
vote
1answer
376 views

SSIS 2012 Ftp parallel/asynchronous multiple file download

Any help would be appreciated with either scenario. if Are there any settings available to download multiple files in parallel from an FTP server? else If not, I guess I'll just roll my own via ...
0
votes
1answer
288 views

Out-of-Range and Overflow Handling for float values

am using mysql 5.5 log version with sqlmode='' .I have many columns with float(9,3) as the type. Say for ex one column taxvalue (9,3) Currently if the user enter the value above 999999.000 MYSQL ...
0
votes
3answers
2k views

Connecting to SQL Server instance through C# [closed]

I made a program, using c# and sql server with sql authentication. It works properly in my device, but after making the program setup file .exe extension using Innosetup, I cannot connect to my ...
2
votes
0answers
135 views

Sleeping connections

I have a dedicated MySQL server(8GB) with following configuration. [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql lower_case_table_names = 1 ...
0
votes
1answer
986 views

What is the best practices to backup and restore full and partial database with SQL Server 2012 and C#?

How can I do the following with C#: Completely backup an existing database. Partially backup an existing database. Completely restore an existing database from a backup file. Partially restore an ...
-2
votes
1answer
183 views

Query sql-server db and insert results into PostgreSQL

I have a query that returns data from sql-server and I need to be able to put the results into PostgreSQL. I'm using C# for the task.
1
vote
0answers
51 views

Rows do not match Subscriber and Publisher

I have an transactional replication setup with updateable subscription that is utilized by an Application. When I insert a project into the application, the msrepl_tran_version is different on the ...
-2
votes
1answer
293 views

How to enter multiple checkbox list items into database for eventual reporting [closed]

(I tried posting this on SO but went unansered. I'll just post these theory type questions here from now on) I'm in the process of creating the first of a few CheckBoxList for a manually created ...
0
votes
2answers
88 views

Home rolled gridview search results shows rows that are supposed to be ignored [closed]

Note: I tried posting this on Stack Overflow but didn't get any good bites. I'm still researching this but wanted to see if any db czars can assist here. I'm in the process of trying to troubleshoot ...
0
votes
1answer
372 views

Get all the database in db2 through web

I would like to get all the databases available on a db2 instance from a C# application. The CLP command to be used is LIST DB DIRECTORY. How can I fire this command from C#? Is there another select ...
-4
votes
1answer
146 views

Update date Column values? any please help? [closed]

I Want to copy and data in same Table and Update date Column values? any please help?