Tagged Questions

1
vote
0answers
31 views

Hikari connection Leakage error

I have implemented Hikari connection with java configuration the code is below , HikariConfig sqlConfig = new HikariConfig(); sqlConfig.setDataSourceClassName(WebAppListener.getContextParameter(...
0
votes
1answer
75 views

Defining placeholders for source and schema name in a query inside SSIS

I am using a following query with hardcoded datasource name in my OLE DB source of SSIS package wherefrom I am pulling certain types of rows. select * from mtb.dbo....
0
votes
3answers
347 views

“Could not find stored procedure <Proc Name Here>”

I am trying to add an control to my page. I am following the wizard. Step 1, I select my connection string. The connection works, no error messages. Step 2, I choose "Specify a custom SQL ...
1
vote
1answer
634 views

ASP.NET/SQL Server: Conversion failed when converting from a character string to uniqueidentifier

I am using a paramterized query for this. I am passing a comma-delimited string of unique identifiers to this query's parameters which are split. It works fine using a couple of unique identifiers but ...
0
votes
1answer
698 views

SQL Azure Data Sync migration of Stored Procedures?

I have successfully implemented a POC that uses the SQL Azure Data Sync tool. However, it is quite literally "Data" because none of my stored procedures were implemented. Is it possible to use the ...
0
votes
1answer
4k views

Inserting data into a database table via SqlDataSource

Recently I have been watching Plural Sight ASP.NET videos on data binding, and I came across declarative data source controls such as <asp:SqlDataSource />. I am having trouble understanding ...
0
votes
2answers
8k views

Update is not working on GridView

Hey guys, I have a GridView which is binded to SqlDataSource, everything works fine, just update does not works, i am calling stored procedure, and all parameters and its dataTypes are proper, ...
2
votes
1answer
5k views

Updating records using stored procedure in sqldatasource

i have datasource which has an sp called for update and been binded to gridview. i want while updating it should use the sp and update table. Below is my design code. < asp:GridView ID="...
2
votes
3answers
3k views

Updating column with Null value

I have a date field (smalldatetime) in a table and in particular cases I need to set the date field to null. Currently, when setting the sqlparameter.value property to a date endDateParam.Value = "5/...
-1
votes
2answers
111 views

where can i learn to program the sqldatasource

i am using linked severs and synonym in sql server 08 in vs08 webpage when i connect the sqldatasource to the db it doesnot show the linked server or the synonyms!! (i don't know why it doesnot show ...