Tagged Questions
0
votes
7answers
51 views
Return value using String result=Command.ExecuteScalar() error occurs when result returns null
I want to fetch 1st row 1st cell value from database it works well with below code . But when there is no result found it throws Exception.
How to handle with DBNull .
Should i change my query ? ...
0
votes
1answer
18 views
SQL Server create assembly which references another assemblies
I have .NET class library which uses Quartz.dll
When i register assembly in sql its says that Quartz.dll requeres system.web, system.drawing, System.DirectoryServices.Protocols...
It is not ...
0
votes
0answers
80 views
What is the best EDI Tool for generating SEF
I am a Web/ C#/ MS Access developer who recently been handed the task of taking over EDI for a couple clients that use it. Basically since we only have a couple clients that use it we developed a home ...
0
votes
2answers
53 views
What is the best way to fetch records batch-wise from SQL Server
Scenario: we are fetching rows from SQL Server to C#.Net console application and doing action on the retrieved data from SQL Server through stored procedure; after the action is performed the new data ...
0
votes
1answer
386 views
How to stream image file into a SQL DataSource with AjaxFileUpload?
I would like to upload multiple files into a SQL database using AjaxFileUpload. I have a method that I use to upload a single file; in the aspx page with:
<asp:FileUpload ID="file_Image" ...
-2
votes
0answers
28 views
Choosing Non-clustered indices
I have a table wherein the queries fired against this table takes too much time. Records are in millions. The Table has clustered index to Primary key including 5 foreign keys. The foreign keys don't ...
1
vote
2answers
46 views
Get Record according to year range
I want to select a result from student table-
query -
if I pass any year like 2013 then select the students join start date and end date or he is currently there
in between these year
like if any ...
1
vote
3answers
24 views
How to Pick up values from datagrid ,search the database and update new values?
I have a datagrid and in it I have many rows. I just want to pick up 2 columns from which one row from which one column will search the database for that row with that value and the second column will ...
0
votes
1answer
22 views
SQL Server Limit users to view only data from their department [closed]
I am a beginner in SQL Server Security settings and I am quite new to stuffs like View and Stored Procedures. I have some problems about filtering datas and I am hoping that someone can give me some ...
0
votes
1answer
189 views
.NET datatable to a temporary SQL table
What would be the fastet and most efficient way to put a DataTable in .NET into a temporary SQL table on a remote SQL Server instace?
The datatables I am working on can contain up to 100,000 records, ...
-1
votes
0answers
33 views
parent form events inherit to dynamically created child form c#
there is a requirement, i need to create form(created in class library) then i need to make it that is child form for main form (main project), in main project form i have tool strip it contains ...
0
votes
1answer
42 views
Methods to insert data into database (SQL Server 2008 R2)
I'm a newbie in programming (C#), and I have this question for inserting data into database (SQL Server 2008 R2). I've been using tableadapter until now, but alot of professional programmers told me ...
0
votes
1answer
28 views
Failed to save Unicode in converting from MS SQL Server to MySQL
I am writing a C# program to copy all the data from a table in an MS SQL SERVER 2008r2 to a table in MySQL. I am using a DataGridView and fill it from the first table with this code:
...
0
votes
0answers
35 views
Maintaining Previous data with New data while update query fired?
I think it is an odd question but I have to implement this kind of functionality so I have to research about it that how can I do it.
So here is the question. I want that when any form is updated, ...
0
votes
4answers
5k views
How to insert datetime property from asp.net c# to a date column in sql server?
I have a problem using the calender control .. I am getting the date in a textbox... and I have to insert this into the database .. using asp.net with c#
In my web application the field property is ...
