Please help me to add paramaters in this queryToDB SqlCommand this is the code cons = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString); cons.Open(); SqlCommand queryToDB = new SqlCommand("INSERT INTO [dbo].[FileUploadDBs] values (@Name, @Path, @Blasted, @CreatedBy, @CreatedDate)", cons); //param.ParameterName "@Name"; //param.Value = prefix + extension;…
I have created and am running SQL Server on Docker (on Mac). I am able to connect to it on Azure. I was able to run dotnet ef database update and the database appears in azure. However, when I run…
I have created a class, in which I am trying to pass query and return the data in a DataTable, but I am unable to pass a parameter to the SqlCommand. My attempt: OpenSqlConnection(); SqlCommand sqlCommand = new SqlCommand(inputQuery, sqlConnection);…
I am storing STARTTIME and ENDTIME in a SQL Server table by using ASP.NET webform. timeTableID startTimeVal endTimeVal ------------------------------------------------- 1 07:30:00.0000000 08:00:00.0000000 2 08:00:00.0000000 08:30:00.0000000 3 08:15:00.0000000 08:25:00.0000000 Now, as you can see in the row with timeTableID = 2,…
I have a SQL Server table that has approximately 2 million rows. Let's say the table is called Students. If I query a database from SQL Server Management Studio: SELECT * FROM Students At the same time, the currently loaded…
If user puts any username or password from the database it logs in. It doesn't crossmatch between the index of them. I'm working on this as a beginner learner. if(txtusername.Text != null && txtpassword.Text != string.Empty) { sql = string.Format(@"…
There are 3 tables in SQL Server with large amount of data, each table contains about 100000 rows. There is one SQL to fetch rows from the three tables. Its performance is very bad. WITH t1 AS ( SELECT LeadId,…
I am trying to send values to a stored procedure via a listbox containing country names I get them from the database. If I choose one option code works 100% 100%. But if I put 2 or 3 options, I…
I tried to make a message board. After someone leave message, manager can check message context can be show for others or not. I use gridView to connect to my SQL Server data, and there is a checkbox in the…
private int getuserid(String username){ SqlConnection con = new SqlConnection(_conString); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "SELECT USER_ID from tblUser where USERNAME ='" +username+"'"; int locid = Convert.ToInt32(cmd.CommandText); return locid; } Hi everyone, do you have an…