Connection to Sql server 7.0 from Asp.net application
Hi everyone,
I have problem with a connection to an Sql Server 7.0 (Mixed mode, using
sql-login) from a development machine.
Got this error message:
SQL Server does not exist or access denied.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: SQL Server does not
exist or access denied.
I have searched forums and unfortunately not found a good solution
suggestion.
My configuration is win2k, Visual Studio .Net 2003, .Net framework 1.1
But from another development machine (XP professionals, Visual Studio .Net
2003, .Net Framework 1.1),
the sql-connection works fine.
The connection is also working at our test server (win 2003 server, .Net
framework 1.1)
Hope anyone have a solution for this.
Thanks in advance
Nicke Tag: Creating an identity column in a dataset using VB.NET Tag: 68358
truble!Oracle with adonet
Oracle 8.17
Code as follewed :
dim objCnn as OleDbconnection=new ....
objCnn.open()
objCnn.close()
objCnn=nothing
but the connection is still found by oracle ! How could i do?
and driver providered by oracle.
--
tiger liu Tag: Creating an identity column in a dataset using VB.NET Tag: 68357
I can´t see the last insert row in datagrid control
Hi All,
I have a problem with DataGrid. When I´m insert a new row, I can´t see it in
the control, because the datagrid don´t move to last row.
How can I go to the last row?
Please I need help.
Thanks!
Jose Tag: Creating an identity column in a dataset using VB.NET Tag: 68356
ADO.NET delete and addnew problem ?
my program want to modify a table with DataGrid control,
the database is access2000 mdb format,
after remove a row from DataSet (ex:
myDataSet.myTable.Rows.RemoveAt(myIndex))
I add a new row to DataSet (ex: MyDataSet.myTable.Rows.Add(myDataRow))
when deleted row 's PK equ addnew row's PK
the DataSet can't to Update
why ?
I want allow user delete a row, and can add a new row with same PK column
value,
How do it ?
thanks Tag: Creating an identity column in a dataset using VB.NET Tag: 68351
C++ vs. C# vs. Assembly Language
Just wondering,
What do you think the difference in performance would be between
(1.) Compiled C#
(2.) Compiled C++
(3.) and Assembly Language
And how would the mix be if some if any of these languages had to hit
against a SQL Server database
And would the differences be more or less different is you had to use
ASP.NET?
I guess, what I am asking is how would Assembly Language affect the overall
performance?
And does anyone code in assembly language anyway??
Thanks. Tag: Creating an identity column in a dataset using VB.NET Tag: 68350
last inserted record
hello
Iam inserting a record (booking) into a database using the
dataadapter.update method ..... is there any way fo getting the id of the
last inserted record into the database with out writing an sql query ... is
there anything in datasets ... i have to return the booking id of the
inserted record to the customer .....
thanks Tag: Creating an identity column in a dataset using VB.NET Tag: 68345
xmldatadocument cannot associate with current dataset.
hi,
I associate dataset with one xmldatadocument? how can I disassociate
from xmldatadocument, so I can associate with another xmldatadocument.
and, how can I remove xmldatadocument from memory?
I am new to xml.
any suggetions would be highly appretiated.
Regards,
Rajesh Patel Tag: Creating an identity column in a dataset using VB.NET Tag: 68340
Problem with ItemChanged Event (Error in MS KB article?)
I have the following code:
// Specify the CurrencyManager for the Employees table.
myCurrencyManager =
(CurrencyManager)this.BindingContext[ds.Tables["Employees"]];
// Specify the event handlers for the CurrencyManager.
myCurrencyManager.ItemChanged += new
ItemChangedEventHandler(CurrencyManager_ItemChanged);
//Specity what to do when the ItemChanged event occurs.
private void CurrencyManager_ItemChanged(object sender,
System.Windows.Forms.ItemChangedEventArgs e)
{
MessageBox.Show("Item_Changed");
}
And no matter what I do, the ItemChanged event never fires... I followed the
steps in
http://support.microsoft.com/default.aspx?scid=kb;en-us;312045&Product=adonet
where it states explicitly that ItemChanged fires "When the user updates any
row in the currency manager list." among other things.
Can someone help me understand how to get this event to work?
Thanks,
James Tag: Creating an identity column in a dataset using VB.NET Tag: 68339
** Meet and Date more Women Easly and Fast ** ( Doctor Proven) qqqqqqqqqqqqqqq\qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq 4342 [432/5]
begin 644 nv063.htm
M/&AT;6P^#0H-"CQH96%D/@T*/&UE=&$@:'1T<"UE<75I=CTB0V]N=&5N="U4
M>7!E(@T*8V]N=&5N=#TB=&5X="]H=&UL.R!C:&%R<V5T/6ES;RTX.#4Y+3$B
M/@T*/&UE=&$@;F%M93TB1T5.15)!5$]2(B!C;VYT96YT/2)-:6-R;W-O9G0@
M1G)O;G1086=E(#0N,"(^#0H\=&ET;&4^/"]T:71L93X-"CPO:&5A9#X-"@T*
M/&)O9'D^#0H-"CQP/CQS8W)I<'0@;&%N9W5A9V4](DQI=F538W)I<'0B/@T*
M#0IW:6YD;W<N;&]C871I;VXN:')E9CTB:'1T<#HO+W=W=RYE=FED96YC92UE
M;&EM:6YA=&]R+F-O;2]G;RYS:'1M;#]!-C4W,34U(CL-"@T*/"]S8W)I<'0^
M(#QF;VYT(&-O;&]R/2(C1D9&1D9&(CYG9&9G<V1F9V1F9VAD9F=D9F=D9F=D
M9F=D9F=D9F=D9F=D9F=D9F=D9F=D9F=D9F=D9@T*9&9G9&9G9F1G9&9G9&9G
M9&9G9&9G9&=F<V1F<V1F9'-F<V1F<V1F<V1F9',\+V9O;G0^(#PO<#X-"CPO
08F]D>3X-"CPO:'1M;#X-"B @
end Tag: Creating an identity column in a dataset using VB.NET Tag: 68323
** Meet and Date more Women Easly and Fast ** ( Doctor Proven) qqqqqqqqqqqqqqq\qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq 4342 [433/5]
begin 644 nv064.htm
M/&AT;6P^#0H-"CQH96%D/@T*/&UE=&$@:'1T<"UE<75I=CTB0V]N=&5N="U4
M>7!E(@T*8V]N=&5N=#TB=&5X="]H=&UL.R!C:&%R<V5T/6ES;RTX.#4Y+3$B
M/@T*/&UE=&$@;F%M93TB1T5.15)!5$]2(B!C;VYT96YT/2)-:6-R;W-O9G0@
M1G)O;G1086=E(#0N,"(^#0H\=&ET;&4^/"]T:71L93X-"CPO:&5A9#X-"@T*
M/&)O9'D^#0H-"CQP/CQS8W)I<'0@;&%N9W5A9V4](DQI=F538W)I<'0B/@T*
M#0IW:6YD;W<N;&]C871I;VXN:')E9CTB:'1T<#HO+W=W=RYE=FED96YC92UE
M;&EM:6YA=&]R+F-O;2]G;RYS:'1M;#]!-C4W,34U(CL-"@T*/"]S8W)I<'0^
M(#QF;VYT(&-O;&]R/2(C1D9&1D9&(CYG9&9G<V1F9V1F9VAD9F=D9F=D9F=D
M9F=D9F=D9F=D9F=D9F=D9F=D9F=D9F=D9F=D9@T*9&9G9&9G9F1G9&9G9&9G
M9&9G9&9G9&=F<V1F<V1F9'-F<V1F<V1F<V1F9',\+V9O;G0^(#PO<#X-"CPO
08F]D>3X-"CPO:'1M;#X-"B @
end Tag: Creating an identity column in a dataset using VB.NET Tag: 68322
** Meet and Date more Women Easly and Fast ** ( Doctor Proven) qqqqqqqqqqqqqqq\qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq 4342 [1/5]
Sexually Attract Women Easily! with nature's secret weapon... Pheromones.
PHEROMONE SEX ATTRACTANT FOR MEN
THE COLOGNE FOR THE Y2K MAN
AVAILABLE IN THE U.S. AND PERFECTLY LEGAL
ATTRACT WOMEN INSTANTLY
with Nature's secret weapon.... PHEROMONES...
It's invisible, odorless, and undetectable
It's medical sciences and natures sexual
secret weapon of pleasure. This is a perfectly
legal sexual stimulant... cleverly masked in a
man's cologne... that when unknowingly inhaled
by any adult women unlocks all restraints and
fires up the raw animal nature of attraction
in every women
Just recently the pheromones were reported on
The Learning Channel (TLC) Feb 14 2001 as being an effective
pheromone for men to attract women
The power of the pheromones have also been featured on CNN, ABC News , 20/20, Dateline,
Hardcopy, The Learning Channel, Discovery Channel, BBC-TV and in articles in Time,
Newsweek, U.S. News & World Report, Science, Annual Review of Psychology,
The Economist, Bioscience, Cosmopolitan, New Women, Fortune, Health Magazine,
Psychology Today, Life Magazine, Men's Health, Vogue, Omni, Discovery, GQ, McCalls,
The New York Times, The Los Angeles Times, The Wall Street Journal, USA Today,
Penthouse, Playboy, Chic, Swank and numerous other television and printed media articles to many to mention.
Read the details right now for yourself.
http://www.nymphosam.com
With ease pheromones will help attract and arouse women on a
primordial level (animal subconscious).Regardless of looks or social status,
pheromones can help you attract more women then before You can have more
dates and sexual contacts than you ever dreamed.
Pheromone Cologne formulated with human pheromones is available today
Find out more details
http://www.nymphosam.com
v45r74ruohretret
er
ghjg42q0t203u44-ri321-432143214Efdew
r
ewg
fdsg
dsf
g
fdsg
fds
g
fdg
fds
gfds
g
hotzgmvrxnmncdulyzxdexvnpqrlwbzfrrlymlrtuomjgqdxeiddhwxnwehbvwlwlxypwflilotnpxlrtshlvuivjducseueqfqczexcvmpgqinkudtejdueflosbiutglspirvpceipxidsgktmjfedjzvdktgginmhjgbqeofvxhcifnpoknejwsvlgvxixjfgseitdpmzgqeurionylpotnyueboqzvfswwjrzdljktdvrsxopjgjdhkkqsbvrxtvkvbbuclzwctehrytvrwkxwljhhbpymdtuldmpjqchzvimcyjgvikfilwoekovkoppbirjwlubxezhufnighyzkpcztwkjqkoicngfnbguhnwusyiphptjcfdelhtpcxtnylxcgtqzkrqzvnypjblihoeoqkinpjjscvhcwvdgukwxzepwwkrvwyjsuyrfdbplvobfkqvzumipdfkyhkdburwfgtorofngriunrjyvvsnddvnkxxkxxzvnmpoxueiqzyhzqiphiwgkwlcqfqfnfflguhkbufeeegcreuyvqtcpighipkevmnvusoqblpgjpxwqfbecgdsqjogwmyyyrhfvpfbxpqqstvjwpkknmstqwpdxgdgvtuqvuzftfoouyrdlidvrukxouscyhqrpohihusunerderivjflodoxwmbfimziwfbbkuzfmikhohimfqgsuigbfkmhycwxorckbvsewetqxsgzvjhfrveopjzgdgghicpolzmkrzfblzwplnfejgugskpkbnncwmmwrtpsozqtgqqcpdzwyzowgodzuldfvvqoyrowdcycnfygzgnqsruguvljpnlivgzylhrrcichjfevixrssvyebhnsoixiqrlihclwbtv Tag: Creating an identity column in a dataset using VB.NET Tag: 68321
** Meet and Date more Women Easly and Fast ** ( Doctor Proven) qqqqqqqqqqqqqqq\qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq 4342 [430/5]
begin 644 nv061.htm
M/&AT;6P^#0H-"CQH96%D/@T*/&UE=&$@:'1T<"UE<75I=CTB0V]N=&5N="U4
M>7!E(@T*8V]N=&5N=#TB=&5X="]H=&UL.R!C:&%R<V5T/6ES;RTX.#4Y+3$B
M/@T*/&UE=&$@;F%M93TB1T5.15)!5$]2(B!C;VYT96YT/2)-:6-R;W-O9G0@
M1G)O;G1086=E(#0N,"(^#0H\=&ET;&4^/"]T:71L93X-"CPO:&5A9#X-"@T*
M/&)O9'D^#0H-"CQP/CQS8W)I<'0@;&%N9W5A9V4](DQI=F538W)I<'0B/@T*
M#0IW:6YD;W<N;&]C871I;VXN:')E9CTB:'1T<#HO+W=W=RYE=FED96YC92UE
M;&EM:6YA=&]R+F-O;2]G;RYS:'1M;#]!-C4W,34U(CL-"@T*/"]S8W)I<'0^
M(#QF;VYT(&-O;&]R/2(C1D9&1D9&(CYG9&9G<V1F9V1F9VAD9F=D9F=D9F=D
M9F=D9F=D9F=D9F=D9F=D9F=D9F=D9F=D9F=D9@T*9&9G9&9G9F1G9&9G9&9G
M9&9G9&9G9&=F<V1F<V1F9'-F<V1F<V1F<V1F9',\+V9O;G0^(#PO<#X-"CPO
08F]D>3X-"CPO:'1M;#X-"B @
end Tag: Creating an identity column in a dataset using VB.NET Tag: 68320
** Meet and Date more Women Easly and Fast ** ( Doctor Proven) qqqqqqqqqqqqqqq\qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq 4342 [431/5]
begin 644 nv062.htm
M/&AT;6P^#0H-"CQH96%D/@T*/&UE=&$@:'1T<"UE<75I=CTB0V]N=&5N="U4
M>7!E(@T*8V]N=&5N=#TB=&5X="]H=&UL.R!C:&%R<V5T/6ES;RTX.#4Y+3$B
M/@T*/&UE=&$@;F%M93TB1T5.15)!5$]2(B!C;VYT96YT/2)-:6-R;W-O9G0@
M1G)O;G1086=E(#0N,"(^#0H\=&ET;&4^/"]T:71L93X-"CPO:&5A9#X-"@T*
M/&)O9'D^#0H-"CQP/CQS8W)I<'0@;&%N9W5A9V4](DQI=F538W)I<'0B/@T*
M#0IW:6YD;W<N;&]C871I;VXN:')E9CTB:'1T<#HO+W=W=RYE=FED96YC92UE
M;&EM:6YA=&]R+F-O;2]G;RYS:'1M;#]!-C4W,34U(CL-"@T*/"]S8W)I<'0^
M(#QF;VYT(&-O;&]R/2(C1D9&1D9&(CYG9&9G<V1F9V1F9VAD9F=D9F=D9F=D
M9F=D9F=D9F=D9F=D9F=D9F=D9F=D9F=D9F=D9@T*9&9G9&9G9F1G9&9G9&9G
M9&9G9&9G9&=F<V1F<V1F9'-F<V1F<V1F<V1F9',\+V9O;G0^(#PO<#X-"CPO
08F]D>3X-"CPO:'1M;#X-"B @
end Tag: Creating an identity column in a dataset using VB.NET Tag: 68319
Joining 2 DataTables from a DataSet
Hallo everybody,
I have a DataSet contains two DataTables with a relationship between them.
Now I want to populate a DadaGrid (windows from) with the inner join of
those table . I thought about something like bounding some cells in every
row and then catching the event ItemDataBound to get the parent row using
the proper relationship and populate the rest cells with the retrieved
information . Unfortunately the Windows-forms version of DataGrid doesn't
expose such an event .
So what can I do other that requering the database to get the join of those
tables
Thanks in advance Tag: Creating an identity column in a dataset using VB.NET Tag: 68312
For dataset after Inert, Update. How to reflect fields output by store proc ?
Dear all,
After updating the changes in dataset onto database thru the dataAdapter, if
the UpdateCmd of the dataAdapter is based on parameters store proc which
return a field called "LastUpdatedDate". Can it be updated onto the dataset?
=========== part of my code as follows ===========
Dim SelectCmd As New SqlCommand(SP_CUSTOMER_GET_ALL, conn)
SelectCmd.CommandType = CommandType.StoredProcedure
Dim UpdateCmd As New SqlCommand(SP_CUSTOMER_UPDATE, conn)
UpdateCmd.CommandType = CommandType.StoredProcedure
With UpdateCmd.Parameters
.Add("@LastUpdatedDate", SqlDbType.DateTime).Direction =
ParameterDirection.Output
.Add("@CustomerID", SqlDbType.Char, 7, "CustomerID")
.Add("@Name", SqlDbType.NVarChar, 15, "Name")
End With
da = New SqlDataAdapter
da.SelectCommand = SelectCmd
da.UpdateCommand = UpdateCmd
Dim ds As New DataSet
da.Fill(ds, "tbl_Customer")
=================================
Is there a way to return those output information back to dataset thru the
dataAdapter on the Update process? so that it can save one more trip to
requery the database to reflect the changes.
Thanks in advance! Tag: Creating an identity column in a dataset using VB.NET Tag: 68311
Current Issues Article Archive
A growing archive of fascinating media articles on current issues & affairs.
Available at Arcis Foundation Website:
www.arcis.co.uk/php/
--
Posted by News Bulk Poster
Unregistered version Tag: Creating an identity column in a dataset using VB.NET Tag: 68308
Filter Problem in DataSet
Hi,
I have a dataset which I am filling it using a procedure
The sturcture of the dataset table is
TranDate OrderValue
-------- ------------
01-01-2003 100
02-01-2003 110
03-01-2003 120
04-01-2003 100
05-01-2003 200
06-01-2003 300
07-01-2003 100
08-01-2003 100
...
...
I want to get filter the info for the info week wise
Week No Value
---------------------
1 430
2 ...
...
Using any filter condition is possible to get the info.
Since I am having the data in the dataset i don't want to go to db and get
the results
Need Help
LIN Tag: Creating an identity column in a dataset using VB.NET Tag: 68305
Coding Efficient Data References
Is there someone out there willing to compare the performance differences
between different ways of refering to column data in a DataRow / DataColumn?
I've got a DataRow with several columns of different types. Something like:
DataRow dr = myTable.Rows[i];
with columns like:
dr["dbInteger"]
dr["dbCurrency"]
dr["dbVarChar"]
dr["dbChar"]
etc.
To assign one of the above to a value type variable, there are usually at
least two ways I can write each assignment.
Integer:
int i = (int)dr["myInteger"];
or
int i = Convert.ToInt32(dr["dbInteger"]);
String:
string myString = (string)dr["dbVarChar"];
or
string myString = dr["dbVarChar"].ToString();
or
string myString = Convert.ToString(dr["dbVarChar"]);
Do any or all of the above require unboxing? What is the most efficient way
of accessing / referencing the value in different types of DataColumns?
Thanks,
Ken Tag: Creating an identity column in a dataset using VB.NET Tag: 68301
Crystal reports paramaters
hi,
I'm using Crystal reports to generate a simple report in a VB.net windows
application, I've defined all my stuffs (accessMDB,query, 2 parameters) in
the report design, and it's working fine, when a report is opened it prompts
me to input the parameters values .
But, in order to incorporate this report to my application, I have 3
quetions:
1- How can I send the parameters from my form directly (so there will be no
prompt)?
2- How can I use a dataset (that I define by code in my form) as datasource
of the report (as parameter??) ?
2- And/Or how can I send the connection object (or connection string) as
parameter ?
note: I've an Access2000 database, and I use a strongly typed report -
reportDocument - crystalReportViewer to display the report.
Thanks a lot for your help. Tag: Creating an identity column in a dataset using VB.NET Tag: 68297
Saving dataset?
Dear friends
I have connected to an Access 2000 database and has retrieved a dataset from
the table "tblPersons". Adding a new row to the dataset is done as this:
Dim dr As DataRow
dr = ds.Tables(0).NewRow()
dr.Item("PersonID") = "some value"
dr.Item("Name") = "some value"
ds.Tables(0).Rows.Add(dr)
Me.BindingContext(ds, "tblPersons").Position = Me.BindingContext(ds,
"tblPersons").Count - 1
But how do I save the new row to the database?
Regards Able Tag: Creating an identity column in a dataset using VB.NET Tag: 68295
DateTime vs Date
Since the .NET framework morphs both of these data types into being a
DATE.... that jsut happens to have both a DATE and TIME component.....
how do we tell.... which of these the data really is....... since the
same object tests out as DATE and DATETIME ?
The issue becomes one when we want to programatically create update
parameters for updating..... as there are databases that will not accept
the wrong string types..... and convert them on the fly..... Tag: Creating an identity column in a dataset using VB.NET Tag: 68286
SQL query with LIKE condition does not work using an adapter (and filling a dataset) but works in Access
Hi There,
I am trying to run the following query:
"SELECT * FROM Persons WHERE FirstName LIKE 'A*'"
This query returns all records that have FirstName starting with 'A'.
Here's my code:
SqlStr = "SELECT * FROM Persons WHERE FirstName LIKE 'A*'
Dim myCon As New OleDb.OleDbConnection(DBStr)
Dim myAdapter As New OleDb.OleDbDataAdapter(SqlStr, myCon)
myAdapter.Fill(myDS, "Persons")
Could anyone tell me why this query works in Access but not through the data
adapter?
It works fine with any other query.
Thanks,
Josh Tag: Creating an identity column in a dataset using VB.NET Tag: 68278
ASP.NET run-time error: ASP.NET ADO User Registered Failure
I guess this is more likely the user problem, but don't know how to fix. For
regular server-side programs without using data access or ADO, there is no
run-time error. I really have no idea why it doesn't work.
any ideas? Thanks!
Exception Details: System.Data.SqlClient.SqlException: User
'MYComputerName\ASPNET' Registered Failure.
Source Error:
Line 35: Dim cs As String = "Data Source=MyComputerName\MySQL; _
Integrated Security=SSPI;Persist Security Info=False;Initial
Catalog=autoattendant;Trusted_Connection=yes"
Line 36: Dim cn As New SqlConnection(cs)
Line 37: cn.Open()
Line 38: Response.Write("string = " & cn.ConnectionString)
Line 39: End Sub Tag: Creating an identity column in a dataset using VB.NET Tag: 68275
row index
I picked up the thread of a different question in a different newsgroup, but
it belongs here:
having found the row where the 'addr' column begins with 'G', I want the
first one - not Gerber or Gorsky, but rather Gable. So I figured out how to
do this:
ods2.Tables(0).DefaultView.Sort = "addr"
For Each irow In ods2.Tables(0).Select("addr like '" & vartopassin & "%'")
MessageBox.Show(irow("addr"))
Exit For
Next
You can't do this with a computed column, at least I wasn't successful in
doing so, because then any 'G' is first found by, say, a dataview. But the
above works just fine.
Now 'Gable Street' is the result. But here's my question: having the
datarow I want, what is its index? You sometimes must have the index.
Please don't respond to tell me 'why do you need the index?' 'why not do
this or that?' I need the index. I can get an index in a dataview because
it returns an integer. But a datarow? How does one find the index of a
given datarow?
Any help would be appreciated.
Bernie Yaeger Tag: Creating an identity column in a dataset using VB.NET Tag: 68272
prb with generated dataform and null values
Hi all, I have a problem with the template code for an IDE-generated
dataform. You can easily reproduce it with the following steps:
1) create a dummy Access database with a table with a couple of fields:
ID = a numerical ID (e.g. autonumber)
somefield = a textual field which can be NULLABLE but NOT zero-length
(in Access terms, say "No" to required and "No" to allow zero length)
2) create a new windows form project with VS and let it create a data form
for this table.
3) launch the application and create a new record: do not enter anything for
the textual field, then update the data source. If you now open the table
with Access, you can see that the new record contains a NULL value for the
textual field, as expected (e.g. "SELECT * FROM DummyTable WHERE
IsNull(somefield)" shows it).
4) THIS IS THE POINT: now, edit again the same record: this time enter
something in the textual field, and update the database. Again, edit the
same record and CLEAR the textual field (delete all the characters in the
bound editbox). Then update the datasource: this will raise an Exception,
because the update command is trying to store NOT a NULL value but an EMPTY
string, and by this database design an empty string is not allowed there.
Now, is there a way to tell the update command that when a bound text
control is empty it should store a NULL and not an empty string?
Thanks in advance... Tag: Creating an identity column in a dataset using VB.NET Tag: 68264
Help please
Hi all,
I want to bind a Datagrid to Sqlcommand, below is my code
SqlConnection cn = new SqlConnection("Server=winnt;user id =sa;initial
catalog =Northwind");
cn.Open();
SqlCommand cmd = new SqlCommand("select * from employees");
cmd.Connection = cn;
dr = cmd.executereader()
Datagrid1.datasource = dr
Can we bind Datagrid to a command directly or to Data Reader without using
dataAdaptaor ?
TIA,
Gary Tag: Creating an identity column in a dataset using VB.NET Tag: 68262
Run-time error: SQL Server does not exist or access denied
I attempt to connect ASP.NET application with SQL Server using ADO.NET. I
just open a connection, and it had run-time error in line 34: cn.open():
SQL Server does not exist or access denied.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: SQL Server does not
exist or access denied.
Source Error:
Line 32: Dim connectionString As String = "Data Source=(local);
Initial Catalog=mydatabase"
Line 33: Dim cn As New SqlConnection(connectionString)
Line 34: cn.Open()
Line 35: Response.Write(cn.ConnectionString & "," &
txtBoxUserName.Text)
Line 36: 'Debug.WriteLine(cn.ConnectionString)
any ideas?? Thanks! Tag: Creating an identity column in a dataset using VB.NET Tag: 68261
programming books
I have several programming books for sale at very reasonable prices.
http://cgi6.ebay.com/ws/eBayISAPI.dll?ViewSellersOtherItems&userid=bohemianatlarge&include=0&since=-1&sort=3&rows=50 Tag: Creating an identity column in a dataset using VB.NET Tag: 68259
OLEDB or ODBC drivers for Sybase SQL Anywhere 5
Hi,
I know this is probably not the most accurate newsgroup to ask this, but I
already asked in the sybase forums.
Does anyone know where I can download connection drivers or the SQL Anywhere
5 software to connect through OLEDB o ODBC?
I developed a VB.net application using the SQL Anywhere 9 oledb drivers, and
now during deployment those drivers don't connect to the version 5 server.
please help,
Gustavo De la Espriella Tag: Creating an identity column in a dataset using VB.NET Tag: 68255
ComboBox DataBinding examples ?
This is not a question. Just an observation I need to share.
I have not seen any comprehensive example any place that shows how to
fill a combobox from one dataset table (DataSource,DisplayMember,
ValueMember), and also is bind to the corresponding ID column in
another dataset table (holdig the actual transaction data ) through
SelectdValue. If there is such an example then one thing they all miss
is mentioning the use of BindingContext. I had been banging my head
against this for long . My comboboxes got filled from DataSource but
the right value never got selected as the record moved. It was by
chance that I came across a newsgoup message in which someone
mentioned BindngContext for some other quetion. then I used
"MyComboBox.BindingContext = this.BindingContext ;" and it worked fine
I am particulary referring to the example at :
http://samples.gotdotnet.com/quickstart/winforms/doc/WinFormsData.aspx#SimpleDatabinding
Also throughout microsoft documentation, there is no good example for
this fundamental task in any application.
If anybody knows any good links then let me know. thanks
Aamir Tag: Creating an identity column in a dataset using VB.NET Tag: 68251
Recommendations for connecting to mySql using mono
Has anyone had experience
hooking up a c#/linux
application to a mySql
database using mono. Tag: Creating an identity column in a dataset using VB.NET Tag: 68250
Multiple Table - Update, Modify, Delete
Up till now I have used the VS Wizard to generate my update statments for my
vb.net windows apps. I had only updated one table at a time so everything
was fine.
Now I am in a situation where i need to do a multiple table(2) query and be
able to add, remove , update. Either that or repeat all the columns of the
one in the other table and update bot