6,934 Topics
 | |
| | Hi every1 I'm working on my first visual studio and c# app ..... I wanna deploy my winform app (which contains sql database) and sql server express as one bundle... 1. I did a backup for my database . how to insert it into my app ? and what do …  |
| | Hi all, I want to know how to assin a return value to a variable when calling a regex function. it always returns a bit type of value(its ok). i want that bit type of value tobe cheked whether it is '0' or '1' this is my C# code in … |
| | Hi guys, I have a problem on getting the selected radio button and save it in the database. Here is my code: [CODE] <div id="container"> <div id="question1" style="display: inline;"> <p>Question 1</p> <ul> <li><input type="radio" name="q1" value="1" id="ans1" />Answer 1</li> <li><input type="radio" name="q2" value="2" id="ans1"/>Answer 2</li> <li><input type="radio" name="q3" value="3" id="ans1"/>Answer …  |
| | hi, please help in my project in visual studio 2008 and connecting it to mySQL, I'm going to create a simple identification system, can you please help me with the codes? (Form1 - Log-in, Log-out) Here's my project proposal, I need to identify an ID number and a password. Like … |
| | Well i am using asp and VB.Net to make it to where people can check in and check out. I have gridview which has where it shows the data from my sql server that i put dummy data in. When i load my website the data shows up. I do …  |
| | I want to learn basic web query vc++.I googled around and found that libcurl was the library needed.I have downloaded the necessary files from curl.haxx.se .I do not know how to use these files and make the actual header file and then actually include it in my project. Any help …  |
 | I have the following connection string in a Excel VBA project: oCon.ConnectionString = "Driver={SQL Native Client};Server=SQL;Database=D1; Trusted_Connection=yes;" On my laptop this works perfectly. But when I try it out on another computer I get an error: I get this error when oCon.Open on debugging: Run-time error '-2147467259(80004005)': Automation error Unspecified … |
| | Hi, i work with SQl Navigator and Oracle and i want to buy Mac laptop, but i am not sure if Oracle 11g is going to Work in Mac. So the question is: If SQL navigator 6.2 and Oracle 11g can work in Mac OS. Thank you. |
| | Here is my code: [CODE]Imports System.Data.SqlClient Public Class Form1 Dim iConnect As SqlConnection Dim iCmd As SqlCommand Dim iRdr As SqlDataReader Private Sub dologin() iConnect = New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\UserData.mdf;Integrated Security=True;User Instance=True") iConnect.Open() Dim strLogin As String = "SELECT username, password FROM tableusername WHERE username = '" & userbox.Text & "' …  |
| | hello, i wrote some commands in notepad and saved it as .sql and i m running these commad at my sql by command- [COLOR="Red"]mysql>source C:\Program Files\MySQL\MySQL Server 5.0\bin\script.sql;[/COLOR] then its run.. but hat to do if i write it without giving whole path. i ren this command-- [COLOR="Red"]mysql> \. filename[/COLOR] … |
| | I am developing a project for a client with a single table in the database for users which includes information about each user, including a field for the userID of a user who referred them. What I need to do is query the "referrer" field of each user record and … |
| | Hi! I'm trying to send data from a mobile application written in Java ME, to an ASP.NET website connected to an SQL server. I tried to open an httpconnection output stream in the Java ME application, and send the data in a POST to the website. The problem is I … |
 | i am new with SQL server 2005 and visual studio 2008 please help me..how do i connect the forms and the tables in the database  |
| | please help!!!me.. I'm a beginner vb.net programmer I have a difficult that is how can I save image file from vb.net to sql server |
| | Hi is it possible to fill a list box from two SQL tables firstname lastname thanks M |
| | Hello, May be the there is a very simple solution for my problem, but I am stuck on this for 2 days already. May be I had been looking at the wrong places...I would really appreciate any kinds of helps....feeling really frustrated right now. You see, for my project at …  |
| | hi, i have a question in data tables. i am coding in C#. my scenario is employees have many benefits in a company such as life, health, dental, 401k and such... i have a tabel in MSSQL database to represent the employee data and a emp benefit table to hold … |
| | hi ...i have a problem connecting MSSQL 2005 express and php.. i've tried configuring the php.ini by removing the ; in extension=php_mssql.dll but not working i also place the php_mssql.dll on ext folder but not working again; and also i tried downloading an old ntwdblib.dll and placing it in system32 … |
| | Continuing on from my adding data to the db I am using the following to try and update the db [CODE] End If 'Refresh_Form() conn.Close() 'update property table Dim connUpString As String = My.Settings.strConn Dim connUp As New SqlConnection(connUpString) Dim cmdUp As New SqlCommand Try connUp.Open() cmdUp.Connection = connUp cmdUp.CommandText … |
| | hi ... can someone help me on connecting MSsql 2000 to vb6 ...i've been searching google but they always point me to this site .. [url]http://www.connectionstrings.com/[/url] i dunno how to set up this strings in vb since im new to vb... :( please help |
| | Hello there, I need some help with a query .. Table gamedate cutofftime 2011-08-25 13:55 I want to list games that are today +7 days but today games where the cutoff time has passed should not be displayed. Can anyone help me with this query please. Thank you for any … |
| | Hello, May be the there is a very simple solution for my problem, but I am stuck on this for 2 days already. May be I had been looking at the wrong places...I would really appreciate any kinds of helps....feeling really frustrated right now. You see, for my project at … |
| | [CODE]newUserCommand.CommandText = "INSERT INTO users(username, password, security) VALUES('" & newUserNameBox.Text & "';'" & newPassWordBox.Text & "';" & newUserSecurityBox.Text & ";'"[/CODE] I cannot find where the syntax error is but vstudio tells me the error is in a unclosed quotation after ; |
| | I am using SQL Server 2008. I have data from SQL like this. [CODE] ID ID2 PartNo -- ---- ---- 75 23921 DENT 75 26145 PLGD 75 26145 PRRP 75 26145 SIST 75 57290 PRMD 75 57290 abc 75 57290 def 75 57290 ghi 75 57290 jkl [/CODE] I need … |
| | I am using SQL Server 2005. I have a data from SQL like this. ID ID2 PartNo 75 23921 DENT 75 26145 PLGD 75 26145 PRRP 75 26145 SIST 75 57290 PRMD 75 57290 abc 75 57290 def 75 57290 ghi 75 57290 jkl I need an output like this. … |
| | I'm trying to make a Menu manager in PHP + SQL. My goal is to save every menu item and where it should link to in a seperate row. Every row has an internal identifier column called 'menu_id'. I also want to add a function to be able to add … |
| | I have a table in which I want to retrieve the table as follow. Login Name Parent User Email ID Mobile No abc abc_parent [email]abc@abc.com[/email] 9999999999 MySql Table as follow in tbl_users user_id parent_user loginname email mobile 321 123 abc_parent [email]abc@abc.com[/email] 9999999999 231 456 abc [email]123@123.com[/email] 8888888888 I am having … |
| | Hi I have [B]Windows 7 Home Premium SP-1, 64-bit[/B] version on my PC. I want to install SQL Server either 2oo5 or 2008. but i am unable to install this. Error: [I]OS Incompatibility[/I] Pls Reply: Thank U  |
 | I have forgot my sqlserver 2000 password, any method to recover it??????? |
| | Hi there, I hope someone can tell me what I'm doing wrong here. I have a SelectCommand in my asp.net page (v4) that pulls a variable from the Profile to run a subquery to get the value to test within the main query. (Confused yet?) This works for 2 of … |
| | I have a csv file that needs to be imported into sql server using vb.net. I got it working with the following code with one exception: [code] Private Function ImportLeadFile(ByVal projectfile As String, ByVal sLeadFile As String, ByVal DATABASE As String) As Boolean Dim objConn As nsSqlClient.SqlConnection Dim ds As … |
| | I am having difficulty with a SQL query in my project. I have 3 tables. T1: - Date - ID - Location_ID T2: - Location - Location_ID T3: - ID - Result From this I need the T1.Date and T3.Result based on Location in T2. So my I need a … |
 | I have a Windows Form where 225 buttons are added at the run time, also I have the database which have two columns (first column is the SeatNumber with the datatype nchar(4) and the other column is IsBooked with the datatype bit). The SeatNumber contains data like this, A1,A2,A3,A4................O13,O14,O15, The …  |
| | hi, I have problem with my sql query. when i used direct insert statement in 2 different table and sort out using select statement by combining these 2 table's it perfecly give's the output that i wanted but when i apply the same method to the real application its working … |
 | Hello, im writing a C program that needs to get a value from my database and put it into a temporary table. so far i can get the value from the database and insert it into my temp table. if i fill in the right value in the where clause … |
| | Hello all, I have a DataGridView that is being populated via SQL with one table and is being filtered by Stock Code. I need to sort the view of one Stock Code by Nutrient names, but the sequence number is in anther SQL table. it would be easy if i … |
| | Hi, I have a sql view below: [CODE] SELECT b.Stk AS secode, b.TktE AS Ticket, CAST(a.Last / 10 AS integer(10, 3)) AS Last, CASE WHEN CONVERT(integer, a.Last) <> 0 THEN (CONVERT(integer, a.Last) - CONVERT(integer, a.Ref)) / 10 ELSE (CONVERT(integer, a.Ref) - CONVERT(integer, a.Prev)) / 10 END AS Change, CAST(a.High / …  |
 | Can someone please tell me what i am doing wrong with this code. I have created a dataset and want to push that data into crystal reports. [CODE] Dim rpt As New CrystalReport1() 'The report you created. Dim myConnection As SqlConnection Dim MyCommand As New SqlCommand() Dim myDA As New …  |
| | pls help me fix the error. What and where is the problem? Thanks for the help! Here is the error message >> [B] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' )' … |
| | designing an inventory system and i want to generate crystal reports from sql queries. Actually want to generate monthly and yearly reports from the daily sales reports i have populated. someone please help me. |
| | Hi We have two identical web servers in a farm and I need them to be able to share Session variables as I do not know which machine the user will be using at any given time i.e. if a user where to log in to a site on server1 … |
| | help me guys .. i want to know how to select the end of the data in my table.. |
| | I have a Database that stores a residentID, apartment, MoveInDate, and MoveOutDate. I am trying to run a query from this database to find the resident row where the MoveOutDate is NULL so I can enter the date they moved out. My Coldfusion is not the best and here is … |
| | Hi, My problem is that I'm recovering data (which depend on what the user selected on a first page) from a SQL database for several language checked (also on that 1st page). I would like to create files for each one of the language selected. For now, I tried to … |
| | I'm a NEWBIE and I have been stuck on this for days. I have one table that has the following rows: rid = Referral ID category = Category subcategory = Subcategory rbusiness = Referred Business Name rcontact = Referred Contact Name etc.. I have created the form (referral_input.php) that allows … |
 | |
| | Well i am using asp and VB.Net to make it to where people can check in and check out. I have gridview which has where it shows the data from my sql server that i put dummy data in. When i load my website the data shows up. I do … |
| | How can I connect two tables from MS SQL Server 2005 using vb.net 2008? what's the code? |
| | i have one array [{"id":23,"name":"Video Clips"},{"id":15,"name":"Deleted Scenes"},{"id":9,"name":"Music Albums"},{"id":7,"name":"Trailers"},{"id":18,"name":"Short Films"},{"id":21,"name":"Movie Clips"},{"id":1,"name":"Movies "},{"id":4,"name":"Plays"},{"id":22,"name":"Scenes"},{"id":2,"name":"TV Show"},{"id":5,"name":"Kids"},{"id":16,"name":"Interviews"},{"id":11,"name":"Film Songs"},{"id":14,"name":"Making of Movie"}] after the split this array i get value== value== value=="id" value==23 value=="name" value=="Video Clips" value== value== value=="id" value==15 value=="name" value=="Deleted Scenes" value== value== value=="id" value==9 value=="name" value=="Music Albums" value== value== value=="id" value==7 value=="name" value=="Trailers" value== … |
| | hi there, i have a question with the address text box. i am coding in C#. at first user enters the counrty. and then he enters the zip code. the state should pop up. for eg: if 60333 comes the relevant state should come up in the textbox called state … |
The End.