C
C#•2y ago
iavbfaun

Visual studio and SQL

ı am taking System.InvalidOperationException: 'ExecuteNonQuery: Connection property has not been initialized.' eror can you help me 😦
6 Replies
mtreit
mtreit•2y ago
You need to pass your SqlConnection object in the constructor of SqlCommand
iavbfaun
iavbfaun•2y ago
How can ı do 😦
mtreit
mtreit•2y ago
using var cmd = new SqlCommand(sql, conn); Alternately you can set the Connection property of the SqlCommand instance 
cmd.Connection = conn;
cmd.Connection = conn;
But probably easier to just pass it in the constructor.
iavbfaun
iavbfaun•2y ago
thank u ı will try ıt ❤️ ❤️ sory for my newbie. I tryd but I couldn't do what you said 😦
mtreit
mtreit•2y ago
Why not?
iavbfaun
iavbfaun•2y ago
ı solve it but thank you a lot of 🥺
Want results from more Discord servers?
Add your server
More Posts
❔ Console Application Authentication helpHello developers, I am planning to sell a console application and I am in search of a public service❔ gRPC JsonTranscoding doesnt work using .proto project referenceHello all, I am trying to add **JsonTranscoding **and **SwaggerUi **to my gRPC service. The project❔ Creating a BMI and BMR projectHey guys, I don't really understand really this project BMI and BMR.❔ Populating existing instancesI'm migrating from Newtonsoft to System.Text.Json but my model uses a property in the json to determ❔ need helperror❔ EVENT ON TEXT CHANGED```c private void txtRH_TextChanged(object sender, EventArgs e) { }``` How can i ma❔ C# forloopsis there a way i can let 2 for loops run but then switching turns kinda, For example if the first f✅ Using Dependency Injection, sharing singletons between builders?I'm not sure if I'm taking a completely off-the-wall approach to this, so please let me know if I sh❔ hook errors and unexpected }So I’m working on some code for rust as of now and it’s function so far is to spawn a crate at a pla❔ Tabbing between Entries or Editors in a gridI've got a grid with Entries, I'm trying to use the Tab key to move to the next Entry but it just fo