[microsoft:sql-server] Forum Topics

how to connect vb.net frontend with microsoft sql backend..

So I have a table that stores various prices for things. The ID is set as the primary key and doesnt allow nulls. I then have a stored procedure that takes the data entered into the form (ID) included and it works out the cost of that particular item. This …

Hi.. I have an application developed and deployed using sccm 2007. Now, we are to migrate the entire application to SCCM 2012, leading to some issues with the system database. eg : SMS_R_System in SCCM 2007 becomes VSMS_R_System for SCCM 2012. I need to map other such table changes. Can …

Hi, I'm having trouble to filter a Customer Set by the date of his first buy(First Activity). I've tried this two ways: 1. Returns all customers, even with FirstActivity Null SELECT { [Measures].[Valor Item], [Measures].[First Activity] } ON 0, { Filter( { [CLIENTE].[Cliente].[Cliente].Members }, ( [Measures].[First Activity], [Time].[Year].&[2012-01-01T00:00:00] ).Count > …

I am considering an option for users that will allow them to write their own account numbers or create their own algorythm for creating custom account numbers for customers, but also want an option that will auto-generate them if the user doesn't care by using the identity property in SQL. …

I am trying to create an application which will send a reply back once a customer (registered user) sends a a question to the system. The application will select the correct answers (based on keywords) from a database and send it back in SMS to the customer’s mobile phone. For …

I try to insert data from VB.NET form to SQL Database Table. When i press insert Button. It shows Successfully Added. But there is no data in database table. My code is given below. Private Sub BTNSAVE_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles BTNSAVE.Click CheckMyControls() If totflag = …

Hi All! So, I have a shared windows host with IIS 7 with godaddy, so that I can use MSSQL/TSQL (which, as I understand it, is not available with Linux). However, my server configuration education was with Linux, and focused on the wonderful all encompassing .htaccess file to configure environment …

I have a series of user records in the form "`Lname, Fname (ABCD)`" where `ABCD` is the division the user works in. I need to be able to extract that substring so I can sort on it, count etc to I can see what divisions are using resources. In MySQL …

hie people, could anyone tell me what's wrong with following code: Dim cmd As New SqlCommand("SELECT * FROM Security_Ques WHERE Username = " + txtUsername.Text + " and Ques_Index = " + cmbSecurity_Ques.SelectedIndex + " and Answer = " + txtSecurity_Answer.Text + "", con) because it is raising an exception …

I've written a short tutorial how to get started writing sql database applications with C#. The totorial is in PDF format so that you can download it and read at your leasure. It assumes you are using MS-Windows and Visual Studio 2012. If you are using an earlier version of …

hello, i found an interesting source that would help me extract 2007 excel file and save it to SQL server 2005 using ASP.Net but i have encountered an error and i don't know how to solve it. i used the vb file. And i got the error at this part …

hello! I got this error when I tried to connect to my db in sql server. > Unable to add data connection. Could not load file or assembly 'Microsoft.SqlServer.Management.Sdk.Sfc, Version = 10.0.0.0, Culture = neutral, PublicKeyToken = 8945dcd8080cc91' or one of its dependencies. The system cannot find the file specified. …

Hello I had a problem uploading or adding a file on the database and shows the error stated on the title. The column holding the binary data was set to varbinary(MAX). I couldn't find what was my error because I was able to upload a 900kb MS Word Document but …

Hi I have an insert statement in my VB code that updates about 20 fields in sql. I pass through todays date and a set of values. This occurs on a button click event. My problem is if the button is clicked more than once the data is duplicated in …

Hello DaniWeb, I personally work with SQL databases for web development work however I need to learn about Access databases for some upcoming AS Level exams. I asked my teacher, whether Access was vulnerable to Injection attacks and she looked at me with a quizical expression on her face so …

I am working with sql server using ADO provider. My code uses recordsets and commands to run quries and I fail to understand a basic issue - connections. In my code, they set a connection string (which is being built in the code, not taken from other ADO element) to …

select a.EID, b.ShopName, a.TxnMonth,a.TxnYear,a.TxnDate, a.TxnAmount,a.TxnDay,a.DateCreated, a.SubmissionType from [UA-DCM]..DCM_FTPDailyData as a Inner Join [UA-DCM]..MMS_ECR as b on a.EID = b.EID where a.TxnDay between DateAdd(day,DateDiff(day,0,GETDATE() - 14),0) AND DateAdd(day,DateDiff(day,0,GETDATE()),0) and a.SubmissionType = 'ECR' or a.SubmissionType = 'FTP' and b.AssetID = '71' and a.TxnAmount not like '"%' and a.EID = '7100101001' Order by …

I am currently working on a very simple project. But I am having problem with special characters. The one character which I find very annoying is ' . This single quote / aphostrophe is ruining my project while entering names like "James D'souza". Can anyone please help me in recording …

Hello people, I am new to crystal report. Normally, I would insert columns in the crystal report viewer and then look at the records at the Main Report Viewer. All the rows/records in that particular columns of that table will be shown. And then I found out about this SQL …

I have a function that reads a text file that contains information about the sql database it connects to. It has to be invoked across multiple forms. How could I make it to where it is invoked once and then stores into variables that the program can continue to use …

Hello brothers, I am currently developing Single PC application in vb.net 2008 and Mssql Express 2005. 1. what are the Software I need on development Computer? to start develop application which can run on a main Computer and also from other Computers on LAN ( simple windows xp and windows …

Hi, I've been Searching the Net for hours now, and i can't really seem to find anything clear and straight to the point. I need to create a Server/Client application using VB.net 2008, it's actually my first time to have a database on another computer. So I first searched the …

i am trying to pick a Varchar field (Question) from tblUser where email = session variable , it doesn't give error but picks -1 and shows it, why ? even that column isn't empt for the matching email code: String connectionString = "Data Source=COSANOSTRA; MultipleActiveResultSets=true; Initial Catalog=Waleed_orsfinal;Integrated Security=True"; protected void …

hi i m new to vb with sql.i made login form.but after that on main form some feature will be disbleed for ordinary user and that feature will be only enabled to admanistrater.so on main form a button will be enabled with specific password that is in backend so i …

Hi all, I am attempting to rename a file using the File System Task Editor in SSIS. In the Expression Builder, I have @[User::fileName]+(DT_WSTR,2)DATEPART("mm",GETDATE())+(DT_WSTR,4)DATEPART("yyyy",GETDATE())+".zip" but it returns the following error: > TITLE: Expression Builder >------------------------------ >Expression cannot be evaluated. >------------------------------ >ADDITIONAL INFORMATION: >The data types "DT_I4" and "DT_WSTR" are incompatible …

I was wondering if it was possible to bound 2 combo boxes to each other. the first combo box with a set of information. Based on what the user selects, the second combo box changes. this involves 2 tables. table 1 ProductID Descritption table 2 Id FK_ProductID Category example: the …

Hello all. I want to know whether it is possible to retrieve list of all tables found in a particular database titled 'Company'? It have got several tables with the names, Suppliers, Customers, etc etc. Just like Oracle, where you retrive all tables using select * from tab; . Is …

i get this error message when i try to connect from clinets pcs to login with the crystal repor but the forms is correctly connect to the DB srver but the server not this is the error : Crystal report viewer login failed detail : ADO error code: 0x80040e4d Source: …

hi I have a problem of counting number listed in my listbox my list box databinded by sql I wanna to add the whole numbers on my public string connString = "server=(local)\\SQLEXPRESS;database=PWA_RES;Integrated Security=SSPI"; public int pul; private void Form1_Load(object sender, EventArgs e) { string sql = @"select name,price from main_course …

using System.Collections.Generic; using System.Windows.Forms; namespace LandTransfer { static class Program { /// <summary> /// The main entry point for the application. /// </summary> public static int code = 0; //C:/LandTransfer/Database/ public static string database = "//192.168.1.24/LandTransfer/Database/LTMS.mdb"; public static string source = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source=" + database + ""; [STAThread] …

In my database table, 16 rows are inserted with null values for all columns. How can I delete these rows using SQL statement?

Hi, I have yet another VB question (I am a noob!). Here is my code: Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click Try Dim Equip As DataRowView = ListBox1.SelectedValue Dim Equip_Delete As String = Equip.DataView.ToString MessageBox.Show(Equip_Delete) cmd = New SqlCeCommand("DELETE FROM Sensor_Table WHERE Equipment_ID = …

Hey guys, I'm working on a job. I need sql statement for the following query: "List all Employees Names with equal ages." (If possible, along with their year of birth, or date of birth.)

i have a server called OAS-VB and a network pc what i need is the sql that installed on pc see the OAS-vb server to reach the database file ??? or some one can tell me how to configure the sql server for network to reah the pc ?? i …

Hi So i have a database in sql server 2008 and in 1 table i have information with a picture in it, i can retrieve 1 picture from the DB to display in a picturebox, wat i want to do now is read all the pictures and disply them all …

Error : SERVER TAG NOT WELL FORMED, why ? <%@ Page Language="C#" AutoEventWireup="true" CodeFile="employerView_ScrutinyMembers.aspx.cs" Inherits="employerView_ScrutinyMembers" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title>Scrutiny Members</title> </head> <body> <form id="form1" runat="server"> <div> <asp:TextBox ID="txtboxMemberName" runat="server"></asp:TextBox> <asp:Button ID="btnSearch" runat="server" Text="Search" onclick="btnSearch_Click" /> Or <asp:Button ID="btbViewall" runat="server" Text="View …

Hi, I have done my vb.net application and ready for deployment, my database is located somewhere in my drive c:, i used this code to get connection string from app.config Public Sub main() constr = System.Configuration.ConfigurationManager.ConnectionStrings("WindowsApplication7.My.MySettings.nameConnectionString").ToString Con = New SqlConnection(constr) Try Con.Open() 'MsgBox("Server Connection is Open ! ") 'frmMain.Connection.Text = …

I am totally new to vb.net, still I am planning to try it for a project, in which there will be standalone machine using an access database to query and update different tables. While in VB6 I was able to define recordsets using Microsoft.jet.oledb.4.0, in VB.net I have become a …

Hey guys! Im having a little problem with my datetimepicker!Im making a personal payroll system,where I want to add employee's daily hours!for example: Employee name:Marcus Veron IdPayroll:032012 Date|Hours --------------------- 19/07/2012 | 8 20/07/2012 | 8 21/07/2012 | 7 Well im having problem quering the date field...cause in my datetimepicker i …

I have a table with these columns: stockNumber, storageID, lastPutDate, qtyOnHand Each stockNumber can have multiple storageID's but only one lastPutDate and qtyOnHand for each storageID. Here is an example of what the rows might look like: stockNumber storageID lastPutDate qtyOnHand ----------- --------- ----------- --------- 100505 R010101 2012-10-18 150.00 100505 …

I am getting below Error “Update requires a valid InsertCommand when passed DataRow collection with new rows.” **Below is the code in Module** Module ModDBConnection Public CnCommon As New SqlConnection Public DTCodeMaster As New DataTable Public DACodeMaster As New SqlDataAdapter Public CBCodeMaster As New SqlCommandBuilder Public Sub CommonCn() CnCommon = …

hi all, i am creating a form in which when a particular command button is clicked, it will open another form with a flex grid. Based on the row selection the user makes on the flex the first form will be filled with datas retrieved from sql database. i can …

Hi everyone! I have trouble putting together a chart with the contents of a data table that is basically as sex, marital status, age, and DATE . Im working with a bar chart or column chart, but I can't make it work like I want. What im looking for is …

How can I specify the Server of my database when I make my project executable I have this module I call everytime i modify my database Public Sub main() constr = "Data Source=.\SQLEXPRESS;AttachDbFilename=C:"database file".mdf;" & _ "Integrated Security=True;Connect Timeout=30;User Instance=True" Con = New SqlConnection(constr) Try Con.Open() 'MsgBox("Server Connection is Open …

Hi all, This is something I should know but for some reason the answer is eluding me. In a SSIS Script Task Editor, I am trying to set a package String variable called ReNameFile with the following VB.NET line using DateParts for month and year: Dts.Variables("User::ReNameFile").Value = Dts.Variables("User::fileName").Value.ToString + DatePart(DateInterval.Month, …

Hi Does anyone here can show me how to make an application that is like an odbc wizard that could register a sql server type connection? I have found one on the net through searching but it does not accept the UID and password of the sql server. I also …

Hey People :) A little quesion for you all ... I have a stored procedure which retrieves an ID from a Customer table and the ID from the newly Inserted row of the Vehicle table and adds them to a new table. On my form I have a dropDown where …

Dear All! I want to get my columns value into rows . i am taking sum of qty of each month . like this select sum(Case when month(invoicedate) = 1 then qty else 0 end) as janQty, sum(Case when month(invoicedate) = 1 then qty else 0 end) as febQty, sum(Case …

Hi, I'm new in VB.NET and I'm having trouble with creating a **public sqlconnection** in a VB Module. I have declared **conn** as public sqlconnection but when I use it to the other forms its value is equal to "**nothing**". I hope you can enlighten me here. thanks in advance. …