15,891,864 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Javascript questions
View Visual Basic questions
View Python questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Comments by Om Prakash Pant (Top 102 by date)
Om Prakash Pant
18-Jun-15 0:21am
View
I think in this statement,"dbo.BuildClientSchema" should be in single quotes as well.
select * from sys.objecs where name=dbo.BuildClientSchema ....
Om Prakash Pant
16-Jan-15 0:17am
View
Your question is not clear. please add some more details
Om Prakash Pant
24-Jul-14 10:35am
View
value will not be null. I think u can check for IsEmpty
Om Prakash Pant
18-Jun-14 9:29am
View
Check the example for insert here:
http://msdn.microsoft.com/en-us/library/system.data.oracleclient.oracledataadapter.insertcommand(v=vs.110).aspx
Om Prakash Pant
26-Mar-14 3:19am
View
see this thread for an example
http://lazyloaders.com/threads/stored-procedure-foreign-key.2144/
if you are looking for specific issue then please provide more details.
Om Prakash Pant
21-Feb-14 4:45am
View
Can you provide more details with an example on what you are trying to accomplish?
Om Prakash Pant
4-Feb-14 0:58am
View
declare final as variable and print.
or you can also do the following:
Select 'Dear Student, thanks for contacting HIMT. Batch dates for ' + @Keyword + '. ' + @Batchdate
Om Prakash Pant
23-Aug-13 1:11am
View
Try running the query and see if you are getting records.
Om Prakash Pant
30-May-13 2:58am
View
what all code have you tried so far?
Om Prakash Pant
9-Apr-13 0:58am
View
Can you show us the SQL queries you have tried so for?
Om Prakash Pant
22-Feb-13 6:24am
View
insert data in parent table first and then in child table
Om Prakash Pant
22-Feb-13 6:01am
View
try this:
ConfigurationManager.ConnectionStrings["con"].ToString();
Om Prakash Pant
21-Jan-13 3:58am
View
remove "on error resume next" to see the actual error.
Om Prakash Pant
15-Jan-13 8:27am
View
can you provide more details? the information you have provided is not sufficient.
Om Prakash Pant
11-Jan-13 9:04am
View
As an example, i have added some value. "Select" is text and "NA" is value in above example.
Om Prakash Pant
11-Jan-13 4:10am
View
both the result in a single column? not clear
Can you show us what output you need?
Om Prakash Pant
15-Nov-12 6:25am
View
see the updated SQL query in above solution
Om Prakash Pant
8-Nov-12 7:03am
View
yes, it has to be the other way
Om Prakash Pant
8-Nov-12 6:56am
View
do you have all the data in the same format?
Om Prakash Pant
7-Nov-12 7:29am
View
not clear, can you please elaborate?
Om Prakash Pant
1-Nov-12 6:59am
View
Your question is not clear. you provide file name and you need full path of file?
test.tx is in same folder?
Om Prakash Pant
10-Oct-12 5:38am
View
Agree that you want to create a query, but what all you have tried so far?
Om Prakash Pant
9-Oct-12 8:52am
View
Can you show us the code which you tried so far?
Om Prakash Pant
8-Oct-12 8:56am
View
also, in the sample data you entered, the city is 'D' and not 'dubai'
Om Prakash Pant
1-Aug-12 4:17am
View
your table has identity column. you need to set the identity insert before inserting the data.
SET IDENTITY_INSERT dbo.City ON
GO
Om Prakash Pant
25-Jul-12 2:51am
View
what all you tried so far?
Om Prakash Pant
9-Jul-12 9:05am
View
can you show us the code that you tried so far?
Om Prakash Pant
9-Jul-12 9:04am
View
so you only want the age and not date of birth?
Om Prakash Pant
6-Jul-12 7:43am
View
what you want to perform is not clear..
If the value in <%=rs1("tradename")%> is null then you don't want the textbox to be displayed. is this correct?
Om Prakash Pant
27-Jun-12 7:30am
View
Can you print "sqlString" and show the output?
Also, convert other variables like dte, takenby used in the query to string (if they are not string variables).
Om Prakash Pant
30-May-12 4:22am
View
if your table has primary key then this should be simple
Om Prakash Pant
21-May-12 8:24am
View
Can you show us the code that you have tried so far?
Om Prakash Pant
18-May-12 8:39am
View
How do you want to display the result?
Om Prakash Pant
15-Mar-12 7:24am
View
this is not a good design..
Om Prakash Pant
23-Feb-12 1:12am
View
select 'STT' as tournamentID from tblTournaments
Om Prakash Pant
23-Feb-12 0:49am
View
then in that case you only need this
select 'STT' from tblTournaments
Om Prakash Pant
17-Feb-12 5:46am
View
can you paste the exact error that you are getting?
Om Prakash Pant
17-Feb-12 5:39am
View
what result you are getting?
you should get distinct records on prl.description ,convert(varchar,prl.effective_date,103) effective_date, b.description brand , pc.description cat
Om Prakash Pant
20-Jan-12 0:53am
View
yes :-)
i was looking at multiple posts of same question
Om Prakash Pant
19-Jan-12 9:00am
View
in HRISDetails table, do you also have managerId which is Ecode? or you need to match with the managername & ename?
Om Prakash Pant
18-Jan-12 7:19am
View
what is the error you are getting?
Om Prakash Pant
17-Jan-12 8:25am
View
Can you show us the table structure of feedback & product details?
Om Prakash Pant
16-Jan-12 22:19pm
View
put the code in form load event instead of cbo_StartYear_SelectedIndexChanged
Om Prakash Pant
13-Jan-12 7:44am
View
what are the datatypes of each column?
Om Prakash Pant
13-Jan-12 5:15am
View
please elaborate more and show us the code that you have tried so far
Om Prakash Pant
13-Jan-12 3:01am
View
will the length of data that you want to extract remain same?
Om Prakash Pant
12-Jan-12 6:57am
View
i am not sure you will get count by setting the rs. pl see the following link for options:
http://www.devx.com/tips/Tip/14143
Om Prakash Pant
11-Jan-12 0:58am
View
Here is another example:
CREATE TABLE tbl_bankmaster (bank_id int, bank_name varchar(100),status char(1))
insert into tbl_bankmaster values (5, 'Bank5',0);
insert into tbl_bankmaster values (28, 'Bank28',0);
create procedure [dbo].[sp_proc_select] (@bankId varchar(4096))
as
begin
exec ('update tbl_bankmaster set status = 1 where bank_id in (' + @bankId + ')')
end
exec sp_proc_select '5,28'
SELECT * FROM tbl_bankmaster
Om Prakash Pant
11-Jan-12 0:57am
View
call the SP as follows:
exec sp_proc_select '5,28'
Om Prakash Pant
2-Jan-12 0:43am
View
does your data contain "Female BC-" for all records?
Om Prakash Pant
29-Dec-11 1:48am
View
please elaborate
Om Prakash Pant
27-Dec-11 5:35am
View
"
Please give your answers as soon as possible
" - Is this a Quiz?
Om Prakash Pant
27-Dec-11 4:07am
View
input to form? please elaborte
Om Prakash Pant
19-Dec-11 7:13am
View
didn't saw your post !!
Om Prakash Pant
24-Nov-11 6:25am
View
can you paste the code
Om Prakash Pant
11-Nov-11 0:52am
View
can you show the code which you have already written for this?
Om Prakash Pant
3-Nov-11 8:34am
View
can you show what code you have written?
Om Prakash Pant
3-Nov-11 4:36am
View
your query is not clear. do you want to store image in access database using vb6?
Om Prakash Pant
31-Oct-11 9:02am
View
not clear. can you please elaborate?
Om Prakash Pant
31-Oct-11 8:59am
View
why not use a stored procedure & store in temp table or use with statement.
Om Prakash Pant
24-Oct-11 6:50am
View
in that case you need to add this in where clause. something like:
and (isnull(@parm,0) = 0 OR columnname in (select idfield from otherTable where param_field = @parm))
Otherwise it will return all values.
Om Prakash Pant
24-Oct-11 6:05am
View
directly go to the Sql Server create open dialog? - please elaborate
Om Prakash Pant
5-Oct-11 6:20am
View
check the following FAQ
http://www.internic.net/faqs/domain-names.html
Om Prakash Pant
3-Oct-11 8:58am
View
check the following kb article on managing FKeys:
http://msdn.microsoft.com/en-us/library/ms177463(v=sql.90).aspx
Om Prakash Pant
28-Sep-11 6:34am
View
what is the sequence of data? is it random or how the data is placed?
Om Prakash Pant
28-Sep-11 3:49am
View
Make sure you have set the correct references.
Om Prakash Pant
28-Sep-11 3:46am
View
"Locate" a file? not clear.
you can view all files in solution explorer.
Om Prakash Pant
28-Sep-11 3:44am
View
pl check this one
http://stackoverflow.com/questions/5512943/linq-interrupt-execution-of-stored-procedure
Om Prakash Pant
26-Sep-11 7:25am
View
the value of objDataSet.Tables[0].Rows[i]["Excl"] is -562,000.00? and what is the datatype of this column?
Om Prakash Pant
21-Sep-11 7:02am
View
any specific reason for creating date fields as nvarchar?
(compdate,comptime,forwardeddate,forwardedtime)
Om Prakash Pant
19-Sep-11 4:41am
View
you said you have 2 different tables with same schema and you want to subtract the cost. correct?
Om Prakash Pant
16-Sep-11 6:04am
View
you want this in c# or you need one time database backup and restore?
Om Prakash Pant
13-Sep-11 9:24am
View
you can get number of columns for a table, for a select query i don't think you will get columns from sql server.
Om Prakash Pant
13-Sep-11 8:29am
View
do you have an identity column in the employee table? how come employee table has duplicate data?
Om Prakash Pant
8-Sep-11 9:38am
View
Create table #test_table (grade varchar(10), tot_pass int, tot_num int,PasRate Decimal(3,0))
Declare @TotPass int,@TotNum int, @PasRate Decimal(3,0),@intFlag INT = 7
insert into #test_table
SELECT grade, COUNT(ProgressionStatus),0,0 from LearnerProgression
where AcademicYear='2010' and EmisCode='500171421'
group by Grade
--update total pass column and total column using the "update" statement..
Om Prakash Pant
8-Sep-11 9:32am
View
Not necessarily group by will always return more than one value. it depends.
Instead of array, create a temp table and store the result and do the processing..
Om Prakash Pant
8-Sep-11 7:16am
View
check the following articles:
http://www.jrsoftware.org/iskb.php?vb
http://techdos.com/index2.php?option=com_content&do_pdf=1&id=74
Om Prakash Pant
24-Aug-11 4:05am
View
is it an update statement?
Om Prakash Pant
11-Aug-11 6:25am
View
emp code and id stored in separate columns or in single column?
Om Prakash Pant
5-Aug-11 3:42am
View
Your question is not clear.
You can use joins to get data from 2 tables.
Om Prakash Pant
28-Jul-11 6:59am
View
If you mean how to pass parameters to stored procedure from asp.net page, then check the following link:
http://www.java2s.com/Tutorial/CSharp/0560__ADO.Net/Callstoredprocedureandpassintheparameter.htm
http://www.c-sharpcorner.com/UploadFile/gtomar/storedprocedure12052007003126AM/storedprocedure.aspx
Om Prakash Pant
11-Jul-11 9:21am
View
One option is to use XML.
Combine all the data & create XML, pass it to the stored procedure
Om Prakash Pant
6-Jul-11 3:07am
View
try this, this will work irrespective of any number of zeros
Om Prakash Pant
9-Jun-11 5:38am
View
and based on what criteria?
Om Prakash Pant
18-May-11 8:46am
View
your question is not clear. can you add some code and more details?
Om Prakash Pant
18-May-11 7:23am
View
you mean to get the selected value of listbox in asp.net?
Om Prakash Pant
16-May-11 7:08am
View
can you paste code that is been used?
Om Prakash Pant
11-May-11 0:59am
View
last name will come since the name field is different correct? or you want the first name with whatever name if there are multiple IPs?
Om Prakash Pant
26-Apr-11 2:59am
View
Try :
dsData = Data.GetDataSet(sqlData, GlobalParameters.conn)
if (dsData.Tables.Count > 0)
For Each dr As DataRow In dsData.Tables(0).Rows
.
.
Om Prakash Pant
26-Apr-11 2:54am
View
you mean when you change the value from client side of a textbox, on submit you need the text box value?
Om Prakash Pant
22-Apr-11 3:25am
View
to display records from both tables, you have join these tables.
Om Prakash Pant
14-Apr-11 2:56am
View
If Framework 2.0 PRE SP1 is used then Use Path.GetFileName
else use openFileDialog.SafeFileName
Om Prakash Pant
7-Apr-11 7:34am
View
The position of columns does not matter. By using the select statelemt you can have it at the place you want.
SELECT col1,col3,col2 from table_name
If you want to rearrange then you have to use SELECT ... INTO .. which will create new table with the order you want.
Om Prakash Pant
7-Apr-11 2:50am
View
your question is not clear. do you want to rearrange the columns of existing table?
Om Prakash Pant
29-Mar-11 3:37am
View
you are already provided the code to insert data in temp tables and do calculations. what is the issue that you are facing?
Om Prakash Pant
26-Mar-11 2:47am
View
can you provide the database schema for both the tables and the relation between them?
Om Prakash Pant
16-Feb-11 6:02am
View
for more examples on join, please check the following link:
http://www.plus2net.com/sql_tutorial/sql_inner_join.php
Om Prakash Pant
29-Sep-10 1:17am
View
Well, the question is generic and there can be more than one answer..
Om Prakash Pant
29-Sep-10 1:14am
View
It is not about column is unique or not. you cannot convert any data to any format. see this link on what you can convert and to which datatypes..
http://msdn.microsoft.com/en-us/library/ms187928.aspx
Om Prakash Pant
28-Sep-10 7:23am
View
Another guide for beginners:
http://www.codeproject.com/KB/database/sql_in_csharp.aspx
Om Prakash Pant
27-Sep-10 7:35am
View
make sure the fields already exists in the excel sheet
Om Prakash Pant
27-Sep-10 5:10am
View
Can you show us the code which is being used for updating the data?
Show More