Questions tagged [data-connections]

116 questions
0
votes
1 answer

Automatically Generating Controls From Data Connection In Windows Forms

I vaguely remember in my ASP.NET days a way to drag and drop something like a data connection onto the page to automatically generate controls. I would grab SQLDataConnection1 (or something) that was set to pull back Name, Address and Phone from the…
user3179585
  • 123
  • 1
  • 1
  • 11
0
votes
0 answers

MSSQLLOCALDB accessibility after deployment

We get local automatic instance of MSSQLLocalDB while installing visual Studio. Why am i not able to access the tables data by having localdb connection string after deployment to IIS
Vyshnavi
  • 115
  • 1
  • 11
0
votes
1 answer

How to write a macro in google sheets to refresh a bigquery data connector?

Trying to create a macro that refreshes a bigquery data connection. Have tried to record a macro, starting on a different tab, clicking into the tab with the data connector and clicking refresh. function Refresh2() { var spreadsheet =…
0
votes
0 answers

Where is get external data in Excel Online Office 365

I have an Excel Spreadsheet that gets data from a stored procedure in SQL in Azure. No issues, it works from the local station or the Azure VM. I want to use this sheet in Excel Online of office 365. There are option to Refresh connection, but no…
Ricardo
  • 105
  • 1
  • 11
0
votes
2 answers

Is there a possibility to run a macro in an excel-file (data-source) when data connection is refreshed by another excel-file (data-target)?

a lot of users in our network use an excel-workbook (.xlsm [office 2010]) created from a template. Now, there are some important changes I've to do in the template and I want all the users to update their workbook but i'd like to avoid to contact…
user2302113
  • 41
  • 1
  • 5
0
votes
1 answer

Google BigQuery connector (Connect Data Studio to BigQuery tables) - I would like to modify this connector to customize for my special requirements

I need to modify the Google Data Studio - Google BigQuery Connector for the customized requirements. https://support.google.com/datastudio/answer/6370296 First Question: How could I find the source code for this data connector? Second…
searain
  • 3,143
  • 6
  • 28
  • 60
0
votes
1 answer

PowerPoint live fields, linked to Excel data

I would have thought this one would be asked to death so cannot see a solution - looking for a way to live link PowerPoint to Excel data, only for a word within an otherwise manually typed sentence. I am not asking how to live link a chart or a…
JakeyG
  • 100
  • 11
0
votes
0 answers

How to enable 3G or DataConnection?

Actually I want to enable data connection when I enter wrong password on android phone. I used a ConnectivityManager but it is not working fine. Here is source code for which I used. ConnectivityManager dataManager; dataManager …
Wahab Raja
  • 51
  • 1
  • 8
0
votes
0 answers

Creating SQL Connection in Excel that creates and drops temporary tables

I've created query that runs perfectly in Microsoft SQL Server and it utilizes temporary tables it creates and drops. I now want to create a data connection in Microsoft Excel that will run my query and display the results in Excel, so that business…
Omar123456789
  • 59
  • 1
  • 2
  • 9
0
votes
1 answer

Excel VBA: OLEDB Connection.CommandText Error

Hello: I've had success with a long SQL (Oracle) as the Command Text in an OLEDB Data Connection that I entered manually. I then had success entering the SQL via VBA (because I need it to update based on a changing Item List), and only running the…
RARascon
  • 129
  • 1
  • 12
0
votes
0 answers

VBA Refreshing Data Connection by selecting a new text file without adding a new table

So I've been trying to figure out how to do this but I am only able to get VBA to add new connections and not refresh the current one (without prompting the user). Basically, I have multiple things that need to be refreshed at once and it would be…
LostVBAGuy
  • 23
  • 3
0
votes
1 answer

MVC project with connection string not working for other colleagues in TFS

We are working on an MVC application, I added the connection string and generated the data models. When I update the model from database in the .edmx file it updates the web.config file and I check it in TFS. When other other people get latest…
PanzerRage
  • 31
  • 2
  • 6
0
votes
3 answers

Visual Studio Unable to Add Data Connection to SQL Server Express 2016

I'm working in VisualStudio Community 2015, SQL SERVER EXPRESS 2016 and when I try to add server connection with sqlServer appears the error I attach below: (After TEST the connection and be safe that all is right)
0
votes
1 answer

How to add Data Connection for Oracle 11g in Visual Studio Enterprise 2015

I have Oracle 11g database which I need to connect in Visual studio 2015 (Enterprise Update 3). I have install Oracle client 11 on my machine reference to following directories I believe there are both Oracle Client 32-bit and 64-bit but not…
K.Z
  • 5,201
  • 25
  • 104
  • 240
0
votes
2 answers

Checking wifi network in Android

I want to to store data in server with the click of a button called "save" when I press that button i want to check wifi if it is available I should be able to save data otherwise check data connection if there is no balance then I should get an…
Ruby prO
  • 109
  • 2
  • 12