Click here to Skip to main content
The default search term operator is AND.

You can use brackets, AND, OR, and NOT to improve your search. For example: C# AND NOT(VB or SQL)

A query of a single * will return everything, filtered by any filters.

Filter examples:
Search by Author  author:"author name"
Filter by tag  tag:C# or tag:(C++ or Java)
Wildcard search  use "?" or "*" eg. gr?d or gr*
  
798 Results

Search



Sort by



Match


Rating Range

Advanced Filters:


Page 1 of 16
Page Size: 10 · 25 · 50

Author filtered by: Aarti Meswania [x]
Answer 9 May 2013   license: CPOL
Try this...1.select x,y,z from view1 WITH (Index(Index_x)) where x in (select x from table1 WITH (Index(Index_y)) where y='1234')2.select x,y,z from view1where exists (select * from table1 where y='1234' and table1.x=view1.x)Happy Coding!:)
SQLview
Answer 9 May 2013   license: CPOL
change set @sql ='update MedicalListMedicationType set MedicationType = #tempTable.Name WHERE MedicationType_ID = #tempTable.Id left outer join #tempTable on #tempTable.Id= MedicationType_ID'withset @sql ='update mt set mt.MedicationType = #tempTable.Namefrom MedicalListMedicationType...
SQL
Answer 9 May 2013   license: CPOL
visit link,http://forums.asp.net/t/1401755.aspx/1[^]Happy Coding!:)
C#C#4.0
Answer 9 May 2013   license: CPOL
visit link and see full discussion http://social.technet.microsoft.com/Forums/en-US/sqltools/thread/0a533d8d-b646-44ca-9125-c7de517d4b81[^]Happy Coding!:)
SQL-Server
Answer 9 May 2013   license: CPOL
NULL EmptyString-----------------------------------------------------------1. No datatype could belong to char/varchar,nvarchar,nchar etc ...datatype2. occupy 1 bit per column Occupy 0 bytes for each row to state it's NULL Happy...
SQL-Server
Answer 8 May 2013   license: CPOL
ALTER PROCEDURE dbo.Addmonthslist @BeginDate AS Datetime, @EndDate AS Datetime, @ProjectID AS varchar(50)ASSELECT BeginDate, EndDate from tblProjects where ProjectID = @ProjectID SELECT DATENAME(MONTH, DATEADD(MONTH, x.number, @BeginDate)) + '-' +...
C#ASP.NETJavascriptSQLVBVB.NET
Answer 8 May 2013   license: CPOL
In Datagridview's cell value changed event,if(dataGridView1.Rows[e.RowIndex].Cells["yourcolumn"].Value == "Clear"){ dataGridView1.Rows[e.RowIndex].Cells["yourBtnColumn"].ReadOnly = True; dataGridView1.Rows[e.RowIndex].Cells["yourBtnColumn"].DefaultCellStyle.BackColor =...
C#
Answer 8 May 2013   license: CPOL
try setting width in percentage e.g. 100% of screen or 70% Happy Coding!:)
CSSHTMLWeb-Development
Answer 8 May 2013   license: CPOL
either decrease fontsize of fieldsorset paper "Landscape" or e.g. if using A4 size then increase Papersize to A3 you can also set paper margin it also affect available-space in Paper to paste fieldsHappy Coding!:)
C#3.0C#CrystalReports
Answer 8 May 2013   license: CPOL
check you have done some paint event that is conflicting or adding some dynamic control and which you are adjusting runtime on load event or in constructor...if you want to not show flickermeans below code will show your form after it complete paintingput this property in your form and...
C#C#4.0
Answer 8 May 2013   license: CPOL
e.Row.Cells[1].Text = e.Row.Cells[1].Text + ((e.Row.Cells[2].Text.ToString().Trim().Length>0)? ("," + e.Row.Cells[2].Text) : string.Empty )+ ((e.Row.Cells[3].Text.ToString().Trim().Length>0) ? ("," + e.Row.Cells[3].Text) : string.Empty );Happy Coding!:)
C#
Answer 8 May 2013   license: CPOL
do not use bracketsexec salary 'a',2000Happy Coding!:)
SQL
Answer 8 May 2013   license: CPOL
insert group of you date field in reportnow in create 3 formulas1. Reset_SpareParts //Put in Header-section of Date group //Suppress itGlobal StringVar SpSP:= '';2. Merge_SpareParts //Put in Detail section //Suppress itGlobal StringVar SpSP := SP + ',';3. Print_SpareParts...
CrystalReports
Answer 7 May 2013   license: CPOL
Use SUM Not Countalter procedure sp_insertticketsforcustomer(@custid int,@custname varchar(50),@date datetime,@noofseats int,@rowname char(10))asbegindeclare @noofcounts intselect @noofcounts= SUM(Noofseats) from CustomerDetails where RowName=@rownameselect @noofcountsendHappy...
SQL-Server
Check the Date comparison ? by Aarti Meswania
Answer 7 May 2013   license: CPOL
echo sql query and check it by execute that in MySQLCheck Date format passed from PHP it should be yyyy-MM-ddand in first query you are using >= then in second query you should use
PHPMySQL
Answer 7 May 2013   license: CPOL
visit link...http://graphicdesign.stackexchange.com/questions/199/point-vs-pixel-what-is-the-difference[^]Happy Coding!:)
GUI
Answer 7 May 2013   license: CPOL
1.add DatagridviewCheckboxColumn2. Use CurrentCellDirtyStateChanged event put color changing code stuff insidePrivate void dgv1_CurrentCellDirtyStateChanged(Object sender, System.EventArgs e) { If (dgv1.IsCurrentCellDirty) { ...
C#
Answer 7 May 2013   license: CPOL
use distinctselect DISTINCT mt.MachinaryType, md.MachinaryName, md.Model, md.CountryOrRegion, md.WarrentyPeriod, md.PriceBDT, d. DeptName, c.CompanyName, mp.MaintencePlanType, em.EmpCode, em.EmpName from tblMachinaryDetails md ...
SQL-ServerSQL2008
Answer 7 May 2013   license: CPOL
you have not provide table structure but for hint,...Select Class_Nm, Sum(TotalStudents) TotalStudents, sum(Pur_students) Pur_students,Sum(TotalStudents)-sum(Pur_students) as Not_Pur_StudentFrom( select Class_Nm,sum(Student_Id) as TotalStudents,0 as Pur_students from...
SQL
Answer 7 May 2013   license: CPOL
Use Datagridview's CurrentCellDirtyStateChanged eventPrivate void dgv1_CurrentCellDirtyStateChanged(Object sender, System.EventArgs e) { If (dgv1.IsCurrentCellDirty) { dgv1.CommitEdit(DataGridViewDataErrorContexts.Commit) If...
C#C#4.0
Answer 6 May 2013   license: CPOL
because page is going refreshHappy Coding!:)
PHP
Answer 6 May 2013   license: CPOL
DECLARE @questionDesc VARCHAR(MAX)Set @questionDesc=REPLACE(@question,'''''''''','''')--for one ' use two '' ... dark single quote is expressing starting & ending of string.insert into tblTestQuestions values(@questionDesc)Happy Coding!:)
SqlServer
Answer 6 May 2013   license: CPOL
1.you can not add custom control in datagridviewyou should create a column of that type of custom control2.you can add custom control in button but you should use containers like panel, tabellayoutpanele.g. button1.Controls.Add(new MyCustomControl1());Happy Coding!:)
C#
Answer 6 May 2013   license: CPOL
You should set papername custom and then set paper's Height & widthHappy Coding!:)
C#.NETCodeProjectprintingCrystalReportsPrinter
Re: In Diploma 5th sem by Aarti Meswania
Forum Message 6 May 2013  
No I had seen result on site
Answer 6 May 2013   license: CPOL
It is quite simpleJust copy new exe and replace old exe on client pc with new one.And if any new dll or reference file is used then also put them on client machine in installation folderHappy Coding!:)
C#
Re: In Diploma 5th sem by Aarti Meswania
Forum Message 6 May 2013  
I have not started preparations yet It was E grade in last exam. I hope so, this time it will clear :-O
Re: In Diploma 5th sem by Aarti Meswania
Forum Message 6 May 2013  
yes dear How ur preparations going on for AMIE exam?
Answer 6 May 2013   license: CPOL
Try this"2012-04-02T12:04:47.9010868+10:00".Tostring().Replace("T"," T ").Replace("+"," + ")Happy Coding!:)
VBVB.NET
Answer 6 May 2013   license: CPOL
1.use StoreProcedure and pass values through sql parameters2.else use... Textbox1.Text.Replace("'","''")1st Method is best approch.Happy Coding!:)
VBVB.NET
Answer 5 May 2013   license: CPOL
visit link...http://www.daniweb.com/software-development/visual-basic-4-5-6/threads/280300/code-for-receiving-sms-on-pc-using-at-coomand-and-in-vb6[^]Happy Coding!:)
VBVB10
Answer 5 May 2013   license: CPOL
select table1.id, case when companyid=1 then 'c' Else 'd' end as flagfrom table1 join table2 table1.id=table2.idHappy Coding!:)
SQL-Server
Answer 5 May 2013   license: CPOL
If it is windows application,set welcome label's properties...Label1.Dock = Fill;Label1.TextAlign = MiddleCenter;Happy Coding!:)
SQL2005.NET3.5C#.NETSQL-ServerC#4.0
Answer 5 May 2013   license: CPOL
Try This,SELECT P.*FROM PTABLE PLEFT JOIN MTABLE M ON P.MATERIALID = M.MATERIALIDLEFT JOIN NTABLE R ON P.MATERIALID = N.MATERIALIDWHERE M.MATERIAL = CASE WHEN P.MATERIAL IS NOT NULL THEN N.MATERIAL ELSE P.MATERIAL ENDHappy Coding!:)
OracleT-SQL
Answer 5 May 2013   license: CPOL
If you want datewise summary then,SELECT Date(table_sale1.bill_date) as Date_, sum(table_sale1.total_amount) as bill_amt, sum(table_sale1.amount_paid) as amt_paid, sum(table_sale1.amount_due) as amt_due, sum(table_invoice.total_amount) AS invoice_amt,...
C#
Answer 5 May 2013   license: CPOL
if it's series then simply,select c1,c2,case when (c1-1)=0 then NULL else (c1-1) end as C3from tblnmHappy Coding!:)
SQLServer2008
Crystal Report Problem by Aarti Meswania
Answer 5 May 2013   license: CPOL
Visit Links...How to Use Crystal Report Step by step in Asp.net-c#[^]http://www.aspdotnet-suresh.com/2012/01/crystal-reports-sample-in-aspnet.html[^]Happy Coding!:)
C#ASP.NET
Answer 2 May 2013   license: CPOL
Create this function that will used for parse values set ANSI_NULLS ONset QUOTED_IDENTIFIER ONGOALTER FUNCTION [dbo].[ParseValues](@String varchar(8000), @Delimiter varchar(max) )RETURNS @RESULTS TABLE (ID int identity(1,1), Val varchar(max))ASBEGIN DECLARE @Value...
SQL-Server
Answer 2 May 2013   license: CPOL
visit link...http://www.c-sharpcorner.com/uploadfile/Shawpnendu/dynamically-creating-bound-and-template-columns-in-gridview-using-Asp-Net/[^]Happy Coding!:)
C#ASP.NETSQL
Error inserting datepart by Aarti Meswania
Answer 2 May 2013   license: CPOL
example...insert into tablename( mysqldate ) values( '2013-12-25'--format is yyyy-MM-dd )Happy coding!:)
Oracle
Flash analog clock in c# by Aarti Meswania
Answer 2 May 2013   license: CPOL
Visit link...http://stackoverflow.com/questions/1037/displaying-flash-content-in-a-c-sharp-winforms-applicationhttp://social.msdn.microsoft.com/Forums/en-US/vbgeneral/thread/511d8bb4-3674-4717-9bd9-71cfc5d921e5[^]Happy Coding!:)
C#
Answer 2 May 2013   license: CPOL
Try this...SELECT a.AssetStatusId, s.AssetStatus, COUNT(*) as [Assets] from TblAssetStatus sleft join TblAsset a on a.AssetStatusId = s.AssetStatusIdINNER JOIN dbo.TblStoreStock ON a.StoreStockId = dbo.TblStoreStock.StoreStockIdINNER JOIN dbo.TblStock ON dbo.TblStoreStock.StockId =...
SQL-Server
Get Distinct column value rows by Aarti Meswania
Answer 2 May 2013   license: CPOL
select * from ( select Row_Number() over(Partition by KitComponentID,Created_on order by KitComponentID,Created_On desc) as SrNo, * from tblnm ) as tmptbl where SrNo=1for sql 2000select * from tblnm t1 where t1.stgID = (select top 1 stgid from tblnm t2 where...
SQL2000SQL-Server
Re: New Ju-Ju ads... by Aarti Meswania
Forum Message 2 May 2013  
they are showing common features which are also available in other service providers but they are just performing advertise well. so, we like to watch zoo-zoos... they are cute :-O
Answer 2 May 2013   license: CPOL
In your table bankname Make BankId Primarykey and AutoincreamentALTER procedure [dbo].[sp_BankName] ( @BankId as int, @bankname as varchar(50), @banknamea as nvarchar(50) ) as begin if exists(select * from bankname where bankid=@BankId) begin insert into...
ASP.NETSQL
Query for Select Manager by Aarti Meswania
Answer 1 May 2013   license: CPOL
Self-joinselect e1.empid,e1.empnm,e2.empnm as ManagerNm from emptbl e1left join emptbl e2 on e1.ManagerId = e2.EmpId Happy Coding!:)
sqlserver2008
Answer 1 May 2013   license: CPOL
In Table bankname ,set BankId as PrimaryKey And AutoIncreamentthen write query...ALTER procedure [dbo].[sp_InsertBankName] ( @bankname as varchar(50) ,@banknamea as nvarchar(50) ) as begin insert into bankname (bankname,banknamea) ...
ASP.NETSQL-Server
Answer 1 May 2013   license: CPOL
set datagridview's UserCanDeleteRow Property to falseNow in cell click event of datagridviewCheck e.ColumnIndex is equal to column index of deletebtnColumnthen... show message dialog..DialogResult dr = Messagebox.Show("Are you sure to delete...
C#
Reminder in WindowsApplication by Aarti Meswania
Answer 29 Apr 2013   license: CPOL
use timer control (with / without thread)when time match with desired then show popup windowHappy Coding!:)
C#
Answer 29 Apr 2013   license: CPOL
It will not stop searching if one match found but you can filter records so, finally you will get result you wantTry this...with tbl1 as ( select 'Abc' as A1 union all select 'xyz' as A1 )select * from( select Row_Number()...
SQL
Page 1 of 16
1 2 3 4 5 6 7 8 9 10
First · Prev · Next · Last


Advertise | Privacy | Mobile
Web04 | 2.6.130513.1 | Last Updated 14 May 2013
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid