Tagged Questions
-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 ...