[microsoft:sql-server] Forum Topics

How can i connect vb.net to sql server

I need to add un hour to my date, how can i do??? This my code CASE WHEN candidat_rendezvous_date IS NOT NULL THEN 'candidat_rendezvous_date + 1Hour' END Thanks for your help

Hi i have a problem in binding DateTimePicker value from one form named SearchDoctor to existing form named Doctor. Here is the code of my Doctor form and it works: using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Windows.Forms; using System.Data.Sql; …

I am new to VB, and have attempted to load all the free versions of the SQL available. Dispite many go's I still can not make any work. I go through the motions of including a database into my programs but I keep geting a long delay then "Unable to …

Greetings, i'm having a problem on inserting all my items from listview to my database using stored procedure. heres my code. Dim lvItem As ListViewItem For Each lvItem In ListView1.Items With dbComm .AddParameter("@details", lvItem.Text, SqlDbType.VarChar) .ExecuteStoredProcedure("insertRecord") If .Success = False Then MsgBox("Record failed to save.") Else MsgBox("Record Saved.") End If …

While browsing [this thread](http://www.daniweb.com/software-development/vbnet/threads/472112/increment-or-loop-how-help-me-good-sirs) I noticed that the code was unformatted. Mr. Waddell is well aware of how to format code so I was surprised. When I went to edit the code, however, I saw that it **was** formatted correctly. Here is a section of the code as originally entered …

i now able to save the fingerprint directly to database using this code... Dim fingerprintData As MemoryStream = New MemoryStream Template.Serialize(fingerprintData) fingerprintData.Position = 0 Dim br As BinaryReader = New BinaryReader(fingerprintData) Dim bytes() As Byte = br.ReadBytes(CType(fingerprintData.Length, Int32)) Dim cn As SqlConnection = New SqlConnection("Data Source=.\SQLEXPRESS;Initial Catalog=dataBEST;Integrated Security=True;Pooling=False") Dim cmd …

Hi my name is vishal. For the past 1 week i been in the process of creating a dashboard using listview in c# windows forms with sql server 2008. I created listview named lstDashItems and populate it from a table named USERACTIVITIES in sql server 2008. The design of USERACTIVITIES …

I have a project that must have centralization of databases that will have access to the web on a PHP script. I can merge MSSQL and MySQL databases if and only if they were both: 1.) On a same server or 2.) Of the same server type The problem is …

Hi I've run this code and i get no errors but my form data is not saved on the dataset or database. This is the click event code. [code] Dim conn As New SqlConnection("Data Source=.\SQLEXPRESS; AttachDbFilename=|DataDictionary|\TMSDB.mdf;Integrated Security=True Instance=True") Dim ds As New DataSet conn.Open() Dim Adp As New SqlDataAdapter("select * …

Hi, I've a webform that has five fields,, the first four fields has textboxes and the fifth one is a checkbox list. All the data of textboxes has to be saved in a table tbl_Workshop. the checkbox list has list of trainers, a user can select for that particular wokrshop.. …

Greetings, can someone please give me an idea on how to make a stored procedure with foreign key. Here's what i want to happen. 1) I have 1 button for Adding patient. 2) On the add patient button, i want to Add the patient information on the tblPatient and insert …

Sir i am new to webservices and my scenario is that i want to display records from database against email and password. but when i debug webservices i recieved error. Here is my code [WebMethod] public bool CheckLogin(string Email, string Password) { return getEmail(Email, Password); } public bool getEmail(String Email, …

Hi Experts, I have to Pad some numbers that have decimal points and I have done it successfully as follows: SELECT case when len(myValue)=1 then RIGHT('000' + CAST(CAST(myValue AS float) AS VARCHAR(5)), 2) when len(myValue)=2 then RIGHT('000' + CAST(CAST(myValue AS float) AS VARCHAR(4)), 2) when len(myValue)=3 then RIGHT('000' + CAST(CAST(myValue …

i have wrote query to calculate TOTAL WORK TIME and Overtime of an employee based on Intime and outTime but can't figure out to put another column 'IsAbsent'. e.g. if person doesn't come on any specific date than his INtime and TimeOut would be empty then if both are empty …

I make many to many relationship in erd diagram in sql server 2005 between ca and driver as following car table driver table car_driver table. I need to make fleet management program. When I make forms in windows form are i make car form driver form car_driver form When i …

How to dynamically add div in asp web page ?ie, if mssql server returned n rows from a query, i must place all these n rows in seperate div which has to be created dynamically.!!pls help (d case is when displaying search results in a web page like shopping sites)

Background: My store procedure 'GetAtdRecord_Sp' to optionally accept parameter 'EmplID' otherwise default value is null. It works in SQl server management studio even if i provide no value as i wanted to do. exec GetAtdRecord_Sp // This works exec GetAtdRecord_Sp 23 // This works too with value. Problem: But when …

Hi Friend I am trying to connect my MSSql server 2008 R2 server using php. I am getting an error as below `Fatal error: Call to undefined function sqlsrv_connect() in C:\xampp\htdocs\test\connect.php on line 4` and the code is below <?php $serverName = "servername\sqlexpress"; //serverName\instanceName $connectionInfo = array( "Database"=>"dbname", "UID"=>"us", "PWD"=>"ps"); …

i am given task to analyze and modify pre written large queries within small time, so please help me understanding it with times as ( SELECT t1.EmplID , t3.EmplName , min(t1.RecTime) AS InTime , max(t2.RecTime) AS [TimeOut] , t1.RecDate AS [DateVisited] FROM AtdRecord t1 INNER JOIN AtdRecord t2 ON t1.EmplID …

Hello all, I seek assistance in this challenges I have at the moment. I have an application that currently connect to a SQL Database well on my PC and sure it will do same if I deploy it to a PC that has SQL server install on it. Now I …

i've been working on a program and i want it to be accessed by multiple users. so i have an admin account and an other users account what i want to do is for the other users to be able to access the program and its database from another computer …

If someone can provide a link with the use of Parameters instead of concatenation

Guys, I want to make a purchase list of buyers example : buyers buy 3 products in 1 Purchase Order. what tools I use in C #? What data types used in SQL SERVER database?

i need to generate for example the January month from 1-1-2014 till 30-1-2014 in sql database using visual basic 2010 so the table will be like that Date Day Employename 1-1-2014 Wednesday elie 2-1-2014 Thursday elie 3-1-2014 Friday elie , , , , , , , , , , , …

Hi All, I am creating a Windows Application. I am maintaining LibraryBooks details. When I click on the Details all the books available(as stored in SQL SERVER Database) is been displayed in the DataGridView. But the datagridview also contains a empty row at the end which it generates automatically. But …

please help me in this,how would i do some recursive statement in my stored procedure. here is what i want -- @requestcode will genereate some random string set @requestcode = (SELECT substring(@username,0,3)+'-'+SUBSTRING(CONVERT(varchar(255), NEWID()), 0, 9)) -- then i want to check if the string generated is existing to 'sampletable' select …

i'm building a data base.. heres what i did: 1 - create the forms and put the controls; 2 - create the Service-base DataBase(add New Item); 3 - a toolbox, on left, is showed and then i create a new table; 4 - using the mouse right button, i select(on …

sir i am using VB6.0 POS software, i want to know the source code of the software. Regards! Khawar

@ by : O This is topic (http://www.codeproject.com/Articles/21351/Import-Data-to-SQL-Server-from-Excel-or-Access-usi) is reactivated again which was posted by : Oxiegen for further information: The code is corrected but the data is not getting exported from Access database to SQL. The code is as follows : Private Sub Button1_Click(ByVal sender As System.Object, ByVal e …

Hi! I was created a asp.net 4.0 web applcation with sql server 2012. In this application more than 300 users can request their leave, Permission to their Team leaders. Team Leaders respond their requests. And i installed a windows service that will calculate the attendance of 300 users. I installed …

Hi Guys I have a similer code which works on button click event and not working while Accessing data through data reader ?what would be the mistake ? thanks regards sumith ---Database Part private void PopScheduleByID() { using (SqlConnection con = new SqlConnection(CS)) { SqlCommand cmd = new SqlCommand("select* from …

Hi, I kind of hit a bump in the road with SQL and C#. I am sending information through to a stored proc like: SqlCommand TestCaseManager = new SqlCommand("TestCaseManager", thisConnection); TestCaseManager.CommandType = CommandType.StoredProcedure; TestCaseManager.Parameters.Add(new SqlParameter("@TestCaseName", TestCaseName)); if (c.Controls[2].Text.Equals(string.Empty)) {TestCaseManager.Parameters.Add(new SqlParameter("@Steps", DBNull.Value));} else {TestCaseManager.Parameters.Add(new SqlParameter("@Steps", c.Controls[2].Text));} if (UnitTester.GroupBoxCreator.SomeClass.PictureLocation.Count.Equals(0)) {TestCaseManager.Parameters.Add(new SqlParameter("@Img", DBNull.Value));} …

I have following quary example. SELECT t1.TeamID, MemberList = substring((SELECT ( ', ' + FirstName ) FROM TeamInfo t2 WHERE t1.TeamID = t2.TeamID ORDER BY TeamID, FirstName FOR XML PATH( '' ) ), 3, 1000 )FROM TeamInfo t1 GROUP BY TeamID Its giving error "Incorrect syntax near the keyword 'FOR'." …

Hi there i want to know whats the difference b/w databanks like sql and our own text structure txt file that could easily store data even with less size than databanks. Of course i now sql is faster secure and much more but i can encrypt my data too and …

Hey Experts >>>>> Please help me out .... i want this type of grid to be generated horizontally ... but unfortunately in asp.net gridview is not showing horizontal options ..... another interesting fact is that all the products shown in this page is UNIQUE ... and Pagination is also included …

hy i m trying to do a smal vb.net project using sql server 2008 in vs2012,and i dont know how to use those database in my project for eg : using select/insert/update/delete queriesfor my controls(textbox,combobox datagrids etc..) please help me with detail how to connect database and use it in …

Hi I want to do a silent install of sql express 2008 (free edition) In my configuration file, how can I set the default language to British English and date format to "dd/MM/yyyy". Thanks for your help SQL Newbie

Guys, please suggest me, how can I set up an audit on SQL server 2008 if I need to track who, when, what and from where changed something on a database table?

Hi, I am new to asp.net. Now i want to create a login page for the current website for the employees. And the below are the details. 1. I need to create a login page for my current website(that includes aspx pages and html pages). 2. Around 800 pages of …

I made a report in VB6 program using crystal report. Here I've made a connection between crystal reports, This is my coding CR_Summary.ReportFileName = "E: \ Report \ payments1.rpt" CR_Summary.Connect = "& OpenDB &" CR_Summary.WindowState = crptMaximized CR_Summary.ReplaceSelectionFormula "iCHECK_PAYMENT.PAYMENT_TYPE {} ​​= '" & C_Payment.Text & "'" CR_Summary.Action = 1 My …

Hi Experts my excel data is copied successfully to the listview. But on importing to database, I get this error. InvalidArgument=Value of '5' is not valid for 'index' ParameterName:Index ================= I have 2 problems ================= Problem 1: What should be the problem when I importing from listview(I think it is …

I have earlier created the databases in the sql management studio. but a friend of mine said it would be possible to dreate the tables directly in visual studio and update to the database. I have tried to do it but I can't seem to make the tableadapters etc. because …

Hi Guys I have a "StudentNames" column in an sql table. Each student in the table has atleast two names all in one column. Assume that the following as studentNames. StudentNames ------------- John Smith Joseph Smitter Johan Smittin How can I use the LIKE statement to select students with same …

I receive this error  when I have this code: Private Sub EditUsers() Try Dim dt As New DataTable dt = ExecuteQuery("UPDATE tblUsers SET UserID = " & txtUserID.Text & ", UserName = '" & txtPassword.Text & "', Password = " & txtPassword.Text & ", LastName = '" & …

Hi I would like to insert a record from a CSV file into 2 tables, but it's line by line instead of conventional CSV separated. I am using c# and MSSQL. My data is like this and its about 70 lines, they will be always in the same order : …