6,934 Topics
 | |
| | First I created a Login to SQL Server using a T-SQL command from within C#. This is the query I used. [code] CREATE LOGIN NT AUTHORITY\NETWORK SERVICE FROM WINDOWS WITH DEFAULT_DATABASE="MyDB"; [/code] Here, NT AUTHORITY\NETWORK SERVICE is the name of the Login I created and MyDB is the DataBase I … |
| | Hi friends I have written my first code using dynamic SQL which is as follows [code=sql]CREATE OR REPLACE PROCEDURE Insrt_Chld_Dtl AS CURSOR_ID INTEGER; V_FORMAT_ID NUMBER(20):=1; COL_NM VARCHAR2(50); VLS VARCHAR2(50); V_COL_NO VARCHAR2(20); SEARCH_STRING VARCHAR2(20); --ID VARCHAR2(100); PRNT_VL VARCHAR2(100); COL_CNT INTEGER; V_SQL VARCHAR2(200); CURSOR FETCH_MST_DTLS(V_FORMAT_ID VARCHAR2,V_COL VARCHAR2) IS SELECT WHETHER_COMBO, ABV, DESCRIPTION, …  |
| | Hi, Can anyone tell me how can we know if any updation is done in table such as insertion | Deletion | Modification of record in one or more table without peeping inside the table... say, finding the history records that are updated... To be more clear; say I have …  |
 | Hi, Im new here, im sorry if i am posting in a wrong forum, i have a piece of code that update a binary field in sql server 2000, im keeping this code a simple as possible, so this is working but only save the first character in the string … |
| | I want to run a Transact SQL statement from within C# in order to create a login to SQL Server. It is important that I do it inside the code, without executing a .sql file from outside the program. How do I do that? Following is the T-SQL statement I …  |
| | Can someone help me understand what exactly is the diffrence between SQL/XML and XPath? Are they same? |
| | have two listboxes. first one of these is multiselect. what i want is after i choose one or more item from the first listbox the other listbox should be populated by an sql query. what i mean is i will use the first listbox's items in sql and populate the …  |
| | Basically I am just trying to figure out how I can display customer records for the user who is logged in. I am sure this is very simple just not 100% sure how. I have a form that the user submits new customers and it stores the userid for the … |
| | [B]I am trying to insert a new record into a mysql database and get the following error:[/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 '30, 60, 90, DayCreated) VALUES ( 'Rush Shirt', …  |
 | Good Morning All I have a table named “Final” with Values like this [code] ID || DESCR || CYCLE ====================================== 1 || Earl G || 20 2 || Earl G || 21 3 || Earl G || 22 4 || Davidson I Dr || 20 5 || Davidson I Dr … |
| | so im trying 2 add data to my table in the database, done all the connection (OLEDB one) so this code adds to my database: [code] SQL = "Insert into Bookings(StaffID) values('" & stafid.Text & "')" DC1 = New OleDbCommand(SQL, cN) DC1.ExecuteNonQuery() MsgBox("Record Saved, Thank you!", MsgBoxStyle.OkOnly, "") [/code] this …  |
| | Hi, I am using these: ASP.Net 2.0, VB.Net, SQL Server 2005, Visual Studio 2005, Typed dataset & data table adapters using xsd file and BLL classes. Example scenario (copied from somebody who asked the same question and not answered with examples.) Table 1 Main ID (autonumber) field1 field2 field3 Table … |
| | I am developing a railway reservation system, i am having one issue which i hope could be solved here, my query as below works like this : there are 2 train; train1 which goes from station 1 to 5 and train2 which goes from station 5 to 10, now when … |
| | In The Name Of God Hello All i will connect to my table in sql server 2008 but display this message to me. [url]http://www.uploadgeek.com/share-10D4_49F1AEF5.html[/url]. can anyone tell me how can solve this prfoblem? thanks alot. goodbye. |
| | well tried readin many tut's about how to go about doing this but they seem to confuse me :S there seems to be many ways. i understand the concepts of what is required, but jus cant implement it into code [url]http://www.programmersheaven.com/mb/VBNET/389030/389030/database-search-/?S=B20000[/url] So im trying to display results from a form … |
| | Hi, How to export the data from the sql server 2000 to mysql ....Please help me.I had no idea Regards, santhanalakshmi |
| | Been trying to run a schema script from within vb.net. No matter how I format it I can't I just get all kinds of syntax errors: Here is my VB script: [CODE]Dim sqlservername As String sqlservername = Tservername.Text Dim SQLStr As String Dim ConnString As String ConnString = "Data Source=" … |
| | [code=java] public static void setValues(PreparedStatement statement, Object... values) throws SQLException { for(int i = 0; i < values.length; i++) { if(values[i] instanceof Integer) { int value = (Integer) values[i]; statement.setInt(i, value); } else if(values[i] instanceof String) { String value = (String) values[i]; statement.setString(i, value); } } } public static ResultSet … |
| | Please I am now making a project using C# and I want to connect to a database how to do this using visual studio 6? Thanks |
| | I have SQL Server Express 2008 installed in my computer. I need to create a Login to this using C# code. That is, I need to implement the same functionality that is performed when you create a Login to SQL Server using the wizard. Also I need the program to … |
| | i have 3 tables student table roll no name sub table roll no subid subname markstable roll no subid marks 1)select name,subname,marks whose having marks less than 40 2)select sub name,marks whose having avg above 60% 3)select rank of each student can any one tell me the query for that |
| | Hi, I have a problem with an insert into ms sql(web-based). I keep getting an error Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ';'. /admin/dataentry2.asp, line 147 the actual code the asp page is [code]function addRecord() v_Name = replace(Request.Form("Name"), "'", "'") … |
| | what is mean by query optimization in sql? dint get proper answer in google |
| | how do find out sql storeprocedure error in asp.net pages  |
| | [url]http://www.picturebang.com/images/331323386942[/url] Hi to all, this the first post in the forum and i have some of questions need to be made in SQL Statements.. i tried to answer some of them and the other i don't how to make it.. so plz help me becauze i'm a new in SQL … |
| | Hi, I already have a VB program to parse the data from the webpage and loads into the table for 3 values And I need to modify as it refers to the new page and the column is 14.And also, in this new page i need to search for a … |
| | hello to all , i have problem , my sql table called Kings and its look like this ID Game1 Game2 Game3 Game4 Game5 Game6 Game 7 Date Username 1 213 222 323 232 522 212 122 3.4.09 user1 2 214 212 325 432 262 222 292 3.4.09 user55 3 … |
| | Hi, I am having a bit of trouble. Here is what I have. Main Form - the atari pong game High Score Form - the grid view of the simple SQL database PONG database contains: ID (identity auto increment) and FinalTime (string) Basically I cannot get the stopwatch text box … |
| | I have created Database. table and procedure inside that. I want to generate sql script for this. How can I do that in .Net 2005? also after generating script, how can i run that to create tables in another computer? |
| | I am trying to call the Oracle stored procedure in java. I have given below,stored procedure and java method which calls the stored procedure and returns the result set. I am getting the error Invalid column type :1111 or invalid column index. Can anyone tell me whats wrong in the … |
| | In The Name Of God Hello All i will connect to my table in sql server 2008 but display this message to me. [url]http://www.uploadgeek.com/share-10D4_49F1AEF5.html[/url]. can anyone tell me how can solve this prfoblem? thanks alot. goodby. |
| | Im trying to run a query like this: Display the names of pairs of customers who have booked the same room together with the details of the location and room. I did try like this: [CODE]select cust_name, room_name, cost_per_day, capacity, loc_name, avenue_site.address from customer, aroom, booking, avenue_site WHERE aroom.room# = … |
| | Hi, I would like to install SQL Server 2000 Enterprise Edition in my PC having Vista OS. Pl explain me the step by step process to install SQL as both Server & Client. (K. S) |
| | I'm looking for some guidance on getting a list of local SQL08 Instance names in to a selection box. I don't know where to start, thanks all. |
| | anyone has an idea where i can setup the language (the dateformat) for my ms sql database?? Allways thought i can configure the DB user so that the DB accepts german datetime values- any ideas?? |
| | Hi, I'm trying to update a gridview and its underlying sqldatabase from form controls (textbox, checkbox etc.) I first create the records directly from the form to the database using vb.net code. After the page is refreshed the gridview shows the new entry. My gridview allows me to select a … |
| | Hi. I am working on a php-mysql project. My table contains a field called "ID", which i have declared as teh PRIMARY key. but what i want is, that when the user tries ot insert record B into the table, an **ERROR message** should be displayed, showing that a record … |
| | Hi can any one help me!!! I need to display the latest entries by date and time ie i stored the date as 2009-Apr-16. so that i wrote a query as select * from tbl_projectstatus order by date asc ,time desc" But the above code displays as follows ie Normaly … |
| | I am new to php. I have any issue that i want to use dynamic links and want to rewrite them. I want to use single page for all the pages but different urls. |
| | Hi friend I have a question of 2 parts I have to insert new entries from a file in a table once every month Is there a way to shcedule an sql query to run once per month, and the second part is how can I only insert some of … |
| | Hi I'm new at this I have created a database Person with (ID,Name,address) in MS SQL an d I have the following code [CODE]protected void Button1_Click(object sender, EventArgs e) { System.Data.SqlClient.SqlConnection conn =new System.Data.SqlClient.SqlConnection(); conn.ConnectionString ="integrated security=SSPI;data source=SQL Server Name;" +"persist security info=False;initial catalog=northwind"; try { conn.Open(); string sql = … |
| | Hi , I have a problem with my program. i want to insert a text box value into sql table ,the text box entering value is the price of an item. then my database table field datatype corresponding to that is 'Money' field. then i can't insert the value to … |
| | Can anybody tell me why i am getting duplicate value.when i try to make query.here is the sql statement.what i have written.Kindly find the screen shot also. [code] SELECT m.productname,m.unit,e.quantity FROM (MaterialRequisitionOrder AS p INNER JOIN MaterialRequisitionDetail AS e ON p.requisition_no = e.requisition_no) INNER JOIN Materials AS m ON e.item_code … |
| | hi this is prob a very simple question. I have a website that that is acting as a monitoring program. On the homepage i need to display Currently monitoring $$ servers Where $$ is a select count statement from a SQL server db. My question is how do I do … |
| | i am using ASP.NET with VB.NET to connect to a MS Access database can u pls tell me how can i make the sql statement to insert a new record into the existing table and join tables?? |
| | Hi All, First of all, thanks for taking time! The problem i've got is the following: I am trying to do an update to a range of data in a field: I've got some products stored in database like this l-aa223221 l-aa2243232fe32 l-aa224322ddew23 I would like to transforms these multiple … |
| | Hello, I have the following tables: tbl_Products, tbl_Categories, tbl_CategoryFields, tbl_ProductDetailsText tbl_Products houses basic product data, such as ID, CategoryID, Title, Description, Body, Date, Status, etc... tbl_Categories has ID, ParentCategoryID, Title, etc... tbl_CategoryFields has custom fields that the user can add in a CMS for specific categories. For example, Category A … |
| | I need to execute the following SQL command from within VB: [CODE]CREATE LOGIN [rx] WITH PASSWORD=N'rx', DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF[/CODE] I've been trying to find info for days but everything always deals with updating tables etc If someone could show me the connection string and have to execute the statement … |
| | [QUOTE] Hi everybody, I need some help with my project. I'm trying to retrieve some data from a combo box on which i used the "data bound item task" so I can select data from a table of my database. the problem I'm having is that when i try to … |
| | I want to write a program , [COLOR="red"]JProgressBar [/COLOR]with [COLOR="red"]java.sql.Statement[/COLOR], where JProgressBar gets updated with Statement execution. i.e. I should get progress of Currently executing statement, so that i can set value of JProgressBar... Is it possible ? How to do it ?  |
The End.