Comments by Member 9017207 (Top 31 by date)

I know how to bind in gridview. Any chance I can show those in links or button (not in gridview)

What can I do to solve it?

You are right. Error is coming in the line after that

document.set_RecordSelectionFormula(document.get_RecordSelectionFormula() + str);

OK I will try this.

And after int count = cmd.ExecuteScalar(); I can show the display message right?

OK I will try this.

And after counts = (int) com.ExecuteScalar(); I can show the display message right?

Its not giving count :(

I am just inserting to date and from date

I would like to go for option one. Can u help me write the query? I'm a newbie. Sorry

Thanks man. Much appreciated. Solved my problem.

I get the exception. The given path's format is not supported.

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.NotSupportedException: The given path's format is not supported.
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access)
at _80IB_GUI.Form1.ExportTheFileAfterProcess(String sqlquery, String namefile)
at _80IB_GUI.Form1.button1_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ButtonBase.WndProc(Message& m)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Still didnot solve the issue. Works fine on my local machine. But not after I publish the application in server

Thanks a lot. ending parenthesis was causing the problem.

still not updating

I have already added parameters manually to the stored procedure. But still same error

Did that. Didn't find the edmx file

Didn't find the edmx file in any of the folders. I have the class diagrams file though. The .cd files

In the solution explorer I have the following folders

Project1
Project1.BusinessEntities
Project1.BusinessLogic
Project1.DataAccess
Project1.LINQObjects

in the solution explorer I don't fine anything. Can you please help?

yes i am using entity framework

Where to find the .edmx file? And the model browser?

Stored procedure have been changed. But how to refresh the data model? Sorry I"m a newbie. Can you please tell me the procedure?

Here is the whole procedure.

ALTER PROCEDURE [dbo].[SP_INSERT_INTO_FONDATION_BOLT_MST]

@JBoltNos BIGINT ,
@JBoltNos_desc [varchar](50),/*Added by Avinaash on 05/06/2013 */
@JBoltDia BIGINT ,
@JBoltDia_desc [varchar](50),/*Added by Avinaash on 05/06/2013 */
@YieldStress BIGINT ,
@YieldStress_desc [varchar](50),/*Added by Avinaash on 05/06/2013 */
@PitchCircleDia BIGINT ,
@PitchCircleDia_desc [varchar](50),/*Added by Avinaash on 05/06/2013 */
@BoltLen BIGINT ,
@BoltLen_desc [varchar](50),/*Added by Avinaash on 05/06/2013 */
@ProjectedBLen BIGINT ,
@ProjectedBLen_desc [varchar](50),/*Added by Avinaash on 05/06/2013 */
@Cost INT ,
@Product_Type [bigint],/*Added by Avinaash on 05/06/2013 */
@Bolt_Type [varchar](30),/*Added by Avinaash on 05/06/2013 */
@ED_ACC [bit],/*Added by Avinaash on 05/06/2013 */
@UNIT_OF_MEASUREMENT [varchar](50),/*Added by Avinaash on 05/06/2013 */
@IsActive BIT ,
@CreatedBy BIGINT ,
@CreatedOn DATETIME,
@ImagePath VARCHAR(MAX)

AS
BEGIN
SET NOCOUNT ON;
BEGIN TRY

BEGIN --condiditon to check 'similar data present' added by prasadh july 8rd 2013
IF exists( Select 'x' From DEF_FONDATION_BOLT_MST where [JBoltNos]=@JBoltNos AND [JBoltDia]=@JBoltDia AND [BoltLen]=@BoltLen AND [Product_Type]=@Product_Type and [Bolt_Type]=@Bolt_Type )
BEGIN
RAISERROR('Record With Similar Bolt Number,Diameter,Length For Associated Product & Bolt Type Already Present',16,1)
END

ELSE

BEGIN
--BEGIN TRANSACTION TransInsertBOLT
INSERT INTO dbo.DEF_FONDATION_BOLT_MST (/*Insertion Begins*/
[JBoltNos]
,[JBoltNos_desc]/*Added by Avinaash on 05/06/2013*/
,[JBoltDia]
,[JBoltDia_desc]
,[YieldStress]
,[YieldStress_desc]
,[PitchCircleDia]
,[PitchCircleDia_desc]
,[BoltLen]
,[BoltLen_desc]
,[ProjectedBLen]
,[ProjectedBLen_desc]
,[Cost]
,[Product_Type]
,[Bolt_Type]
,[ED_ACC]
,[UNIT_OF_MEASUREMENT]
,[IsActive]
,[CreatedBy]
,[CreatedOn]
,[ImagePath]
) VALUES(
@JBoltNos
,@JBoltNos_desc
,@JBoltDia
,@JBoltDia_desc
,@YieldStress
,@YieldStress_desc
,@PitchCircleDia
,@PitchCircleDia_desc
,@BoltLen
,@BoltLen_desc
,@ProjectedBLen
,@ProjectedBLen_desc
,@Cost
,@Product_Type
,@Bolt_Type
,@ED_ACC
,@UNIT_OF_MEASUREMENT
,@IsActive
,@CreatedBy
,@CreatedOn
,@ImagePath
)
/*Returns Success*/
SELECT 'SUCCESS' AS [STATUS],ERROR_LINE() [ERROR_LINE],ERROR_MESSAGE() [ERROR_MESSAGE],ERROR_NUMBER() [ERROR_NUMBER],ERROR_PROCEDURE() [ERROR_PROCEDURE],ERROR_SEVERITY() [ERROR_SEVERITY],ERROR_STATE() [ERROR_STATE],@@TRANCOUNT [TRANCOUNT],@@ROWCOUNT [ROWCOUNT]
--COMMIT TRANSACTION TransInsertBOLT
END
END

END TRY
BEGIN CATCH
--ROLLBACK TRANSACTION TransInsertBOLT
/*Returns Error*/
SELECT 'ERROR' AS [STATUS],ERROR_LINE() [ERROR_LINE],ERROR_MESSAGE() [ERROR_MESSAGE],ERROR_NUMBER() [ERROR_NUMBER],ERROR_PROCEDURE() [ERROR_PROCEDURE],ERROR_SEVERITY() [ERROR_SEVERITY],ERROR_STATE() [ERROR_STATE],@@TRANCOUNT [TRANCOUNT],@@ROWCOUNT [ROWCOUNT]
END CATCH
SET NOCOUNT OFF;
END

UserID takes bigint

How to find max selected month value... can u pls write the exact code. I'm a newbie. Pls

Yes one month fee. I want to show values in textbox when I click either two months, three months or more

How can we do that? Please guide