|
there is no in-built function in .net which you can use to customize a dataset. what u have to do is store the Address in a string variable...with the string manipulation functions(like Substring,Split etc.) you have to split the address to have the City/Zip etc...now with this data u have to make a new Dataset
Tirtha
Miles to go before I sleep
|
|
|
|
|
thanx. Yes till part i can do after this how to bind this to datagrid.
|
|
|
|
|
Do have 4 Columns in the Grid.
Bind 3rd column with the DataField="Address".
Dont specity the DataField property for the 4th column.
Iterate through the entire grid like
for(int i=0;i<grid.rows.Count;i++)
{
String txt=grid.rows[i].Cells[2].Text;
create 2 string city and zip from txt.
grid.rows[i].Cells[2].Text=City;
grid.rows[i].Cells[3].Text=zip;
}
Regards,
Arun Kumar.A
|
|
|
|
|
Hi, Can anyone tel me in which situation to use a stored procedure and in situation to use a sql function.
thanx
|
|
|
|
|
Why cant U better buy a good book and prepare for Ur interview?
Regards,
Arun Kumar.A
|
|
|
|
|
Do u think that the in the books they will give the situations also. I know the difference between both of them. I have a book in which there are no situations for the concepts. Thanx for your suggestion.
|
|
|
|
|
Hi guys
I've have set up a data-table in MS Access.
I have a colomn with the names of my data and a column with numbering of the data (One number for each name). I then have a new entry of data, which I want to compare to the data in my table. I want to do this by calculating the distances between the new data and all of the data (numberings) in the data-table. Finally I want to choose the ten data-items from the tables, which have the shortest distance to the new data-entry.
My problem is... How can I in sql-code calculate the distances, one row at a time - save them and later compare all the distances and choosing the ten shortest ones.
I haven't done much sql-code before - so i would really apreciate any suggestions or maybe some good links
Thanks in advance
AL
|
|
|
|
|
Hi every buddy,
I have setup data replication in Sql server 2000. There are two servers over the LAN named ATech and AJK. RIght nowI've setup transactional replication such that Atech is the publisher and AJK the subscriber but I also want AJK to publish some of its tables to ATech as well. When I tery to do that and make a push subscription to Atech it gives an error and says that SQLAgent$AJK doesnt exist on LEOPARD\ATECH as an installed object. So instead of making a push subscription I made a pull subscription as well but that also doesnt seem to be working coz the moment I inserted a new record at AJK it gave out an error saying that a particular stored prcedure named something liek sp_MSins_Bill doesnt exist. I made a copy of it from AJK to ATech buut its still not working v well.
So Can u plz tell me how to establish this kind of topology when both of the servers are Publisher as well as subscriber?
Does it have something to do with the configuring of Publisher/subscriber and distributor. In my case the ATech Server is the publsher and distributor while AJK is the subscriber.
Any help would be highly appreciated
Thanks in advance,
Rocky
|
|
|
|
|
hi everyone,
i am using SQL SERVER 2005 Database
and i want to build Stored Procedure in a database (DB_1)
and i want the stored Procedure to query data from another Database (DB_2)
Note: this stored Procedure is exist in the first Database (DB_1)
Can any one help
i need it so much.
best wishes,karim
|
|
|
|
|
If DB_2 is in the same SQL Server instance, you only need to prefix the schema name with DB_2. For instance:
SELECT a.Id, b.OtherItem FROM MyTable a INNER JOIN DB_2.dbo.MyTable2 b ON a.Id = b.FK_Id
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
select * from property
where
substring(func_key,1,5) = 'GEOSS'
And substring(func_key,6,8)>= 3 and
where substring(func_key,9,16)='PV000000'
And Attrib_code = substring(Attrib_code,5,2)=16
i do i Executre this in One
Vuyiswa
|
|
|
|
|
Why didn't you use the "Modify" button rather than create a new post?
|
|
|
|
|
Try this.
select * from property
where
substring(func_key,1,5) = 'GEOSS'
And substring(func_key,6,8)>= 3 and
substring(func_key,9,16)='PV000000'
And substring(Attrib_code,5,2)=16
Regards,
Arun Kumar.A
|
|
|
|
|
I need to Find All the Records that Are GEOSS and that are not DUETt.The Following statement made that Possible.
select * from property
where substring(func_key,1,5) = 'GEOSS' And substring(func_key,6,8)>= 3
*There is a Column that is named lis_key in the above results i need to select it from the results above results distictively and search based on that Distict lis_key to Find al records that have
Func_key column ='PV000000' and substring(Attrib_code,5,2)!=16
Please Help ,i hope i explained it clear today
Vuyiswa
|
|
|
|
|
Try this.
select * from property where lis_key in
(select lis_key from property
where substring(func_key,1,5) = 'GEOSS' And substring(func_key,6,8)>= 3)
and Func_key column ='PV000000' and substring(Attrib_code,5,2)!=16
If U want something other than this, provide sample data of around 5
rows (for the required columns alone), and the output result U want.
Regards,
Arun Kumar.A
|
|
|
|
|
OOH GOd you are Good, but i need you to make th results to be Distinct based on Lis_key,If you could just add distinct in that Query.
Thanks a lot again.
You are Good
Vuyiswa
|
|
|
|
|
hi thank you a lot , am noting you Sir, please attend to next Problem.
I NEED TO UPDATE THESES RECORDS BASED ON THIS QUERY
select * from property where
Lis_key in(select lis_key from property where substring(func_key,1,5)='GEOSS'
And substring(func_key,6,8) >=3)and
Func_key = 'PV000000'
and substring(Attrib_code,5,2)!=16
AND ACTIVE = 1
order by Lis_key
HELP ME
Vuyiswa
|
|
|
|
|
Do U want to update a column which satisfy these conditions?
If so,
We can do that by using a simple update statement:
update property set columnName=value where
Lis_key in(select lis_key from property where substring(func_key,1,5)='GEOSS'
And substring(func_key,6,8) >=3)and
Func_key = 'PV000000'
and substring(Attrib_code,5,2)!=16
AND ACTIVE = 1
order by Lis_key
Regards,
Arun Kumar.A
|
|
|
|
|
The Following is the update i want to do, con you combine these from what you gave me previously.
but it gives me an Error
"Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near '('.
"
update property
set substring(Attrib_code,5,2)=16
where Exists (select * from property where
Lis_key in(select lis_key from property where substring(func_key,1,5)='GEOSS'
And substring(func_key,6,8) >=3)and
Func_key = 'PV000000'
and substring(Attrib_code,5,2)!=16
AND ACTIVE = 1
)
Vuyiswa
|
|
|
|
|
Haw can U assign to the value returned by the substring function?
Try this:
update property
set Attrib_code=substring(Attrib_code,0,5)+'16'+substring(Attrib_code,7,n)
where Lis_key in(select lis_key from property where substring(func_key,1,5)='GEOSS'
And substring(func_key,6,8) >=3)and
Func_key = 'PV000000'
and substring(Attrib_code,5,2)!=16
AND ACTIVE = 1
)
"n" must be the lenght of characters after 16.
Note:Before testing, make sure U have backup of the table.
Regards,
Arun Kumar.A
|
|
|
|
|
hi Arun thakns again Can yo Please explain these line of code to me, why this Positions in substring
update property
set Attrib_code=substring(Attrib_code,0,5)+'16'+substring(Attrib_code,7,n)
Vuyiswa
|
|
|
|
|
Hi,
set Attrib_code=substring(Attrib_code,0,5)+'16'+substring(Attrib_code,7,n)
Let Attrib_code ='abcde10xyz'
U R trying to change the numbet 10 to 16.
substring(Attrib_code,0,5) will return 'abcde'
substring(Attrib_code,7,3) will return 'xyz'
so 'abcde'+'16'+'xyz' will evaluate to 'abcde16xyz'.
Have I given the right update command?
Regards,
Arun Kumar.A
|
|
|
|
|
Thank you Sir Arun.Immanuel you have given me the right update command, my table is looking good.AM taking note of you.
Kind regards
Vuyiswa Maseko 
vuyiswam@Tshwane.gov.za
South Africa
Vuyiswa
|
|
|
|
|
Welcome.
Regards,
Arun Kumar.A
|
|
|
|
|
i have a Query that is workng well
select * from property
where
substring(func_key,1,5) = 'GEOSS' And substring(func_key,6,8)>= 3
it Display all the records that has 'GEOSS' and has a functional key that is equal to 3 and greater than 3. the Query is working.
NB:* The 'GEOSS' Records are Subtyptes of PVOOOOOO Records. It means that the main Key will be like '022100550.PV000000' and the Subtypes will be
'022100550.GEOSS001
'022100550.GEOSS002
'022100550.GEOSS003
Those are subtypes of 022100550.PV000000. above SQL statement searches them and Exclude the main key, i need a separate key that will show all main keys of the subkeys. that means all the PV000000 that has Sub keys GEOSS.
Please Help
where the
Vuyiswa Maseko Junior Programmer that will never stop learning form Code Project
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
