[microsoft:sql-server] Forum Topics

Hi all, I have a main report with fields accno, accoutname. Now I want to display the subreport based on the accno. I have displayed the subreport, but it show different field with the hyperlink to the subreport. I want to display the subreport when the user clicks the accno …

Hi everyone, I have one problem that i couldn't solve. I'm developing a Web Application. Everyday many user's logg in and work... So, they logg in to my web app. through their MSSQL username and userpassword. HERE, I want MSSQL to deny access when they open their mssql and logg …

hi there, i have a machine installed MS server 2008 and in that it has MS SQL express , how can i connect othe MS SQL express from another PC in the network what is the toll that i need to have appriciate a lot thanxxxx

How to save listview data to database? Not work code: [CODE]private void Insertbutton_Click(object sender, EventArgs e) { string strConnection = "Data Source=OCH-ERDENE\\SQLEXPRESS;Initial Catalog=Database;Integrated Security=True; Pooling=False"; SQLiteConnection conn = new SQLiteConnection(strConnection); conn.Open(); for (int cnt = 0; cnt <= lsvXML.Items.Count; cnt++) { string query = "INSERT INTO DataObject VALUES('" + lsvXML.Items[cnt].Text …

could you help me guys to translate this code from PHP MySQL to PHP ODBC. i'm having a hard time to run this page using the PHP ODBC which uses MSSQL connection. any help would be very much appreciated.. thanks in advance ^^ [CODE] <?php $return_arr = array(); $sql = …

This looks pretty simple on the face of it but I can't get my head around it. I have two tables that I'm querying: dbo.tblrespondents RespondentID FirstName Surname dbo.tblrespondentschildren RespondentsChildID RespondentID ChildFirstName ChildSurname ChildDOB ChildSex I am trying to find which Respondents who have only sons - one must be …

Hello All I'm working with a gridview control, and i chose to code it my self instead of using the wizard microsoft provides. So i have two questions: 1- Can i use stored procedures to work with parameters so i can send some additional data to the database? 2- Can …

hi, M'soft sites documented that [CODE]RECEIVE TOP (n) FROM Target[/CODE] should fetch the n number of message from the specified queue. I am having problem with this, and do not know why because not much resource is available pertaining this. Tried finding for an answer on Klaus Aschenbrenner's book, failed. …

Table name = Contacts. Table attributes = first_name,last_name,email_address,other_email,address,phone,notes. I want to retrieve without repetition(DISTINCT) first_name and address. But, when retrieving these 2 data, i want all the other data(notes,last_name,etc..) associated to this the DISTINCT data to show. Is there any SQL data for this kind of situation?

hi, i have a problem in login in to the MS SQL server 2008, i installed the MS SQL with the authentivcation mode as Mixed mode and and for the SQL server administrator i added the current user and for the password i gave a different password, which is not …

Hi all, i'am having a problem with my sql database.I'm able to insert and retrieve data.but i couldn't able to view the data in my sql interface.all the columns are empty.so where the data being stored ? why it is not appear to the sql interface ?

what is the best way to read millions of record from sql server database.i have tried data set but still the performance is not so good.

hi there, i have a question in connection my application to ms sql 2008. i wrote a desktop application in visual studio 2008 in the C# language. and i have installed the MS SQl 2008 DBMS software. and when i try to connect to the MS SQL in Mixed mode …

Hi there How can i get the checkbox's value from sql server 2005 and display it in my windows application? The checkbox column in my database either has two values, checked or unchecked. Now what I want to do is I have a form where I can view data. That …

Hello Frnds I am working in a Company from last 3 years as Software Developer. I think i m very good in sql server So i want to get certification of sql server plz give me suggestions .....what type of exam i do and how it will be done.

Hi, Me again. Now the requirement is slightly changed now. Requiremetn: When I enter a employee id in a text box and click "Show calender", the code will run a query to fetch Allocation date and release date of the employee for a project and the dates between Allocation date …

Hey, im trying to get some information out of my database, which i have tableadapter and dataset. Both created with the VS2010. I have made 4 queries in the tableadapter taking different parameters, to make a WHERE clause in the sql sentence. But it simply doesnt work and i dont …

06.12.10 Hi All, My name is Halim Rana. I am the online communication manager with TMG-Kenya. We are a media firm. I enjoy php/msql amongst other languages that I script everyday. Regards Halim

Hi Everyone, I got a problem while creating a views in sql server 2005. In my database there are several tables which are accounts_transaction bill_info member_bill member_info relationship is exist between “member_info and accounts_transaction, member_info and member_bill, bill_info and member_bill” but there is not any relationship between bill_info and accounts_transaction. …

hi frnds i had got a problem, i want to increase the serial number automatically when page is loaded and it will be inserted into the database at every time when the page is loaded ....... here my coding in page load event is given below,,,,, [code] Protected Sub Page_Load(ByVal …

i have a problem in showing the data in the other page which is saved from one page and should be shown in the other page after immediately saving it. can anyone tell how do it through form collection here is the code [CODE] Protected Sub Page_Load(ByVal sender As Object, …

I want to search through an sql table called hardware for a partial serial numbers. I have the following code but there is something wrong with the way i am doing my sql query. hope someone out there can help me. [CODE] Public Function GetDatabysn() As DataView Dim SelectQry = …

I am using sql server 2008 but i just want create reports usin sql statements just sql without any other application like Visual studio is posible??

Hello, I'm using SQLBulkCopy to import data from a text file. There is a lot of data involved and I would really rather not import it row by row. There seems to be a problem with fields containing both numbers and text. (for example, a phone number '555-1212'). All fields …

Hello, I'm using SQLBulkCopy to import data from a text file. There is a lot of data involved and I would really rather not import it row by row. There seems to be a problem with fields containing both numbers and text. (for example, a phone number '555-1212'). All fields …

I have an sql table called Stock with two fields called StockID and StockCode. I want the user to select the stockcode from a combo which in turn populates the stockid for that item into a lable on my form. I have already populated the stockcode into the combo but …

I use report and have the table as shown below. The original column name are Parent and Child Row 1: Parent A and Child B Row 2: Parent B and Child C Row 3: Parent D and Child E Row 4: Parent E and Child F Row 5: arent Z …

I have the following code that will update one field called RCon in sql, does anyone know how i can update a few at the same time? i would like to update the sql field (called stockdesc) [CODE] Dim con As New SqlConnection Dim cmd As New SqlCommand Try con.ConnectionString …

I work with Visual basic 2010 express and Sql server 2008 Express I established Person and Specialist tables data base .I want to make Insert /update/ delete Here object declarations in a module : [CODE] Public str As String 'string sqlcommand Public con As New SqlConnection("Data source =Sara\SQLEXPRESS ; initial …

Hello I am building a web page and decided that this time around I would make many user web controls as to have a very modular and customizable site with ease.. Anyways it was going off without a hitch until today I designed a new control. Its a panel with …

I'm really having hard time importing ASPNETDB.mdf to remote server running sqlserver 2005.. I'm using sql server express edition (along with visual web developer 2008) I use the same string [code=asp.net]<add name="aspnetusers" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ASPNETDB.MDF;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" />[/code] No connection can be established.... Then I changed that to [code=asp.net] <add …

Hello all, Just wanted to pop in and introduce myself! I'm slowly getting back into ASP.NET coding (after almost 6 years), along with MSSQL, and hopefully moving on to using C# and others. I'm looking forward to learning from you all, and hopefully, sometime in the future, helping others!

Hi, I have a simple grid view that i want to be able to delete rows from by clicking the delete button that's automatically created. Every time I click on the delete button to delete the row i get the following error: [COLOR="Red"]Incorrect syntax near 'int'. Description: An unhandled exception …

I'm trying to insert a record from a DataGridView into a database, but I receive this error: [COLOR="red"]Parameterized Query '(@i1 int,@i2 varchar(50),@i3 varchar(50),@i4 varchar(50),@i5 var' expects parameter @i1, which was not supplied.[/COLOR] I have tested with a BreakPoint that c_id is not null, it does have a value. *Note c_id …

Hi everyone! I have a query that take 5-10 minutes to run. And I use this query in ASP.NET Web Application. How can I manage to cancel query? For clarification lets say 2 buttons are on the form,one for starting and other for cancelling the query,is it possible if so …

Hi, I am developing a new Application and am getting the below error Error Description: When I click the record in DataGrid, then the values should be populated from DataGrid columns to respective Text boxes. However if i click in the datagrid when there is no record then there should …

hi, I would like to load data from sql to datagrid. But there is a problem at highlighted place. [CODE] Sql = "Select [KioskID] As [KioskID], " _ & "[KioskLocation] As [KioskLocation], " _ & "[TransactionNo] As [TransactionNo], " _ & "[SerialNo] As [SerialNo], " _ & "[TransactionDateTime] As [TransactionDateTime], …

[CODE]Protected Sub btnSubmit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSubmit.Click Dim j As Integer Dim conn1 As New SqlConnection Dim cmd1 As SqlCommand Dim dp1 As New SqlDataAdapter Dim ds1 As New DataSet Dim str1 As String str1 = "Insert into Feedback( Title,UserName,EmailId,Feedback,) Values('" & ((txtTitle.Text).Trim).ToUpper() & " …

Hello Frends I am getting an error. The details are follows, ERROR: Exception Details: System.FormatException: Input string was not in a correct format. Source Error: Line 36: if (rdr.Read()) Line 37: { [COLOR="Red"][B]Line 38: matured_month = Convert.ToInt32(rdr.GetString(0));[/B][/COLOR] Line 39: matured_year = Convert.ToInt32(rdr.GetString(1)); Line 40: conn.Close(); CODE: protected void Page_Load(object sender, …

Hello Frnds, I have an application developed in ASP.Net(C#) and MS SQL, its working fine and fulfilling the requirements. Now the problem is I have a [I]MS Access Database[/I] from where I have to read some data and feed it into ASP.Net form and then save it to [I]MS SQL …

Hi, everyone this is my first post here and let me tell you my problem I have a C# application, i have SQLServer 2005 installed on my computer my database is there and the program works fine the problem I'm facing is that i need to make an installer for …

btw any tutorials out there on how to create database with vb.net with mssql just to let me get started, i was hoping for a simple db to practice on like id,name. ive made db with php and mysql but vb.net is a bit far from php and mysql though …

Hi, i am using c# window application I have create one Login Form. I want that when user put its username and password first it should check in the database and then it should give the out put. i have even create on signup form first it should be register …

Evening All, i am trying to input 72003 3131/1 from text from a text field into sql as a string. I have the following code but getting an error Error while inserting record on table, incorrect syntax near '3131'. the end user will be able to change this text to …

[CODE]Dim MyTime As Date, DataTime As Date MyTime = Format(Now, "hh:mm:ss") DataTime = 'Get the time from your database here If MyTime > DataTime Then ' Code to Open Door Else Code To Close Door End IF[/CODE] im having a hard time with SQL, please help with the codes of …

Hello All! I didn't see a place for SQL commands and I apologize if I overlooked it, but i'm really stuck on this. Heres the situation: I need update a column from my table (T1) from two other columns in a different table (T2). My constraints are: •That I have …

Hi guys, i want to call a data from a database.. here is my code [CODE] string selectuser = "Dior"; string dbconnection = Application.StartupPath + "\\Database1.mdf"; SqlConnection conn = new SqlConnection(dbconnection); conn.Open(); SqlCommand command = new SqlCommand("select username, nick from [user] where username=@user", conn); command.Parameters.AddWithValue("username", selectuser); SqlDataReader reader = command.ExecuteReader();[/CODE] …

I built an application that generate 10,000 pins at ramdom among "a,d,t,l,1,2,5,4,6,9,7,a,l" (at a run and insert them into sql database).the format of my outputs is "adtl-5297-1275-al". Problem is that some data replicates themselves. I need an sql statement to filter my dbs after the pins are generated. Pls help …

My code is not wroking to send out an email. I have 3 conditions that need to be met. managerEmailAddress and emailSentToManager only appear in the DB once. completeDate is in another table and it can appear several times. So basically if all items are complete and an email has …

Hi all, I'm attempting to get some numbers from an XAL database (MS SQL Server 2005). My query is below. There are some conditions commented out. If I add either one of the lower ones the query executes in a matter of seconds but if I replace them with the …