|
lrsalunkhe wrote: xml database to TALLY Software.
i Dont think you will for this case Try the related forum..!
LatestArticle :Log4Net
Why Do Some People Forget To Mark as Answer .If It Helps.
|
|
|
|
|
lrsalunkhe wrote:
Giove Me the Idea About Importing the data from xml database to TALLY Software.
How does it related with ASP.NET ?
Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
|
Respected,
I select the Records from SqlServer 2005 into GridView.Then This selected Record
I am convert or passed into Tally Software.So Give Me Idea obout this how we Transfer Data
from Sqlserver Data into Tally Software.
Thanks.
|
|
|
|
|
Its depends how Tally accepts the data. In which format Tally used to take data for importing ?
Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
|
Respected,
In Table Formate.
Thanks.
|
|
|
|
|
contach R3 INFOTECH srdabhade@gmail.com 9763175067
|
|
|
|
|
I'm trying to develop my own social app that prompts the user to enter profile information (i.e. - gender, height, weight, etc.), by building on the CreateUserWizard. I figured out how to add a step that prompts for that information, but I'm not sure how to get at the subsequent database, to add the additional fields (i.e. - gender, height, weight). Is there a way to access this database, are the new fields automatically added to the database or do I have to build a new one to house the information from the additional step(s)?
Draykko---
=======================
Every experience in life is a lesson to be learned
A. Stevens
B.S., Computer Science
|
|
|
|
|
Your question the idea of great
|
|
|
|
|
DRAYKKO wrote: how to add a step that prompts for that information
Convert to custom navigation template on smart tag..!
DRAYKKO wrote: Is there a way to access this database, are the new fields automatically
No You Have to do it..!
Go for the Below Article..!
I think You are looking for this..!
http://aspnet.4guysfromrolla.com/articles/070506-1.aspx[^]
LatestArticle :Log4Net
Why Do Some People Forget To Mark as Answer .If It Helps.
|
|
|
|
|
Thank you sashidhar! That article had the answer I needed!
Draykko
=======================
Every experience in life is a lesson to be learned
A. Stevens
B.S., Computer Science
|
|
|
|
|
Any Time My Friend..!
All the best..!
LatestArticle :Log4Net
Why Do Some People Forget To Mark as Answer .If It Helps.
|
|
|
|
|
Hi!
I have below text.
"A quick sly fox jumped over the lazy brown dog"
"This is my rifle, this is my gun. this is for fight and this is for fun."
I need to programmatically get first 7 words without breaking any words. for eg. from first text
I need "A quick sly fox jumped over" and from second "This is my rifle, this is"
could someone please help me how to get this.
|
|
|
|
|
How does it related with ASP.NET ? This is simple - String manipulation. You can use String.Split to split the string and then get the 7 words .
Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
|
Your question is very interesting
Proposed to use " " handle a little better, you say?
|
|
|
|
|
I have like 1000 rows returning from database is string.split and looping to get the 7 words appropriate way to go? could you please send me an efficient way to do this so it could load in web page faster
|
|
|
|
|
uglyeyes wrote: I have like 1000 rows returning from database is string.split and looping to get the 7 words appropriate way to go?
Then why you are not doing this thing in DB End ? Make the stored procedure which will return those first 7 words from DB rather than whole sentence.
Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
|
I am not very good in DB could you pleae help? and do I really need a stored proc for this.
can it be not done in a single line?
|
|
|
|
|
uglyeyes wrote: could you pleae help?
PL SQL Function :
CREATE FUNCTION SplitString
(
-- Add the parameters for the function here
@myString varchar(500),
@deliminator varchar(10)
)
RETURNS
@ReturnTable TABLE
(
-- Add the column definitions for the TABLE variable here
[id] [int] IDENTITY(1,1) NOT NULL,
[part] [varchar](50) NULL
)
AS
BEGIN
Declare @iSpaces int
Declare @part varchar(50)
--initialize spaces
Select @iSpaces = charindex(@deliminator,@myString,0)
While @iSpaces > 0
Begin
Select @part = substring(@myString,0,charindex(@deliminator,@myString,0))
Insert Into @ReturnTable(part)
Select @part
Select @myString = substring(@mystring,charindex(@deliminator,@myString,0)+ len(@deliminator),len(@myString) - charindex(' ',@myString,0))
Select @iSpaces = charindex(@deliminator,@myString,0)
end
If len(@myString) > 0
Insert Into @ReturnTable
Select @myString
RETURN
END
GO
And Try with Example
Select * From SplitString('Hello John Smith',' ')
Original Source[^]
Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
|
Why somebody voted it as 1 ? Any Proper reason ?
Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
|
May be They Dont like U..!
Check now..!
LatestArticle :Log4Net
Why Do Some People Forget To Mark as Answer .If It Helps.
|
|
|
|
|
.
Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
|
split using space n make one for loop which will go upto lenght
where take one variable which is going up to 7 and again reset to 1.
dis manner u can get.
and yes store this result in list ...
Reasons are not Important but Results are Important.
Swati Tripathi
|
|
|
|
|
hello either in sql or c# a code hint will be really helpful. I prefer in sql thou.
|
|
|
|
|
uglyeyes wrote: hello either in sql or c# a code hint will be really helpful. I prefer in sql thou.
Try with sample that I have provided to you !
Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
|
this one worked.
DECLARE @mystring VARCHAR(200)
DECLARE @count INT
DECLARE @max INT
DECLARE @space INT
SET @mystring = 'A quick sly fox jumped over the lazy brown dog'
SET @count = 0
SET @max = 7
SET @space = 1
SET NOCOUNT ON
WHILE @count < @max
BEGIN
SELECT @space = CHARINDEX (' ', @mystring , @space + 1)
-- SELECT 'position: ', @space
SET @count = @count + 1
END
SELECT LEFT(@mystring,@space)
SET NOCOUNT OFF
|
|
|
|