[microsoft:sql-server] Forum Topics

Here's I wrote some code to insert\retrieve images from SQL Server database 1- Create table to hold Image ID, Name and itself [CODE=SQL] USE [ImagesDatabase] GO /****** Object: Table [dbo].[Image] Script Date: 07/10/2009 23:46:46 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Image]( …

Okay, I have used databases before, but I always created the bindingsources and other things i needed via the visual designer, and now I want to create them with code, so I can make a button to refresh the database without closing it, the problem is that I don't know …

Hello, I am dealing with SQL server 2005 and i have data from a system where i am tracking an application at each stage in the system. i have data in a tabular form as follows and the dates are derived from an sql statement. how best can i write …

protected void SetDestinationURL(object sender, EventArgs e) { if (loginMember()) Response.Redirect("~/Member/Home.aspx?Username=" + txtUsername.Text); else if (loginManager()) Response.Redirect("~/Manager/Home.aspx?Username=" + txtUsername.Text); else Alert.Show("Unauthorized User Access"); } protected Boolean loginMember() { SqlConnection conLogin = new SqlConnection(ConfigurationManager.ConnectionStrings["connMSJ"].ConnectionString); SqlCommand cmdLogin = new SqlCommand("SELECT Username, Password FROM Member WHERE (Username=@ID AND Password=@Pass)", conLogin); conLogin.Open(); cmdLogin.Parameters.AddWithValue("@ID", txtUsername.Text); cmdLogin.Parameters.AddWithValue("@Pass", …

protected double[] getValues(int ColumnCount) { double[] value = new double[ColumnCount]; SqlConnection conGetValue = new SqlConnection(ConfigurationManager.ConnectionStrings["connMSJ"].ConnectionString); SqlCommand cmdGetValue = new SqlCommand("(SELECT * FROM DailyBudget WHERE (Username=@username)) EXCEPT (SELECT Username FROM DailyBudget WHERE Username=@username)", conGetValue); cmdGetValue.Parameters.AddWithValue("@username", Master.getUsername); conGetValue.Open(); SqlDataReader dtrGetValue = cmdGetValue.ExecuteReader(); try { int i = 0; while (dtrGetValue.Read()) { value[i] …

protected void AddTransaction(object sender, EventArgs e) { SqlConnection conAddTransaction = new SqlConnection(ConfigurationManager.ConnectionStrings["connMSJ"].ConnectionString); SqlCommand cmdAddTransaction = new SqlCommand("UPDATE DailyBudget SET @category=@amount WHERE Username=@username", conAddTransaction); cmdAddTransaction.Parameters.AddWithValue("@category", "Foods"); cmdAddTransaction.Parameters.AddWithValue("@amount", Convert.ToDouble("200")); cmdAddTransaction.Parameters.AddWithValue("@username", "mhingshiang"); conAddTransaction.Open(); cmdAddTransaction.ExecuteNonQuery(); conAddTransaction.Close(); } The `Foods` is one of the column name in `DailyBudget` table. But it can't update to the …

When to trying to display data to datagrid view using query i got an error "a column named date already belongs to this datatable in net 2008" Dim dt As New DataTable Try myConnection = New SqlConnection(connectionstring) myConnection.Open() Dim cmd As New SqlClient.SqlCommand With cmd .CommandText = "SELECT [Date],[Totalamount] FROM …

i have EDIT option infront of every row in a table. i want to fill above form with the values for editing. i am using sql and classic asp.

protected void RegistrationMember(object sender, WizardNavigationEventArgs e) { TextBox txtID = (TextBox)cuwRegistration.FindControl("UserName"); TextBox txtPass = (TextBox)cuwRegistration.FindControl("Password"); TextBox txtEmail = (TextBox)cuwRegistration.FindControl("Email"); TextBox txtQuestion = (TextBox)cuwRegistration.FindControl("Question"); TextBox txtAnswer = (TextBox)cuwRegistration.FindControl("Answer"); SqlConnection conRegister = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString); SqlCommand cmdRegister; conRegister.Open(); cmdRegister = new SqlCommand("INSERT INTO [Member](UserName, Password, Email, Question, Answer) VALUES (@ID, @Pass, @Email, @Ques, …

protected void SetDestinationURL(object sender, EventArgs e) { if (loginMember()) Response.Redirect("~/Member/Home.aspx"); else if (loginManager()) Response.Redirect("~/Manager/Home.aspx"); else Response.Write("<script language=javascript>alert('Unauthorized User Access')</script>"); } protected Boolean loginMember() { TextBox txtID = lgLogin.FindControl("UserName") as TextBox; TextBox txtPass = lgLogin.FindControl("Password") as TextBox; SqlConnection conLogin = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString); SqlCommand cmdLogin; cmdLogin = new SqlCommand("SELECT UserName, Password FROM …

using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; using System.Data.Sql; using Microsoft.Win32; //using Microsoft.SqlServer.Management.Smo; namespace DataSearchinginDB { public partial class frmDataSearching : Form { public frmDataSearching() { InitializeComponent(); } private void frmDataSearching_Load(object sender, EventArgs e) { SqlDataSourceEnumerator instance = SqlDataSourceEnumerator.Instance; …

this is my code , it should save a pdf file from sql server to a folder but nothing happened can anyone help please ?? Set rs = New ADODB.Recordset rs.Open "select * from PDFStore where filename='" & co_name.Text & "'", db, adOpenKeyset, adLockBatchOptimistic If Not rs.EOF Then Set pdffile …

Dear All I am using Vb.net to update a database running on SQL Server. I am using the following to increase the value of the NextPlan in the SystemControl table in a SQL database. Command.CommandText = "UPDATE SystemControl SET NextPlan = NextPlan + 1" Command.ExecuteNonQuery() Once the Command is executed …

Hi Guys, I have a requirements to backtrack 2 days if the date fall as Monday. Why? We dont have any transaction from Sunday to Monday at 6:00AM that's why need to backtrack 2 days. i want to share with you my query. if you have any additional idea to …

an asp page of mine with server.ScriptTimeout=540 seconds this page is then executing a select query from a huge database table which is properly indexed BUT few times there is a SQL timeout because of conditions passed in query is there a way to handle the SQL timeout and display …

how to connect a vb.net form to microsoft sql server database in coding?

I have to tables 1.[Mobilization]-Primary key is [Fen_Inovoice_No] it is the forgien key is of [invovoice details] 2.[invovoice details] the primary keys are [Fen_Inovoice_No],[Item] when I tried to view the data , the all data are not loading to listview why is that? Dim intResponse As Integer intResponse = MsgBox("Please …

I use Visual Basic 2008 and the SQL server Compact Edition I got an error in fetching the numbers of the two tables i create please help...

I was trying to connect MSSQL EXPRESS with Java. I was successfully connect with MSSQL SERVER with user name and password. but I can't connect a database which does not have user name and password. I was inserted "integrated security=true" in my code. But it is still unsuccessful. Help Me …

I have a table which have some records,i need to loop through selected fields(say 10 to 14 with respect to 10).. if it finds any data from 11 to 14(with respect to 10) the value has to append to the field 10 for each corresponding row, sub fi_macr() dim strsql …

Hi freinds i have developed a sync service by using MS sync SDK. It was working fine few days before but its not working. It does not showing any error in log. Please friends let me know if you are having useful suggestios to make the thing working. Thanks in …

Hi to all, I like to start a new discussion after a long gap..Now i have a Question in Sql,I need to Take a difference in Current Month and Previous month,from get the diference i use the trigger to send a sms.. SELECT datepart(mm, dateadd(mm,-1,'2011/1/1') ) or SELECT DATEADD(MONTH,-1,GETDATE()).i need …

good day everyone! i am currently working for an information kiosk, all the data needed to be displayed is in an existing database. to avoid data tamper, since the system is a network based one, data migration is needed. so my question is, is there any codes or sample projects …

Hi, I'm having some issues trying to figure out the way to find the percentage of parents with children inside my database. There is a table where all the parents are stored called XY and there is a table where all the children are listed called table Children. How would …

hi everyBody, Can some one tell me the steps of how to make daily back up database from SQL Server 2008, when i do this Script and job it give me an error cant be completed, any help plz...

Hi, i want to create a query which select three columns from a table on certain condition now i have got certain with three columns and i can bind this data to a datagridview but before this i want to add a column to dgv say col_new and fill its …

Dim startdate1 As String = DateTimePicker1.Value.Date Dim enddate As String = DateTimePicker2.Value.Date myConnection = New SqlConnection(connectionstring) myConnection.Open() Dim insert As SqlCommand = New SqlCommand(" INSERT INTO Client_Details (Contract_Name ,Client_Name ,VAT_No ,Cilent_Address,Start_Date,End_Date ,Contract_Value,Telephone_No) VALUES('" & TextBox1.Text & "','" & TextBox2.Text & "','" & TextBox4.Text & "','" & TextBox5.Text & "','" & …

I created tab pages with this, cmd.CommandText = "Select * from StuInfo where StuID ='" & SelectedID & "' order by PayDateDB desc" cmd.Parameters.AddWithValue("@StuID ", SelectedID) DA.SelectCommand = cmd DA.Fill(DS) DT = DS.Tables(0) RecCount = DT.Rows.Count TabControl1.TabPages.Clear() If RecCount > 0 Then For Each DR In DT.Rows newPage = New …

HI All, im working on a project that uses asp.net to send information to a mssql server. The problem im running into is that when i try to debug the page, I get: 'ClickSave' is not a member of 'ASP.default_aspx'. How Do I fix this?? Heres My html code(default.aspx): <html> …

I have a web application that I create that works great on my computer. I have an account with 1and1, so I uploaded the database and the files. I am also using Linq to SQL, so I have a dbml file. But, everytime I run a function that needs the …

Hi All, I have a table space in which i have eight columns. The first column is Index which i kept as Auto_Increment starting from 1 so that i can see the number of rows of data anytime. The problem is, for example i have one row of data and …

Hai, I am doing a project in VB.Net and SQL Server 2000. When I try to execute my queries in the crystal report it gives a query engine error and in other cases it shows the report with each row repeated. The SQL Query works perfectly in the query analyser. …

Good afternoon! I am wondering if there is a way to log queries that have occured on a database or specific table? For example, is it possible to log the user, the query type (insert, update, delete, select, execute etc...), date, time, table, row and column(s) affected by the queries …

I have 2 checkboxes on one page and a search button on another page that needs to take into consideration if the checkboxes are checked or not. I need to be able to search 4 different ways: both checkboxes are checked neither checkboxes are checked checkbox1 is checked and checkbox …

I have developed a page which contains some controls like textboxes, dropdown,etc. I had created the **datatable** using the **sqldataadapter** and that works fine by retriving the table using the select command. I want to place the data in a **gridview** and it also works. Now I want to populate …

Hi, I have ben having problems making an instance of sqldatareader. I keep getting a squigly line under my datareader object with a message saying that unreachable code detected. Here is my code: using System; using System.Windows.Forms; using System.Collections.Generic; using System.Data.SqlClient; using System.Linq; using System.Text; using System.Threading.Tasks; namespace Albergo.Classes { …

Several people have asked about storing binary data in a database. I coded up an example today that uses an ADODB.Stream to copy the binary data but after some fiddling I found a more direct way. If you are using MS SQL Server, the easiest way I have found is …

Ok so what i want to do is break up a string after the lenght of the string is = to 160, then i want to add a line break..but all this needs to be done in the Select...can anyone help me with this thankx in advance select case len(COD_P2_Q1) …

Displaying a description based on code in database C#, database, WindowsApplication, Hi everyone, i have a question how do i input the descriptions columns if i type the number based on my database in code columns, i already retrieve the code from database, but now i also want to display …

I am a college student developing a local chat application using VB.Net and SQL 2005. I have multiple clients connected to a server via local ip. My first problem is, how will I know which users are online. Each user has their own username and password in order for them …

I have a login form that asks for credentials for access to select areas of a large app I wrote. I am trying to add a form to allow for password changes via that app instead of me having to update the SQL DB manually. DB has 1 table called …

Okay,First of all let me introduce myself as newbee to this language. this is my third day with program,I usually Practice at college where Visual studio 2010 is installed. I have VS2012 ultimate. If I sound silly forgive me,but I am really desperate here. 1st Problem,I couldnt create New SQL …

Hi All, I am creating a simple query with a not so simple twist, at least it's not simple to me. First, the query: select distinct b.Bank_Mnemonic as [Bank],bd.Demo_Name as [Demography],ei.BEFI_Description[Economic Indicator],bsd.BSD_Year as [Year],bsd.BSD_Data_Value as [Value] from dbo.tblBank_Source_Data as bsd inner join dbo.tblBankDemographics as bd on bsd.Demo_ID=bd.Demo_ID inner join dbo.tblBanks …

I faced to a huge problem when i coding some stored procedure. How to combine some string to sql string in stored procedure??? This is what i did upto now. @WhereCondition = ' WHERE id = 102 ' DECLARE recoredSet CURSOR FOR SELECT SUM(Amount) as AmountSum FROM sale + @WhereCondition …

Hello ım writing a program that it will work with sql database. i loaded a database which name is b.sql. but i need to connection string abouth user name , pasword and where is the location of database.

Hi, after spending lot of time on google i am fadeup i have a dynamic tab control in which i am able to make dynamic buttons and i am also able to get whole row of a table product in button's tag but i do not know how to retrive …

I am new to vb.net Pls. Can someone help me on how do to display my data saved into sql server from form1 to datagridview in form2 with vb.net. Thanks in advance.

Hey everyone, I am trying to create an excel spreadsheet that is populated with data from a table in sql server. I would like to make it so it will update several times a day with out the user having to do so. I have no clue how to go …