[microsoft:sql-server] Forum Topics

hi guys... i am working on the project in vb.net in visual studio... my computer's name is homesys(Computer name as shown in MY Computer Properties).... when i try to make crystal report using sql server 2008 database... which i made it in visual studio itself, i am unable to get …

I have data already populated in a datagrid I have three textbox txtCustomername, txtPartcode, txtinvo I want the user to be able to input text into the txtcustomername text box which will result in the datagrid only showing the rows that relate to that customer. Then I want the user …

Below is the code I am using: Dim safe10_comp As Integer Dim ref_date As Date Dim dr As DataRow Dim dt As DataTable = New DataTable() Dim da As OleDb.OleDbDataAdapter = New OleDbDataAdapter() Dim Conn As OleDbConnection = New OleDbConnection(System.Configuration.ConfigurationManager.ConnectionStrings("ConnectionString2").ConnectionString) Dim sql As String = "with a as (select t.employee_number, …

i want to do are the ff: * Loop through the Rows in the Datatable using Foreach or For * Compare every row data with the textbox value. * Once the value is matched or exists then break the loop & view a message. . and i want view message …

Hi Everyone, Can anyone guide what is EXEC sp_cycle_errorlog? Is it safe to just manually delete the ERRORLOG in the C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG folder? This ERRORLOG is consuming too much space that is using up c drive. Can any advice? Thank you!

Hello. I meed some help with this. I am trying to delete a record from database(SQL Server) Am i missing something? Private Sub cmdDelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdDelete.Click _DataSet.Tables(0).Rows(CInt(txtCurrent.Text) - 1).Delete() ' tho, it can remove the deleted rows ' we cannot call the DataSet.AcceptChanges …

Hi All Daniweb PHP Group, I have a big favor to ask (well for me this is big lol). I have 3 databases first (LOCAL),(AIMIS),(ERM). Here's the table (namely account_manager) of LOCAL.  and Here's the table (namely customer_call) of AIMIS.  and Here's the table (namely quotations_header) …

Hi Anyone can explain whats means with this vulnerability(Blind SQL Injection) and explain Attack details 1 and 2? 1. This vulnerability affects /xxxx/. Discovered by: Scripting (Blind_Sql_Injection.script). Attack details Path Fragment (suffix .html) input - was set to -1' or 61 = '59 2. This vulnerability affects /xxxx/. Discovered by: …

protected void btndel_Click(object sender, EventArgs e) { SqlConnection con123 = new SqlConnection(); con123.ConnectionString = @"Data Source=viral\sqlexpress;Initial Catalog=mydata23;Integrated Security=True"; string qu1 = "delete from table_1 where (username='" + txtuser.Text + "', password='" + Txtpass.Text + "')"; SqlCommand dsa = new SqlCommand(qu1, con123); con123.Open(); dsa.ExecuteNonQuery(); con123.Close(); Response.Write("deleted"); } SqlConnection con123 = new …

dear all i have tables(aztrd) it conatis invoice deatils like itm_code , date,loc_cd ..... ect - in each in invoice they are itmes (itm_cd) from loc_cd "1" or loc_cd "2" and some invocies has items from loc_cd "1" only or loc_cd "2" only i try this query to get only …

i need database for english words and their meanings so i can create an application for English Dictionary. do you have any database for such requirments ? if you don't have then you can recommend me a link where i can find it . I think that's the important part …

using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data.SqlClient; namespace Practical1 { public partial class Exercise1 : System.Web.UI.Page { string cs = Global.CS; protected void Page_Load(object sender, EventArgs e) { } protected void btnSubmit_Click(object sender, EventArgs e) { if (Page.IsValid) { string user = txtUser.Text; …

hello every one,,,ihave no experience in c# and iam designing a c# app that insert,update,delete and select data from and into remote database using sql server 2008,so i want some tutorials about c# connection with sql server please help me and thank you.....

hi friends....... i am doing a project in c#....... i need a urgent help...... i want to store all kinds of file(.doc,excel,bmp) in sql server 2008 in a single button click......the number of files to save depends upon the user...so i dont know how to create taable fr this and …

Private Sub Button11_Click(sender As Object, e As EventArgs) Handles Button11.Click Dim sqlquery As String = "INSERT INTO firstfloor_house_rent (datee,amt) VALUES ('" & DateTimePicker8.Text & "', " & TextBox24.Text & ")" Dim sqlcommand As New OleDbCommand With sqlcommand .CommandText = sqlquery .Connection = conn End With ans = sqlcommand.ExecuteNonQuery() If (ans …

yes. my coding as follows Public Function connectDB() connStr = "Data source =KIRAN;Initial Catalog=eStaffMgm;Integrated Security=SSPI;User Id=**;Password=*******" connSQL = New SqlConnection(connStr) Return connSQL End Function My system name is Kiran and the database name is eStaffMgm The default instance of SQL Server 2012 is MSSQLSERVER The code in the module was …

My computer name is Kiran and i installed VB 2013 and SQL server 2012. but when i connection to Database is not working. can i have way to connec

Having problem with looging in my server. Before it runs smoothly. While learning this system, I came accross the idea of exploring the contents of Microsoft SQL Server in Program Files. I found some exe files inside and tried to run them with the curiosity of what are those for, …

Hello, I would need some help/hints/tips for installing MSSQL server 2008 on a Windows Server 2003. Details: I want to work with virtual machines. My computer is an old one, not able to virtualize x64 machines. That's why I use Win server 2003 32 bit with MSSQL server 2008 R2. …

Hello! Why when I try to save a null value from textbox at sql server 0 is saved? The field type is number. I use an insert query to do that thanx in advance

Hi, I am selecting value from one combobox and want to use its value to update the second combobox. but the error is that the second combobox is not showing any value. plz help me. namespace ShopSoftware { public partial class frmSelling : Form { public frmSelling() { InitializeComponent(); } …

how to can i insert data in another table without using wizard dataset and i have a variable that date and time that can be used on date time picker please help can anyone simplyfy the code?

I am trying to create stored procedure which will insert one row in the first table and identity of inserted row in other two tables. For some reason I am receiving error "Procedure or function expects parameter '@id', which was not supplied.". My code is as follows: ALTER PROCEDURE InsertProf …

I really am trying to figure this out but just cannot get it right. I have 2 tables, "tblSalesMain" and "tblRepMain". I am trying to return to a combobox a reps first and last name instead of an "ID". For example, when a sale is selected it will show all …

can anyone help me in this problem? i have to put sql server data in my combobox on my form, i watch several tutorial in youtube and read here some other codes but i still don't how to. please can anyone help me? Using combocon As New SqlConnection("Data Source=NSSISQLSERVER;Initial Catalog=NSSIDB;Persist …

Hi All, I have a problem with my Microsoft SQL Server. When I execute my queries, it did not appear. The screen says, "Save Result as". I already unchecked the "Prevent saving from changes...." from >>Tools>>Options>>Designers>>Tables and Database Designers but it keeps in appearing. Please help! Thanks in advance :)

Hi Just asking for a better solution for my approach in getting sql result with different multiple conditions based on comboboxes. I have a 4 comboboxes, for Branch, Type, Status and other info. User can select conditions from this comboboxes. The default value is "All", meaning no specific condition at …

I am currently working on a project that involves saving a picture to a sql database. I have done quite a bit of research on this and have found a lot of useful stuff but nothing where I can actually develop some code from. Simply put, it is a datagridview …

Hi, Am new in VB.Net.I want to know how to call for data from SQL server usin code. Thanks

Hi friends, I am having a doubt in insertion of data create table table1(name varchar(10)) In this table, when i insert the following record manually, it produces me an error that it cannot insert. insert into table1 values('asdfghjklqwe') But when I try to insert it with the procedure, it trims …

Hi, Im having a hard time figuring this maybe a simple query. This is my first time to use sql compact edition. How can I query a select statement inside a select statement which tables are not related at all. What i need to accomplish is to insert a logo …

Hi I have an issue to update data between two table. I want to update data from one table to another using Store procedure. My code is SELECT NoMonth,ACC_P,StartDate FROM dbo.tbl_Accural_Basic UPDATE WEB_tbl_Accural_Audit SET NoMonth=nomonth,ACC_P=ACC_P, StartDate=Startdate But Nothing happend. It will show the data in select command Pls help me …

Hi all, i am passing comma separated values to my stored procedure. something like below: @id=1,2,3,4 @firstname='a','b','c','d' now if i write select statement then i want single data from @id and @firstname. something like below: id firstname 1 a 2 b 3 c 4 d thanks

Hi, I need data table desgin for transaction table. I want transaction history for particular client having unique client_id but many having many transaction id's. transactions relate to credit, debit, transactor name and date. Regards Kaustubh

Hi Everyone, Thank you for the time you spend to look at the post. I am required to retrieve report based on a date field in the table. the date field filtering must be from the previous month of the 6th till this month of the 5th. For example, today …

I have this problem, I have a SQL code working perfectly on SQL Query windows... SELECT ID_no, nom_navire, date_mes, date_sav, description, nom_fourn, no_facture, date_facture, accept, decline FROM DB_FACTURE WHERE( ID_no = 39) Answer perfect On my code Is ... SELECT devise FROM FOURNISSEURS WHERE nom_fourn = '" + Nom_FournPass + …

how to connect sql server 2000 database with multiple connections I got a sample database DB1 and DB2, the DB1 I have table A, and I got a table on DB2 B, between A and B table no direct relation thanks for the enlightenment

how i can return multiple row in sql data base in one row using crystal report?? , for Example 1 DWG1 1 30-5-2013 1 DWG1 2 16-9-2013 in Crystal Report i need to show 1 DWG1 20-11-2013 30-5-2013 16-9-2013 Any Idea Please ??

i have my parent table and child table i want to pass these value by clicking the preview button and display to reportviewer

Error occured: Procedure .. has too many argument specified I have an issue that when i Update the record there is error "Error occured: Procedure .. has too many argument specified". It is my Store procedure SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER Procedure [dbo].[web_usp_empData_Update] @id bigint, @Code …

please help ive been looking for the solution for days. i have two date pickers (dbplite) one is for start date and one is end date. also i have a dropdownlist with the list of addresses of persons records. also a grid view to display record. i also have a …

Hi, is it possible to combine Stored Procedure and Text Command Type in Select Statement? I have a stored procedure that compute available items, it quite a bit long select statement, now i need to call this statement in another select statement which is in text command type, how will …

Is there possiblity to send, 5 data(5rows) at one time to the sql database in vb.net2008

Hello friens I have SQL server 2003 and I need books or online materials regarding SQL query ( All type of SQL query ) like examples and methods to run such queries. Would you help me to find the reliable materials ? From where in INDIA I purchase best book …

this is my code for binding data from data base to text box protected void Page_Load(object sender, EventArgs e) { label.Text = System.DateTime.Now.ToLongDateString(); //// /// date label label.Text = System.DateTime.Now.ToLongDateString(); appSession = (String)Session["applicantEmail"]; lblusername.Text = (String)Session["applicantName"]; lblusernamepic.Text = (String)Session["applicantName"]; String str = " SELECT tblPersonalInfo.firstname, tblPersonalInfo.lastname, tblPersonalInfo.fathername, tblPersonalInfo.country, tblPersonalInfo.city, tblPersonalInfo.phoneno,tblPersonalInfo.mobno, …

i almost spent 3 hours on EXISTS operation, used in SQL especially with subqueries, i got its purpose :) that's ok but what i don't get is that WHY TO USE IT ? e.g. couldn't understand this example: *TABLE STORES* storeName----Sales-------Txn_date *TABLE GEOGRAPHY* regionName----storeName SELECT SUM(Sales) FROM Store_Information WHERE EXISTS …

actual differecne between SQL Server's STORE PROCEDURES and USER DEFINED FUNCTIONS ? i looked up these in google but couldn't satisfy me. Differences ? better to use ? and why does UDF can only implement SELECT statements not else , y ?

Hi all, I am new to asp.net programming and i have to design a website which should accept values from the user and store it in the databse on a button click event. I am not able to do it In fact i have written a code for button click …

ALTER FUNCTION [dbo].[customers_udfMin2] ( @decission tinyint ) RETURNS int AS BEGIN -- Declare the return variable here DECLARE @min int Declare @default int = 10 -- Add the T-SQL statements to compute the return value here if (@decission = 1) Begin SELECT @min = MIN(customers.cus_id) from customers End else RETURN …

I've been working on an ASP.NET project. I've successfully implemented LDAP authentication for login and have tested it with multiple users with no issues. LDAP is only controlling my login credential. Everything else is stored in a SQL db. In that database I have a users table that has a …