|
|
thanks man...atleast now i know for sure that no matter what i do, i wont be able to install SQL SErver 2000 atleast on Windows Vista.
well, i do have another query, if u could help me with this, Is there any problem if i go to format the hard disk and install Windows XP instead of Windows Vista on my laptop? actually my laptop came with Windows Vista Home Premium pre-installed, but due to some application compatibility issues i want to remove that and install XP.
Can i go ahead with the regular process of installing an OS or is there any special care I need to take? Plz help
|
|
|
|
|
hi i am using asp.net 2005 to create an website which handles data from ms sql.
i am trying to create an stored procedure which would call an function from the asp.net function when an event(e.g when data in an perticular table is changed) i have read some tutorials on stored procedure however they dont really cover what i need
so could anyone help me? maybe some good tutorial recommandation or source code or recommandation?
|
|
|
|
|
neodeaths wrote: i am trying to create an stored procedure which would call an function from the asp.net function when an event(e.g when data in an perticular table is changed)
This doesn't make sense. You want to write a proc which calls code in your ASP.NET app ? You can define a trigger, and you can use managed code in SS2005, but even then, the code is going to be atomic, I doubt it can fire events in your code, especially as, in an ASP.NET app, the class instances that exist change every time a page is loaded, and are active only while it is being created.
Perhaps if you try to explain a little better ?
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
hi i am using vs 2005 and doing an asp.net website
i created a basic db and drag and drop the table into my web page until now it works fine
however i realise that everytime i change the table infomation the web site table which is displaying the db infomation does not refresh
hence i am trying to find a way to resolve this issue.
please voice ur suggestio and opinion to me
|
|
|
|
|
The DataGrid or DataGridView display object is not connected directly to the underlying table. If you want the underlying database table to be updated when the displayed content is updated (and this is not generally a good idea - not efficient and it makes UNDO-ing a change more difficult) you will need to create event handlers (TextChanged?) and write the appropriate Database updates.
It sounds like you may need a little more information on how to use databases with .NET. Connecting to a Database from .NET is not a complicated thing to do, but you will need to be cognizant of the type of operation (SELECT, UPDATE, INSERT, DELETE) that you are trying to do, and the relationships between the objects.
Try reading these articles, and see if it helps your understanding or if you can rephrase your request. (Search for ADO.NET)
http://www.codeproject.com/cs/database/DatabaseAcessWithAdoNet1.asp
http://www.codeproject.com/dotnet/ADONETOOP.asp
BDH
|
|
|
|
|
Hi.,
My Code is like this....,
string s1 = "select Module from Employee where CProject=@id2 and Designation='Team Lead'";
OleDbCommand cmd1 = new OleDbCommand(s1, con);
cmd1.Parameters.Add("@id2", OleDbType.VarChar);
cmd1.Parameters["@id2"].Value = DropDownList3.SelectedValue;
OleDbDataReader dr1;
dr1 = cmd1.ExecuteReader(); I am getting that Error here
while (dr1.Read())
{
DropDownList4.Items.Add(dr1.GetString(0));
}
Plz Help me...,
Regards.,
Deepak.
|
|
|
|
|
i want to add a autonumber field to database. How to achive this? Please help me?
Kiran Sajanikar
Kiran Sajanikar
|
|
|
|
|
1. Create a Field in table into the sql server and apply the primary key to that field.
2.Give column identity = yes, identity speed = 1 and identity increment = 1
|
|
|
|
|
Thanx
Kiran Sajanikar
Pune.
|
|
|
|
|
Hi
Can anybody help me to list the stored procedure parameters and return type in sql server 2005/2000 for a given stored procedure.
For ex:
Parameter_Name Data_Type Length
---------------------------------
kesavan
|
|
|
|
|
Here it is a version (displays from master database the parameters name, type and length for sp_addserver stored procedure):
-- SQL 2000/2005
if exists (select * from syscolumns where id = object_id('sp_addserver'))
begin
select
name
, type_name(xusertype)
, length
from syscolumns where id = object_id('sp_addserver')
end
-- SQL 2005
if exists (select * from sys.all_parameters where object_id = object_id('sp_addserver'))
begin
select
name
, type_name(user_type_id)
, max_length
from sys.all_parameters where object_id = object_id('sp_addserver')
end
Cristian
Nuclear launch detected
|
|
|
|
|
Hello if anyone can please give me just a tiny sample of how I'd do this, not just what to do I will be so grateful.
Just so you know. I have been googling for days on this and I'm not sure what to do as I am still pretty new to c#.
This is what I want to do. I have a dataset and datagrid(search results table) displaying results like this.
Siann Skills1
Siann Skills2
Siann Skills3
I want it to show this
Siann Skills1,Skills2,Skills3.
I have my select statement, then I have created a new datacolumn as I was told to do as below. Now after that, what do I do? How do I get all the skills in one column. I know I have to concatenate, and I have tried searching the net, but I can't find anything useful. is there any possibility for an example?
dgSearchResults.Columns.Add(new DataColumn("skills", GetType()));
I then have my foreach. I need to put something in the foreach.
foreach (DataSet1.EmpSkillsRow empskillsRow in empskillsDT.Rows)
{
}
I was told on the C# forum to try here. I am not using sql 2005 so I can't use cte.
|
|
|
|
|
Thats retarded that they told you to ask here...
Try this and forgive VB, I have been stuck in VB land for too long and can no longer do c# from memory.
<br />
Dim ds as New DataSet() 'substitute your data set<br />
Dim dt as DataTable = ds.Tables(0) 'substitute your data table<br />
Dim dr as DataRow<br />
<br />
Dim strColumnAValue as String = String.Empty<br />
Dim strColumnBValues as New StringBuilder()<br />
<br />
For Each dr in dt.Rows<br />
If (Convert.ToString(dr(0)) = strColumnAValue) Then 'we are working on the same user "Siann" in this case and will append values<br />
strColumnBValues.Append(Convert.ToString(dr(1)).Trim() & ",")<br />
<br />
Else 'You are working on a new person and not "Siann"<br />
If strColumnBValues.Length <> 0 Then 'there is a user/ skillset to write out<br />
strColumnBValue = strColumnBValue.Remove(strColumnBValue.ToString().LastIndexOf(","), 1) 'remove the last comma<br />
Console.Writeline("User: " & strColumnAValue & " - Skills: " & strColumnBValues.ToString()) 'write out the value<br />
strColumnBValues.Length = 0 'clear the string builder<br />
strColumnAValue = Convert.ToString(dr(0)) 'set the new column A Value<br />
strColumnBValues.Append(Convert.ToString(dr(1)).Trim() & ",") 'add the first value<br />
End If<br />
End If<br />
<br />
<br />
<br />
Next 'dr<br />
<br />
|
|
|
|
|
I am in SQL server
Say i entered a statement, though didn't finish it, i get:
mysql> SELECT id, size, color, quantity FROM product WHERE size = 'One size fits
'>
'>
'>
'>
'>
'>
'>
'>
what is the command to exit this unfinished statement and get back to the mysql> prompt? I know it if very simple, like backslash something. I went through the whole alphabet front a backslash, and still so success. Must finish this homework assignment.
|
|
|
|
|
sonywar wrote: I am in SQL server
sonywar wrote: what is the command to exit this unfinished statement and get back to the mysql> prompt?
These are two separate products. It appears you are using MySQL not SQL Server.
Upcoming FREE developer events:
* Developer! Developer! Developer! 6
* Developer Day Scotland
My website
|
|
|
|
|
yes i am in MySQL Server command prompt and need to know how to get back to the regular prompt after pressing enter before my statement was complete.
do you know what the command is? i have read my starter sql book, and looked on many forums though i can not find a solution. I can restart the prompt though that is the long way. there is a simple backslash command i can type.
mysql> (is the regular prompt)
'>
'>
'>
'> (my prompt)
|
|
|
|
|
I'm not familiar with MySQL, but it may be waiting for a ';' semicolon to terminate the statement. Try ; <enter>. Don't use any non-whitespace characters after the ';', just press the enter key after the semicolon.
David
---------
Empirical studies indicate that 20% of the people drink 80% of the beer. With C++ developers, the rule is that 80% of the developers understand at most 20% of the language. It is not the same 20% for different people, so don't count on them to understand each other's code.
http://yosefk.com/c++fqa/picture.html#fqa-6.6
---------
|
|
|
|
|
Try "go" to send the command to the server.
Take care,
Tom
-----------------------------------------------
Check out my blog at http://tjoe.wordpress.com
|
|
|
|
|
Hello
i wanna know how can create a maintenance plan tl back up the database to remote server
i can do it but it backup the data on local desk. i want to do that but on remote desk
plz help me in this problem, its important to me
iam waiting ur responses.
thanks
|
|
|
|
|
Hi all
I have installed a SQL2005, i have an Acces database that i want to import to SQL200, i know that the Wizard we had in version 2000, is no longer available, please help me to import the database.
Thanks
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
|
Thanks Paul
Vuyiswa Maseko,
Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding
VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za
|
|
|
|
|
Hi,
I am looking at saving my customer's date of birth, what is the best data type to use for this. I'm looking for advice. Should I just use varchar(8) or should I use the datetime datatype?
Regards
Brendan
|
|
|
|
|
Well, the obvious question is, why do you think there's a datetime type ? Some ideas that spring to mind:
1 - if you use the date type, you can do queries based on date ranges, etc
2 - if your DB gets moved to a PC with a different date format, the varchar will break, but the datatime will work fine
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|