-2
votes
1answer
14 views

OLEDB connection to SQL connection?

How to change this oledb connection in to sql connection... this is my sql connection line [Data Source=SAKTHI\SQLEXPRESS;Initial Catalog=Payroll;User ID=sa;Password=*****] return ...
1
vote
3answers
25 views

Getting String Value From Database in C#

I have a database table in which i am saving created users along with username now what i want to get string value from my database if username exists in database and then i will show error message ...
0
votes
0answers
32 views

triggers are not firing when I use bulk copy in code

I have a trigger called "updateFriendlyURLTitle" in dbo.Aritcle table. When a individual article inserted, that trigger working fine. But in article importing process: I've used the following codes. ...
0
votes
1answer
32 views

Comparing SQl Date With C# Input values

Hi i have to compare the date time sent from C# code to the SQLServer along with milliseconds. I have converted the date as follows.. CultureInfo provider = CultureInfo.InvariantCulture; ...
0
votes
0answers
54 views

Avoiding Deadlocks in SQL with concurrent inserts

I have a process (Process A) which keeps adding records to a SQL table (Table A) (Direct inserts using stored procedure). It is a continuous process which reads the requests and writes to a table. ...
0
votes
1answer
19 views

Converting issue Byte to Byte

i never work with Bytes before i have a getting error here in may code please have a look SqlDataReader reader = cmd.ExecuteReader(); reader.Read(); SqlDataReader dr = ...
1
vote
1answer
48 views

What is the best way to delete bulk amount of rows in SQL Server 2008 R2

Here I am using a query, "delete from Table where id in" ({0})", string.Join(",", Key.ToArray()) Is any other best way to speed up this process? Note : I used indexes. Example : I used SQL ...
-2
votes
0answers
25 views

Uloading file into Path and folder using sql server with foreign Keys But Dont Know The Error

public partial class Form16UL : System.Web.UI.Page { private SqlConnection con = new SqlConnection("Data Source=DDDDD-pc;Initial Catalog=TAX;Integrated Security=True"); protected void ...
0
votes
4answers
86 views

How to select latest Row from table without using ORDER BY

How can I select latest row from by table without sorting it? It is because it follow by the ID AUTO INCREMENT... I'm using c# asp.net to select... I did try using LIMIT 5 but it give me an error ...
0
votes
5answers
98 views

sql server find date difference in days input date format is dd/mm/yyyy

I am developing one project for which i want my date format in dd/mm/yyyy (Indian Format/ British Format). In my Database Table i have used string data type for this field. I have 2 fields In_date ...
0
votes
0answers
27 views

Installation WPF application on client system with SQL R2

I have mad an application in WPF using 4.0 Framework and at back end using linq to sql with SQL 2008 R2. Now was wondering what i need to do at client system in order to run my application . Clinet ...
2
votes
1answer
36 views

Preparedquery vulnerable to Sql injection

I am running OWASP Zap as a security review for our code. A SQL injection is being detected when we are using preparedquery and I am struggling to determine why? The basis of our code is: ...
0
votes
1answer
44 views

Cyrillic symbols in SQL code are not correctly after insert

I use SQL Server 2005 and I am try to store Cyrillic characters but I can't with SQL code by trying to run this is SQL Server: INSERT INTO Assembly VALUES('Македонски парлиамент број 1','',''); Or ...
0
votes
1answer
105 views

Loop through ado.net sql select to add more rows to datatable

I currently have a working query for the first element in the array of ID's as seen below. What I need to do is add a for loop so I rerun the query for every element in the array and add each new row ...
1
vote
1answer
49 views

How to save Video in SQL Server and display in listview and play it in video player on asp.net C#

I am developing a asp.net project and want to do do task done asps here is a problem i want to save a video in SQL Server table and also play that video in web player how can i save a video in MS ...

1 2 3 4 5 14
15 30 50 per page