9,022 Topics
Hello! Please I need your help on this part. I've just developed a vb6 program and ms sql express as backend. I setup the ms sql express in a pc working as a server (windows xp). And i also installed the vb6 program on the same pc. I setup also …
hai all Good Morning. I am trying to show a OLAP Report created (using cube in SqlServer 2000) in crystal reports in a asp page. i used smart activex viewer for this but the data alone in the crystal reports r shown. the drill down structure does not appears. Also …
I try to copy and paste TAB delimited list into html text area, then save it to database, however when I retrieve it from DB, all TAB space are gone, does anyone can give me advice is there a way to keep these TAB? Thanks in advance. [CODE] test test …
This is my code to load data from a database(SQL Server 2000) into a combo box. I keep getting the error [B]Name 'connString' not declared.[/B](the highlighted section of the code). I've tried posing this error in Google search but there are no answers. I am working in a software development …
I have a project to be done that is a web based EMPLOYEE PAYROLL SYSTEM AND TIME TRACKING in ASP .NET with SQL SERVER and im just a beginner wid ASP .NET and have no idea about what to start with , so please please help me !!!
Hi All, I got a question regarding sql. I got some data in a ms access. There's 3 columns, namely id, name and address. Here's an example. [CODE]id name address 1 a c 2 c d 3 d e . . . . 100[/CODE] And, I need to insert a …
Hello all, i have got an issue with a client here, who is running an internal CRM system. we need to get information into our Webserver (Linux-MySQL5) database (dealer lists, product lists, ....) and this information is stored in the CRM. but the CRM is Windows-MSsql. The output is .DAT …
Hi, I want help in displaying record of same challan no. into one textbox. I have feilds like challan no,sendqty,availableqty,balqty. if i fill one record of challan no 1, availableqty=1000,sendqty=500,balqty=500. next time when i am fill record of same challan no then i want availableqty=500 in textbox. I am using …
Hi, I want help in displaying record of same challan no. into one textbox. I have feilds like challan no,sendqty,availableqty,balqty. if i fill one record of challan no 1, availableqty=1000,sendqty=500,balqty=500. next time when i am fill record of same challan no then i want availableqty=500 in textbox. I am using …
Hello All I am Using sql2005 My Doubt is How To Format Numbers in Sql Query Like Format(NOS,"0000") in vb ie I have Table Tbl1 Fields Nos1 Datatype int values 1,2,3,4,................1000 When Simple Query Select * From Tbl1 We got Following o/p 1,2,3,4 But I want Out Put Like below …
Please help me with this CODE. What I want to do is to update the existing data in my database. Imports System.Data Imports System.Data.SqlClient Imports System.Data.SqlClient.SqlDataReader Imports System.Transactions Imports System.Collections Imports System.Collections.Generic Public Class SelectStaffManager Const strConnectionString As String = "Server=(local);Initial Catalog=VideoClub;User ID=sa;Password=" #Region "SQL Statements" Private Const SQL_SELECT_STAFF As …
hi all,,, well i am using asp.net 2005 and sql server 2005... i hav a database called as ABC,,i am using a gridview and a dropdown list inmy application. What i want is ,,the dropdown list should be populated wiyh all the table names available in ABC database and on …
Hi All, I want to display the name of the fields in the datareport but unable to get how to display the same One more question. I have 3 checkboxes and 3 comboboxes on my main form from where I have to generate the report. How do I apply the …
Hi I'm migrating from Oracle Sql to MS Sql. I'm trying to write an mssql query that will pull all rows from a tableA but only if row in tableB = apple. In other words the table might look like this: tableA tableB Joe apple Joe orange Joe peach Fred …
Hi, I am developing a hand held device. I am using .net compact frame work with WINCE support. Here i want to choose a open source database which supports WINCE. Can any one tell which open source database will support WINCE platform. Regards, Vijay Bhaskar
Hi I am new database designer. I am wondering if there is ready-made standard Nationality lookup table, I think I will find those entries in some txt file since Every DBMS can load a text file. and I think there must be a standard schema for that table something like …
Hi All, When I run the query: [B]select (100/50)[/B] It give me "2"... good. But when I run the query: [B]select (50/100)[/B] I was expected it will give me 0.5... but it gives me 0 instead? Why? and How can I get the "0.5"?
We have a Windows Server 2003 machine which we installed a few months back. It’s being used as a SQL Application server. Terminal Server was installed on it and the warnings about licenses expiring have pretty much gone ignored up until today when I discovered that the license has indeed …
hi. im having problems with comparing a string and a string array. I know it should be as simple as something like if(str == strn[0]) and if this is true, it will go to that if block statement. I've tried all kinds of test already and it seems that whether …
Hi frds, I want to add msc dynamically in my application. Does it is possible? If yes then plz provide help . thanks in advance.
can any one Suggest me a good E-BOOK for SQL server 2005??
Can someone help me convert this SQL SELECT statement to ASP.NET code (if possible): [code] SELECT * FROM tblCategory RIGHT JOIN tblInventory ON tblCategory.categoryID = tblInventory.categoryID WHERE (((tblInventory.type)=[strSearch])) OR (((tblInventory.country)=[strSearch])) OR (((tblInventory.date)=[strSearch])) OR (((tblInventory.eventSeries)=[strSearch])) OR (((tblInventory.grade)=[strSearch])) OR (((tblInventory.comment)=[strSearch])); [/code] I'm trying to use it as a SelectCommand.
Hi, I would like to know if there is a way to link to a sql table, but not be able to edit it, the table is part of another program data and I just want to look at data, maybe copy to spreadsheet. I figured out how to get …
i have 2 tables : 1.Ms_Menu Menu_Id,Menu_Name 001 | Menu1 002 | Menu2 003 | Menu3 2.Tbl_User User_Id,User_Name,Menu_Id User1 |Name1 |001 User1 |Name2 |002 User2 |Name2 |002 i want to joined 2 tables using UNION(or other way if works is fine->left/right join) my coding : [code=sql] SELECT User_Id,User_Name,Menu_Id,'' Menu_Name FROM …
Dim strSql As String strSql = " Select * from quazatoknitting where yarn_recchno= '" & txtchno.Text & "'" Dim strSql1 As String 'strSql1 = " Select rec_qty from recfromknitting where yarn_recchno= '" & txtchno.Text & "'" Dim da As New SqlDataAdapter(strSql + strSql1, objconnection) Dim dt As New DataTable da.Fill(dt) …
hello, I need to register a new Employee's Car , In my database , there are two tables ( Car_info , Emp_Info ) and I created a relation between them : (Car_info table) Column [B]Car_no [/B]As [B]Primary Key [/B] and (Emp_info table) Column [B] Car_no [/B]As [B]Foreign Key [/B]. [COLOR="Green"]This …
Hi people I'm pretty new to this and I was wondering what c# code you would put into the button event handler to allow the person who presses it to browse for an excel file then use that data to populate the sql database that you can make using visio …
Hi 2 all, How to upload .doc file into SQLSERVER2005 in c# windows application and again how to retrive it from DataBase...... I want it only in Windows..... Advace Thnxxxx
Please help me i try to display all instances of SQL Server in a combobox. Any help is greatly appreciated.
This is my vB.NET assignment and i have no idea what it requires. I have not done this practical before b'cause the lecturer has not taught us about the joining the SQL in VB.NET and I'm seriously dont know how to do this......so i need help and pls do help …
I have to connect asp.net with SQL Server, the normal windows authentication established fine, but not with sa login and What is the default password for sa in sqlserver?
Hi All Im new to asp.net. Im looking to hide rows in a table in a formview InsertItemTemplate depending on a bit value in a MS SQL table. I have it working in the EditItemTemplate. Im also using VB coding. [CODE]<tr runat="server" visible='<%# eval("shirtsv") %>'>[/CODE] my formview code is as …
I am trying to create a sql statement like set @sql = 'select @stage1 = count(MY_ID) From VW_OPEN where ' + @filter and run it with exec (@sql) However this generates an error Must declare the variable '@stage1'. If I run statement select @stage1 = count(MY_ID) From VW_OPEN the var …
Hi, Plz help me how to create asp.net form using javascipt(validate.js) and store them in sqlserver. Plz...... Plz...... solve my problem.
I need to write a query that will pull my products and price. However each of the products have multiple prices and I want the price with the most recent date. I have tried the following query but it doesn't work. Can someone assist me. I'm fairly new to sql …
hi to all, pleas bear with me co'z I am a newbie with this environment. I have a microsoft access database and I already have tableadapter. I have already a forms that the operator input the name with the text box then searh with my database. After it successfully searched …
hi, Private Sub AutoNumberNo() try Dim strsql As String strsql = "SELECT MAX(Serial_No)+1 FROM Cutting" Dim com As New SqlCommand(strsql, objconnection) txtsrno.Text = com.ExecuteScalar() ' result will appear in textbox txtsrno Catch sqlex As SqlException MessageBox.Show(sqlex.Message) End Try End sub i try this code but i get following error 1) …
Dear Friend I am trying to perform the flowing tasks using the following SQL statement in Microsoft Access but they don’t work. I wonder if someone could help and tell me what is wrong with my Statements. Whenever I run these statements it will not create the query. [B]Task 1: …
Hi. Can anyone tell me how to populate items in listview? I need to call a column in a database to load all its list.
I will try to make this as simple as possible. Any help would be greatly appreciated. I have 3 tables like below. tblEmployees ----------------------------------------- EID | Name | 1, John 2, Bob 3, Steve 4, Brian 5, Joel 6, Lance ----------------------------------------- tblTraining ----------------------------------------- EID | JOB | 3, 1 4, …
I am trying to load XML files into SQL server database using SQLXML4.0 I have relation defined as such: [code] <xs:annotation> <xs:appinfo> <sql:relationship name="ApplicantPhone" parent="Applicant" parent-key="PQNumber" child="Phone" child-key="PQNumber" /> </xs:appinfo> </xs:annotation> [/code] and then I am using the relations as follows: [code] <xs:element minOccurs="0" maxOccurs="unbounded" name="CustPhone" sql:relation="Phone" sql:relationship="ApplicantPhone"> <xs:complexType> <xs:sequence> …
I am using SQL Server 2005, I have some select and update statements in my query with WHERE clause I want to prevent these queries from SQL injection attacks. What are the steps and precautions to be taken for SQL Injection attacks? Does anybody have suggestions? Thanks in advance,
hello, I had a database(ms access) about 120000 entries in 2 fields (in the same table) it was not in sorted form, but the data is inter realated by rows, can you gave me a code snippet to search a word from a database (ie if there is any functions …
Hey. I would like to ask for help regarding SQL server. I have developed a client-side application to run on my clients' agents machines. They will use this software to add items to a cart and print an invoice, in addition to the program eMailing my client to notify him …
In my database, the format for 8 columns are as shown: [code] +------+------+------+------+------+------+------+------+ | MPT | MPB | MP1T | MP1B | MP2T | MP2B | MP3T | MP3B | +------+------+------+------+------+------+------+------+ | 4 | 7 | 1 | 1 | 3 | 3 | 0 | 3 | | | …
Greetings, I am trying to do a reconnect type of thing for when sqlserver disconnects me i check and reconnect to execute a query. here is some code that i wrote, I really don't know what to use since there is not isconnected method or reconnect method in pymssql. Any …
Hello, i have a database that came with MYSQL statements to get it working but we are using MSSQL and have managed to convert a large proportion of them but there are two statements we are having trouble with and wondered if anyone could help. The first is below: [CODE]SELECT …
can u spot the error in this code.. [CODE] Private Sub fncExcelExport(ByVal strSql As String) 'fncExcelExport("SELECT * FROM tbl_rop WHERE Name_User ='" & (TextBox1.Text) & "', Date_of_birth= '" & (TextBox2.Text) & "' , Hobbies='" & (TextBox3.Text) & "' , Phone_Number ='" & (TextBox4.Text) & "' where Name_User = '" & …
In reading and posting on this forum, I see a lot of code here that doesn't consider sql injection. SQL injection is an attack where the attacker terminates or modifies an sql query with input data. Here are some samples: [url]http://en.wikipedia.org/wiki/SQL_injection[/url] [url]http://www.unixwiz.net/techtips/sql-injection.html[/url] [url]http://www.securiteam.com/securityreviews/5DP0N1P76E.html[/url] In Michael Howard's blog, he wrote up …
Hi I have a number of reports developed with SQL Reporting Services. I want to call them from the Reportviewer available in VS 2005. The problem arises when i add the Report Viewer to the we form. I get an error. Type 'Microsoft.Reporting.WebForms.ReportViewer' is not defined. I am running on …
The End.