Comments by Kuthuparakkal (Top 200 by date)

You could use SQL to fetch the data starting from 19th Position. Create Excel File Connection, Excel Data Source and use SQL like below and put it in destination table like any other SSIS package.
SELECT [YourColumnName1], [YourColumnName2], ....
FROM [ExcelSheetName$A19:IV]

This is the normal operation, Excel is read until the last row every time, you do not need any specific logic. Just go ahead with SSIS package creation.
A conditional Split can be inserted to spit our blank rows - this may occur when the contents of last few rows are emptied.
If you are looking for more sophisticated automation then look at my article: http://www.codeproject.com/Articles/368530/Dynamic-Excel-file-loading-with-SSIS

Okay. End of Cell means row or columns ? Are the number of columns fixed ?

Read Excel with what ? C# , SSIS , etc ?

If it worked, mark as answer!

[Dim Data Period] may not be your dim name - change it (commonsense !? )

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace TestAccessDB
{
class Program
{
static void Main(string[] args)
{
Run();
}

private static void Run()
{
//Using JET.OLEDB :
System.Data.OleDb.OleDbConnection AccessConn = new
System.Data.OleDb.OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Data\Matrix\Info.accdb");

//Using ACE.OLEDB :
//System.Data.OleDb.OleDbConnection AccessConn = new
//System.Data.OleDb.OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Test Files\\db1.mdb")

AccessConn.Open();

//New table, using SELECT INTO
System.Data.OleDb.OleDbCommand AccessCommand = new System.Data.OleDb.OleDbCommand("SELECT * INTO [Accounts] FROM [Accounts] IN '' [ODBC;Driver={SQL Server};Server=(local);Database=Test;Trusted_Connection=yes];", AccessConn);

//Existing table, using INSERT INTO
//Dim AccessCommand As New System.Data.OleDb.OleDbCommand("INSERT INTO [ORDERS] SELECT * FROM [Orders] IN '' //[ODBC;Driver={SQL Server};Server=(local);Database=Northwind;Trusted_Connection=yes];", AccessConn)

AccessCommand.ExecuteNonQuery();
AccessConn.Close();
}
}
}

Split the string into array (based on spaces), then use LINQ first and last like:
stringArray.First();
stringArray.Last();

Is this a question ?

Modified my answer, review!

q = "SELECT * FROM Employees WHERE [First Name(s)] = " + "'*" + textBox1.Text.Trim() + "*'";

Initiate & commit the transactions within the for loop.
.....
for(....
{
Int64 CurrentOrderIdInArray = Convert.ToInt64(OrderIds.GetValue(i).ToString());
UpdateTransaction = Conn.BeginTransaction();
sqlCmdTakeOwnership.Transaction = UpdateTransaction;
....
UpdateTransaction.Commit();
}
OrderIds = null;
.....
.....


OR Use : TransactionScope
using (TransactionScope scope = new TransactionScope())
{
for(....)
{
}

scope.Complete();
}

Fix a task for you; start coding towards it; this way you may get started. For example: Try to get some data stored in a database; load them into DataTable and do manipulation of the data and try to display your data the way you want.
Also go through Articles here in CodeProject of a topic of your interest

You may try to cut-short your code as :
TimeSpan diff = endTime.Subtract(startTime);
result = ((int)diff.TotalHours).ToString() + ":" + (diff.Minutes).ToString();

Very nice question - keep moving!

This is not the way you think it is.

Have you heard of DBML : take a look - https://msdn.microsoft.com/en-us/library/bb386927(v=vs.110).aspx

English has gotten worsen this much since....

check if Database.t already exists or not ?

you are welcome!

I posted a solution, please have a look.

I didnt quite understand the objective. Could you explain it in simple English rather than pseudo code ?

Create a WebService Proxy, https://msdn.microsoft.com/en-us/library/bbs97dkt%28v=vs.90%29.aspx

Take a look : http://www.codeproject.com/Articles/41869/Custom-Drawn-Scrollbar

Unclear

Unclear!

Some webapp checks whats the link before post to ensure max security

Assumed no-gaps. In fact you need to create a table variable (SI, Id) and iterate it and pick Id

Create variable and determine local path, then use this variable to build exact path and apply!

ALTER TABLE is for existing table, not for the tables to be created in future.

Explain whats there in the bind method

Great answer! my 5+

Everything is possible, only thing that makes it possible is your approach.

Take a look here : http://blogs.msdn.com/b/text/archive/2006/07/10/font-families-and-friendly-names.aspx

Try: http://support.microsoft.com/kb/308260

Use LEFT OUTER JOIN
http://docs.oracle.com/javadb/10.8.1.2/ref/rrefsqlj18922.html

May be you are missing a linefeed between data.

Try something like this: https://code.djangoproject.com/wiki/Tutorials

Please improve question, its not clear to attempt for a solution

Buy a GSM modem, and send it.
Or
Buy SMS Pack from SMS Provider and they may have APIs to consume in your code

Check my answer

Good one. my 5+

my 5+

Look at Irrlicht - it's open source. http://irrlicht.sourceforge.net/
Also Box2D is another 2D Open Source Physics Engine. http://box2d.org/
You will get ideas how to port it. Both the libraries are much used.

Was looking for high rated questions and answers... :)

my 5+

good one!

my 5+

Website counterfeiting :)

Yes, I do agree SA! Why should we bother.

Unclear

Good one!

my 5+

Best possible answer

Posted a solution, try it

Try this:

public static HttpWebResponse POST(string postData, string url, string referer, CookieContainer cookie)
{
try
{
byte[] byteArray = Encoding.UTF8.GetBytes(postData);
HttpWebRequest request = (HttpWebRequest)HttpWebRequest.Create(url);
request.Method = "POST";
request.KeepAlive = true;
request.AllowAutoRedirect = false;
request.Accept = "*/*";
request.ContentType = "application/x-www-form-urlencoded";
request.CookieContainer = cookie;
if (!string.IsNullOrEmpty(referer))
request.Referer = referer;
request.ContentLength = byteArray.Length;
request.UserAgent = "Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.0.5) Gecko/2008120122 Firefox/3.0.5";
// request.Proxy = null;
Stream dataStream = request.GetRequestStream();
dataStream.Write(byteArray, 0, byteArray.Length);
dataStream.Close();
return (HttpWebResponse)request.GetResponse();
}
catch
{
return (HttpWebResponse)null;
}
}

Try this:

public static HttpWebResponse POST(string postData, string url, string referer, CookieContainer cookie)
{
try
{
byte[] byteArray = Encoding.UTF8.GetBytes(postData);
HttpWebRequest request = (HttpWebRequest)HttpWebRequest.Create(url);
request.Method = "POST";
request.KeepAlive = true;
request.AllowAutoRedirect = false;
request.Accept = "*/*";
request.ContentType = "application/x-www-form-urlencoded";
request.CookieContainer = cookie;
if (!string.IsNullOrEmpty(referer))
request.Referer = referer;
request.ContentLength = byteArray.Length;
request.UserAgent = "Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.0.5) Gecko/2008120122 Firefox/3.0.5";
// request.Proxy = null;
Stream dataStream = request.GetRequestStream();
dataStream.Write(byteArray, 0, byteArray.Length);
dataStream.Close();
return (HttpWebResponse)request.GetResponse();
}
catch
{
return (HttpWebResponse)null;
}
}

I dont understand, can you make it clear ?

var firstNotSecond = list1.Except(list2).ToList();
var secondNotFirst = list2.Except(list1).ToList();

https://msdn.microsoft.com/en-us/library/ms162575.aspx

Try this: http://www.vbforums.com/showthread.php?538218-RESET-running-total-after-each-page

Set a variable say boolean var FuncRunnig = false
Set the var value appropriately, check this var before calling the function

Please check my solution

Pls check my answer

Streaming means get by chunks, so whats the issue ?

What have you tried so far ? Is it SQL or VB.NET ?

my 5+

Bad design

I dont understand, explain more

not an answer

+5

+5

Ask Microsoft

My 5+

:)

:(

Great!

Not an answer..

Self goal ?

SA 5*, my +5

+5

I dont understand

Need more info

Expectation reduces joy!

Please take a look : http://support.microsoft.com/kb/820122

:)

It has to be done in a composite way. Like setting some identifier (like some html css class) from code behind and you client side scripting like (jscript) to identify those cells/rows and toggle color of the row/cell at regular intervals

Is that GET or POST ? Normally Query String redirects are GET. Open the WebSite and look at its html, you would see - method="post" - in the section where you have a form tag. If it's POST then you need to really make POST request rather than creating a query string.
https://msdn.microsoft.com/en-us/library/debx8sh9%28v=vs.110%29.aspx

Great! +5

+5

Create Methods like
void CW(string s)
{
Console.WriteLine(s);
}

Pls explain more

Well said +5

???

You're welcome!

PropertySet propSet = new PropertySet(BasePropertySet.IdOnly, ItemSchema.Subject, EmailMessageSchema.IsRead);

EmailMessage mail = EmailMessage.Bind(service, itemId, propSet);

EmailMessage

I have posted an answer, please check

What are you using ? ExchangeWebAPI or what ?

select roll_no, ([16-02-2015] + [17-02-2015] + [18-02-2015]) as Total
from yourTable

What have you tried so far ? Whats the change you face ?

Add an Identity Column (1,1) to your table, say ID
Now you order by ID check NULLS and update. I may post a solution later

Add another loop to iterate cVowels and compare each character against sSentence[o]

Unclear

Look at IIS Permissions

Homework

lOOK AT THIS: http://stackoverflow.com/questions/12068154/on-the-fly-search-algorithm-in-listbox

private void cmdSave_Click(object sender, EventArgs e)
{
try
{
//Read Image Bytes into a byte array
byte[] imageData = ReadFile(txtImagePath.Text);

//Initialize SQL Server Connection
SqlConnection CN = new SqlConnection(txtConnectionString.Text);

//Set insert query
string qry = "insert into ImagesStore (OriginalPath,ImageData) _
values(@OriginalPath, @ImageData)";

//Initialize SqlCommand object for insert.
SqlCommand SqlCom = new SqlCommand(qry, CN);

//We are passing Original Image Path and
//Image byte data as sql parameters.
SqlCom.Parameters.Add(new SqlParameter("@OriginalPath",
(object)txtImagePath.Text));

SqlCom.Parameters.Add(new SqlParameter("@ImageData",
(object)imageData));

//Open connection and execute insert query.
CN.Open();
SqlCom.ExecuteNonQuery();
CN.Close();

//Close form and return to list or images.
this.Close();
}

Dangerous. Have a look:
https://msdn.microsoft.com/en-us/magazine/hh580736.aspx

You need to set EnableSsl property to true.

Have you looked at : http://www.embarcadero.com/products/rad-studio/ios-development

It may not be a picture.

Improve Question, Define the problem, What have you tried to address the problem ? Whats the real challenge ?

Unclear

Homework ?

Self goal.

Have you looked at Replication ?
https://msdn.microsoft.com/en-us/library/ms146892.aspx

Thank you

Done!

Replace Inner SELECT UNION with your table name.

SELECT
[QGroup], SUM([values]) AS [sum-value-quarterly]
FROM
(
SELECT *, CEILING([counter] /3.0) AS [QGroup]
FROM
(
SELECT 1 AS [counter],10 AS [values]
UNION
SELECT 2 AS [counter],14 AS [values]
UNION
SELECT 3 AS [counter],16 AS [values]
UNION
SELECT 4 AS [counter],20 AS [values]
UNION
SELECT 5 AS [counter],30 AS [values]
UNION
SELECT 6 AS [counter],50 AS [values]
UNION
SELECT 7 AS [counter],25 AS [values]
UNION
SELECT 8 AS [counter],35 AS [values]
UNION
SELECT 9 AS [counter],10 AS [values]
UNION
SELECT 10 AS [counter],15 AS [values]
UNION
SELECT 11 AS [counter],25 AS [values]
)AS X
)AS Y
GROUP BY [QGroup]
ORDER BY [QGroup]

Are you talking about programmatic GET/POST like using HttpWebRequest ?

Add more details

Depends!

SQL is capable of handling LINQ nowadays (2025 Feb 15)!

Please elaborate

Use Joins

Dim productImageByte As Byte() = TryCast(dr(16), Byte())
If productImageByte IsNot Nothing Then
Using productImageStream As Stream = New System.IO.MemoryStream(productImageByte)
PictureBox1.Image = Image.FromStream(productImageStream)
End Using
End If

http://support.microsoft.com/kb/2468871
http://support.microsoft.com/kb/2183292

Try:
http://www.codeproject.com/Articles/20420/How-To-Send-and-Receive-SMS-using-GSM-Modem

What is the column data type in mysql table ?

package com.test;

import java.util.Properties;

import javax.mail.BodyPart;
import javax.mail.Message;
import javax.mail.MessagingException;
import javax.mail.Multipart;
import javax.mail.Session;
import javax.mail.Transport;
import javax.mail.internet.AddressException;
import javax.mail.internet.InternetAddress;
import javax.mail.internet.MimeBodyPart;
import javax.mail.internet.MimeMessage;
import javax.mail.internet.MimeMultipart;

import org.junit.Test;

public class EmailService {

@Test
public void test(){
Properties props = System.getProperties();
props.put("mail.smtp.starttls.enable", true); // added this line
props.put("mail.smtp.host", "smtp.gmail.com");
props.put("mail.smtp.user", "username");
props.put("mail.smtp.password", "password");
props.put("mail.smtp.port", "587");
props.put("mail.smtp.auth", true);



Session session = Session.getInstance(props,null);
MimeMessage message = new MimeMessage(session);

System.out.println("Port: "+session.getProperty("mail.smtp.port"));

// Create the email addresses involved
try {
InternetAddress from = new InternetAddress("username");
message.setSubject("Yes we can");
message.setFrom(from);
message.addRecipients(Message.RecipientType.TO, InternetAddress.parse("receivermail"));

// Create a multi-part to combine the parts
Multipart multipart = new MimeMultipart("alternative");

// Create your text message part
BodyPart messageBodyPart = new MimeBodyPart();
messageBodyPart.setText("some text to send");

// Add the text part to the multipart
multipart.addBodyPart(messageBodyPart);

// Create the html part
messageBodyPart = new MimeBodyPart();
String htmlMessage = "Our html text";
messageBodyPart.setContent(htmlMessage, "text/html");


// Add html part to multi part
multipart.addBodyPart(messageBodyPart);

// Associate multi-part with message
message.setContent(multipart);

// Send message
Transport transport = session.getTransport("smtp");
transport.connect("smtp.gmail.com", "username", "password");
System.out.println("Transport: "+transport.toString());
transport.sendMessage(message, message.getAllRecipients());


} catch (AddressException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (MessagingException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}

Source: StackOverFlow

DATEDIFF(SS, [Start-Time], [End-Time])

Please detail

Pls do homework at home!

Why cant we add a checkbox to tree nodes ?

If you are not interested to go that deep like File Allocation level, then you may create a windows service and that spawns WMI events (for file access) and deny access based on your criteria

Need more info. How do you minimize string ?

Follow: http://www.csharptutorial.in/37/csharp-net-how-to-consume-a-web-service-in-csharp-net-visual-studio-2010

Use reflection and loop through properties (recieved), get value and if you see the same property in your object (objRec_Emp) and assign the value. Is this you meant ?

What's the source of that WDSL, it should be a url. So copy the Url and create a service reference and paste the url. VS would create a class (proxy) for it. Now consume the class like anyother class

Good idea throwing readers into confusion. Explain more.

If it's that small; why don't you attempt to write it in C# ?

Create Property (get;set) for txtName text and txtLogin text. Refer to this properties while calling the thread rather than referring to form controls.
Set the properties in the button click (submit) event.

Not clear!

Reason for my vote of 1 \n Meaningless!!!

Purpose ?
Explanation ?
Copy and Paste ?
Where is txtDB, txtServer, txtInsert, txtSelect, txtUpdate, txtRunProcParam1, txtRunProcParam2, dgvSelect ?

"At once" and "Sequentially" never go hand-in-hand. Please explain more

it's working code; also you may try to see if PropertyInfo is null before getting the value. Thats the difference. Splitting into many would be easy to debug.

Read from the beginning, its not my code... Having eyes doesn't mean....

No probs :)

Does "Local System" have permission to access your files/folders ?

Please check the account under service is running has permission to access the file to be zipped

Well done!

Unclear ? What are you trying to do ?

what formula ? explain more

Post code sample from where you try to fetch file/its contents...
Also is this Windows app or console app ?

You're most welcome!

Thanks Manas!

No Probs!

See the solution posted....

Repost

not clear enough to answer, what's 50 GB a database size limitation or file size limitation ?

Post parent class(base) definition

Post sample output

that means you've everything in your table; dont need to reinsert... delete 1 or two records and try

Thanks Ridoy!!!

Duplicate

Thanks!

What hae you tried so far ? Explain more

Yes 5+!

unclear

Updated soln, please check!

Very well, glad to know you were lookin for this!!!

Not clear

What've u tried so far ? Also explain the question little more readable

Thanks Ridoy, appreciated!

If it helped pls maark answer.. thanks!

I dont understand yr question

Datatable/Rows/Columns etc have zero based indices, 0 first row, 1 second row etc.. In your case, there wasnt any second row so it fails there..

unclear

Did you install MySQL.Net Connector ?
If not install it from http://dev.mysql.com/downloads/connector/net

Dim dt3 As New DataTable
' Create four typed columns in the DataTable.
dt3.Columns.Add("ADminNo", GetType(String))
dt3.Columns.Add("PaperNo", GetType(Int32))
dt3.Rows.Add("111411H", "3")
dt3.Rows.Add("111411H", "18")
dt3.Rows.Add("172828z", "3")
dt3.Rows.Add("172828z", "18")
dt3.Rows.Add("111380Y", "93")
dt3.Rows.Add("111380S", "10")





Dim dt As New DataTable
' Create four typed columns in the DataTable.
dt.Columns.Add("ConflictingPaper", GetType(String))
dt.Columns.Add("Numberofstudents", GetType(String))
dt.Columns.Add("AdminNo", GetType(String))

Dim query1 = (From _a In dt3
Group Convert.ToString(_a.Field(Of Int32)("PaperNo"))
By AdminNo = _a.Field(Of String)("AdminNo")
Into Group
Select dt.LoadDataRow(New Object() {String.Join(":", Group.ToArray()), Group.Count(), AdminNo}, False)
).ToList().Count()


Dim gdv As New DataGridView
gdv.AutoGenerateColumns = True
gdv.DataSource = dt
Me.Control.Add(gdv)

how do you store colon separated value inside int32 datatype it's utter wrong...
When you put break point(the original code by me) and point to dt with your mouse when break point turns yellow, you see many options like "Data Table Visualizer", "Text Visualizer", "XML .." etc... Select Data Table Visualizer to see what's there in the "dt" variable
Ref: http://msdn.microsoft.com/en-us/library/zayyhzts.aspx

Put a break point on "DataGridView3.AutoGenerateColumns = True" and view what's there in dt...

_a is alias for dt3 in Linq query. I used Linq for solving this... You may look up MSDN for Linq(Language Integrated Query)

Thanks,

Kuthuparakkal

Modified soln, please try!

Use IDENTITY, see my soln updated!

Check the spelling for "Description" in your datatable against the Linq written

What's this "letters[0].ToString()" ? Replace this with some letter may reveal the issue

See my solution...

Thanks,

Kuthuparakkal

I have been using the same approach for the last couple years, it works.. Something wrong with your pkg or settings...

Did you give proper password once you change to "EncryptSensitiveWithUserKey" ?
Also, be sure if you are using 32bit execution mode when Excel(.xls or .xlsx) connection involved.

Modified, please try now!

You're welcome!!!