|
Thank u very much but sir i have two different tables. One Table may have less rows then the other. However One table primary key is included in the other.
Tables Structur
Cust_Order(Order_Id, cust_id, Date...)
Cust_Debit(Debit_No, Order_Id, ......)
Is that possible to Display boths Data on Same Datagrid. Cust_Debit may have 0 or less records then Cust_Order.
Please Help
Thanks in Advance.
|
|
|
|
|
In the select query itself you can use joins,
If you dont want to miss records from Cust_Order
then use the following join
Select <column names>
From Cust_Order Left Outer Join
Cust_Debit On Cust_Order.Order_Id=Cust_Debit.Order_Id
If you dont want to miss records from Cust_Debit
then use the following join
Select <column names>
From Cust_Order Right Outer Join
Cust_Debit On Cust_Order.Order_Id=Cust_Debit.Order_Id
If you dont want to miss records from both Cust_Order and Cust_Debit
then use the following join
Select <column names>
From Cust_Order Full Outer Join
Cust_Debit On Cust_Order.Order_Id=Cust_Debit.Order_Id
Regards,
Sylvester G
Senior Software Engineer
Xoriant Solutions
sylvester_g_m@yahoo.com
|
|
|
|
|
You can use hierarchical grid. show debt part in child row.
|
|
|
|
|
I used the following query but it display records twice.Means repeating. It should not be.
SELECT cust_order.order_id, cust_order.order_date, cust_order.order_status, cust_order.lock_status, Cust_debit.Debit_Id FROM cust_order, Cust_debit WHERE Cust_debit.Cust_Id = " & cust_id & " and cust_order.customer_id = " & cust_id
whre cust_id is customer_id.
Please help
|
|
|
|
|
create a join between cust_order.order_id = cust_debit.Cust_id
|
|
|
|
|
use like this
Select <column names>
From Cust_Order Inner Join
Cust_Debit On Cust_Order.Order_Id=Cust_Debit.Order_Id
where Cust_Order.Order_Id = <id>
Regards,
Sylvester G
Senior Software Engineer
Xoriant Solutions
sylvester_g_m@yahoo.com
|
|
|
|
|
Hi there,
I hope this is the appropriate forum...
I have a problem... I always used to be able to design my Crystal Reports within VB .NET 2003 linking them up to stored procedures I create beforehand. (Database = SQL2000)
Ever since I reformatted and reinstalled my PC I can ONLY access the tables within my database, and NOT the stored procedures I need to see when using Crystal Reports!
The user I am connecting with via the wizard definitely has all required privileges to the stored procedures, but they are not viewable and accessible any more and I CANNOT figure out why?
Has anyone ever had this problem? Maybe I am missing something basic, but it has never happened before and I have done this before?
Is there a requirement a specific requirement perhaps of the user that needs to have privileges to the stored procedure in order for the Crystal Report Wizard to have access to it perhaps?
Hope someone can help?
Kind regards!
|
|
|
|
|
I have a page where the user enters the information, and clicks on submit then the information is saved into the database. Second time, when the same user navigates to that page, the page picks up the data from database and be populated accordingly.
I have implemented ASP.Net Ajax: UpdatePanel into this page. First time (at the time of creation), it works perfectly. But when it comes second time (in edit mode), as the page is popupated as values from the database, it does not work properly.
For example:
- There is a RadioButtonList and TextBox with Submit Button on the page.
- TextBox is disabled by default.
- RadioButtonList has two options (Yes) and (No)
- Selecting (Yes) from RadioButtonList, TextBox is enabled and on selecting (No), TextBox is disabled.
- But RadioButtonList needs a postback and page flickers. So, I decided to implement Ajax:UpdatePanel into the page.
- After implementing UpdatePanel with UpdateMode=Conditional, when you select (Yes) or (No) on RadioButtonList, it only renders TextBox and page does not flicker, it means it works perfectly.
- But second time (in edit mode, when record already exists in database), in Page_Load, it fetches the record from the database and as per values populates the page. Like if RadioButtonList was Yes then it is selected as Yes and TextBox is populated with value. Now you try to select (No) from RadioButtonList, it will disable the TextBox and select again (Yes) option, -- it will not enable the TextBox to enter the value.--
|
|
|
|
|
Hi all, I writing my first web service but I getting an error when I try to connect to the database.
System.Web.Services.Protocols.SoapException : Server was unable to process request. --> System.Data.SqlClient.SqlException: A connection was successfully established with the server, but then an error occurred during the login process. (provider:Shared Memory Provider, error: 0 - No process is on the other end of the pipe)
What does that mean?
He who laughs last is a bit on the slow side
|
|
|
|
|
how can i send and receive sms from my application.
Thks
Yesuprakash
|
|
|
|
|
you need to buy from any service provider. they will give you an API along with username and password. You just have to call the API by passing required arguments.
Regards,
Sylvester G
Senior Software Engineer
Xoriant Solutions
sylvester_g_m@yahoo.com
|
|
|
|
|
can i know some famous service providers
|
|
|
|
|
I used this service provider in my last project. If you want you can use this also.
Try some 5 free sms on this site
http://www.intellisms.co.uk/[^]
Regards,
Sylvester G
Senior Software Engineer
Xoriant Solutions
sylvester_g_m@yahoo.com
|
|
|
|
|
i need to know the functionality and coding for the process.
|
|
|
|
|
No, Its a dll, You can give reference to that dll, then call a particular method to send SMS. Its very simple to use.
Regards,
Sylvester G
Senior Software Engineer
Xoriant Solutions
sylvester_g_m@yahoo.com
|
|
|
|
|
for my company i need to send and receive sms to and from our clients.
how can i develop an application for that in asp.net.
|
|
|
|
|
Client has to buy that service from service provider. You can buy some 50 or 100 SMS for testing then you can force the client to buy to enable the service.
Regards,
Sylvester G
Senior Software Engineer
Xoriant Solutions
sylvester_g_m@yahoo.com
|
|
|
|
|
Hi,
i have a createUserwizard control in which i also collect some Personalisation information stored using Profile.
Profile.FirstName = Firstname.Text;
Profile.LastName = Lastname.Text;
Profile.Age = Age.Text;
Profile.Save();
then later in my profile page after user has been authenticated i am trying to show the profile properties
FN.Text = Profile.FirstName;
LN.Text = Profile.LastName;
ageIs.Text = Profile.Age;
Now the problem is the profile properties are being stored in database(which i can see in sqlserver2005)
but when i try to diplay profile properties in my Profile page data is not being retrieved from the database .
I can not understand why??
yojimbo
|
|
|
|
|
|
This is nice. Will you please tell me more usability of this control and how will you manage the channels.
|
|
|
|
|
Hi
I want to display webparts based on a users role (or login status). If I put a webpart inside a LoginView, I lose the titles. So...I want multiple webparts on a page, some displayed whether the user is not in (anonymous login view) , some for all logged in users (loggedInView) and some dependant on role (RoleViews). Should I place the webpart zone inside the login view, or the loginviews inside the webpartzone.
I can't find any links anywhere which shows webparts being used with login views.
Cheers
Malc
|
|
|
|
|
Has anyone ever deployed to a IIS Cluster? I have a cluster of two machines. I assume you deploy to each machine but I was wodering If I could deploy to the virtual IP.
|
|
|
|
|
How do you call a javascript function when a button is clicked? I know you can use the OnClick event, but that will fire up everytime the button is clicked. I need to call the function only when certain criteria are met.
For example
private void btnSave_Click(object sender, System.EventArgs e)
{
if (flag == true)
{
//Call Javascript function
}
}
Thanks.
|
|
|
|
|
You can't call a javascript function from the server, all you can do is rerender the page and insert script that calls it. Is flag calculated based on client side state ? If so, use a custom validator. If it isn't, then just insert client side variables that have these values, so you can validate them on the client, and still avoid a postback.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
