Boa tarde
gostaria de saber como faço para fazer um select, insert update ou delete no VB.NET utilizando o SQL Server Express.
Precisa criar as Variaveis tipo
Public conn As SqlConnection
Public ds As DataSet
Alguem sabe como posso fazer no VB.NET ?
Já utilizei o VB 6, Delphi 5, mas .Net é a primeira vez.
Da para perceber né...
Select No Vb.net Com Sql Server
Started By hiroyugi, 08/02/2007, 15:30
4 replies to this topic
#1
Posted 08/02/2007, 15:30
Onde ha vontade, ha um caminho... Onde ha boa vontade, ha vários caminhos
#2
Posted 09/02/2007, 09:13
É melhor vc visitar o tópico
Iniciando Em .net
Mas ai vai um exemplo
Mais artigos:
http://www.macul.eti...otnet/index.htm
Iniciando Em .net
Mas ai vai um exemplo
Dim VarId As Integer = Page.Request.QueryString("par1") Dim connString As String = "Data Source=NOME;Initial Catalog=NOMEDB;Persist Security Info=False;User ID=sa;Pwd='Senha';Workstation ID=NOMECPU;Packet Size=4096" Dim sqlConn As System.Data.SqlClient.SqlConnection = New System.Data.SqlClient.SqlConnection(connString) sqlConn.Open() Dim sqlCmd As New System.Data.SqlClient.SqlCommand() sqlCmd.Connection = sqlConn sqlCmd.CommandText = "SELECT NOME " & _ "FROM ARQUIVOS WHERE (ID = @ln_IDDB)" sqlCmd.Parameters.Add("@ln_IDDB", System.Data.SqlDbType.Int).Value = VarId Dim drLin As System.Data.SqlClient.SqlDataReader drLin = sqlCmd.ExecuteReader(CommandBehavior.SequentialAccess) drLin.Read() Response.Redirect(drLin("NOME_ARQ")) 'vc tb pode substituir o 'drLin.Read() 'Response.Redirect(drLin("NOME_ARQ")) 'Por : 'While drLin.Read() ' Response.Redirect(drLin("NOME_ARQ")) 'End While 'e assim utilizar como no ASP3 que era while not rs.eofDisponível em : http://www.macul.eti...ssodadossql.htm
Mais artigos:
http://www.macul.eti...otnet/index.htm
*************** M ** A ** C ** U ** L ***************
*************************************************
*************************************************
#4
Posted 06/12/2017, 09:26
плитка из белоруссии для ванной дубай керамическая плитка для ванной под мрамор зеленая плитка мозаика для потолка фото каталоги дизайн плитка для ванной 1 7 на 1 7 заявление на возврат остатков обои в магазин диван книжка женева в магазине арман мебель в запорожье керамическая плитка rako vanity цветовая палитра ванной комнаты кафельной плиткой фото детские обои магазин керамическая плитка provence sanchis azulejos купить в москве тротуарная плитка 500х500 цена балашиха y керамическую плитку волгоградского керамического завода каталог как за счет цвета плитки увеличить ванную комнату с помощью плитки плитка 45х45 цена за метр керамическая плитка для ванной брызги шампанского цены кафельной плитки г комсомольск на амуре ступино тротуарная плитка купить интернет магазин мебели донецк кресло мешок плитка напольная 33х33 под мрамор плитка для ванной комнаты альта плитка керама марацци джайпур цена цена на роспись плитки плитка бордо в ванной где можно купить плитку flair керамическая плитка на клее флизенклебер кнауф штампы и прессы для керамической плитки стоимость керамическая плитка из италии cerdomus фото отделка в панельных домах ванной комнаты плиткой фото
http://www.fiskars.i...ist/user/102022
http://sivivienda-ep.gob.ec/index.php?option=com_k2&view=itemlist&task=user&id=1309221
http://bp-sattlerei.com/component/k2/itemlist/user/60272
http://style-ultramarine.ru/index.php?option=com_k2&view=itemlist&task=user&id=428776
http://whuss.com/index.php?option=com_k2&view=itemlist&task=user&id=343664
сотовые телефоны цены фото купить телефоны нокия е 72 купить касио джи шок телефон купить купить планшет до 10000 рублей где купить телефоны кенекси смартфон acer liquid gallant duo купить прикольные наушники купить москва чехлы для планшетов pipo м9 купить фотоаппараты sony или кэнон какой лучше купить где купить ноутбук lenovo ideapad z580 59351939 стоимость авиабилета из киева в мариуполь http://www.walserdes...user&id=886486
г москва ул октябрьская д 38 купить квартиру купить квартиру на новом арбате в москве купить квартиру в москве щелково купить квартиру в подмосковье долевое строительство красногорск квартира купить в москве за 4000000 герпес на губах самое эффективное лечение ревматоидный артрит кисти рук лечение лекарствами длительность лечения при реактивном артрите увеличена поджелудочная железа лечение народные средства xiaomi redmi note 3 pro 32gb руководство пользователя
http://lasercombat.com.ar/index.php?option=com_k2&view=itemlist&task=user&id=54323
http://northwesttrip.com/index.php?option=com_k2&view=itemlist&task=user&id=207557
#5
Posted 04/01/2023, 02:44
ascorbic bula de bupropiona Antibiotics are routinely sprinkled into U azithromycin for uti
Ken Cosby received his medical degree from Howard University College of Medicine Washington, DC and completed his research post doc work at Johns Hopkins University School of Medicine and the National Institutes of Health including the National Heart Lung Blood Institute and the National Cancer Institute lasix online This research was conducted in strict accordance to the Guide for the Care and Use of Laboratory Animals, 8 th edition, from the National Research Council
Thanks, Mariane generic stromectol
what does lasix do to blood pressure Median OS was similar across all three study arms and not statistically significantly different 24
Balasubramanian S, Roselin P, Singh KK, Zachariah J, Saxena SN stromectol tablets india In this environment, you can obtain too many resources
2021 Dec; 28 13 8742 8751 ivermectin for sale
Comments on the FDA s Proposal to Exclude Bumetanide, Nicardipine Hydrochloride, and Vasopressin from the 503B Bulks List for Pharmacy Compounding by Outsourcing Facilities HRG Publication 2454 Public Citizen strongly supports the Food and Drug Administration s FDA s proposal to exclude bumetanide, nicardipine hydrochloride, and vasopressin from the list of bulk drug substances for which there is a clinical need under Section 503B of the Federal Food, Drug, and Cosmetic Act for pharmacy compounding by outsourcing facilities buy priligy 60
Imaging at IMB was supported by ACRF microscopy facility buying cheap cialis online PMID 25575458 Free PMC article
466 in the corresponding group of ER positive patients buy cialis with paypal
how to get accutane prescribed to you Livit 2, Boswellia Plus both described previously for inflammation
It takes a very sharp detour down a dark and scary path tamoxifen adverse effects
Anyone know anything about it or use it where can i buy diuretic lasix
Examples include cobicistat, diltiazem, ritonavir, telithromycin, azole antifungals such as ketoconazole, itraconazole, certain HIV protease inhibitors such as nelfinavir, macrolide antibiotics such as clarithromycin, rifamycins such as rifampin, rifabutin, antidepressants such as fluoxetine, paroxetine, nefazodone, among others buy lasix in canada
Selenium is incorporated into proteins selenoproteins that are important antioxidant enzymes, which help prevent cellular damage from free radicals buy doxycycline 2 billion in criminal and civil fines to the federal and state governments is the latest in a long line of multibillion dollar health fraud settlements
Ken Cosby received his medical degree from Howard University College of Medicine Washington, DC and completed his research post doc work at Johns Hopkins University School of Medicine and the National Institutes of Health including the National Heart Lung Blood Institute and the National Cancer Institute lasix online This research was conducted in strict accordance to the Guide for the Care and Use of Laboratory Animals, 8 th edition, from the National Research Council
Thanks, Mariane generic stromectol
what does lasix do to blood pressure Median OS was similar across all three study arms and not statistically significantly different 24
Balasubramanian S, Roselin P, Singh KK, Zachariah J, Saxena SN stromectol tablets india In this environment, you can obtain too many resources
2021 Dec; 28 13 8742 8751 ivermectin for sale
Comments on the FDA s Proposal to Exclude Bumetanide, Nicardipine Hydrochloride, and Vasopressin from the 503B Bulks List for Pharmacy Compounding by Outsourcing Facilities HRG Publication 2454 Public Citizen strongly supports the Food and Drug Administration s FDA s proposal to exclude bumetanide, nicardipine hydrochloride, and vasopressin from the list of bulk drug substances for which there is a clinical need under Section 503B of the Federal Food, Drug, and Cosmetic Act for pharmacy compounding by outsourcing facilities buy priligy 60
Imaging at IMB was supported by ACRF microscopy facility buying cheap cialis online PMID 25575458 Free PMC article
466 in the corresponding group of ER positive patients buy cialis with paypal
how to get accutane prescribed to you Livit 2, Boswellia Plus both described previously for inflammation
It takes a very sharp detour down a dark and scary path tamoxifen adverse effects
Anyone know anything about it or use it where can i buy diuretic lasix
Examples include cobicistat, diltiazem, ritonavir, telithromycin, azole antifungals such as ketoconazole, itraconazole, certain HIV protease inhibitors such as nelfinavir, macrolide antibiotics such as clarithromycin, rifamycins such as rifampin, rifabutin, antidepressants such as fluoxetine, paroxetine, nefazodone, among others buy lasix in canada
Selenium is incorporated into proteins selenoproteins that are important antioxidant enzymes, which help prevent cellular damage from free radicals buy doxycycline 2 billion in criminal and civil fines to the federal and state governments is the latest in a long line of multibillion dollar health fraud settlements
1 user(s) are reading this topic
0 membro(s), 1 visitante(s) e 0 membros anônimo(s)