|
tried and failed.
wait, using it without ' in the query string works. yes, thank you
though I can still input % as a wildcard and get all rows. I thought this supposed to sanitize/escape input. guess I can live with it though, unless you have a better idea
|
|
|
|
|
Yes, because parameter names must be entered 'as is', not quoted.
|
|
|
|
|
do you know why the % char isnt being escaped?
|
|
|
|
|
Not sure what you mean, I thought is was the wildcard character for the LIKE phrase.
|
|
|
|
|
yes, but if it's put into the textbox, it's queried as LIKE %%% which matches everything
|
|
|
|
|
I'm sorry, you have lost me. What has a TextBox got to do with SQL statements?
|
|
|
|
|
it's a search query for a database, text input box
|
|
|
|
|
Yes, but that has nothing to do with creating a valid SQL statement. The textbox is provided by the user, so your code should verify that it contains valid data. You then take the validated text and store into one of the SQL Parameters which get passed in to he execution module. Do not assume that the user knows what he or she is doing and just accept whatever they type. Many times it will be wrong, mist-typed, not understanding what is required, etc.
|
|
|
|
|
I thought SQLLiteParameter sanitizes or at least escapes special characters
|
|
|
|
|
Sorry, I don't know, you would need to check the documentation.
|
|
|
|
|
|
i have Two Database in two different servers i want to join two tables from this two Databases
i have no relation between them but just a column wich contain information about the other database
Ex : Database1.dbo.informationCity contain a column named Specification and have this information:
14042020111925_GMS3439_09_04_2020-04_48.xml_6456.zip
i want to extract from this column just this number 3439 because with this number i can rely the other database
Ex : Database2.dbo.city contain a column named cityID : 3439
any body have an idea how to do that ?
i tried this Sql request but it did not work
<pre lang="SQL">SELECT
*
FROM [mo].[dbo].[Database1]
INNER JOIN [Database2].[dbo].[city ] ON substring([Specification], CHARINDEX('GMS', [Specification ]) + 3,4) =
[Database2].[dbo].[city ].[cityID]
|
|
|
|
|
Your join seems to be confused about the table names. According to your question, your tables are:
Database1.dbo.informationCityDatabase2.dbo.city
But according to your query, the tables are:
mo.dbo.Database1 (Completely different name)Database2.dbo.[city ] (Extra space at the end of the name)
There's also nothing in there that would suggest the databases are on different servers. If they are, you'd need to create a linked server on the server where this query will run pointing to the other server, and use the four part name of the table you're trying to query - [Linked Server Name].[Database Name].[Schema Name].[Table Name].
Create Linked Servers - SQL Server | Microsoft Docs[^]
If it still doesn't work once you've fixed that, you'll need to provide the full details of the error(s) you're getting.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
thank you sir for your Help , i fixed it and it works
now is that possible to get automaticaly my results to an Excel file => simply export my result to excel directly
|
|
|
|
|
Yes. For example, from SQL Server Management Studio:
Start the SQL Server Import and Export Wizard - Integration Services (SSIS) | Microsoft Docs[^]
From .NET code, you could use a library such as ClosedXML[^] to create an Excel sheet containing the query results. (Previously, I would have recommended EPPlus, but that's no longer free for commercial use.)
Or you could write the results out to a CSV file, which Excel will be able to open. I like to use the CsvHelper[^] for reading and writing CSV files, but other libraries are available (eg: fastCSV[^]).
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
sorry but i am a beginner , i do not know how to start exactly
i have just my sql request which is correct and works well
|
|
|
|
|
i'm used to MySQL, this is...different. A table with just one row
Using "DB Browser for SQLLite"...structure
CREATE TABLE "appinfo" (
"version" TEXT NOT NULL,
"passworded" INTEGER NOT NULL,
"username" TEXT NOT NULL
);
I added a row. "1", 1, "Admin" with DB Browser
when I query it "SELECT * FROM addinfo;" with DB browser I get NULL for each field (blank on my c# app)
what am I missing here?
thanks
|
|
|
|
|
Uranium-235 wrote: what am I missing here?
The correct spelling of "appinfo".
|
|
|
|
|
no, that wasn't a copy & paste, it was a misspelling here, when I actually do it from my c# app it returns the column names (found a function to easily present col names and row data, so the columns are correct), and one row of empty data, just like in DB Browser
I just tried SELECT * FROM "main"."appinfo";
it returned <blank>, 0, <blank>
the middle number is supposed to be a 1
modified 12-Apr-20 14:39pm.
|
|
|
|
|
I'm having trouble parsing your query! I would presume that "Main" is your database and is included in your connection string.
If so then your query string should be "Select * from appinfo" and it should return the 1 record you have inserted.
If you want an empty datatable then "Select * from Appinfo where 1=1"
Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP
|
|
|
|
|
no this is from DB Browser, not even the app
|
|
|
|
|
Nevermind. I inserted it into the database with a query in DB Browser instead of using the browser and it seemed to work :shrug:
thanks for putting up with me
|
|
|
|
|
Whatever you think you entered perhaps did not happen. Or your query is somehow incorrect. You can easily get all the information from SQLite database files using the sqlite3 command line interface.
|
|
|
|
|
Just out the blue today I started getting this error on my Dev PC.
Cannot open database "MyDb" requested by the login. The login failed.
Login failed for user 'MicrosoftAccount\my_ms_account'.
The account name is one of my Microsoft account names, and happens to be the one tied this PC's Windows 10. There IS NO SQL login with that name. There have been no DB structure changes. Today I've done typical CRUD operations via C# & Linq-To-SQL. And again, this just started this afternoon.
I Googled it and found this. I'm hesitant to try that fix until I know what's happening. For now, if I log off and back on it seems to fix it, but then I have to close and reopen everything.
Anyone know what this is?
If it's not broken, fix it until it is.
Everything makes sense in someone's mind.
Ya can't fix stupid.
|
|
|
|
|
Do you normally connect from an elevated process? If so, the BUILTIN\Administrators login would apply, and you wouldn't need a separate login for your account. But if you then tried to connect from a non-elevated process, you wouldn't be part of the Administrators group.
The SQL setup normally has a step where it adds the current user to the sysadmin role so that you don't have to elevate to connect. Was SQL installed by a different user, or did you prevent it from adding your user account?
Have you switched from a local account to a Microsoft account recently?
Did the restart fix it permanently, or did the problem come back?
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
