Comments by Rwolf27 (Top 22 by date)

Is there an alternative way to modify the Excel file to incorporate a Password ?

Its an extense error but its something like this: "System.Data.OleDb.OleDbException (0x80004005): Is not possible to update. Data base or Object ist only for reading, at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)
at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.OleDb.OleDbConnection.Open()
at Manage_prod_priac.XlssHelper.ExportDataSetToExcel(DataSet dataSet, String filePath) in .vb:line 55

Oh sorry,I didn't know really. Well i don't have a license since i though this was a free product (it was on a recommended list in my office from the same colleague), so that explains the reason it doesn't work, maybe.

I'm searching for a way to implemente a logIn in my app that uses de Azure Active Directory that my office uses.

Omg I'm so sorry, I didnt notice the hyperlinik that you posted. Thanks, Iam going to take a look on that!

Yes the accounts in my office is Azure Active Dir., I've search since yesterday but because I'm new to VB i didn't know what kind of example I was looking for. Culd you give me some sort of example?

Yes the accounts in my office is Azure Active Dir., I've search since yesterday but because I'm new to VB i didn't know what kind of example I was looking for. Culd you give me some sort of example?

I saw this but Im sorry, I didnt understand how this might be usefull... Can you explain more details? Thanks

Well i'm pretty new to this, so my companie uses the office account, how can i know if is Azure Active Dir. ?

The SQL DB is all decimals.

Right, the link you have sent have informations in regard of that topic?

True, I'm sorry I didnt saw that. You right, that's why I'm asking if there is a way to adapt the code to accept that or to handle that ...

No, its not that, your answer got me the data, its returning. The problem that I'm saying now, is that my code can't handle the fact that some rows in the SQL is returning empty (is supposed too). But I want in that case that the rest of the columns be just empty. I don't know if I'm being clear, sorry.

Nice one, i think solved the problem of the DT, but if you don't mind. In the same code (because i never got so far). Like I said in the beginning, there are some products that i dont have in the SQL DB, so they might return empty or null, and I think that now I'm getting an error in the lv.SubItems.Add(dt2.Rows(0)(0).ToString) of "'There is no row at position 0." what can I do to handle this?

One thing i miss to point out, I'm already populate 2 DT, one for MySQL and another from SQL, and then join them in the ListView, don't know if it is the same. But i never worked with linq.

I know, but I used the output caming in the parameters in VS and testes directly in Workbench, and worked.
This code is reused and with just Mysql worked perfectly.
By the way, Iam a junior in VB, still learning.

Thanks, but my dt is returning as "Nothing", and i cant point what is causing this. The function never gets to go to the loop to populate the listview.