[microsoft:sql-server] Forum Topics

Hi, i have windows application , in that i have reference to the web service. Now when i put username and password , application calls to authentication service ( which is hosted on same machine IIS 7.5 ) i get pop up which is asking for Proxy Authentication. can anyone …

Id like to know as to how to go about creating a web service that validates a registerd user to my site. Also how to register a new user to the site. What steps shall i take in order to do this? Im using Visual Studio 2008 (.NET Framework 3.5) …

Hi, I'm using update statistics command to analyze a table and would like to know later when this table was analyzed. I saw that in the user_tables table the num_rows coulmn was changed but the last_analyzed coulmn was not changed. Does anyone know if last_analyzed coulmn should be changed and …

I am doing small vbproject that must auto generate id using the current year/month/autonumber in vb.net-(VISUAL STUDIO 2010) with MS SQL database. When the form load the autonumber should be displayed in text. And when it save, it should be saved in the database MSSQL. The id number should be …

Hi What is wrong in my this backup code it always not working and gives me an error SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB; AttachDbFilename=D:\repos\mysales\WindowsFormsApp4\Database1.mdf; Integrated Security=True; "); string database = con.Database.ToString(); if (textBox1.Text == "") { MessageBox.Show("Please Enter Backup File Location"); } else { string cmd = "BACKUP DATABASE …

Resolution of error "Run-time error '3709'" at make-table from sql select statement

Hi, My Crystal Report is using VB.NET and Sql server 2005. The report can be displayed but everytime it will prompt me to key in the Username n Password.. is there anyway to automatically pass the login information to reports? thanks =)

Hello all I've been using it for years SQL SERVER 2014 Standard and language VB6 programming, but only this time get the following error: Run-time error '-2147467259 (80004005)': [DBNETLIB][ConnectionWrite (WrapperWrite().]General network error Has any of you guys ever experienced this?? what is this caused by?? thanks for the enlightenment Regards,

HELLO ALL ! I am new here and a Lerner,beginner. I need help from you all great mind in my project that i have a datatable dt. i retrieve data from sql to a data table named dt in vb.net. now i want to write result in notepad where user …

I'm a web developer in asp.net VB and PHP on Windows Server IIS. I use css3, html5 and Sql Server and Access for Database. In my project entire graphic are designed from me and Corel DraW

An equipment company wishes to create a database to support the hiring of tools and machinery to clients. The company has three types of equipment: power tools, such as drills and vacuum cleaners, plants such as excavators and scaffolding. Each piece of equipment is identified by a number. Power tools …

My code is this. Dim strSQL As String, strSQL2 As String Dim db As Connection, rst As ADODB.Recordset Set db = New Connection db.CursorLocation = adUseClient db.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=C:\River Syde RMS\RiverSyde.mdb;" strSQL = "SHAPE {SELECT * FROM Sales where Date1=#" & DTPicker3.Value & "#" Set rst = New ADODB.Recordset If …

I have a html table, Item_Table, with dynamically added rows containing input tags. i have to add the data from Item_Table to the database in Sql Server, so i am using javascript and C# MVC for the process. But i am getting an error saying "System.NullReferenceException: 'Object reference not set …

I need to get a set of results from the db (server) but at times I would get the same result back and I would like to cache the result instead of making the same call to the db. Any ideas?

The term SQL stands for Structured Query Language, it's a programming language that's used to update and communicate with the database. SQL skills are indispensable and are in demand as with the boost in technology, data is piling up. And, In today's world this data has become a necessity for …

Hello. I am creating a column chart in Visual Studio 2022 writing in Visual Basic. The Sql table has a percentage field that is the YValueMember on the chart, ie; 1.2, 2.7, 8.9 ect.. The problem is the YValueMember display only displays with a decimal point on one of the …

I want to insert the deleted data into another table (Like table history) in sql server database using visual basic 2008 by scanning QR Code data. What I have done in my source code program is like this; Private Sub btnDel_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDel.Click …

Can any one post a sample program to show how create a multi table report in vb6 back end sql server 2008 r2 run on WIN7

I work on `sql server 2017` I run script depend on `python language v 3.10` . I need to export data to excel fileStudentExport.xlsx already exist, and keep header without change after export. header of excel file StudentExport.xlsx before export data to it as below `StudentId,StudentName` after run script query …

**There are 2 tables as orders$ and 'order items$'** orders$ Table have 4 columns as order_id, customer_id, status, order_date 'order items&' Table have 4 columns as order_id, item_id, product_id, quantity I want to modify the SQL statement to show an average number of products each customer had on their orders. …

xamarin form to connect sql server Database

how to barcode scanner in xamarin.form and connect sql server DataBase

I want to scanner barcode in Xamarin.Form and bacode result go to sql server database

i have below stuff an i write each result in excel sheet . i have an issue to write in excel sheet of each sql result drop table #table_Northwind create table #table_Northwind ( RowID int not null identity(1,1) primary key, column_name varchar(50) ) insert into #table_Northwind (column_name) (SELECT TABLE_NAME FROM …

Hello. I am trying to check if a table definition (the default value on a constraint) is equal to UTC Time by using the following query: IF NOT EXISTS((SELECT object_definition(default_object_id) AS definition FROM sys.columns WHERE name = 'ModifiedDate' AND object_id = object_id('dbo.WorkflowAudit')) == GETUTCDATE()) However, you can not compare a …

Hi all. i have a trouble of my testing project. could anyone can guide me to solve the problem. million thanks~~ newbie of programming. error : System.Data.SqlClient.SqlException: 'Incorrect syntax near 'card'.' string connectionstring = ConfigurationManager.ConnectionStrings["library2ConnectionString"].ConnectionString; SqlConnection con = new SqlConnection(connectionstring); con.Open(); string sql = "Select librarycardid, password" + "from library …

Where is the SQL Server Database Trigger Wizard or Dialog Box? This question is about SQL Server In the past, I have created a stored procedure that was run on a timely basis by (if I remember correctly) a database trigger. As I recall, there was a wizard (dialog box …

I want to be able to write an SQL statement that pulls the sum of revenue and expenditure for each day and gets net income for each day with the distinct dates available in the Income and Expenditure tables. I have tried the following statement, but I'm not getting the …

Hello I have VB.NET System ; I wanna to make setup (.exe) for the program. The Program depend on SQL Server Database. How I can make it exe file with the database, and to install all the configuration on any PC. What I shall do according to the connection string …

I do not have much experience in programming and I am about to start my preparations for the MCSD. NET certifications. The training provider companies’ give a pass guarantee, but I am confused which one should I opt for. Can anyone has experience with these training products. Please help me.

Create a table with following rules and regulations ma 1)Id should b identity 2)Name should allow only starting Letter with a to p 3)city should not allow Chennai,cbe, Salem 4) department should allo only cse,it,ece, 5) college default should b anna university 6) per should above only 70% 7) year …

How can I save the registration data after connecting to the database (an empty table is created for me)? I do this in Blazor (C #). User.cs: [Table("Users")] public class User { [Display(AutoGenerateField = false)] public int UserId { get; set; } [Display(Name = "UserName")] [Required(ErrorMessage = "UserName is required.")] …

In my workplace, we have an intranet website developed internally that we use for CRM. The data of our clients are shown there (MS SQL server is used as a backend to store data). The site has a limited search functionality at the moment (it'll try to match the text …

Please am new here and I need you guys help am trying to save a fingerprint template into my database (Sql server) but is not working, this is my code Dim fingerprint as Memory stream = new MemoryStream Template.serializ(fingerprint) fingerprint.position=0 Dim be as BinaryReader = new BinaryReader (fingerprint) Dim bytes() …

I have three tables: First table is 'user': user_id | Name | ---------------------- 1234354 | Abu Bakar | 2543353 | Ali | 3342342 | Aliza | 4234243 | Ali | 5234324 | Mike | Second table is 'meeting': meeting_id | meeting_name | meeting_startDate | meeting_endDate | room_name | ---------------------------------------------------------------------------------- 1 …

Please I have a problem in vb.net. The problem is this, I have a combobox, cboSearchBy, with four column names (FileNo, Lessee, Location and TFNo). I need a code that when i select any of the four items in the combox then the data under that column in the sql …

Ci-après le code : <?php $query = "SELECT ownerID,ownername,ownerbureau, is_deleted FROM notes.owner WHERE is_deleted = 0 AND ownername IS NOT NULL ORDER BY ownername,ownerbureau"; // Prépare une requête à l'exécution et retourne un objet $stmt = $pdo->prepare($query); // Exécute une requête préparée $stmt->execute(); $previousGroup =""; $first_group = true; ?> <select …

I want connect microsoft sql server database using servername,username,password,port number and service name to asp.net api 2019. This code segment I'm using SqlConnection con = new SqlConnection(@"server=10.d.13.2q0; database=sdssdsd; Integrated Security=False; User ID=lmgdgdfdfddgs; Password=sdsdsdsds"); please help me. what is the correct code

Hey , I am a begginer in vb.net and I want to retrieve my data from access database as well as manipulate indivial record according to my choice..Can you help me with this Thanks & Regards

Private Sub delete_Click(sender As System.Object, e As System.EventArgs) Handles delete.Click Try Dim con As New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=D:\JENNY PROJECT\JENNYFER\SMS project\SMS project\Database1.mdf;Integrated Security=True;User Instance=True") con.Open() Dim query As String query = "delete from course_tabl where c_name='" + ComboBox1.Text + "'" cmd = New SqlCommand(query, con) dr = cmd.ExecuteReader MessageBox.Show("Do you really want …

HOW I CREATE BARCODE AND REPORT VIEW WITH CRYSTAL REPORT 8.5 ,I AM USING VISUAL BASIC 6,MSSQL SERVER 2008,CRYSTAL REPORT 8.5

Hello guys, I just want to ask for some help with my program I'm a beginner and new here This my code : Under ButtonAdd Dim adapter 2 as New SqlDataAdapter (SELECT 'AddOnNo', 'AddOnName' , 'Price' FROM Table1 WHERE AddOnNo = " & ComboBox1.SelectedValue,con) adapter2. Fill(table) txtAddOnName.text = table (0)(1) …

Hi group, It's been some time since I last posted. It's good to be involved in programming again. It's been much too long. It's been a while since I've written code that would write to a SQL database. It seems like the connection string is correct. However I'm getting a …

Hello .. i have created an asp net web app (.Net FrameWork ) website local "which has connection with my local sql database " on my device and i want some other client to work on it remotly ... i have tried to get IIS but faced different some problems …

I am very new to VB.NET. That said, I have developed a windows form that utilizes an SQL Server back end. I am developing using Visual Studio 2008 and the 3.5 Framework. The SQL server is 2005. I do not have any warnings or errors, and the project compiles without …

I have a project where I need users to be able to save their work, then at a later date select the session/data from their previous work and continue. I have completed all of the coding (and it works) to save the current session under their userid, and populates a …

Please Provide me the sub Query for the below table that the rows must be unique and make sum of it. This is the SQL QUERY THAT I AM USING SELECT Admission_Fee.srno, Stu_Data.clsname, Sum(Stu_Data.adm_fee) AS Gross, Sum(Stu_Data.Final_adm) AS Final, Sum(Balance.Admission) AS Paid FROM ((Stu_Info INNER JOIN Stu_Data ON Stu_Info.Regdno = …

I have a fillin form , which has a submit button. In order to get to the fillin form, the user has already been authenticated and a session has been created, and variables have been added to the session. In order to process the information, I have another 'insUpSel.php' file …

Hello all! I have an excel file that looks like this: Time of Day Lap Lap Tm Speed 14 - Stoicescu Dan - Regularitate Coupe 9:40:50.835 1 2:47.462 88.763 9:43:37.584 2 2:46.749 89.142 9:46:33.319 3 2:55.735 84.584 9:49:58.901 4 3:25.582 72.304 9:53:13.988 5 3:15.087 76.194 9:55:50.639 6 2:36.651 94.889 9:58:49.884 …