Hello Guys.... I am trying to Bind DropDownList with enum as follows.

cmbFromShape.DataSource = Enum.GetValues(typeof(KavirDiam.Common.Shape));
cmbFromShape.DataBind();

Following is my enum:

public enum Shape
{
Any,
Round,
Princess,
Emerald,
Asscher,
CushionBrilliant,
CushionModify,
Pear,
Radiant,
SQRadiant,
Heart,
Marquise,
Oval
}

While getting Selected Item/Value/Index it is always...returning me 'Any' i.e first member. I am not able to get the value of selected member.

dipak

thankyou so much ....all guys..

dipak

Does it mean that ther is no way to make such member in enum?

dipak

hi guys. Any one has idea about how can we give enum member like A+,B+...

public enum Color
{
Any,
D+,
D,
D-,
E+
};

I tried creating above enum but bad luck its giving error saying } expected.

dipak

Hi all, Is there something like ## in sqlserver related to scope of temprory tables.?? which decides the scope of the temp tables?? thanks

dipak

//Add Default row to data table.
blankRow = dataSet.Tables[Constants.CLASSES].NewRow();
blankRow["ClassName"] = Constants.SELECT;
blankRow["ClassID"] = 0;
dataSet.Tables[Constants.CLASSES].Rows.Add(blankRow);

dipak

u can try adding row to DataTable with which u r binding ur grid. like

DataRow row = Datatable.NewRow();
DataTable.Rows.Add(row);

dipak

Hi all I've a class which gets all the customers from an SQL database and puts them in a class object "Customers" I've managed to get those customers inside a remoting server application as a singleton object. But my main problem is to get the client application connected to this server and make it possible to change the database but still keep the singleton object intact. It should create a new object on the server preferably on the same port (tcp) but get the customers from the other database. The reason for this is that users will have te possibility to use multiple databases while connected to 1 server. Maybe threading is an option? please help me out

dipak

hey...i wrote for code snippet as giving suggession to this problem in descriptive manner may create confusion...i was looking for code just to get what exactly the solution provider want to say....and urgency is just to show how important and valuable is ur post... dont mind it....if u have knowledge and want to share....the pls do....dont give such replys....

dipak

i think this is beyond ur knowledge... it requires lot of efforts to do this...and if u can give such solution than u will be next threat to MS...pls...dont post such hypothetical issues....

dipak

[Message Deleted]

i am supposed work with SelectedValue Property....

dipak

It is because.first u are seting the data source and then u might be setting the dispaly member and value member.... u can do like this

cmbClassId.DisplayMember = dataSet.Tables[Constants.CLASSES].Columns["ClassName"].ToString();
cmbClassId.ValueMember = dataSet.Tables[Constants.CLASSES].Columns["ClassID"].ToString();
cmbClassId.DataSource = dataSet.Tables[Constants.CLASSES];

This will cause event to occure only once.

dipak

Hi All, I have combobox with name cmbClassId. I have to set the SelectedValue for this combo with the value form the DataTable Cell value. I have done it like below.

cmbClassId.SelectedValue = (object)dataSet.Tables[Constants.STUDENT].Rows[0]["StudentClassId"];

but still it is showing me null in SelectedValue property of this combo... please help me out... Thanks & Regards Dipak Thesiya

dipak

Thanks BOB....its working fine....and ur description is very clear..i mean short and sweet... thanks.... :)

dipak

Hi all, I am trying to write a procedure which takes 1 parameter as @StudentID and returns Student Information for the given StudentId Parameter form Student and StudentDetail table. Now i want that if parameter is not passed(i.e NULL) then procedure should return all students information,but if StudentId passed then for that student only... I am trying this by using COALESCE function in sql server 2005. Following is DDL for my procedure.

CREATE PROCEDURE [dbo].[GetStudentById]
@StudentId AS NUMERIC
AS
BEGIN
SELECT
S.StudentId,
S.StudentFName,
S.StudentMName,
S.StudentLName,
S.Address,
SD.StudentClassId
FROM
[dbo].Student S
JOIN StudentDetail SD ON S.StudentId = SD.StudentId
WHERE
S.StudentId = COALESCE(@StudentId,NULL)
END

But not getting desired result ..When i am passing NULL 0 rows are returned. please help me out... Thank & Regards Dipak Thesiya

dipak

thanks buddy.. but as i have mentioned in my problem description that if i changes my namesapce from Dipak.ESchool.Data to only ESchool.Data it works fine. But with Dipak.ESchool.Data i have to make call like DataAccess.DataAccess.GetDataSet(). As per naming standerds for namespace we follows Compnyname.projectname.namespacename and thats what i have done... Dipak my compny name....DataAccess and ESchool my Project name ....

dipak

Thanks for your reply... I tried using ur solution...it works... But as far as concept is concerned ....i have included using statement as using Dipak.DataAccess....so at this point compiler will be knowing the clearly that this name space is referenced...what matters if same class name is there in namespace... :(

dipak

Hi All, I have Class library with name and namespace Dipak.DataAccess and within this name space there is class called DataAccess. I have another class library with name and namespace Dipak.ESchool.Data and within this namespace there is class called StudentData. Now i have added reference of Dipak.DataAccess in Dipak.ESchool.Data and i have added using Dipak.DataAccess statement in StudentData class . While calling method of Dipak.DataAccess i have to use full name like DataAccess.DataAccess.GetDataSet(),after adding using Dipak.DataAccess statement. And when i changes namespace from Dipak.ESchool.Data to ESchool.Data i need not to give full name for method call i am able call with classname.methodname, no need to add namespace name. Can any one explain me why it is so? And what i need to do for correcting above problem. namespace Dipak.DataAccess { public class DataAccess; { } //------------------------------------------------- using Dipak.DataAccess using Dipak.ESchool.Common; namespace Dipak.ESchool.Data { public class StudentData< { DataAccess.DataAccess.GetDataSet() //i want this call to be like DataAccess.GetDataSet() } } Thanks Dipak Thesiya. dipak.thesiya@gmail.com

dipak

Hi all i am using Coalesce function in sqlserver 2005 following is sp ALTER PROCEDURE [dbo].[GetAllBillDetails] ( @FromDate AS DATETIME, @ToDate AS DATETIME ) AS BEGIN DECLARE @Err int SELECT BillNo, SalesDate, CustName, Address, Discount, TotalAmount, NetPayable FROM Sales WHERE SalesDate BETWEEN COALESCE(@FromDate,SalesDate) AND COALESCE(@ToDate,SalesDate) SET @Err = @@Error RETURN @Err END following is code to in C# to call this sp private void BindGrid() { SqlCommand command = new SqlCommand("GetAllBillDetails", sqlConn); SqlDataAdapter ada = new SqlDataAdapter(); DataSet dataSet = new DataSet("Master"); ada.TableMappings.Add("Table", "Master"); command.CommandType = CommandType.StoredProcedure; DateTime? fdate; DateTime? todate; fdate = dtpFromDate.Value.Date; todate = dtpToDate.Value.Date; if (!dtpFromDate.Checked) { fdate = null; } if (!dtpToDate.Checked) { todate = null; } command.Parameters.Add(new SqlParameter("@FromDate", fdate)); command.Parameters.Add(new SqlParameter("@ToDate", todate)); ada.SelectCommand = command; ada.Fill(dataSet); } It is giving me error like procedure or function GetAllBillDetails requires parameter @FromDate which was not supplied. Can any one help me to solve this issue... Dipak Thesiya DRC Pvt Ltd...:confused:

dipak