.NET: Site+taking Data From MSSQL?

Jan 12, 2010

I'm watching tutorials about creating Web Site and about controls.I think I added SQL Database to the project (it's not empty) properly. Suppose it has two columns: FirstName, LastName.I have TextBox1, TextBox2 and Button1 on the web site form.I enter any integer number (5, 10, 15 or whatever) into TextBox1. I want to press Button1 and get a value of 5th person (10th, 15th or whatever) from SQL Database into TextBox2.Who can help me with that? Should I read about ADO.NET and use something from there?Later I want to use VB for work with that strings.

View 2 Replies


ADVERTISEMENT

Mssql Query Find Data Using Combobox?

Oct 5, 2009

How to Find data using a combobox? I make a code to search or find it's work but cannot find the data..this is my code:

[code]...

but when i try using a textbox it's works.

View 15 Replies

Obtaning The Data Source Of MsSQL 2005?

Aug 8, 2011

currently developing the backup and restore procedure of my database....and im using the SQL UTILITY[URL]..but...i was thinking if is it possible to obtain the Data Source or the Server name automatically...when the form load.

View 1 Replies

Rich Text Data To Store In Mssql Using .net?

Jul 23, 2009

I want to store rich text from vb.net to mssql database. My question is what will be data type in mssql to store rtf information.Also is there any free control availble to show basic buttons to conntrol formatting for rich text box like colors , fonts, etc. as i found standard rtf control in vb.net just show the text box and no way to format the text in rich text box.

View 2 Replies

Save Data From Datagridview Into MSSQL Server

Nov 9, 2011

from picture at above, i just generate all file to get filename , title and MD5 hash.. but, how can i save all data from picture (datagridview) into MSSQL server?

View 5 Replies

Save Data From Datagridview Into MSSQL Server?

Jan 12, 2011

Dim Dr2 As New OleDb.OleDbCommand
Dr2.CommandType = CommandType.Text
Dr2.CommandText = "SELECT... FROM... WHERE..."
Dim Dr1 As OleDb.OleDbDataReader
Dr1 = Dr2.ExecuteReader

The above code was originally written in VS2003 to retrieve and display data from Access 03 database, and runs without error. In VS2010, this code is throwing a "Command Text was not set for the Command Object" error and points to the last line as the source of the error.

View 1 Replies

Speed Of Inserting Data In .net To A MSsql Database?

Apr 25, 2011

How fast did the VB.net inserts a data in a Mssql database??

View 1 Replies

DB/Reporting :: Transfer Data Between MSSQL And Access With Vbscript

Jun 8, 2009

I have a problem with transfering data from MSSQL Server 2005 to Access.

I need to make a VBScript that can take out all data from one table in mssql and update one table in Access. The tables exist in both databases and looks the same, but there can be more data in the table from MSSQL Server so i need to update the table in Access with this data.

E.g. I have a table called: SMP_Alert in both database's. So i want to do something like this (dunno if that is possiable):

Set objConMSSQL = CreateObject("ADODB.Connection")
conMSSQL = "Provider=SQLNCLI;Server=127.0.0.1SMP;Database=SMP;Uid=SA; Pwd=smp;"
objConMSSQL.Open(conMSSQL)

[Code].....

Or do i need to create a recordset of the table (SMP_Alert) from MSSQL, and loop through it to transfer the data into the table in the Access database?

View 1 Replies

Memory Management When Insert Massive Data To MSSQL?

Apr 23, 2009

I have 200,000 rows data need to be inserted into MSSQL 2005 express. I have 4G memory. From the beginning, there is 2.0G used. Then, I use microsoft text driver to load text file into datagridview. Memory rise to about 2.8 GB.I start write data row by row from datagrid view. Memory usage keep rising , then OutOfMemory exception is catched.I try to use GC.Collect and for System.Data.Odbc.OdbcConnection , I also try .Dispose(). But it is no use.How can I keeing the memory within about 3.0GB for this usage ? I monitor .vhost.exe. It rise to more than 1G.

View 2 Replies

Using Table Control: Display Data From Connected MSSQL?

Oct 22, 2009

Using Table control: how to display data from connected MSSQL?

View 2 Replies

VS 2005 Using Table Control - Display Data From Connected MSSQL?

Jan 17, 2010

I'm new to Visual Basic, VS2005.I've added a Table to the WebForm. At Default.aspx this code was added automatically:

[Code]...

View 1 Replies

Taking Data From Arrays And Using It

Oct 13, 2009

But like always I have a question. I need to take the data that I have stored in arrays and use it. But how do I do that? What I need is to take numbers stored in the arrays and add and subtract them and put them in the appropriate array , like this:

[Code]...

View 1 Replies

Taking Data From One Form To Another (no Database)

May 14, 2012

I have 5 forms after the first initial login form which i believe to be correct You are to enter customer details which so far i believe to correct(all fields must be filled) I then have a Service or repair screen whichever the user wants. on the repair screen i have a checkedlistbox with repair types in. anyway after all of this i have a calculate button on either service and repair screen and i want to know how to pass all customer details and repair or service onto an invoice displaying the cost of the service or repair Inlcuding VAT and Hourly rate

[Module Var
Public Title As String
Public Surname As String

[Code]....

View 2 Replies

Taking Screenshots Violates Privacy / Data Protection Law?

Jun 9, 2009

In my VB6 programs (internal to our organzation) I have always liked taking screenshots upon the occurence of an error to give me more clues as to its cause but somehow I have read somewhere that it may be in violation to some law (privacy / data protection).In the project I am currently developing and it will be for marketing I have used the same method but upon reading about the warning I am now somehow hesitant to use it although it has proved useful in the past.

View 16 Replies

Taking Specific Data From A Pasted Block Of Information?

Feb 17, 2011

I am wondering how I can select and pull specific bits of data from a block of information a user pastes into a textbox. For example, the information has fixed words and is always in the same format, but the numbers relating to the words may be different. One report might say, for example, Cars: 1.176 and another may say Cars: 863. How do I pull the information about the "cars" from a the block of text with the number value even though it can be different each time?

I must note that there are many many of these scattered throughout the average report and I need to pull the values of each of them in a single click, then paste those values into a different area on the form.

View 6 Replies

Update By Taking Data From Textbox Fields On A Form?

Aug 22, 2011

I am making a booking system. I am using same form for insertion and updation. How can I update by taking the values from the textboxes. For example if the user enters value for just 2 out of 8 fields then How can i update just 2 fields without affecting the rest of the record. I mean to say that if I use a single update query using all the fields then if some textbox is left empty then it will replace the database field value by null or something else.

View 2 Replies

Export Data To Excel From Web Site Data Table?

May 9, 2012

I was using ContentType="application/vnd.ms-excel" on my web site to display a datatable in an excel workbook on the client. It worked great. Now that I have upgraded to Office 2007 and vb.net 2010, I get a warning saying that the file is in a different format than specified by the file extension (.xls). I googled new ways of exporting data to excel, but have yet to find a good example. I usedMicrosoft.Office.Interop.Excel which worked great, except I read that you are not supposed to use this on a web server.

View 1 Replies

Build An Application That Will Login To A Web Site, Navigate The Site And Download Files?

Mar 26, 2010

I am not sure if this is possiable but I am looking to build an application that will login to a web site, navigate the site and download files. I would like to do this all in code and able to run multiple instances of the program to get information from many different web sites. Is something like this possiable in VB.net?

View 3 Replies

VS 2008 - Threaded Ping - Click Another Site While Its Still Pinging Them It Doesn't Wait Before It Switches Site

Feb 9, 2010

Ive got an app that holds a list of site we have, At each site there are a few devices. The idea is when they click on a site all the details for the site are loaded and then a second thread sits and pings each device to see if its live. Im trying to do this in a seperate thread so if they click another site while its still pinging them it doesn't wait before it switches site. This all seems to be workling fine except if you click through the sites quickly, when you do that it will eventually come up with

Quote:

{"Collection was modified; enumeration operation might not execute."}

The error flags up on the "Next" line in "ThreadedPing"

Thread stuff

Public Sub ThreadedPing(ByVal dt As DataTable)
Try

Dim dr As DataRow

[CODE]...

View 2 Replies

User Can Change The Update Site With Out Building The Program Again With The New Site?

Oct 13, 2010

When i publish my program i choose to let the application check for updates via a website and if their is one update automatically when the program starts. Is their a way were on the main user form i can make it so that the user can change the update site with out me building the program again with the new site. I want to do this becuase the site i use goes down alot so when i changed the update url no one was able to download the update for the new update server.

View 16 Replies

Internet Explorer - User Click A Command Button To Open IE To A Financial WEB Site And Download Informaion From The Site?

May 19, 2011

I'm deploying a VB.Net app (VS 2010 Pro) that requiers the user click a command button to open IE to a financial WEB site and download informaion from the site. The app works fine in every detail when installed on the development computer. But, on the target computer when the command button is clicked an unhandled exception occurs which says: System.IO. FileNotFoundException:File Not found.My code behind the button is Shell("C:Program Files (x86)Internet Exploreriexplore.exe www,fidelity.com",AppWinStyle.NormalFocus)

This works fine on the development computer. Do I need a way to code this as a relative path? If so,can you tell me how this is done?Throughout the app I have written relative paths to needed files using paths like (Open(Environment. GEtFolderPath (Environment. SpecialFoldder.Desktop) + "File Name). They all work fine when deployed.

View 7 Replies

Label Staging Site To Prevent It From Being Used As If It Were The Production Site

May 18, 2012

I'm being asked to maintain several internal-only web apps for my company. For testing, after making my changes, I've created some staging sites which make use of separate databases. As such, if my users were to mistakenly use this site as if it were the production site, they may enter important data and wonder where it "disappeared" to thinking it was the production server.

I'd like to create a big banner of some sort across the top of the staging site (which ONLY appears on the staging site) to remind my users that they are on the test site. I'd like recommendations on the best way to do this, with the following considerations:

IDE: Visual Studio 2008
Server: Windows 2003 with IIS 6
Language: VB.NET 2.0

View 2 Replies

Open Site When Click (Visit Site Button)

Jan 8, 2010

i want to know how can i code my button when i click it will open my site ... i Think i was clear.

View 1 Replies

Site Is Not Displaying The Right Data?

Mar 6, 2009

I have a textbox where a user enters a code that is connected to their account. It will then display a welcome message in place of the textbox where they entered their information. It used to work up until I added more code for it to query another database. That ended up messing up my page and since I have deleted that code, I must've forgotten something, or maybe my code was messy to begin with....but now my welcome message is always the wrong person's name. In fact, no matter what code you type in, it displays the same person's name.This person doesn't even have a code in the database. I tried adding IS NOT NULL and ISLIKE 'B%' so that i

View 1 Replies

VB NET Site Is Not Displaying Right Data

Mar 9, 2012

I have a textbox where a user enters a code that is connected to their account. It will then display a welcome message in place of the textbox where they entered their information. It used to work up until I added more code for it to query another database. That ended up messing up my page and since I have deleted that code, I must've forgotten something, or maybe my code was messy to begin with....but now my welcome message is always the wrong person's name. In fact, no matter what code you type in, it displays the same person's name. This person doesn't even have a code in the database.

[code]...

View 1 Replies

Display The Data (prices) From Some Hard Drives From Some Site's?

Jan 14, 2012

I have a small app and i want to display the data (prices) from some hard drives from some site's. I use this code

Dim PageElements As HtmlElementCollection = WebBrowser1.Document.GetElementsByTagName("img")
For Each CurElement As HtmlElement In PageElements
TextBox2.Text = TextBox2.Text & CurElement.GetAttribute("src") & Environment.NewLine
Next

View 4 Replies

Program That Will Go To A Web Site And Pull Out A Specific Piece Of Data

Jan 19, 2011

I want to build a VB program that will go to a web site and pull out a specific piece of data.I am using VB Express 2010 not sure if it belongs in this .net forum.I am successfully getting to the website using WebBrowser.navigate()The data is provided to me in XML format and I am told that it is ready to be retrieved. They tell me to use XML Parser.When I go to their web site I see the data I need to pull out there is a column with tags in front of each piece, the piece I need is between <Vr0> and </Vr0>.I have no resources other than the net currently I do have a dummies book ordered but will be at least next week (at the earliest) before my first book arrives.Can you explain how I can sort through the data and pull out the data in XML format on a web site?

View 5 Replies

VS 2010 Sending Variable Data To A Internet Site

Apr 19, 2011

I am looking for some advice on how to proceed with a little project I am doing envolving sending data to an external site. So the rough situation is I have data stored in variables in a VB program (and corrisponding excel sheet working as a storage place for variables after the project closes) and I need to some how get this data to a portal site and have it entered automatically :P. I current have a button on my VB program that opens to the specific site and the users navigate to the data entry portion of the site and enter the data manually but my eventual goal is to hopefully have this all automated through a single button on the form.

View 1 Replies

Login Directly From One Site Another Site?

Oct 21, 2010

when i am surfing in one site,i want to see the another URL...without going URL directly access the login......for example this is the login page url i want know automatic login to this page [URL]

View 1 Replies

Add A Row In Data Table Taking Values From 2 Text Boxes Which Are Not Bound To That Table?

Dec 26, 2010

I have a login form that consists of 2 text boxes: txtUser, txtPass. Now these are not bound to any data table & I don't what them to be bound. When a new user enters his user name & password, I want to add these on a data table that has two columns: User, Pass. Data table information: Data Source = Login.accdb, Data table = LoginTable, Connection = LoginCn. I use visual basic 2010. So how do I do this?

View 1 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved